Search Postgresql Archives

Access FE - This operation is not supported within transaction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?
 
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux