Обсуждение: Parse errors

When using the DB Migration plugin to import Sql Server or Access dbs, I
consistently get errors similar to:

An error occured at: 2/2/03 5:51:37 PM:
-2147467259: ERROR:  parser: parse error at or near "varchar"

Is there a way in the current app to view a more verbose error (i.e., the
offending field or line, etc).

Additionally, is this a typical error?  Is there a typical fix ;-)?

Thanks,
John

> -----Original Message-----
> From: John Wells [mailto:jb@sourceillustrated.com]
> Sent: 02 February 2003 23:50
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Parse errors
>
>
> When using the DB Migration plugin to import Sql Server or
> Access dbs, I consistently get errors similar to:
>
> An error occured at: 2/2/03 5:51:37 PM:
> -2147467259: ERROR:  parser: parse error at or near "varchar"
>
> Is there a way in the current app to view a more verbose
> error (i.e., the offending field or line, etc).
>
> Additionally, is this a typical error?  Is there a typical fix ;-)?

Hi John,

Under Tools -> Options, switch the log level to Errors + SQL. That
should show what's going on in the logfile it generates.

Regards, Dave.