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

Serial field problem with Access 97 (fwd)

From: "Diego A(dot) Puertas F(dot)" <dpuertas(at)uc(dot)edu(dot)ve>
To: PostgreSQL Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Serial field problem with Access 97 (fwd)
Date: 2000-12-13 23:16:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I have a PostgreSQL 7.02 database on a Linux RedHat 5.2 server, my
frontend is Access97.

I have linked tables, using ODBC drivers, with serial fields as indexes.

The problem is that every time I try to insert a register Postgres
complaints with the following message:

  Insert on a linked table "tablename" failed
  Cannot insert a duplicate key into unique index "indexname-pkey"

We don't set the value of the serial index fields on Access, we relay on
Postgres for such task.

Before we move to the RedHat server, we were working on our experimental
server, wich is a Linux Slackware 7.1 box with PostgreSQL 7.02, and
everything worked fine.

I could use some enligthment here. Thanks in advance.

pgsql-novice by date

Next:From: Tom LaneDate: 2000-12-14 00:59:29
Subject: Re: Creating Log file - run in background.
Previous:From: Brett W. McCoyDate: 2000-12-13 22:18:15
Subject: Re: check_primary_key on Postgres 6.5.3-23

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