Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35E9DB1B.F59BE928@alumni.caltech.edu>
Date: Sun, 30 Aug 1998 23:07:07 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Bruce Momjian <maillist@candle.pha.pa.us>
CC: peter@retep.org.uk, hackers@postgreSQL.org
Subject: Re: [HACKERS] Open 6.4 items
References: <199808302111.RAA16751@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> > Works fine _if_ the user has database creation privileges:
> Can I ask why sequence creation is related to database CREATION.  
> Seems very strange to me.

I'd guess that it is related to being allowed to put entries into
whatever supports sequences (a view or table?). If you created the
database you get some other privileges too??

> > tgl=> create table test (x text,
> > tgl-> i int default nextval('test_s_seq'));
> > ERROR: pg_aclcheck: class "test_s_seq" not found
> > it looks like the sequence should internally be created before the
> > table, though in some cases it doesn't matter. I was concerned that 
> > this might be the case, and the parser is not at the moment 
> > configured to allow this.

                   - Tom