Ralph Smith <smithrn@xxxxxxxxxxxxxxxx> writes: > On Oct 25, 2007, at 12:24 PM, Tom Lane wrote: >> Hmph. Nothing obviously wrong there, except that it's not finding >> anything except template1. What does "select * from pg_database" >> show? > postgres=# select * from pg_database ; > datname | datdba | encoding | datistemplate | datallowconn | > datconnlimit | datlastsysoid | datfrozenxid | dattablespace | > datconfig | datacl > -----------+--------+----------+---------------+-------------- > +--------------+---------------+--------------+--------------- > +-----------+------------------------------------- Ummm ... those are the column headings for 8.2 pg_database, not 7.4. You're looking at the wrong postmaster. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
