no prompt in psql!!!

From: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
To: "PGSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: no prompt in psql!!!
Date: 2006-05-28 04:53:05
Message-ID: 65937bea0605272153t285e04c6p6d8a7e9cfaa232ab@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message P.M 2006-05-28 09:11:59 stored function and grant execute
Previous Message Chris Broussard 2006-05-28 04:13:58 Schema Limitations ?