Access FE - This operation is not supported within transaction

From: "Sim Zacks" <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Access FE - This operation is not supported within transaction
Date: 2005-07-26 14:15:06
Message-ID: dc5d5r$7pe$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am using an Access front end to a PG 8.0 backend using linked tables.
When I use referential integrity it gives me the error:
This operation is not supported within transactions
This error occurs when referential integrity is used for both Cascade and restrict Delete. It actually does the cascade delete and it happens when there are no child records when it is restrict.
When I remove the constraint, then the delete works with no errors.

Does anyone have any insight into this problem?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-07-26 14:26:05 Re: pgsql client/server compatibility matrix?
Previous Message Scott Marlowe 2005-07-26 14:14:12 Re: pgsql client/server compatibility matrix?