December 7th, 2012, 07:24 PM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 1
Time spent in forums: 13 m 48 sec
Reputation Power: 0
|
|
Pg_dump: unknown object type (84) in default privileges
I'm using PostgreSQL 9.2 on Windows.
I created a small database with four tables and one function. I set up default privileges for a group role on the public schema. All seems to be working except when I try and backup the database. I receive this error:
Code:
pg_dump: unknown object type (84) in default privileges
Here is the SQL that pgAdmin III generates when I select the public schema:
Code:
CREATE SCHEMA public
AUTHORIZATION postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
GRANT USAGE ON SCHEMA public TO my_group;
COMMENT ON SCHEMA public
IS 'standard public schema';
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER ON TABLES
TO my_group;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT, UPDATE, USAGE ON SEQUENCES
TO my_group;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT EXECUTE ON FUNCTIONS
TO my_group;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT USAGE ON TYPES
TO my_group;
Anyone know why this is happening?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
