Re: [HACKERS] pg_dump permissions problem

2003-09-29 Thread Bruce Momjian
Tom Lane wrote: > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > > My live 7.3.4 database dumps data like this: > > > REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC; > > GRANT ALL ON TABLE log_freeprofile TO brett; > > GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO "au-php"; > > GR

Re: [HACKERS] pg_dump permissions problem

2003-09-29 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > My live 7.3.4 database dumps data like this: > REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC; > GRANT ALL ON TABLE log_freeprofile TO brett; > GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO "au-php"; > GRANT SELECT ON TABLE log_freepr

[HACKERS] pg_dump permissions problem

2003-09-29 Thread Christopher Kings-Lynne
Hi guys, My live 7.3.4 database dumps data like this: SET SESSION AUTHORIZATION 'auadmin'; -- -- TOC entry 346 (OID 1012952) -- Name: log_freeprofile; Type: TABLE; Schema: public; Owner: auadmin -- CREATE TABLE log_freeprofile ( date date DEFAULT ('now'::text)::date NOT NULL, "start" int