Re: Ocasional problems !!!!

I really have constraints of foreign keys but not on delete, only on update

Stephan Szabo wrote:

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

--
Luis Sousa
Tecnico Superior de Informatica
Gabinete de Assessoria e Planeamento
Universidade do Algarve