silence and failure of SQL commands - Mailing list pgsql-novice

From John Payne
Subject silence and failure of SQL commands
Date
Msg-id 003e01cc05df$fb0a8bc0$f11fa340$@edu
Whole thread Raw
Responses Re: silence and failure of SQL commands
List pgsql-novice

Sorry for getting defensive, and yes I think Leif’s suggestion is much better than mine.  A statistics program I use (R) has a simple and elegant solution: it drops the cursor one line and puts in a “+” sign.  For example, here I enter the command “read” at the command prompt (>), and then forget to close the parenthesis:

 

> read(

+

 

That doesn’t solve the other potential problem, of forgetting to add the backslash to internal commands, or of putting a semicolon on them, but if I remember the error output was clearer in the latter case.

 

John

 

 

John Payne
POST Staff Scientist and US Coordinator
www.postcoml.org

Tel. (206) 463-3404

 

pgsql-novice by date:

Previous
From: "John Payne"
Date:
Subject: failure and silence of SQL commands
Next
From: Robert Poor
Date:
Subject: Re: silence and failure of SQL commands