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