From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Open 6.4 items |
Date: | 1998-08-30 10:55:03 |
Message-ID: | Pine.LNX.3.96.980830115328.493T-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 25 Aug 1998, Thomas G. Lockhart wrote:
> > > > SERIAL type auto-creates sequence
> > > I won't have time to do this for v6.4.
> > This would be nice to have, so maybe we can jam it in. If it is not
> > 100% correct, we have a month to make it correct, right?
>
> OK, I've committed the SERIAL type support to the CVS tree:
>
> postgres=> create table test (x text, s serial);
> NOTICE: CREATE TABLE will create implicit sequence test_s_seq for
> SERIAL column test.s
> NOTICE: CREATE TABLE/UNIQUE will create implicit index test_s_key for
> table test
> CREATE
I've just tried this (using a CVS tree from Friday), and got this:
peter=> create table test (x text, s serial);
NOTICE: CREATE TABLE will create implicit sequence test_s_seq for SERIAL
column test.s
NOTICE: CREATE TABLE/UNIQUE will create implicit index test_s_key for
table test
ERROR: pg_aclcheck: class "test_s_seq" not found
\d shows that nothing is created. Any ideas?
--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
From | Date | Subject | |
---|---|---|---|
Next Message | Massimo Dal Zotto | 1998-08-30 11:04:43 | Re: [HACKERS] flock patch breaks things here |
Previous Message | Peter T Mount | 1998-08-30 10:53:02 | Re: [HACKERS] Open 6.4 items |