Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_catalog.pg_get_viewdef pretty-print removes important parentheses - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_catalog.pg_get_viewdef pretty-print removes important parentheses
Date
Msg-id 1581700.1669909025@sss.pgh.pa.us
Whole thread Raw
In response to pg_catalog.pg_get_viewdef pretty-print removes important parentheses  (Duncan Sands <duncan.sands@deepbluecap.com>)
List pgsql-bugs
Tree view 
Duncan Sands <duncan.sands@deepbluecap.com> writes:
> When pg_catalog.pg_get_viewdef is called with pretty-print enabled, it removes
> parentheses around (DATE + INTERVAL) in the construct "(DATE + INTERVAL) AT TIME
> ZONE TZ", outputting SQL that fails to parse.

So it does :-(.  Will fix, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Duncan Sands
Date:
Subject: pg_catalog.pg_get_viewdef pretty-print removes important parentheses
Next
From: Jeff Davis
Date:
Subject: hashing bpchar for nondeterministic collations is broken