Skip site navigation (1) Skip section navigation (2)

Re: @@IDENTITY (Was: Access - ODBC - serial problem)

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: <pgsql-odbc(at)postgresql(dot)org>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Subject: Re: @@IDENTITY (Was: Access - ODBC - serial problem)
Date: 2004-04-10 08:59:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
> For reasons unfathomable to modern man, Microsoft chose @@IDENTITY to
> not the current user, as I or you or any sane person would expect, but
to hold 
> the incremented value of an autoincrementing column fed by an insert.
> triumph in orthogonally named things from Microsoft.
> Anyway, what the original conversation was about was getting back the
> increment value from pgsql via ODBC with access on top.  The problem
> that postgresql doesn't have a simple "what was the autoincrement I
just put 
> in" but requires the user to either use the system catalogs to look up
> sequence name and then use currval on it, or something like a plpgsql
> to insert your data.  


Without a way of getting the autoincrement from the ODBC driver, there
will always be cases, when adding data to a table through a linked
table, where the data that appears onscreen is not the one that has been
added to the table. And this until you requery the whole table.

- After an insert, Microsft ODBC driver issues a "SELECT @@IDENTITY".

- After an insert, Postgresql ODBC driver reads the data based on the
values that have been inserted. There are cases were these values
already existed in the table before the insert, and so the autoincrement
fetched may not be correct.

Is there anything that can be done at the driver level?


pgsql-odbc by date

Next:From: Ed BrownDate: 2004-04-10 14:17:55
Subject: Re: @@IDENTITY (Was: Access - ODBC - serial problem)
Previous:From: Sheeraz fazalDate: 2004-04-09 21:40:14
Subject: Syntax to pass IN parameters through ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group