Thread: Error Message

Error Message

From
"Ian"
Date:
<p><font face="Comic Sans MS" size="2">-- System Information --</font><p><font face="Comic Sans MS" size="2">Platform:
             Windows XP</font><br /><font face="Comic Sans MS" size="2">Version:                5.1</font><br /><font
face="ComicSans MS" size="2">Build:          2600 Service Pack 1</font><p><font face="Comic Sans MS" size="2">--
ApplicationInformation --</font><p><font face="Comic Sans MS" size="2">Name:           pgAdmin II</font><br /><font
face="ComicSans MS" size="2">Version:                1.5.60</font><br /><font face="Comic Sans MS" size="2">Descripton:
   </font><p><font face="Comic Sans MS" size="2">Name:           pgSchema</font><br /><font face="Comic Sans MS"
size="2">Version:               1.5.60</font><br /><font face="Comic Sans MS" size="2">Descripton:     PostgreSQL
SchemaObjects v1.5.60</font><p><font face="Comic Sans MS" size="2">-- Database Information --</font><p><font
face="ComicSans MS" size="2">Version:                7.3.3</font><br /><font face="Comic Sans MS" size="2">Descripton:
   PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3</font><p><font face="Comic Sans MS" size="2">-- Driver
Information--</font><p><font face="Comic Sans MS" size="2">Name:           PostgreSQL</font><br /><font face="Comic
SansMS" size="2">Version:                7.3.100</font><br /><font face="Comic Sans MS" size="2">Descripton:    
PostgreSQL7.3.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3</font><p><font face="Comic Sans MS" size="2">-- Error
Information--</font><p><font face="Comic Sans MS" size="2">Description:    ERROR:  Unable to identify an operator '='
fortypes 'integer[]' and 'integer'</font><br />        <font face="Comic Sans MS" size="2">You will have to retype this
queryusing an explicit cast</font><br /><font face="Comic Sans MS" size="2">Number:                
-2147467259</font><br/><font face="Comic Sans MS" size="2">Routine:                pgAdmin
II:frmTable.cmdOK_Click</font><p><fontface="Comic Sans MS"
size="2">************************************************************</font><p><fontface="Comic Sans MS"
size="2">Insertyour comment:</font> 

Re: Error Message

From
"Dave Page"
Date:
 
-----Original Message-----
From: Ian [mailto:ian@thewufamily.com]
Sent: 01 July 2003 17:47
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Error Message

Description:    ERROR:  Unable to identify an operator '=' for types 'integer[]' and 'integer'
        You will have to retype this query using an explicit cast
Number:                 -2147467259
Routine:                pgAdmin II:frmTable.cmdOK_Click

************************************************************

 

Hi Ian,

Can you switch logging to SQL + Errors under Tools -> Options, recreate the error and then send the logfile please?

Regards, Dave