Did you perhaps have foreign key constraints with an on delete
clause defined on a table that referenced this one? Postgres doesn't
currently check that the types are comparable before making the
constraint. I'm working on adding a check for that now.
Or for that matter, any other rules or triggers could do it.
On Fri, 15 Dec 2000, Luis Sousa wrote:
> I just trying to execute a simple query in a table to delete a simpe record
> or all of them, like:
>
> DELETE * FROM table;
>
> I have a schema of more or less 25 tables, that are created using a script.
> When i'm trying to use that table (and only happens in this table) when
> created by the script i receive the message below.
> The most strange is that i droped the table and i created again,
> maintaining the structure created with the script and i didn't had any
> problems !!!
>
> Best Regards
>
> Luis Sousa
>
>
> Stephan Szabo wrote:
>
> > What is the schema of the table involved and what are the queries you
> > are trying to run?
> >
> > Stephan Szabo
> > sszabo@bigpanda.com
> >
> > On Thu, 14 Dec 2000, Luis Sousa wrote:
> >
> > > I'm trying to delete all the records or only one record or insert one
> > > record in a table but
> > > i'm having this message:
> > > ERROR: Unable to identify an operator '=' for types 'int4' and 'text'
> > > You will have to retype this query using an explicit cast
> > >
> > > What's this means ???
> > >
> > > Thanks
> > >
> > > Luis Sousa
> > >
>