Thread: Error Message: ERROR: Attribute 'cursor' not found

Error Message: ERROR: Attribute 'cursor' not found

From
"Aldo Tomasich"
Date:
-- 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



Re: Error Message: ERROR: Attribute 'cursor' not found

From
"Hiroshi Saito"
Date:
Dear Aldo.

Though it is a reservation word, you must be able to use it with QUOTE.
Do you apply this patch, and can you try it?
See my last pgadmin-support mail.
This patch overlaps.

frank will apply it soon.
Or Dave.

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Aldo Tomasich" <aldo.tomasich@et-spa.com>


(snip)
> -- 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.
(snip)
> II:frmSQLOutput.cmdSave_Click: -2147467259 - ERROR:  Attribute 'cursor' not
> found