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@xxxxxxxxxxx
