"Jose Manuel Mira" <[EMAIL PROTECTED]> writes: > If we open manually a connection (with this sentence: > select dblink_connect('conexion','dbname=XXX user=XXX password=XXX > host=localhost') ) the trigger must show a notice that there are open > connections and proceed to close it. The trigger never evaluates this > condition and proceeds to insert a row, not taking into account that there > are open connections with the same name.
You didn't show exactly what you did and what result you got. I tried the function and trigger and they seem to work as expected here. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs