Re: [BUGS] BUG #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread Tom Lane
Jeff Frost writes: > On Jul 18, 2013, at 11:47 AM, Tom Lane wrote: >> I see no bug here. This is not different from any other >> property-alteration you might do on an extension member object. >> We allow that (if you have privileges), but it's up to you to keep it >> in sync with the extension

Re: [BUGS] BUG #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread Jeff Frost
On Jul 18, 2013, at 11:47 AM, Tom Lane wrote: > j...@pgexperts.com writes: >> permtest=# create extension dblink; >> CREATE EXTENSION >> permtest=# grant EXECUTE on FUNCTION dblink(text) to permtestuser; >> GRANT > > I see no bug here. This is not different from any other > property-alteration

Re: [BUGS] BUG #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread Tom Lane
j...@pgexperts.com writes: > permtest=# create extension dblink; > CREATE EXTENSION > permtest=# grant EXECUTE on FUNCTION dblink(text) to permtestuser; > GRANT I see no bug here. This is not different from any other property-alteration you might do on an extension member object. We allow that (i

[BUGS] BUG #8315: GRANTS allowed on extension functions, but not dumped by pg_dump

2013-07-18 Thread jeff
The following bug has been logged on the website: Bug reference: 8315 Logged by: Jeff Frost Email address: j...@pgexperts.com PostgreSQL version: 9.2.4 Operating system: Scientific Linux 6 Description: Simple test case: pgx-test:~ $ createdb permtest pgx-test:~ $ ps