Re: [HACKERS] SERIAL type isn't listed...? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] SERIAL type isn't listed...?
Date
Msg-id Pine.GSO.4.02A.10002031727040.10941-100000@Katt.DoCS.UU.SE
Whole thread Raw
In response to SERIAL type isn't listed...?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
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@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
> 
> 
> ************
> 
> 

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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Proposed Changes to PostgreSQL
Next
From: Karel Zak - Zakkr
Date:
Subject: array operators to the main tree