pgsql8 cant see databases

[homerog]

hi folks!
(please excuse my english)

i've installed phpcodegenie 3.0.2 on fedora core 3.
everything looks fine, i can login.
the "databases root" only show the "system" tables, no my databases either my tables.

any idea?
thanks in advance.
regards,
homero.

[homerog]

I found the problem.

databaseQuery.class.php
Line 477.

original line:
if (($this->getDatabaseType()=="mysql") || ($this->getDatabaseType()=="odbc") || ($this->getDatabaseType()=="ado"))

must set to:

if (($this->getDatabaseType()=="mysql") || ($this->getDatabaseType()=="odbc") || ($this->getDatabaseType()=="ado") ||
($this->getDatabaseType()=="postgres"))

[kam]

Your suggestion works! However, if you let PCG3 generate "simple" code it ignores the that you're using postgresql & writes code for mysql (in dbConnection.php, it uses mysql_connect & mysql_select_db).

Sorry if I missed this in the documentation, but since many of us don't read the docs but DO read forums, maybe this will help someone.

I have tried using postgresql8 with the advanced generator, but I keep running into path issues (so many path issues, urg!) so I don't know if it works...but I'll let you know.

Anyway, let's keep this forum active because I think this project has merit & has been dormant too long.