Rod Taylor wrote: >>>In MSSQL this >>>is gotten around by allowing the properties of the data type to be >>>altered, e.g. in MSSQL you can turn the IDENTITY property on or off >> >>Rather pointless if it can be turned off, wouldn't you say? >> >>What I would do if I wanted such a guarantee is to make insertions >>go through a view rule that prevents the serial column from being > > > In the future if we have per column privileges, we could disable insert > and update on serial columns by default for everyone but the table owner > and super-users (to accommodate dataloads).
That sounds like the best way-to-go. > Till then a trigger or view will do the job for those who wish to add > them. Agreed. Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html