ERROR: current transaction is aborted, queries ignored until end of transaction block

COMMIT;

DROP TABLE fktable, pktable;

-- deferrable, initially deferred

CREATE TABLE pktable (

idINT4 PRIMARY KEY,

otherINT4

);

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pktable_pkey" for table "pktable"

CREATE TABLE fktable (

idINT4 PRIMARY KEY,

fkINT4 REFERENCES pktable DEFERRABLE INITIALLY DEFERRED

);

NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "fktable_pkey" for table "fktable"

NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)

BEGIN;

-- no error here

INSERT INTO fktable VALUES (100, 200);

-- error here on commit

COMMIT;

ERROR: insert or update on "fktable" violates foreign key constraint "$1"

DETAIL: Key (fk)=(200) is not present in "pktable".

COMMIT;

DROPTABLE fktable, pktable;

CREATETABLEpktable (

idINT4PRIMARY KEY,

otherINT4

);

CREATETABLEfktable (

idINT4PRIMARY KEY,

fkINT4REFERENCES pktable DEFERRABLE INITIALLY DEFERRED

);

BEGIN;

INSERT INTO fktableVALUES (100,200);

COMMIT;