Another nasty pg_dump problem
От | Christopher Kings-Lynne |
---|---|
Тема | Another nasty pg_dump problem |
Дата | |
Msg-id | 09be01c345c7$114970e0$2800a8c0@mars обсуждение исходный текст |
Ответы |
Re: Another nasty pg_dump problem
|
Список | pgsql-hackers |
On my 7.3 server: australia=# \dp exercise_activities Access privileges for database "australia"Schema | Table | Access privileges --------+---------------------+--------------------------------------------- ------------public | exercise_activities | {=,chriskl=arwdRxt,auadmin=arwdRxt,au-diary=r,au-php=r} (1 row) is dumped as: REVOKE ALL ON TABLE exercise_activities FROM PUBLIC; GRANT ALL ON TABLE exercise_activities TO chriskl; GRANT SELECT ON TABLE exercise_activities TO "au-diary"; GRANT SELECT ON TABLE exercise_activities TO "au-php"; Now if you load that into 7.4CVS, you get: australia=# \dp exercise_activities Access privileges for database "australia"Schema | Table | Access privileges --------+---------------------+--------------------------------------------- -------------------------------------------------------------public | exercise_activities | {auadmin=a*r*w*d*R*x*t*/auadmin,chriskl=arwdRxt/auadmin,"\"au-diary\"=r/auad min","\"au-php\"=r/auadmin"} (1 row) Which is dumped as: REVOKE ALL ON TABLE exercise_activities FROM PUBLIC; GRANT ALL ON TABLE exercise_activities TO chriskl; GRANT SELECT ON TABLE exercise_activities TO "\""au-diary\"""; GRANT SELECT ON TABLE exercise_activities TO "\""au-php\"""; ie. 7.4 considers the double quotes around a username to be part of the username... Chris
В списке pgsql-hackers по дате отправления: