On Fri, Feb 26, 2010 at 3:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Terry <td3201@gmail.com> 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...