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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq