Re: [HACKERS] SERIAL type isn't listed...?

Serial isn't a type. The parser transforms it to int4 plus some default
and a sequence. There is a TODO item in this direction, but I think no one
is quite sure how/why/whether to do it.

On Thu, 3 Feb 2000, The Hermit Hacker wrote:

>
> Shouldn't this produce something? Was talking with Dave Page today about
> the lack of a serial type in PgAdmin, and he mentioned that its not a listed
> type?
>
>
> template1=> SELECT typname FROM pg_type WHERE typrelid = 0 and typname='serial';
> typname
> ---------
> (0 rows)
>
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>
> ************
>
>

--
Peter Eisentraut Sernanders vaeg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden