Re: Ocasional problems !!!!

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
> > >
>