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

From Sevo Stille
Subject Re: [HACKERS] SERIAL type isn't listed...?
Date
Msg-id 3899C39F.6F4AE35F@ip23.net
Whole thread Raw
In response to SERIAL type isn't listed...?  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
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?

On 6.5, serial is not a type, but is promoted to "int4 DEFAULT nextval (
'"sequence_name_here"' ) NOT NULL", generating the associated sequence
in the process.

Sevo


pgsql-hackers by date:

Previous
From: "Mark Hollomon"
Date:
Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL
Next
From: "Ross J. Reedstrom"
Date:
Subject: coming ColdFusion support for PostgreSQL