BUG #2074: Error switching connection in embedded PostgreSQL program

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BUG #2074: Error switching connection in embedded PostgreSQL program

Edoardo Innocenti

The following bug has been logged online:

Bug reference:      2074
Logged by:          Edoardo Innocenti
Email address:      [hidden email]
PostgreSQL version: 8.1.0
Operating system:   Linux
Description:        Error switching connection in embedded PostgreSQL
program
Details:

We have problem on switching connection in PostgreSQL 8.1.0 database. Here a
test case:

#include <stdio.h>

main ()

{

 EXEC SQL BEGIN DECLARE SECTION;

 EXEC SQL END DECLARE SECTION;


 EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati1 AS connection1
USER root;

 EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati2 AS

 connection2 USER root;

 EXEC SQL SET CONNECTION connection1;  (*)

 EXEC SQL DISCONNECT connection1;

 EXEC SQL DISCONNECT connection2;

}

We have syntax error when compiling this example with ecpg at line (*)
(this is the syntax used in 8.1 documentation).

If we write

#include <stdio.h>


main ()

{

 EXEC SQL BEGIN DECLARE SECTION;

 EXEC SQL END DECLARE SECTION;


 EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati1 AS  connection1
USER root;

 EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati2 AS  connection2
USER root;

 EXEC SQL SET CONNECTION TO connection1;

 EXEC SQL DISCONNECT connection1;

 EXEC SQL DISCONNECT connection2;

}


we haven't compiling errors but we obtain [4-1] ERROR:  unrecognized
configuration parameter "connection" in PostgreSQL logs.

Thanks in advance

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match