Discussion:
Problems with select version
(too old to reply)
Vaughn, Adam (IMS)
2004-06-30 15:08:48 UTC
Permalink
Sorry to bother you but I was unable to find this problem after looking
through the mailing list. I have postgres setup up on UNIX and I
configured the appropriate files and followed the steps from the manual.
After I initialized the database server and started the postmaster I
attempted to query template1 for the version number. Every time I run
select version(); I get 0 rows returned. I also ran the query select *
from pg_database which returned no rows, shouldn't template1 at least be
in there? Did I miss a step, or is there any way to initialize these
values. I am attempting to connect to this database using pgAdmin 3 but
the select version() is failing because template1 is returning no rows.
Any help would be appreciated.

Thanks,
Adam

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Tom Lane
2004-07-01 21:50:21 UTC
Permalink
Post by Vaughn, Adam (IMS)
Sorry to bother you but I was unable to find this problem after looking
through the mailing list. I have postgres setup up on UNIX and I
configured the appropriate files and followed the steps from the manual.
After I initialized the database server and started the postmaster I
attempted to query template1 for the version number. Every time I run
select version(); I get 0 rows returned.
*Something's* awfully broken then. I'd suggest rebuilding from scratch
... and try the regression tests.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Loading...