Hello,
Sorry for the newb question; I've spent a good amount of time trying to figure this out. I am fairly new to the Postgre world. I am currently in the process of upsizing several MS Access apps to a single PostgreSQL system; I will continue to use Access as the frontend. I have duplicated the table structure in Postgre and have successfully connected Access as a frontend to view data.
I am having trouble inserting a record into Postgre using Access. I am using a bound form with command button to insert to 2 tables with the event code
-
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
-
I get the error message "ODBC--insert on a linked table 'sinfo' failed. ERROR: null value in column "personid" violates not-null constraint."
-
CREATE TABLE person
-
(
-
personid serial NOT NULL,
-
fname character varying(50),
-
lname character varying(50),
-
roleid bigint,
-
CONSTRAINT person_pkey PRIMARY KEY (personid),
-
CONSTRAINT person_roleid_fkey FOREIGN KEY (roleid)
-
REFERENCES "role" (roleid) MATCH SIMPLE
-
)
-
-
CREATE TABLE sinfo
-
(
-
personid bigint NOT NULL,
-
sid character varying(7) NOT NULL,
-
CONSTRAINT stinfo_pkey PRIMARY KEY (personid),
-
CONSTRAINT sinfo_personid_fkey FOREIGN KEY (personid)
-
REFERENCES person (personid) MATCH SIMPLE
-
CONSTRAINT sinfo_sid_key UNIQUE (fduid)
-
)
-
Thanks for your time
