Re: pg 12 \if unwanted message - Mailing list pgsql-admin

P {margin-top:0;margin-bottom:0;}

Hi postgresql community,

I've this message "command ignored" on false in \if \else \endif. How can passthrough this ?

postgres@postgres# \echo :SERVER_VERSION_NAME

12.11 (Ubuntu 12.11-0ubuntu0.20.04.1)

postgres@postgres# \if 1 \echo 'ONE' \else \echo 'NOT ONE' \endif

ONE

\echo command ignored; use \endif or Ctrl-C to exit current \if block

postgres@postgres# \if 0 \echo 'ONE' \else \echo 'NOT ONE' \endif

\echo command ignored; use \endif or Ctrl-C to exit current \if block

NOT ONE

_________________________________

Cordialement, Pascal CROZET

DBA  - METANEXT, Think, Build, Run the Cloud

• www.metanext.com • 04 78 22 74 90

Hi Pascal,

This message only appears if you execute these statements one by one interactively. When reading them from a file, no hint regarding the open if branch is given.

Setting QUIET to 0 or client_min_messages to error doesn't suppress the messing in interactive mode, unfortunately.

Best Regards,

Holger

-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012