Re: pg_catalog.pg_get_viewdef pretty-print removes important parentheses

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Duncan Sands <duncan(dot)sands(at)deepbluecap(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: pg_catalog.pg_get_viewdef pretty-print removes important parentheses
Date: 2022-12-01 15:37:05
Message-ID: 1581700.1669909025@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Duncan Sands <duncan(dot)sands(at)deepbluecap(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2022-12-01 20:11:29 hashing bpchar for nondeterministic collations is broken
Previous Message Duncan Sands 2022-12-01 14:12:09 pg_catalog.pg_get_viewdef pretty-print removes important parentheses