From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Luis Sousa <llsousa(at)ualg(dot)pt> |
Cc: | pgsql-hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Ocasional problems !!!! |
Date: | 2000-12-15 17:17:47 |
Message-ID: | Pine.BSF.4.21.0012150915230.60011-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
> > >
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-12-15 17:23:19 | Re: Outer joins aren't working with views |
Previous Message | Vadim Mikheev | 2000-12-15 17:17:06 | Re: switching txlog file in 7.1beta |