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