X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B4EA6DBC00 for ; Thu, 24 Nov 2005 10:10:38 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24069-04-2 for ; Thu, 24 Nov 2005 14:10:41 +0000 (GMT) X-Greylist: delayed 03:02:06.559476 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 9D4EDDBC11 for ; Thu, 24 Nov 2005 10:10:34 -0400 (AST) Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by svr2.postgresql.org (Postfix) with ESMTP id 6E34EF0B18 for ; Thu, 24 Nov 2005 11:08:30 +0000 (GMT) Received: from localhost (unknown [127.0.0.1]) by mail.sdb.it (Postfix) with ESMTP id 8230C3003EB for ; Thu, 24 Nov 2005 12:08:17 +0100 (CET) Received: from mail.sdb.it ([127.0.0.1]) by localhost (gw.sdb.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04576-05 for ; Thu, 24 Nov 2005 12:08:17 +0100 (CET) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id 4AA0F3003C2 for ; Thu, 24 Nov 2005 12:08:17 +0100 (CET) Received: from localhost (unknown [127.0.0.1]) by geronimo.sdb.it (Postfix) with ESMTP id 8247135E32; Thu, 24 Nov 2005 12:06:49 +0100 (CET) Received: from geronimo.sdb.it ([127.0.0.1]) by localhost (geronimo [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19157-09; Thu, 24 Nov 2005 12:06:49 +0100 (CET) Received: from cochise.sdb.it (cochise.sdb.it [10.118.122.240]) by geronimo.sdb.it (Postfix) with ESMTP id 49F4B35E2B for ; Thu, 24 Nov 2005 12:06:49 +0100 (CET) Received: from [10.118.122.64] (baluardo.sdb.it [10.118.122.64]) by cochise.sdb.it (Postfix) with ESMTP id 99B622A4C2 for ; Thu, 24 Nov 2005 12:06:39 +0100 (CET) Message-ID: <43859ED5.4060708@sdb.it> Date: Thu, 24 Nov 2005 12:07:01 +0100 From: Edoardo Innocenti Reply-To: edoardo.innocenti@sdb.it User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: it, it-it, en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: ERROR CONNECTION POSTGRES 8.1 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at sdb.it X-Virus-Scanned: by amavisd-new at sdb.it X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.166 required=5 tests=[SUBJ_ALL_CAPS=1.166, UPPERCASE_25_50=0] X-Spam-Score: 1.166 X-Spam-Level: * X-Archive-Number: 200511/63 X-Sequence-Number: 5859 We have problem connecting to postgres 8.1 database Example #include 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 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