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

Re: Serial columns and ADO

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Serial columns and ADO
Date: 2006-11-10 09:25:17
Message-ID: ej1ghi$1sa8$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
I've tried your snapshot (8.2.0201) and found no difference in behaviour. It 
sends 'SELECT 0' as before. Is it really corrected in the snapshot? Maybe I 
have incorrect driver settings. Which ones affect most of all?

"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> wrote in message 
> Dmitry Samokhin wrote:
>> As far as I understand, since the driver exposes 'serial' columns as 
>> 'AutoNumber', ADO issues 'SELECT @@IDENTITY' to retreive the new 
>> generated values just after inserts. The driver, in turn, has to modify 
>> that query into 'SELECT currval(...)'.
>> When working with PG tables from inside MS Access, it all works 
>> perfectly! But here is a small test suite that doesn't work as expected:
> Please try the snapshot dll at
> .
> regards,
> Hiroshi Inoue
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to


pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-11-10 09:28:29
Subject: Re: Serial columns and ADO
Previous:From: Hiroshi InoueDate: 2006-11-10 00:41:42
Subject: Re: Serial columns and ADO

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