Re: [HACKERS] Serial syntax

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Serial syntax
Date: 1998-09-16 05:18:16
Message-ID: 35FF4A18.A4832E83@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-09-16 06:33:19 Re: [HACKERS] 'select @1' problem
Previous Message Thomas G. Lockhart 1998-09-16 05:14:13 Re: [HACKERS] query crashes backend - cvs