Обсуждение: Re: [SQL] Anyone recognise this error from PL/pgSQL?

Mark Dalphin <mdalphin@amgen.com> 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 ...
        regards, tom lane

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