On Tue, 2006-09-05 at 12:25 -0400, 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:
Please read the ">>" that was from Joshua who was testing on 8.1.3, not me. I am running 7.3.4. In my test I do not see stuff2 either. The problem here is that I have sensitive production data, so my tests are hard to read, and not able to submit here. So how do I recreate this template thing without killing production data? TTYL, Blair. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend