[SQL] Problem with inserting data produced by the function (when the function is performed).

2012-03-23 Thread Bear
The function calculates the data line by line, and inserts into the table, at the end of the function I need to send data from a table to another database via dblink. I noticed that the problem is to perform this operation in one function (or the main function of the two subfunction). My guess is t

Re: [SQL] problem with nested dblink function

2012-02-10 Thread Bear
I'm sorry, everything is in order. Today I looked with fresh eyes, a slight adjustment in the calling function and it works. Thanks for your attention. Best regards. Ps. recently I deal with postgresql and I wanted to consult with you. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org

[SQL] problem with nested dblink function

2012-02-10 Thread Bear
Hello everyone ! I have a problem with dblink function. I need to insert data using pl / pgsql function from one server to another. The data from server FS4 to server FS3. This code does not work: "select dblink ('dbname = ant_trendy port = 5433 host = FS3 user = postgres password = postgres ', '