Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Open 6.4 items

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 (view raw or flat)
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


In response to

Responses

pgsql-hackers by date

Next:From: Massimo Dal ZottoDate: 1998-08-30 11:04:43
Subject: Re: [HACKERS] flock patch breaks things here
Previous:From: Peter T MountDate: 1998-08-30 10:53:02
Subject: Re: [HACKERS] Open 6.4 items

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group