From: Edoardo Innocenti <edoardo.innocenti@sdb.it>
To: pgsql-interfaces@postgresql.org
Subject: ERROR CONNECTION POSTGRES 8.1
Date: Thu, 24 Nov 2005 12:07:01 +0100
Message-ID: <43859ED5.4060708@sdb.it> (raw)
We have problem connecting to postgres 8.1 database
Example
#include <stdio.h>
main ()
{
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati_latin AS
connection1 USER root;
EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati_arg AS
connection2 USER root;
EXEC SQL SET CONNECTION connection1;
EXEC SQL DISCONNECT connection1;
EXEC SQL DISCONNECT connection2;
}
We have syntax error when compiling this (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/basedati_latin AS
connection1 USER root;
EXEC SQL CONNECT TO tcp:postgresql://localhost/basedati_arg 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".
Can you help us
Thanks in advance
--
Best regards,
Doc. Edoardo Innocenti
System Administrator
Lulli S.r.l, ITALY
Tel: +39.055.721365
Fax: +39.055.721637
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: edoardo.innocenti@sdb.it
Subject: Re: ERROR CONNECTION POSTGRES 8.1
In-Reply-To: <43859ED5.4060708@sdb.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox