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

Re: [HACKERS] Open 6.4 items

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: peter(at)retep(dot)org(dot)uk, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Open 6.4 items
Date: 1998-08-30 23:07:07
Message-ID: 35E9DB1B.F59BE928@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> > 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

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-08-30 23:13:51
Subject: Re: [HACKERS] Core dump in regression tests.
Previous:From: D'Arcy J.M. CainDate: 1998-08-30 23:01:01
Subject: Re: [HACKERS] Release 6.4

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