Dear all,
I'm running into a problem I just can't seem to get fixed. I've
searched a long time for this already but haven't found anything that
comes close to what I'm seeing.
I'm trying to connect (and later use) a postgres database through php,
using PDO.
The webserver is a recently set up
I have several modules in a PHP program that access a postgres
database. The program needs to create a new Name record in a table
is it has a new name or use a name chosen from the database if it
doesn't have a new name. I want to load the chosen id in person_id if
the name is already
Check this link.
http://ca3.php.net/function.pg-query
The second example shows one way to perform a transaction, or the first
commit shows another potential way (sending a BEGIN; as it's own
query).
An easier way than using CURRVAL is to use the RETURNING clause on
your first INSERT, and then