Current sources fail if two 'serial' columns in one table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Current sources fail if two 'serial' columns in one table
Date: 1999-10-22 16:01:57
Message-ID: 20857.940608117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

With current sources,

regression=> create table xx (f1 int, f2 serial, f3 serial);
NOTICE: CREATE TABLE will create implicit sequence 'xx_f2_seq' for SERIAL column 'xx.f2'
NOTICE: CREATE TABLE will create implicit sequence 'xx_f3_seq' for SERIAL column 'xx.f3'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'xx_f2_key' for table 'xx'
NOTICE: CREATE TABLE/UNIQUE will create implicit index 'xx_f3_key' for table 'xx'
CREATE
regression=> insert into xx values(1);
ERROR: Relation 'xx_f2_seq' does not exist
regression=>

6.5.2 fails to do the CREATE TABLE at all. I'm betting this is related
to the multiple-unique-index bug that you thought you had fixed.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message James Thompson 1999-10-22 16:05:52 Re: [GENERAL] Re: What's WAL
Previous Message Brian E Gallew 1999-10-22 15:57:11 Re: [HACKERS] Neverending query on 6.5.2 over Solaris 2.5.1