Re: pgadmin III: query builder

Hi Marc,

I believe I have fixed this - can I email you an updated .exe?

Regards, Dave.

> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla(at)mgvd(dot)be]
> Sent: 16 June 2003 10:23
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: [pgadmin-hackers] pgadmin III: query builder
>
>
> Dave Page wrote:
>
> >
> >>-----Original Message-----
> >>From: Marc Cuypers [mailto:mozilla(at)mgvd(dot)be]
> >>Sent: 16 June 2003 10:14
> >>To: pgadmin-hackers(at)postgresql(dot)org
> >>Subject: [pgadmin-hackers] pgadmin III: query builder
> >>
> >>
> >>Hi,
> >>
> >>I'm using pgadmin III (windows XP) with pgsql 7.3.3 (linux
> >>debian 3) as
> >>backend.
> >>
> >>When I try to add a table (query builder/tools/add a table)
> I get the
> >>following error message:
> >> ' ERROR: parser: parser error at or neqr "a" at character 201'
> >>
> >>Am I doing something wrong?
> >
> >
> > Probably not - it's alpha software :-)
> >
> > Can you switch on logging to Errors & SQL under File -> Options ->
> > Logging, recreate the error and send us the logfile please?
> >
> > Cheers, Dave.
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> >
> last lines in the logfile:
> 2003-06-16 11:16:03 ERROR : ERROR: parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:16:05 ERROR : ERROR: parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:19:48 QUERY : Set query (test:5432): SELECT a.relname
> FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace
> WHERE nspname
> <> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
> 'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='r' ORDER BY
> lower(a.relname)
> 2003-06-16 11:19:48 ERROR : ERROR: parser: parse error at
> or near "a"
> at character 201
>
> 2003-06-16 11:19:51 QUERY : Set query (test:5432): SELECT a.relname
> FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace
> WHERE nspname
> <> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
> 'pg_temp_%' ) b ON a.relnamespace = b.oidWHERE a.relkind='v' ORDER BY
> lower(a.relname)
> 2003-06-16 11:19:51 ERROR : ERROR: parser: parse error at
> or near "a"
> at character 201
>
>
>
> --
> Best regards,
>
> M.
>
>