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.kla...@aklaver.com


Reply via email to