Postgres Pro
Downloads
Home   >   mailing lists

Thread: psql is broken in 8.4

psql is broken in 8.4

From
Zdenek Kotala
Date:
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 7832742



See the garbage at the end.
    Zdenek

Re: psql is broken in 8.4

From
Heikki Linnakangas
Date:
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

Re: psql is broken in 8.4

From
Zdenek Kotala
Date:
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

Re: psql is broken in 8.4

From
Zdenek Kotala
Date:
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