-- 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