Re: Ocasional problems !!!! - Mailing list pgsql-hackers

From Luis Sousa
Subject Re: Ocasional problems !!!!
Date
Msg-id 3A39E553.8088ECF8@ualg.pt
Whole thread Raw
In response to Re: Ocasional problems !!!!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: Ocasional problems !!!!  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
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
> >



pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: Why vacuum?
Next
From: Luis Sousa
Date:
Subject: Re: Ocasional problems !!!!