Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    10

    Unhappy Unanswered: errors with "dblink"

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    don't know

    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 :-)
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Jul 2003
    Posts
    10

    Re: don't know

    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..

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    lack of time

    At the moment I' short of time
    but I will look at this in the evening and send you the answer.
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Jul 2003
    Posts
    10

    Talking Re: lack of time

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •