Re: sequences and pg_type - Mailing list pgsql-hackers

From pw
Subject Re: sequences and pg_type
Date
Msg-id 1062905917.16961.94.camel@downstairs
Whole thread Raw
In response to sequences and pg_type  (pw <p.willis@telus.net>)
List pgsql-hackers

I think I found a solution. Hopefully the system tables don't change 
too much in the future.I just used pg_attrdef to tell me which columns
*not* to use.

I hope that's right. It seems to work.

Peter



On Sat, 2003-09-06 at 18:19, Tom Lane wrote:
> pw <p.willis@telus.net> writes:
> > I have a table with a serial type in it as a record id.
> > The type of this object comes back as int4 when I query via
> > pg_type.
> > How can I distinguish this counter type from just a plain int4?
> 
> Well, you can't, because serial isn't actually a type in Postgres.
> As the manual tries to explain, serial is just a shorthand for
creating
> an integer column whose default is a nextval() call on a sequence.
> So the way to tell is to look for a default expression of that kind.
> 
>             regards, tom lane




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: sequences and pg_type
Next
From: Hannu Krosing
Date:
Subject: Re: [PATCHES] Warning for missing createlang