Re: no prompt in psql!!!

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. +