Re: Ocasional problems !!!! - Mailing list pgsql-hackers
From | Luis Sousa |
---|---|
Subject | Re: Ocasional problems !!!! |
Date | |
Msg-id | 3A40D336.83DD5837@ualg.pt Whole thread Raw |
In response to | Re: Ocasional problems !!!! (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
List | pgsql-hackers |
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@bigpanda.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@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 > > > > > > -- Luis Sousa Tecnico Superior de Informatica Gabinete de Assessoria e Planeamento Universidade do Algarve
pgsql-hackers by date: