Re: strange plpgsql error

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.

In response to

Responses

Browse pgsql-general by date

  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