Re: BUG #6043: Compilation PLpgsql Succesful but execution bad - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #6043: Compilation PLpgsql Succesful but execution bad
Date
Msg-id BANLkTi=5bNwqJguQxzGLQNB9GD_WVp=Tng@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6043: Compilation PLpgsql Succesful but execution bad  (Emanuel Calvo <postgres.arg@gmail.com>)
List pgsql-bugs
2011/5/28 Emanuel Calvo <postgres.arg@gmail.com>:
>>>
>>> Thanks Heikki for your fast response! ^^
>>>
>>>
>>>> The compiler would have to determine that the loop never ends, or it
>>>> would complain that there's no RETURN at the end.
>>>>
>>>> Many compilers for other languages do that kind of analysis, but it
>>>> usually only results in a warning, and compilers sometimes get that
>>>> wrong. I don't think it's worthwhile to do that, but of course, patches
>>>> are welcome.
>>>>
>>>
>>> Yeah, it's not a very big concern, althougth cold be taken for future
>>> improvements
>>> in plpgsql. I very far for submit a patch :P
>>>
>>
>> The deep check of embedded SQL is not possible in PL/pgSQL - =C2=A0this
>> remove dependency between PL/pgSQL and database objects. Deeper checks
>> mean a broken compatibility :(.
>>
>
> Good point.
>
>> PL/PSM has different philosophy where full check is implemented now.
>>
>
> Do you think that make some test in 9.1 =C2=A0worthwhile for this
> language? I see that the last contrib was submitted years ago.
>

I worked on new implementation called PL/PSM - but it is not mature.
It should to work with 9.1.

https://github.com/okbob/plpsm0

all features https://github.com/okbob/plpsm0/blob/master/test.sql are
supported, but there are no real project that is based on this
language now.

Regards

Pavel Stehule

> Regards,
>
>
> --
> --
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Emanuel Calvo
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Helpame.com
>

pgsql-bugs by date:

Previous
From: Emanuel Calvo
Date:
Subject: Re: BUG #6043: Compilation PLpgsql Succesful but execution bad
Next
From: Greg Sabino Mullane
Date:
Subject: Failed pgbench: setrandom invalid maximum number 0