Re: How to fix 0xC0000005 exception in Postgres 9.0

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Justin" <zzzzz(dot)graf(at)gmail(dot)com>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)2ndquadrant(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to fix 0xC0000005 exception in Postgres 9.0
Date: 2020-02-21 20:50:01
Message-ID: B596487D64604440ADD33427B31AC91C@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

>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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-02-21 21:24:01 Re: How to fix 0xC0000005 exception in Postgres 9.0
Previous Message Adrian Klaver 2020-02-21 20:44:36 Re: Error “cache lookup failed for function”