(mysql to postgresql) in php functions - Mailing list pgsql-general

From Camarao, Wagner (v)
Subject (mysql to postgresql) in php functions
Date
Msg-id 6849495BC0DED61188D500080245C6D1A37286@exchange-rio.bowneglobal.com.br
Whole thread Raw
Responses Re: (mysql to postgresql) in php functions  (Ericson Smith <eric@did-it.com>)
List pgsql-general
Hi. I am migrating a site database from MySQL to PostgreSQL.

    First I just changed the function calls and then I got the error
message that PHP was not compiled with PostgreSQL support.

    Ok, so I recompiled the PHP as necessary and now the problem is that
there was a function being used, called mysql_select_db();, that there is
none to use with PostgreSQL instead of it.

    I really dont know if it is necessary to use the select_db function
after the connection to the database. But I think so, because when I try to
execute a query (without running the select_db function) I get the error
message:

    "Fatal error: Call to undefined function: pg_query() in
/path/file.php on line 123"

    Anybody can help me? Although this is not a php mail list?! :-)

Tks,
Wagner


pgsql-general by date:

Previous
From: u_andy@pisem.net
Date:
Subject: user authentication
Next
From: Brad Paul
Date:
Subject: pg_dump: NOTICE: ShmemAlloc: out of memory