pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: FIXED Problems when using MS Access to display
2+ messages / 2 participants
[nested] [flat]
* Re: FIXED Problems when using MS Access to display
@ 2004-05-03 06:24 Simon Dobie <simon@auditbureau.org.au>
2004-05-03 15:18 ` Re: FIXED Problems when using MS Access to display Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 2+ messages in thread
From: Simon Dobie @ 2004-05-03 06:24 UTC (permalink / raw)
To: pgsql-interfaces
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.)
cheers!
%simon
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: FIXED Problems when using MS Access to display
2004-05-03 06:24 Re: FIXED Problems when using MS Access to display Simon Dobie <simon@auditbureau.org.au>
@ 2004-05-03 15:18 ` Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2004-05-03 15:18 UTC (permalink / raw)
To: Simon Dobie <simon@auditbureau.org.au>; +Cc: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-03 15:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-03 06:24 Re: FIXED Problems when using MS Access to display Simon Dobie <simon@auditbureau.org.au>
2004-05-03 15:18 ` Bruno Wolff III <bruno@wolff.to>
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