Page 1 of 1

7-SQLSTATE =42601

PostPosted: Sat Apr 25, 2009 2:30 am
by docbom
Still using PT2 and finally converting to Postgres. Just downloaded 8.4 and when I go to convert my databases I get the following error on any database I choose:

Error creating table - DATAWINDOW_PREFS

7 - SQLSTATE = 42601
ERROR: syntax error at or near "window";
Error while executing the query

Any ideas on what might be causing this? Thanks.

Re: 7-SQLSTATE =42601

PostPosted: Sat Apr 25, 2009 6:47 am
by ptrack pat
You need to use either PostgreSQL 8.3 or 8.2. 8.4 is a beta and has never been tested with PT2.