From raingsey@pasteur-kh.org Wed Jan 28 10:09:00 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D589DD1DE65 for ; Wed, 28 Jan 2004 10:09:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10107-07 for ; Wed, 28 Jan 2004 06:08:31 -0400 (AST) Received: from Charlotte.pasteur-kh.org (huguette.pasteur-kh.org [203.144.74.66]) by svr1.postgresql.org (Postfix) with ESMTP id DD845D1D202 for ; Wed, 28 Jan 2004 06:08:25 -0400 (AST) Received: from raingsey.pasteur-kh.org ([10.9.8.20]) by Charlotte.pasteur-kh.org (8.12.2/8.12.2) with ESMTP id i0SA8Gae020080 for ; Wed, 28 Jan 2004 17:08:17 +0700 Message-Id: <6.0.0.22.2.20040128170738.01b35b70@mail.pasteur-kh.org> X-Sender: raingsey@mail.pasteur-kh.org X-Mailer: QUALCOMM Windows Eudora Version 6.0.0.22 Date: Wed, 28 Jan 2004 17:12:19 +0700 To: pgsql-sql@postgresql.org From: raingsey@pasteur-kh.org Subject: Help! Error with postgresql! Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_34494270==.ALT" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_10_20, MANY_EXCLAMATIONS, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200402/11 X-Sequence-Number: 16702 --=====================_34494270==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed Hello, I have problem when i execute the .sql file in my psql command prompt. The error code is below: pylori=# \i log-clinique.sql CREATE psql:log-clinique.sql:100: ERROR: parser: parse error at or near ".3" psql:log-clinique.sql:107: ERROR: parser: parse error at or near ".3" psql:log-clinique.sql:113: ERROR: parser: parse error at or near ".3" pylori=# \i trigger-clinique.sql " does not exist in the system catalog. createlang: external error DROP CREATE DROP CREATE pylori=# I hope some of you can help me with this. Thank a lot, raingsey --=====================_34494270==.ALT Content-Type: text/html; charset="us-ascii" Hello,
I have problem when i execute the .sql file in my psql command prompt.
The error code is below:

pylori=# \i log-clinique.sql
CREATE
psql:log-clinique.sql:100: ERROR:  parser: parse error at or near ".3"
psql:log-clinique.sql:107: ERROR:  parser: parse error at or near ".3"
psql:log-clinique.sql:113: ERROR:  parser: parse error at or near ".3"
 
pylori=# \i trigger-clinique.sql
" does not exist in the system catalog.
createlang: external error
DROP
CREATE
DROP
CREATE
pylori=#

I hope some of you can help me with this.
Thank a lot,

raingsey --=====================_34494270==.ALT-- From paulhart@redchocolate.ca Mon Feb 2 02:33:08 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BC9EAD1D597 for ; Mon, 2 Feb 2004 02:33:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 92923-06 for ; Sun, 1 Feb 2004 22:33:09 -0400 (AST) Received: from achilles.redchocolate.ca (toronto-hs-64-26-176-180.s-ip.magma.ca [64.26.176.180]) by svr1.postgresql.org (Postfix) with SMTP id 913C6D1D59F for ; Sun, 1 Feb 2004 22:33:04 -0400 (AST) Received: (qmail 20314 invoked from network); 2 Feb 2004 02:33:03 -0000 Received: from unknown (HELO ?192.168.1.100?) (192.168.1.100) by achilles.redchocolate.ca with SMTP; 2 Feb 2004 02:33:03 -0000 In-Reply-To: <6.0.0.22.2.20040128170738.01b35b70@mail.pasteur-kh.org> References: <6.0.0.22.2.20040128170738.01b35b70@mail.pasteur-kh.org> Mime-Version: 1.0 (Apple Message framework v612) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <203D8DD5-5528-11D8-8202-000393CC268A@redchocolate.ca> Content-Transfer-Encoding: quoted-printable Cc: Paul Hart , pgsql-sql@postgresql.org From: Paul Hart Subject: Re: Help! Error with postgresql! Date: Sun, 1 Feb 2004 21:33:03 -0500 To: raingsey@pasteur-kh.org X-Mailer: Apple Mail (2.612) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/12 X-Sequence-Number: 16703 Would you mind telling us what's in your SQL file? it seems that=20 there's a problem in it. On 28 Jan 2004, at 05:12, raingsey@pasteur-kh.org wrote: > Hello, > I have problem when i execute the .sql file in my psql command prompt. > The error code is below: > > pylori=3D# \i log-clinique.sql > CREATE > psql:log-clinique.sql:100: ERROR:=A0 parser: parse error at or near ".3" > psql:log-clinique.sql:107: ERROR:=A0 parser: parse error at or near ".3" > psql:log-clinique.sql:113: ERROR:=A0 parser: parse error at or near ".3" > =A0 > pylori=3D# \i trigger-clinique.sql > " does not exist in the system catalog. > createlang: external error > DROP > CREATE > DROP > CREATE > pylori=3D# > > I hope some of you can help me with this. > Thank a lot, > > raingsey=20