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:
> Actu
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 a
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
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 tri
But i'm not making any compare.
I just wrote delete from table; and i receive that message.
>>
>> Hmm. We will need to know more about your setup, since a simple
>>
>> delete from table;
>>
>> in psql does not involve *any* comparisons, and should never provoke the
>> message you are
I received that message working directly in psql.
I already send another email, please see.
Regards
Luis Sousa
Thomas Lockhart wrote:
> > But i'm not making any compare.
> > I just wrote delete from table; and i receive that message.
>
> Hmm. We will need to know more about your setup, since
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 recei
What is the schema of the table involved and what are the queries you
are trying to run?
Stephan Szabo
[EMAIL PROTECTED]
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: U
> 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
Without knowing your schema and query, we can't tell you exactly. But
your query is trying to compare a string to an integer, whi
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
10 matches
Mail list logo