Re: Ocasional problems !!!!

I think i already discovered what's the problem !! At least the problem is not
happening again.

It was some problems in some triggers that are implementend in the database.

Anyway, i appreciatte all the time that you took with my problem

Best Regards

Luis Sousa

Stephan Szabo wrote:

> Actually, it's not going to matter since all foreign keys have a delete
> portion (realized after seeing your response) that checks to make sure
> the one you are deleting is not being referenced.
> I'm surprised you're not seeing this on inserts into the fk table or
> on updates to the pk table. What are the types of the columns on
> both tables?
>
> Stephan Szabo
> sszabo(at)bigpanda(dot)com
>
> On Mon, 18 Dec 2000, Luis Sousa wrote:
>
> > 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(at)bigpanda(dot)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
> >
> >
> >

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