X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DDAA3A5EEE for ; Mon, 13 Dec 2004 08:44:33 +0000 (GMT) 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 20679-07 for ; Mon, 13 Dec 2004 08:44:28 +0000 (GMT) Received: from druid.net (druid.net [216.126.72.98]) by svr1.postgresql.org (Postfix) with ESMTP id 188993A5406 for ; Mon, 13 Dec 2004 08:44:29 +0000 (GMT) Received: from imp.druid.net (imp [216.126.72.111]) by druid.net (Postfix) with SMTP id E2FB31ABC; Mon, 13 Dec 2004 03:44:27 -0500 (EST) Date: Mon, 13 Dec 2004 03:44:11 -0500 From: "D'Arcy J.M. Cain" To: Kenneth Gonsalves Cc: tgl@sss.pgh.pa.us, talexb@gmail.com, pgsql-sql@postgresql.org Subject: Re: parse error at or near "(" -- Huh??? Message-Id: <20041213034411.76e3f470.darcy@druid.net> In-Reply-To: <0412130927042G.21547@thenilgiris.com> References: <14681.1102905949@sss.pgh.pa.us> <0412130927042G.21547@thenilgiris.com> X-Mailer: Sylpheed version 1.0.0beta3 (GTK+ 1.2.10; i386--netbsdelf) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/76 X-Sequence-Number: 19696 On Mon, 13 Dec 2004 09:27:04 +0530 Kenneth Gonsalves wrote: > and while on this topic, how does one interpret the line numbers one > gets when running psql -f to create tables? Forget about line numbers. Add the -e option and your statements will show up in your output. Here is a sample (Unix) command line that I commonly use to run statements from a file: psql table -f in.file -e > out.file 2>&1 Now I can search the file for "ERROR" and see exactly what preceded it. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.