On Tue, 6 Dec, 2022, 4:17 pm Pavel Stehule, wrote:
> Hi
>
> for record - the problem was probably in using plpgsql_check together with
> PL debugger (plugin_debugger). Both extensions use the PLpgSQL DBG API, but
> this API is not designed to be used by more extensions. plpgsql_check has
>
Hi
for record - the problem was probably in using plpgsql_check together with
PL debugger (plugin_debugger). Both extensions use the PLpgSQL DBG API, but
this API is not designed to be used by more extensions. plpgsql_check has
implemented some workaround, but it should be loaded last if this
Hi
po 5. 12. 2022 v 15:22 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Hello Pavel,
>
> I have re installed it after upgrade as update option was not working.
>
> I could see the error in syslogs as error 4 in plpgsql_check.so and the
> databases are restarting.
>
1.
Hello Pavel,
I have re installed it after upgrade as update option was not working.
I could see the error in syslogs as error 4 in plpgsql_check.so and the
databases are restarting.
On Mon, 5 Dec, 2022, 5:51 pm Pavel Stehule, wrote:
>
>
> út 29. 11. 2022 v 17:28 odesílatel Pavel Stehule
>
út 29. 11. 2022 v 17:28 odesílatel Pavel Stehule
napsal:
>
>
> út 29. 11. 2022 v 16:37 odesílatel shashidhar Reddy <
> shashidharreddy...@gmail.com> napsal:
>
>> Plogsql check version is 2.2 and one more finding is before calling the
>> function if we drop and recreate the plpgsql_check
po 5. 12. 2022 v 11:24 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Is there any way to get the older version 1.1 of plpgsql_check to install
> it?
>
you can compile it from source code
https://github.com/okbob/plpgsql_check
there are complete history
Regards
Pavel
Am Mon, Dec 05, 2022 at 03:54:28PM +0530 schrieb shashidhar Reddy:
> Is there any way to get the older version 1.1 of plpgsql_check to install
> it?
Is there any way to get you to respect the kind requests to
follow this list's posting customs as expressed by the very
people you want to help you
Is there any way to get the older version 1.1 of plpgsql_check to install
it?
On Mon, 5 Dec, 2022, 1:36 pm Pavel Stehule, wrote:
>
>
> po 5. 12. 2022 v 8:42 odesílatel shashidhar Reddy <
> shashidharreddy...@gmail.com> napsal:
>
>> Pavel,
>>
>> Below is the back trace result
>>
>> libffi6-dbg
po 5. 12. 2022 v 8:42 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Pavel,
>
> Below is the back trace result
>
> libffi6-dbg libgcc1-dbg libkrb5-dbg libstdc++6-8-dbg libxml2-dbg
> postgresql-13-dbgsym postgresql-13-pldeb
> ugger-dbgsym zlib1g-dbg
>
I am sorry, I don't
Pavel,
Below is the back trace result
libffi6-dbg libgcc1-dbg libkrb5-dbg libstdc++6-8-dbg libxml2-dbg
postgresql-13-dbgsym postgresql-13-pldeb
ugger-dbgsym zlib1g-dbg
On Mon, Dec 5, 2022 at 11:28 AM Pavel Stehule
wrote:
> Hi
>
>
> po 5. 12. 2022 v 6:49 odesílatel shashidhar Reddy <
>
Hi
po 5. 12. 2022 v 6:49 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Pavel,
>
> Where can I get list-dbgsym-packages.sh script?
>
https://manpages.debian.org/testing/debian-goodies/find-dbgsym-packages.1.en.html
https://wiki.ubuntu.com/DebuggingProgramCrash
please,
Pavel,
Where can I get list-dbgsym-packages.sh script?
On Wed, Nov 30, 2022 at 10:04 AM Pavel Stehule
wrote:
>
>
> st 30. 11. 2022 v 5:28 odesílatel Pavel Stehule
> napsal:
>
>>
>>
>> st 30. 11. 2022 v 1:38 odesílatel shashidhar Reddy <
>> shashidharreddy...@gmail.com> napsal:
>>
>>> I have
st 30. 11. 2022 v 5:28 odesílatel Pavel Stehule
napsal:
>
>
> st 30. 11. 2022 v 1:38 odesílatel shashidhar Reddy <
> shashidharreddy...@gmail.com> napsal:
>
>> I have tried updating after upgrade but that wasn't working, so I have
>> dropped and recreated the extension.
>> Now it is crashing
st 30. 11. 2022 v 1:38 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> I have tried updating after upgrade but that wasn't working, so I have
> dropped and recreated the extension.
> Now it is crashing every time when we call the function.
>
what is version od
I have tried updating after upgrade but that wasn't working, so I have
dropped and recreated the extension.
Now it is crashing every time when we call the function.
On Tue, 29 Nov, 2022, 9:58 pm Pavel Stehule,
wrote:
>
>
> út 29. 11. 2022 v 16:37 odesílatel shashidhar Reddy <
>
út 29. 11. 2022 v 16:37 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Plogsql check version is 2.2 and one more finding is before calling the
> function if we drop and recreate the plpgsql_check extension there is no
> issue, but each time we can't drop and create.
>
Plogsql check version is 2.2 and one more finding is before calling the
function if we drop and recreate the plpgsql_check extension there is no
issue, but each time we can't drop and create.
On Tue, 29 Nov, 2022, 7:19 pm shashidhar Reddy, <
shashidharreddy...@gmail.com> wrote:
> Hello Pavel,
>
Hello Pavel,
This is the function causing the issue on all servers, and also i noticed
when I use *plpgsql_check_function *in any function I am facing the same
issue.
On Tue, Nov 29, 2022 at 6:43 PM Pavel Stehule
wrote:
> Hi
>
>
> út 29. 11. 2022 v 13:49 odesílatel shashidhar Reddy <
>
Hi
út 29. 11. 2022 v 13:49 odesílatel shashidhar Reddy <
shashidharreddy...@gmail.com> napsal:
> Hello,
>
> Recently we have upgraded postgres from version 12 to 13 and upgraded
> plpgsql_check
> to the latest version but after upgrade when calling the below function
> causing postgres
Hello,
Recently we have upgraded postgres from version 12 to 13 and upgraded
plpgsql_check
to the latest version but after upgrade when calling the below function
causing postgres restart .
CREATE OR REPLACE FUNCTION pro.po_check(
)
RETURNS void
LANGUAGE 'plpgsql'
COST 100
20 matches
Mail list logo