Another nasty pg_dump problem

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Another nasty pg_dump problem
Date: 2003-07-09 03:06:17
Message-ID: 09be01c345c7$114970e0$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message subbiah K 2003-07-09 05:06:08 postgres security
Previous Message Christopher Kings-Lynne 2003-07-09 01:58:47 Re: Bad permissions bug in 7.3 dump (and 7.4)?