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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 access97s 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 access97s table view or forms. But these
access97 un-editable records can be edited/modified/deleted in psql or
pgAdmin II (V1.1 build 34). Whats wrong? The error MS Access97s
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 havent 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
From | Date | Subject | |
---|---|---|---|
Next Message | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 2001-10-26 05:45:27 | Returning recordsets from functions |
Previous Message | G.LeeJ | 2001-10-25 18:43:34 | pgaccess/msaccess |