Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group