"Jose Manuel Mira" <labsig(dot)iug(at)ua(dot)es> 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