BUG #2074: Error switching connection in embedded PostgreSQL program

From: "Edoardo Innocenti" <edoardo(dot)innocenti(at)sdb(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2074: Error switching connection in embedded PostgreSQL program
Date: 2005-11-29 08:05:43
Message-ID: 20051129080543.8FC84F0BF1@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2074
Logged by: Edoardo Innocenti
Email address: edoardo(dot)innocenti(at)sdb(dot)it
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Kari Lavikka 2005-11-29 14:05:44 postgres 8.1 crashing
Previous Message Frank van Vugt 2005-11-29 00:36:00 Re: segfault of autovacuum process during restore - coredumps included