[GENERAL] suggestions for tracking down syntax errors?

2003-10-09 Thread Terrence Brannon
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 se

[GENERAL] relation vs table...

2003-10-09 Thread Terrence Brannon
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when building the database: 3:ERROR: table "country" does not exist 6:ERROR: table "customer" does n