Re: pg_dump and grants to PUBLIC

Tom Lane wrote:
> Blair Lowe <postgresql@zedemail.ca> writes:
>> On Mon, 2006-08-05 at 16:32 -0700, Joshua D. Drake wrote:
>>> What version of PostgreSQL is this that you are using? Because it
>
>> ]# rpm -qi postgresql
>> Name        : postgresql                   Relocations: (not
>> relocateable)
>> Version     : 7.3.4                             Vendor: Red Hat, Inc.
>                 ^^^^^
>
> That does not square with this:
>
>>> postgres@scratch:~$ psql -U test2 test2;
>>> Welcome to psql 8.1.3, the PostgreSQL interactive terminal.
>                    ^^^^^
>
> and the psql session is talking to test2 but you're dumping an
> unrelated database:
>
>>> postgres@scratch:~$ pg_dump test1;
>
> I see no evidence here that test1 didn't already have "foo" in it.
>
>             regards, tom lane
>

Tom, you are commenting on my example of why his doesn't make sense :).
I used 8.1.3 to test his theory, but he is running 7.3.

Sincerely,

Joshua D. Drake



--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/