From: | SunWuKung <Ralikwen(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: strange plpgsql error |
Date: | 2009-10-11 22:21:05 |
Message-ID: | 25848214.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yep,
it is probably a bug though.
Adrian Klaver wrote:
>
> On Sunday 11 October 2009 2:48:02 pm SunWuKung wrote:
>> Right,
>> I replace the table alias irq to instreq and the function works.
>> I don't know what could have been the problem: is irq a reserved word, or
>> it's because the table alias has the same name then the function name.
>>
>> Thanks for pointing me to the right direction.
>> SWK
>>
>
> It is not a reserved word
> (http://www.postgresql.org/docs/8.4/interactive/sql-keywords-appendix.html)
> My guess is it was the name conflict between the function name and the
> table
> alias.
>
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
View this message in context: http://www.nabble.com/strange-plpgsql-error-tp25847709p25848214.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-10-11 22:45:08 | Re: How to send multiple SQL commands from Python? |
Previous Message | Adrian Klaver | 2009-10-11 22:01:37 | Re: strange plpgsql error |