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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Bad permissions bug in 7.3 dump (and 7.4)?
Следующее
От: Kenji Sugita
Дата:
Сообщение: Re: PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: