View Revisions: Issue #551

Summary 0000551: Some cases where now() is not rewritten in native replication mode
Revision 2019-10-08 15:27 by nagata
Description I found some cases where now() function in a query is not rewritten to a timestamp text in native replication mode.

1. CREATE TABLE tbl1 AS SELECT now();
2. SELECT now() INTO tbl2;
3.
WITH x AS (SELECT now()),
       ins AS ( INSERT INTO tbl3 SELECT * FROM x RETURNING 1)
SELECT;

These might be corner cases but users could issues such queries and I couldn't find any description about these restrictions in the documentation.
Revision 2019-10-08 15:22 by nagata
Description I found some cases where now() function in a query is not rewritten to a timestamp text in native replication mode.

1. CREATE TABLE tbl1 AS SELECT now();
2. SELECT now() INTO tbl2;
3.
WITH x AS (SELECT now()),
       ins AS ( INSERT INTO tbl3 SELECT * FROM x RETURNING 1)
SELECT;

These might be conner cases but users could issues such queries and I couldn't find any description about these restrictions in the documentation.