Re: [HACKERS] Serial syntax - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Serial syntax
Date
Msg-id 35FF4A18.A4832E83@alumni.caltech.edu
Whole thread Raw
In response to Serial syntax  (darcy@druid.net (D'Arcy J.M. Cain))
List pgsql-hackers
> Yeah. I'm testing some patches now...

postgres=> create table t (s serial, ss serial primary key);
NOTICE:  CREATE TABLE will create implicit sequence
         t_s_key for SERIAL column t.s
NOTICE:  CREATE TABLE will create implicit sequence
         t_ss_seq for SERIAL column t.ss
NOTICE:  CREATE TABLE/UNIQUE will create implicit index
         t_s_key for table t
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
         t_pkey for table t
CREATE

pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] query crashes backend - cvs
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] 'select @1' problem