From: Bruno Wolff III <bruno@wolff.to>
To: Simon Dobie <simon@auditbureau.org.au>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: FIXED Problems when using MS Access to display
Date: Mon, 3 May 2004 10:18:30 -0500
Message-ID: <20040503151830.GA23846@wolff.to> (raw)
In-Reply-To: <4095E59C.9040904@auditbureau.org.au>
References: <40958AAA.30707@auditbureau.org.au>
<4095E59C.9040904@auditbureau.org.au>
On Mon, May 03, 2004 at 16:24:28 +1000,
Simon Dobie <simon@auditbureau.org.au> wrote:
> Its ok, i managed to figure it out. the Primary Key was not being
> updated (i did make it auto update in postgress but it doesnt seem to
> auto update) so i had to manually change the unique value for the
> records (which was the same for each one.)
There is no auto update in Postgres. If you are talking about the serial
type, it is important to know that it works by having a function get a
value from a sequence as a default action. If you actually provide a
value for this column when inserting a row, that value will get used
instead of using the default action to get a value.
If you still have questions about this, if you describe precisely what you
are doing we might be able to shed more light on what is happening.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bruno@wolff.to, simon@auditbureau.org.au
Subject: Re: FIXED Problems when using MS Access to display
In-Reply-To: <20040503151830.GA23846@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox