Re: prepare, execute & oids - Mailing list pgsql-general

From Chris
Subject Re: prepare, execute & oids
Date
Msg-id 44D05835.5010306@gmail.com
Whole thread Raw
In response to Re: prepare, execute & oids  (phazon <phazon.ml@gmail.com>)
List pgsql-general
phazon wrote:
> I use PHP.
> When I make juste a simple insert like
>
> Insert Into my_table (my_field) values ('value')
>
> I get back the OID of the inserted line.
>
> But when i use the prepareInsert fonction, I get nothing back. That's a
> pprobleme becaus i need to take the primary key of the line inserted in
> order to make post-operations.
>
> I can't use the curval of a sequence because it can be the value of
> another insert made by another user.

currval is transaction safe, it's not a problem you need to worry about.

http://www.postgresql.org/docs/8.1/static/functions-sequence.html

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: "Christian Rengstl"
Date:
Subject: Re: Strange error message
Next
From: Frank Finner
Date:
Subject: Re: Strange error message