Skip site navigation (1) Skip section navigation (2)

Re: Trigger problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jreniz <jreniz(at)tutopia(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Trigger problem
Date: 2001-03-18 20:37:41
Message-ID: 25641.984947861@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-docspgsql-generalpgsql-hackerspgsql-interfacespgsql-sql
jreniz <jreniz(at)tutopia(dot)com> writes:
> So, when I run this trigger there is a mistake:
>  ''there is no operator '=$' for types 'int4' and 'int4'

> (My system is 6.5.3)

This is an old bug.  Update to 7.0.3.

It might work to add spaces around the '=' signs in your trigger
function, but an update would be a good idea anyway.

			regards, tom lane

In response to

pgsql-docs by date

Next:From: willy lubambaDate: 2001-03-19 02:54:03
Subject: unsubscribe
Previous:From: Björn LundinDate: 2001-03-18 20:23:20
Subject: Error in programer's guide JDBC chap 23

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-03-18 20:52:03
Subject: Re: Allowing WAL fsync to be done via O_SYNC
Previous:From: Peter EisentrautDate: 2001-03-18 20:21:53
Subject: Re: Re: Beta6 for Tomorrow

pgsql-general by date

Next:From: Peter EisentrautDate: 2001-03-18 20:41:51
Subject: Re:
Previous:From: Peter EisentrautDate: 2001-03-18 20:19:24
Subject: Re: simple question regarding the building of psql

pgsql-interfaces by date

Next:From: Althaf HussainDate: 2001-03-19 02:36:37
Subject: need help to communicate from applet to servlet
Previous:From: Tom LaneDate: 2001-03-17 21:58:25
Subject: Re: Problem building PL/Perl

pgsql-sql by date

Next:From: Grant FurickDate: 2001-03-18 23:56:17
Subject: hierarchical order equivalent
Previous:From: David OlbersenDate: 2001-03-18 18:42:57
Subject: Re: Select very slow...

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group