Error Message: ERROR: Attribute 'cursor' not found

From: "Aldo Tomasich" <aldo(dot)tomasich(at)et-spa(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Error Message: ERROR: Attribute 'cursor' not found
Date: 2003-09-24 09:32:14
Message-ID: ACEBLCODPJGJPNLKFHBIMEIECDAA.aldo.tomasich@et-spa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-09-24 09:56:51 Re: Aborted viewing operation
Previous Message Aldo Tomasich 2003-09-24 09:24:34 Error Message: ERROR: parser: parse error at or near "Desc"