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

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. But in case it hasn't been suggested,
try putting a space between the equals sign and the dollar sign...

- Thomas

--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California

Thomas Lockhart <lockhart@alumni.caltech.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