[greg_ggl]

I use dblink with PostgreSQL 7.3.2

but i have errors :

> select dblink('dbname=testdb','select * from act2');
Error: ERROR: Cannot display a value of type RECORD

> select * from dblink('dbname=testdb','select * from act2');
Error: ERROR: A column definition list is required for functions returning RECORD

I don't know why....

Please help me,
Thanks,
Greg

[eperich]

I thin k you should look in the postgresql sources in the dir
contrib/dblink/sql

there is a file called dblink.sql with many examples
maybe you find something useful there

If it is not resolving your problem then come back and ask :-)

[greg_ggl]

the 2 examples are as those of the file contrib/dblink/sql applied on my database...

And I do not understand these errors...

On the other hand with dblink_connect I have no problem, the result is correct.

It is right a problem whith the return "value" of the function dblink..


P.S. thanks to have taken some time to answer and help me..

[eperich]

At the moment I' short of time
but I will look at this in the evening and send you the answer.

[greg_ggl]

ok thank you very much, I am not too hurry so take your time....