PSQL Syntax errors running PL/SQL scripts

From: "Oleg Konovalov" <okonovalov(at)sarnoff(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: PSQL Syntax errors running PL/SQL scripts
Date: 2004-07-22 13:54:16
Message-ID: 40FFC708.5970EC94@sarnoff.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I am trying to run SQL scripts creating schema in PSQL [PostgreSQL
7.4.3]
and getting tons of errors, mostly "syntax error at or near
character..."
Complains about CONSTRAINTS, Prompt, Set, Local, CREATE, '(', ')' ,...
Also many errors "relation ... already exists"
[I guess, if DROP failed]

My script runs fine with Oracle 8i/9i.

Is PostgreSQL so much different from PL/SQL ?

Any good syntax reference for PostgreSQL ?

Thank you in advance,
Oleg.

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Browne 2004-07-22 14:42:44 Re: LIKE on index not working
Previous Message Stephan Szabo 2004-07-22 13:52:25 Re: next integer in serial key