Re: psql \l error - Mailing list pgsql-hackers

From SAKAIDA
Subject Re: psql \l error
Date
Msg-id 390E9D19280.E184SAKAIDA@smtp.psn.ne.jp
Whole thread Raw
In response to Re: psql \l error  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List pgsql-hackers
Peter Eisentraut <e99re41@DoCS.UU.SE> wrote:

> On Tue, 2 May 2000, Tom Lane wrote:
> 
> > I think there are some other small incompatibilities between 7.0 psql
> > and pre-7.0 servers anyway, so eliminating this one by dumbing down \l
> > is probably not the way to proceed.
> 
> The oidvector thing is essentially a show stopper for this.
 In my client software named PGBASH-2.1, I have dealt with "\l" 
compatibility problem as following.
query1= SELECT pg_database.datname ..        pg_encoding_to_char(pg_database.encoding) as \"Encoding\" ..
..query2=SELECT pg_database.datname ..        pg_database.encoding as \"Encoding\" ..        ..
 
 1. Make pset->quiet quiet mode. 2. Send query1. 3. Make pset->quiet original mode.  3. If error occurs then send
query2.

--
Regards,
SAKAIDA Masaaki  -- Osaka, Japan




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: shmem_seq may be a bad idea
Next
From: Peter Eisentraut
Date:
Subject: Re: When malloc returns zero ...