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

Re: PostgreSQL serials in MS-Access are writable, but they are supposed to be read-only

From: "Joel Burton" <joel(at)joelburton(dot)com>
To: "Antti Toivanen" <antti(dot)toivanen(at)telemerkki(dot)fi>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: PostgreSQL serials in MS-Access are writable, but they are supposed to be read-only
Date: 2002-06-04 01:11:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Antti Toivanen <antti(dot)toivanen(at)telemerkki(dot)fi> said:

> -----Original Message-----
> From: Antti Toivanen [mailto:antti(dot)toivanen(at)telemerkki(dot)fi] 
> Sent: 29 May 2002 17:02
> To: Dave Page
> Subject: RE: [pgadmin-support] Migration from MS Sql server using the
> plug-in
> Hi again!
> Okay, I did as you told me to. 
> Basicly the PostgreSQL's serial_col now works as supposed. 
> But I ran to a another problem, altough it is not related to the
> Migration plugin nor pgAdmin. 
> The MS-Access doesn't regognize the ID field as a Auto_Increment. 
> For example: this is problem if I want to copy a record from table A to
> table B with ADO (or DAO), field by field. 
> If the procedure doesn't know which fields are writable and which arent
> (the Auto_Increment from PostgreSQL is writable), it might try to create
> a duplicated key since it copies it from the old record.
> Do you know a fully Access compatible way to handle this without
> possible code modifications, or can you address it for those who can
> make such a way possible?

Unlike Access' Auto_Increment fields, which are always read-only, PG (& most 
other databases) uses sequences, which _can_ get the next number, or can 
allow you to supply a number.

In my Access front-ends, I usually hide this column in datasheet view, and, 
change the properties of the textbox on form view to mark it as read-only. 
Very easy to do.

- J.


Joel BURTON | joel(at)joelburton(dot)com | | aim: wjoelburton
Knowledge Management & Technology Consultant 

In response to

pgsql-odbc by date

Next:From: SZ?CS GaborDate: 2002-06-04 11:40:16
Subject: Re: int8 becames string in BDE :-(
Previous:From: Hiroshi InoueDate: 2002-06-04 00:49:45
Subject: Re: int8 becames string in BDE :-(

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