Tom Lane wrote:
Blair Lowe <[EMAIL PROTECTED]> 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:
[EMAIL PROTECTED]:~$ 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:
[EMAIL PROTECTED]:~$ 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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
