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