Re: How to fix 0xC0000005 exception in Postgres 9.0

On 2/21/20 12:50 PM, Andrus wrote:
> Hi!
> 
>> In psql what does \d tempestuous show?
>> What relation is andmetp to tempestuous?
> 
> I'm sorry, this was typo. Correct commands issued from application are
> 
> select drop_table('temptulemus');
> create temp table  temptulemus as select * from andmetp;
> select * from temptulemus  offset 0 limit 900;

Alright so what does:

\d temptulemus

and/or

\d andmetp

show?

> 
>> I thought you said you had problem with same table in Linux and 
>> Windows servers?
> 
> Yes.
> 
>> From above what does the drop_table() function do in?:
>> select drop_table(‘temptulemus’);
> 
> drop_table is defined as
> 
> CREATE OR REPLACE FUNCTION drop_table(TEXT)
>   RETURNS VOID STRICT LANGUAGE plpgsql AS $$
>     BEGIN
>     EXECUTE 'DROP TABLE ' || $1;
>     EXCEPTION WHEN UNDEFINED_TABLE THEN
>     RETURN;
>     END;
>     $$;
> 
> 
> Andrus.


-- 
Adrian Klaver
adrian.klaver@aklaver.com