On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane <[email protected]> wrote: > Terry <[email protected]> writes: >> I am somewhat confused. My app is detecting it as a serial data type >> but describing the table shows that its an integer. What am I >> missing? > >> dssystem=# \d clients_event_log >> Table "public.clients_event_log" >> Column | Type | >> Modifiers >> ----------------+-------------------------+------------------------------------------------------------------- >> ev_id | integer | not null default >> nextval('clients_event_log_ev_id_seq'::regclass) > > Nothing. "Serial" is nothing but a shorthand for an integer column > with a default like that.
And a dependency for the sequence on the column. I wonder if Terry's application is sorting through dep info to make a bad decision... -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
