Re: get last oid

thanks Roberto,

i'm new in vb and also in postgresql,
well, if there'no function to get the last oid,  how to catch the message
INSERT 2237168 1 in visual basic ?

if no, maybe i have to try to select the bigest oid to get it but i'm
affraid while somebody insert in the same time, the oid will not match.

you have suggestion about this?

BR

Ricky


----- Original Message -----
From: "Ropel" <ropel@xxxxxxxx>
To: "postgre" <pgsql-odbc@xxxxxxxxxxxxxx>
Sent: Friday, December 19, 2003 3:20 PM
Subject: Re: [ODBC] get last oid


> PHP uses "pg_last_oid() ": a reliable way because it work's at connection
> level (i.e. it will not be affected
> by inserts made from other tasks or connections .
> I'd try searching starting from there for a solution without php: every
> other language i've seen has an equivalent solution.
>
> With "psql" you have:
>
> postgres=# insert into cars(name) values('lamborghini');
> INSERT 2237168 1
>
> where 2237168 is the oid...
>
> I hope it willl help...
>
> Roberto
>
>
> ----- Original Message -----
> From: "Ricky" <ricky@xxxxxxxxxxxxxxxxxxx>
> To: "postgre" <pgsql-odbc@xxxxxxxxxxxxxx>
> Sent: Friday, December 19, 2003 1:05 AM
> Subject: [ODBC] get last oid
>
>
> > hello,
> >
> > i try get the last oid after INSERT command but i have no idea about
> > command/function
> > .anyone know or is there any better method?
> >
> > Thanks
> > Ricky
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)