ERROR CONNECTION POSTGRES 8.1

From: Edoardo Innocenti <edoardo(dot)innocenti(at)sdb(dot)it>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ERROR CONNECTION POSTGRES 8.1
Date: 2005-11-24 11:07:01
Message-ID: 43859ED5.4060708@sdb.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Eugene Prokopiev 2005-11-27 15:17:06 pl/pyton: exceptions.ImportError: No module named email.Parser
Previous Message Bruce Momjian 2005-11-22 22:33:18 Re: Not clear on what PQgetResult does