[HACKERS] Operator *=

[Luis Sousa]

Hello

I know that exists a script file for postgreSQL that have the operator *=
and others.

Where can I find that script ?

Thanks

Luis Sousa


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Ocasional problems !!!!

[Luis Sousa]

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
 [EMAIL PROTECTED]

 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
 [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:  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

Re: [HACKERS] Ocasional problems !!!!

[Luis Sousa]

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
   [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:  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