Re: suggestions for tracking down syntax errors?

On Thursday 09 October 2003 13:15, Terrence Brannon wrote:
> I created a schema and piped it to psql but got an error message:
>
> ~/hacks/psql $ cat create.sql | psql test
> ERROR: table "country" does not exist
> ERROR: parser: parse error at or near ")" at character 91
> ERROR: table "customer" does not exist
> NOTICE: CREATE TABLE will create implicit sequence
> 'customer_customer_id_seq' for SERIAL column 'customer.customer_id'
>
> But I don't know exactly where character 91 is... a line number
> (including the comments in the file) would be more useful to me.

Try psql -f create.sql, or in psql \i create.sql - both should give you line
numbers.

Also, try not to post a new question by replying to an existing one. It can
make it difficult for people to notice your question.

--
Richard Huxton
Archonet Ltd