Hi - I'm new to PostGres, but have used MSSQL for about a year. I'm going
through the documentation, but after reading about serials have a lot of
worries about keeping referential integrity in place and other things.
Specifically, here are a few scenarios:
a.)
CREATE TABLE TestTable (
TestID SE
Alvaro Herrera-3 wrote:
>
> Just do not update the ID -- what use do you have for that
> anyway? If you want to prevent it, you can put a trigger to the column,
> but IMHO it would be a waste of your time and machine resources.
>
I have absolutely no use to update the ID. I'm not sure why an