Re: get last oid - Mailing list pgsql-odbc

Wanderful!!!  I never thought about this !!

Roberto


----- Original Message -----
From: "sqllist" <sqllist@coralindia.com>
To: "postgre" <pgsql-odbc@postgresql.org>
Sent: Friday, December 19, 2003 12:22 PM
Subject: Re: [ODBC] get last oid


> Hi Ricky,
>
> There is a work around for this...
>
> 1. Create a LOCAL TEMPORARY table.
> 2. On the MAIN table, put a trigger to store NEW.oid in that TEMPORARY
> table.
> 3. On your VB application, Fetch OID from that TEMP table.
>
> Since, the local temporary table's data is visible to specific to session,
> each session will get their OID even if "n" numbers of users are inserting
> data in that table at a time..
>
>  HTH
>
>  Thanx
>
>  Denis
>
>
> > ----- Original Message -----
> > From: "Ropel" <ropel@ropel.it>
> > To: "postgre" <pgsql-odbc@postgresql.org>
> > Sent: Friday, December 19, 2003 2:32 PM
> > Subject: Re: [ODBC] get last oid
> >
> >
> > > ... In a well designed relational Db, every table has a (unique)
primary
> > > key: if so, you don't even need to
> > > know the oid, because the record just inserted is directly reachable
> using
> > > the PK.
> > > If your PK uses sequences, you have to get the next seq value "select
> > > nextval() from seq_xxxxx..." and use the
> > > value obtained for inserting your new row instead of using it as a
> default
> > > value; this way you are protected from
> > > concurrent writing to the DB.
> > >
> > > If you REALLY need the oid from the ODBC connection, I can't help...
> sorry
> > !
> > >
> > > Bye
> > >
> > > Roberto
> > >
> > > ----- Original Message -----
> > > From: "Ricky" <ricky@babonmultimedia.com>
> > > To: "postgre" <pgsql-odbc@postgresql.org>
> > > Sent: Friday, December 19, 2003 9:25 AM
> > > Subject: Re: [ODBC] 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@ropel.it>
> > > > To: "postgre" <pgsql-odbc@postgresql.org>
> > > > 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@babonmultimedia.com>
> > > > > To: "postgre" <pgsql-odbc@postgresql.org>
> > > > > 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 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match