dblink max per function

Started by Peter Kroonalmost 11 years ago4 messagesbugsgeneral
Jump to latest
#1Peter Kroon
plakroon@gmail.com
bugsgeneral

Hi,

I've got a function with 5 dblink select statement all to my local server
with the same connection string.
When one more dblink select statement is added the query fails.
Is there some kind of limit that I can configure? If so, which one an where?

Thanks,
Peter

#2Peter Kroon
plakroon@gmail.com
In reply to: Peter Kroon (#1)
bugsgeneral
Fwd: dblink max per function

Hi,

I've got a function with 5 dblink select statement all to my local server
with the same connection string.
When one more dblink select statement is added the query fails.
Is there some kind of limit that I can configure? If so, which one an where?

Thanks,
Peter

#3Peter Kroon
plakroon@gmail.com
In reply to: Peter Kroon (#1)
bugsgeneral
Re: dblink max per function

Sorry, wrong list.....

2015-07-05 20:52 GMT+02:00 Peter Kroon <plakroon@gmail.com>:

Show quoted text

Hi,

I've got a function with 5 dblink select statement all to my local server
with the same connection string.
When one more dblink select statement is added the query fails.
Is there some kind of limit that I can configure? If so, which one an
where?

Thanks,
Peter

#4Peter Kroon
plakroon@gmail.com
In reply to: Peter Kroon (#2)
bugsgeneral
Re: dblink max per function

A restart of my system solved the matter.....

2015-07-05 20:54 GMT+02:00 Peter Kroon <plakroon@gmail.com>:

Show quoted text

Hi,

I've got a function with 5 dblink select statement all to my local server
with the same connection string.
When one more dblink select statement is added the query fails.
Is there some kind of limit that I can configure? If so, which one an
where?

Thanks,
Peter