On 12/8/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Rajesh Kumar Mallah" <mallah.rajesh@xxxxxxxxx> writes: > We connected psql 8.2.0 accidently to postmaster ver 8.1.5. > \d tablename does not work. > should psql at least warn like pg_dump does in case > of such client server version mismatches ? Um, did you read the banner? $ ~/version82/bin/psql -p 5581 regression Welcome to psql 8.2.0 (server 8.1.5), 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: You are connected to a server with major version 8.1, but your psql client is major version 8.2. Some backslash commands, such as \d, might not work properly.
Dear Sir, I am extremely sorry i was just going to apologize for the mistake. But i like the way pg_dump behaves , it refuses to work unless -i is specified. Actually my colleagues complained that \d is not working. I think they got the database prompt as they get everyday and did not notice the warning. ( even i missed to see the WARNING) Warm Regds mallah.
regression=# regards, tom lane