pgsql: Improve error message for misuse of TZ, tz, OF formatting patter

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve error message for misuse of TZ, tz, OF formatting patter
Date: 2017-02-20 15:27:53
Message-ID: E1cfpsX-0001mL-O7@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve error message for misuse of TZ, tz, OF formatting patterns.

Be specific about which pattern is being complained of, and avoid saying
"it's not supported in to_date", which is just confusing if the error is
actually coming out of to_timestamp. We can phrase it as "is only
supported in to_char", instead. Also, use the term "formatting field" not
"format pattern", because other error messages in the same file prefer that
terminology. (This isn't terribly consistent with the documentation, so
maybe we should change all these error messages?)

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1c073505e8e4fa8a03312fea714da25ab83cb5fa

Modified Files
--------------
src/backend/utils/adt/formatting.c | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2017-02-21 09:08:17 pgsql: Small correction to BRIN docs
Previous Message Tom Lane 2017-02-20 15:05:29 pgsql: Fix documentation of to_char/to_timestamp TZ, tz, OF formatting