Re: psql is broken in 8.4

Hi all,

last version of psql is broken:

psql (8.4beta1, server 8.3.7)
WARNING: psql version 8.4, server version 8.3.
Some psql features might not work.
Type "help" for help.

postgres=# \d test
ERROR: syntax error at or near ","
LINE 1: ...index, relhasrules, reltriggers <> 0, relhasoids, ,'',
relta...
^
It should work. I think describeTableDetails() does not have something
like: if (pset.sversion >= 80100) ...

Another problem is with resultset. When I run for example following
command I got this output:

postgres=# select oid from pg_am;
oid
------
403
405
783
2742


See the garbage at the end.

Zdenek

Zdenek Kotala wrote:
> last version of psql is broken:
>
> psql (8.4beta1, server 8.3.7)
> WARNING: psql version 8.4, server version 8.3.
> Some psql features might not work.
> Type "help" for help.
>
> postgres=# \d test
> ERROR: syntax error at or near ","
> LINE 1: ...index, relhasrules, reltriggers <> 0, relhasoids, ,'',
> relta...
> ^
> It should work. I think describeTableDetails() does not have something
> like: if (pset.sversion >= 80100) ...

I fixed this a while ago:

revision 1.211
date: 2009/05/04 17:31:35; author: heikki; state: Exp; lines: +2 -2
Fix the query used for \d against 8.2 and 8.3 servers.

Should work with a fresh checkout.

> Another problem is with resultset. When I run for example following
> command I got this output:
>
> postgres=# select oid from pg_am;
> oid
> ------
> 403
> 405
> 783
> 2742
> 

That's odd. Work for me. Can you try to debug that, please?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Heikki Linnakangas píše v čt 21. 05. 2009 v 16:53 +0300:
> Zdenek Kotala wrote:
> > last version of psql is broken:
> >
> > psql (8.4beta1, server 8.3.7)
> > WARNING: psql version 8.4, server version 8.3.
> > Some psql features might not work.
> > Type "help" for help.
> >
> > postgres=# \d test
> > ERROR: syntax error at or near ","
> > LINE 1: ...index, relhasrules, reltriggers <> 0, relhasoids, ,'',
> > relta...
> > ^
> > It should work. I think describeTableDetails() does not have something
> > like: if (pset.sversion >= 80100) ...
>
> I fixed this a while ago:
>
> revision 1.211
> date: 2009/05/04 17:31:35; author: heikki; state: Exp; lines: +2 -2
> Fix the query used for \d against 8.2 and 8.3 servers.
>
> Should work with a fresh checkout.

Yeah, thanks. It works with beta2.

> > Another problem is with resultset. When I run for example following
> > command I got this output:
> >
> > postgres=# select oid from pg_am;
> > oid
> > ------
> > 403
> > 405
> > 783
> > 2742
> > 
>
> That's odd. Work for me. Can you try to debug that, please?

I will look on it.

Zdenek

Heikki Linnakangas píše v čt 21. 05. 2009 v 16:53 +0300:
> Zdenek Kotala wrote:

>
> > Another problem is with resultset. When I run for example following
> > command I got this output:
> >
> > postgres=# select oid from pg_am;
> > oid
> > ------
> > 403
> > 405
> > 783
> > 2742
> > 
>
> That's odd. Work for me. Can you try to debug that, please?
>

We looked on it with Peter and it is problem with plural translation of
rows for Czech language. I'm going to fix it.

Zdenek