Error Message: ERROR: Attribute 'cursor' not found
От | Aldo Tomasich |
---|---|
Тема | Error Message: ERROR: Attribute 'cursor' not found |
Дата | |
Msg-id | ACEBLCODPJGJPNLKFHBIMEIECDAA.aldo.tomasich@et-spa.com обсуждение исходный текст |
Список | pgadmin-support |
-- System Information -- Platform: Windows 2000 Version: 5.0 Build: 2195 Service Pack 3 -- Application Information -- Name: pgAdmin II Version: 1.6.0 Descripton: Name: pgSchema Version: 1.6.0 Descripton: PostgreSQL Schema Objects v1.6.0 -- Database Information -- Version: 7.1.0 Descripton: PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 -- Driver Information -- Name: PostgreSQL Version: 7.3.100 Descripton: PostgreSQL 7.1 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 -- Error Information -- Description: ERROR: Attribute 'cursor' not found Number: -2147467259 Routine: pgAdmin II:frmSQLOutput.cmdSave_Click ************************************************************ Insert your comment: When compose a query if a column have a name equal to a reserved name, the double quote on attribute is omitted. SELECT count(*) AS count FROM "TableList" WHERE "Name" = 'label33' AND "Pos" = '2' AND Cursor = 'SELECT DISTINCT "Service" FROM "TempInb" WHERE "Service" <> \'\' AND "Dir" <> \'1\' AND "Type" = \'0\'' AND "FieldTable" = 'SonInField' AND "FieldCursor" = 'Service' AND "Subset" = 'INSERT INTO "TempInb" SELECT * FROM "Calls" WHERE "Start" >= $date1$ AND "Start" <= $date2$' AND "SubsetTable" = 'TempInb' AND "Busy" = '0' AND "Application" = '0' AND "CursorTable" = 'TempSIF' AND "SubsetTableCreate" = 'CREATE TABLE "TempInb" ( "ID" int4, "IDCallBack" int4, "Start" timestamp, "Stop" timestamp, "Wait" interval, "Talk" interval, "SourcePort" int2, "SourceChannel" int2, "DestPort" int2, "DestChannel" int2, "Manager" text, "NPcalling" text, "NPcalled" text, "ExtCalling" text, "ExtCalled" text, "Type" char(1), "Dir" char(1), "Transfer" char(1), "Service" text, "OPCalling" text, "OPCalled" text, "Tax" int4, "Delivered" bool, "Delayed" bool, "Diverted" char(1), "Connected" bool, "Distributed" bool);' AND "CursorTableCreate" = 'CREATE TABLE "TempSIF" ( "ID" int4, "IDCallBack" int4, "Start" timestamp, "Stop" timestamp, "Wait" interval, "Talk" interval, "SourcePort" int2, "SourceChannel" int2, "DestPort" int2, "DestChannel" int2, "Manager" text, "NPcalling" text, "NPcalled" text, "ExtCalling" text, "ExtCalled" text, "Type" char(1), "Dir" char(1), "Transfer" char(1), "Service" text, "OPCalling" text, "OPCalled" text, "Tax" int4, "Delivered" bool, "Delayed" bool, "Diverted" char(1), "Connected" bool, "Distributed" bool);' AND "Lang" = 'IT' 24/09/03 11.25.09 - Error in pgAdmin II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR: Attribute 'cursor' not found
В списке pgadmin-support по дате отправления: