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

Re: Role syntax (or, SQL99 versus sanity)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Role syntax (or, SQL99 versus sanity)
Date: 2005-06-28 17:56:05
Message-ID: 22208.1119981365@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> Is there some way we could use that 'ON' is required for the
> 'privileges' grant?

Well, the difficulty is that we can't see the ON until we've scanned
the list of privilege or role names.  Now that I've calmed down a bit,
the solution is fairly obvious: the name list has to be left as strings
during the grammar.  We'll check the privilege names for validity at
execution.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-06-28 17:58:01
Subject: Re: Occupied port warning
Previous:From: Tom LaneDate: 2005-06-28 17:54:17
Subject: Re: [PATCHES] Users/Groups -> Roles

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