Re: [HACKERS] Re: [SQL] Anyone recognise this error from PL/pgSQL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Mark Dalphin <mdalphin(at)amgen(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [SQL] Anyone recognise this error from PL/pgSQL?
Date: 1999-08-14 15:30:24
Message-ID: 7762.934644624@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>>>> And this is the error I get when I try to insert anything, regardless
>>>> of whether the foreign key exists or not:
>>>> ERROR: There is no operator '=$' for types 'int4' and 'int4'
>> I see it too. Looks like a bug ...

> I seem to have lost this thread.

Sorry, it was over in pgsql-sql (and probably should have been in BUGS).
I just wanted to draw attention to it in the hackers list.

> But in case it hasn't been suggested,
> try putting a space between the equals sign and the dollar sign...

There isn't any '$' anywhere in his function ... plpgsql is dropping the
ball somehow.

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Hub.Org News Admin 1999-08-14 23:19:31
Previous Message Thomas Lockhart 1999-08-14 15:26:37 Re: [HACKERS] Re: [SQL] Anyone recognise this error from PL/pgSQL?