Re: sorry, now with subject... trigger & nextval(seq) - Mailing list pgsql-sql

From Daniel Migowski
Subject Re: sorry, now with subject... trigger & nextval(seq)
Date
Msg-id 4C04E980.9080906@ikoffice.de
Whole thread Raw
In response to Re: sorry, now with subject... trigger & nextval(seq)  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-sql
Am 21.05.2010 03:46, schrieb Adrian Klaver:
> You know serial is just a shortcut for:
>
> pid int NOT NULL DEFAULT nextval('seq')
>
> I think you will find Access will place nice if you use the long form to define
> your autoincrement.
>
Not true. Serial will also add an internal dependency between the
sequence, will create the sequence and will drop everything if the
column gets dropped.

Regards,
Daniel Migowski


Attachment

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Extending Regular Expression bounds limit of 255.
Next
From: Wes James
Date:
Subject: how to construct sql