DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
	b=bZKqJH6PeqBEUVfbhYIvXjZPgBmy8ZL4QKxSYiK+EVHAVSZB+tnaU+1lTn631LIGoM8LOXa8qtGpxJJ4mx6Y+WtHfV9GwbjDnvIfWnEfsYel8+YT/X/b9intaQPkDO158++/nqQGPvVLN7kf2OZlxRbj03DqozzMlCiY6vSlc2E=
Message-ID: <f9870c0104121219434b1e6e21@mail.gmail.com>
Date: Sun, 12 Dec 2004 22:43:16 -0500
From: Alex Beamish <talexb@gmail.com>
Reply-To: Alex Beamish <talexb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: parse error at or near "(" -- Huh???
In-Reply-To: <20041213021800.GB67661@winnie.fuhr.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <f9870c010412091219495dbb8e@mail.gmail.com>
	<20041213021800.GB67661@winnie.fuhr.org>

On Sun, 12 Dec 2004 19:18:00 -0700, Michael Fuhr <mike@fuhr.org> wrote:
> On Thu, Dec 09, 2004 at 03:19:56PM -0500, Alex Beamish wrote:
> 
> > I'm getting a frustrating error
> >
> >   ERROR:  parser: parse error at or near "(" at character 201
> >
> > in a CREATE TABLE statement from an SQL script that I'm running from
> > within a Perl script. When I run the same script from the command
> > line, either as a regular user or as root, it works fine.
> 
> Your SQL statements ran fine for me, so please show us a small but
> complete Perl script that duplicates the problem.

Michael, Tom,

Thank you both for your responses .. I discovered that, while I was
editting what I thought was the running script, I was actually running
an earlier (wrong) version extracted a moment earlier from the version
control system, in a paralell directory. This became obvious when I
deleted the offending line and the error remained exactly the same.

However, I am intrigued to find out about the character offset that
appears in the error. How is that calculated? This would be useful
diagnostic information to have in the future.

Thanks!

Alex