Re: pg 12 \if unwanted message

Holger Jakobs <holger@xxxxxxxxxx> · Fri, 29 Jul 2022 12:38:47 +0200



    Am 28.07.22 um 16:45 schrieb Pascal
      CROZET:

    
        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
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature