Interesting... I was looking into a couple of frameworks (codeignitor,
symphony, cake) and they all use either LASTVAL() or CURRVAL for their last
insert id's
On Thu, Oct 23, 2008 at 2:29 PM, Lonnie Olson <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 22, 2008 at 3:18 PM, thebigdog <[EMAIL PROTECTED]> wrote:
> >> I'm not having any luck finding the equivalent to mysqli_insert_id() for
> >> postgres. I've seen the method of getting the id from the sequence, but
> I'm
> >> hoping for a better way to do then that...
> >
> > technically, there is not a php function in postgesql like that function.
> you
> > can write a query to provide that information based on the sequence that
> you are
> > using.
> >
> > select currval('sequence_name');
> >
> > that will return the last value used. however, there is not a php
> function that
> > will provide the functionality that mysqli_insert_id() does.
>
> Eeek. That's bad. Don't do that.
>
> You are exposing a race condition where the sequence may be
> incremented by another INSERT before you get a chance to query the
> current value.
>
> Like Joseph said, If you need to have the last ID in your code, use
> the old-school method:
> 1. Request new ID from the sequence
> SELECT nextval('sequencename');
> 2. Insert your record using this value.
> INSERT INTO table (id, col, col, col) VALUES ($id, ....
>
> If you don't need the last ID in your code, you can use the new method
> (new to Pg that is) which is just like MySQL.
>
> Declaring the ID column as SERIAL is what gives you the automatic
> sequence magic like MySQL.
> http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-SERIAL
>
> --lonnie
>
> _______________________________________________
>
> UPHPU mailing list
> [email protected]
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net
>
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
