Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group