Linked server update from a trigger

More
12 years 6 months ago #2710 by Moderator
Replied by Moderator on topic Re: Linked server update from a trigger
Have you enabled "two phase commit protocol" (2PC)? The test works on a system with 2PC support enabled.

Please see description of 2PC in Developer's Manual on pp 34, 35 ( www.pgoledb.com/index.php?option ... wnload&cid [0]=3&Itemid=68).

Please Log in or Create an account to join the conversation.

  • fran_pascual
  • Topic Author
  • Offline
  • User
  • User
More
12 years 6 months ago #2719 by fran_pascual
Replied by fran_pascual on topic Re: Linked server update from a trigger
Finally!!!! the problem was with:

2.6.3 Enabling prepared transactions in PostgreSQL

Some later versions of PostgreSQL have prepared transactions disabled by default. To enable the prepared
transactions, edit postgresql.conf file as described below. Open the postgresql.conf file in editor and find line with
max_prepared_transactions parameter (if missing, new line can be added). Uncomment the line by removing ‘#’
symbol in front and set the parameter equal to maximum allowed number of connections or more, e.g.
max_prepared_transactions = 100;
# zero disables the feature

Restart PostgreSQL Server.

tnks a lot ^^

Please Log in or Create an account to join the conversation.

Time to create page: 0.149 seconds
Powered by Kunena Forum