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

From: Sevo Stille <sevo(at)ip23(dot)net>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] SERIAL type isn't listed...?
Date: 2000-02-03 18:06:23
Message-ID: 3899C39F.6F4AE35F@ip23.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-02-03 18:36:14 coming ColdFusion support for PostgreSQL
Previous Message Mark Hollomon 2000-02-03 17:47:18 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL