On 13/12/13 18:18, John Dennis wrote:
It seems odd to me that postgres requires permission beyond INSERT to
Well, calling nextval on a sequence is a modify, so yes - it is subject to permissions.
create a row having a unique key, but apparently after googling a bit this is the case for postgres > 8.3(?). If you're a postgres expert and see an issue with the above please chime in.
It looks ok. TBH that postgres setup could be a lot better, but it depends on which version of PG you're willing to mandate and a bit on taste (e.g. the use of "VARCHAR(x)" everywhere is a waste of time - "text" is no slower on postgres, and considerably less fragile when a field suddenly gets wider). I would spend some time on it, were I not swamped with IP routing issues at the moment...