Обсуждение: Can't view data/execute SQL on tables in schemas (7.3) with quote d names

Поиск
Список
Период
Сортировка

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

От
Murthy Kambhampaty
Дата:
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