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