Hello,
CREATE TABLE test (
id INT,
create_time TIMESTAMPTZ DEFAULT now(),
update_time TIMESTAMPTZ DEFAULT now());
With a table like this, users often want the update_time to automatically update
to the current timestamp when executing an UPDATE statement, without having to
exp
Hello,
Thank you for your response.
We encountered a scenario where orphaned temporary views are preventing DDL
operations on a table, such as "ALTER TABLE xxx ALTER COLUMN xxx TYPE xxx." The
corresponding error message is "ERROR: cannot alter type of a column used by a
view or rule."
In this case
Hello,
I have discovered a peculiar issue: after creating a temporary view, if the
backend process exits abnormally, the temporary view is not cleaned up. However,
if a temporary table is created and the backend process exits abnormally, the
temporary table is cleaned up.
After reviewing the code,
