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

Cannot Modify or Delete 'Some' Old Records?

From: "Phillip J(dot) Allen" <paallen(at)attglobal(dot)net>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Cannot Modify or Delete 'Some' Old Records?
Date: 2001-10-25 19:22:44
Message-ID: 3BD86684.D824F5D3@attglobal.net (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all,

I have a postgres 7.1.2 bibliography database on a RH7.2 server that I
enter records through an MS Access97 front end.  One of my tables
contains a list of authors which I created by:
CREATE TABLE "c_author" (
  "type_numb" int4 DEFAULT nextval('"c_author_type_numb_seq"'::text) NOT
NULL,
  "auth_code" bpchar(6),
  "auth_fname" bpchar(50),
  "auth_mname" bpchar(50),
  "auth_plname" bpchar(50),
  "auth_mlname" bpchar(50),
  "auth_com" bool,
  "auth_memo" text,
  CONSTRAINT "c_author_pkey" PRIMARY KEY ("type_numb")
);
REVOKE ALL ON "c_author" FROM PUBLIC;
GRANT ALL ON "c_author" TO "paallen";
GRANT ALL ON "c_author" TO GROUP "biblio";

The type_numb column was originally created with a “SERIAL PRIMARY KEY”
command.

I imported a few records into the table from an original access97 table
I had.  I can now add new records to this table in access97’s tables or
form views and edit/modify them afterwards.  Some old records that I
appended into the psql table from the earlier access97 table I cannot
now edit or modify in access97’s table view or forms.  But these
“access97 un-editable records” can be edited/modified/deleted in psql or
pgAdmin II (V1.1 build 34).  What’s wrong?  The error MS Access97’s
error message reads:
Write Confict
This record has been changed by another user since you started editing
it.  If you save the record you will overwrite the changes the other
user made……….

And keep in mind there is only 1 user using the database and it is me.

I have some other tables that I built the same way and I haven’t had any
problems editing records.  Most of these tables I ported directly from
access to postgres using an ODBC link, then dumped the tables, modifed
the dump sql file (to add a serial primary key column), deleted the
table and loaded the dump sql file.  Then I updated the next value for
my sequence.  Is this procedure the root of my problems now?

Thanks

Phillip J. Allen
Consulting Geochemist/Geologist
Lima Peru
e-mail: paallen(at)attglobal(dot)net





pgsql-novice by date

Next:From: Torbj=?ISO-8859-1?B?9g==?=rn AnderssonDate: 2001-10-26 05:45:27
Subject: Returning recordsets from functions
Previous:From: G.LeeJDate: 2001-10-25 18:43:34
Subject: pgaccess/msaccess

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