Can't view data/execute SQL on tables in schemas (7.3) with quote d names

From: Murthy Kambhampaty <murthy(dot)kambhampaty(at)goeci(dot)com>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Can't view data/execute SQL on tables in schemas (7.3) with quote d names
Date: 2002-12-10 16:31:03
Message-ID: 2D92FEBFD3BE1346A6C397223A8DD3FC0920C3@THOR.goeci.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I am using postgresql 7.3 and pgAdmin II v1.4.2. When I try to execute SQL
to screen or view data, with quoted schema identifiers (e.g., "TestSchema"),
I get the following error:

"12/10/2002 11:26:57 - Error in pgAdmin II:frmSQLOutput.Display: 5 - Invalid
procedure call or argument"

This error does not appear if the schema name is not quoted (e.g.,
"executing select * from test_schema."TestTbl" to the screen works fine).

Thanks,
Murthy

Browse pgadmin-support by date

  From Date Subject
Next Message Tino Wildenhain 2002-12-10 20:43:16 Unicode in PGAdmin
Previous Message Julio Mendoza 2002-12-10 16:12:50 pgadmin 1.4.3 postgreqsl 7.3