Re: no prompt in psql!!!

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: PGSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: no prompt in psql!!!
Date: 2006-05-29 13:57:48
Message-ID: 200605291357.k4TDvmP04124@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


We haven't made much progress on this lately, but the good news is that
I don't remember anyone reporting a problem for about a year, so I
figured it was fixed. I think it has to be assumed to be a buggy
terminal program.

---------------------------------------------------------------------------

Gurjeet Singh wrote:
> Hi,
>
> If I use mingw's rxvt.exe shell, I can't see any prompt in psql.
> In a message to -patches
> (http://archives.postgresql.org/pgsql-hackers-win32/2003-09/msg00019.php),
> Bruce said:
>
> The MinGW command console seems to have some problems with flushing
> output to the screen (no prompt, no errors display), but the same binary
> runs fine in CMD.EXE. We can look at that later.
>
> I don't know if this problem has been fixed! I am running Win2K.
> psql is running just fine from cmd.exe, and from the sh.exe run from
> within that!! Following are the sessions:
>
> >From MinGW:
>
> $ psql test postgres
> \set
> VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC
> gcc.exe (GCC) 3.4.2 (mingw-special)'
> AUTOCOMMIT = 'on'
> VERBOSITY = 'default'
> PROMPT1 = '%/%R%# '
> PROMPT2 = '%/%R%# '
> PROMPT3 = '>> '
> DBNAME = 'test'
> USER = 'postgres'
> PORT = '5432'
> ENCODING = 'SQL_ASCII'
> \q
>
> $
>
> >From CMD and sh within that:
>
> E:\Documents and Settings\Gurjeet>psql test postgres
> Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> Warning: Console code page (437) differs from Windows code page (1252)
> 8-bit characters may not work correctly. See psql reference
> page "Notes for Windows users" for details.
>
> test=# \set
> VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)'
> AUTOCOMMIT = 'on'
> VERBOSITY = 'default'
> PROMPT1 = '%/%R%# '
> PROMPT2 = '%/%R%# '
> PROMPT3 = '>> '
> DBNAME = 'test'
> USER = 'postgres'
> PORT = '5432'
> ENCODING = 'SQL_ASCII'
> test=# \q
>
> E:\Documents and Settings\Gurjeet>sh
> sh-2.04$ psql test postgres
> Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> Warning: Console code page (437) differs from Windows code page (1252)
> 8-bit characters may not work correctly. See psql reference
> page "Notes for Windows users" for details.
>
> test=# \set
> VERSION = 'PostgreSQL 8.2devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)'
> AUTOCOMMIT = 'on'
> VERBOSITY = 'default'
> PROMPT1 = '%/%R%# '
> PROMPT2 = '%/%R%# '
> PROMPT3 = '>> '
> DBNAME = 'test'
> USER = 'postgres'
> PORT = '5432'
> ENCODING = 'SQL_ASCII'
> test=# \q
> sh-2.04$
>
> Thanks in advance,
> Gurjeet.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Bruce Momjian http://candle.pha.pa.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2006-05-29 14:20:04 Re: Question Regarding DELETE FROM ONLY
Previous Message Michael Fuhr 2006-05-29 13:43:44 Re: Question Regarding DELETE FROM ONLY