Bug #764: 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #764: 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments
Date
Msg-id 20020912094843.58817476B75@postgresql.org
Whole thread Raw
Responses Re: Bug #764: 7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tim Knowles (tim@ametco.co.uk) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
7.3b1 : SET gives misleading error information with non-valid option name and multiple arguments

Long Description
PostgrsqSQL 7.3b1

If you use SET with a non-valid option name and multiple arguments it gives a misleading error message suggesting that
thenon-valid option name is correct and can take only one argument. 

Sample Code
test=# set anythinyoulike=1;
ERROR:  'anythinyoulike' is not a valid option name

test=# set anythinyoulike=1,2;
ERROR:  SET anythinyoulike takes only one argument

No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Mats Lofkvist
Date:
Subject: Re: _bt_check_unique checks every row in table when doing update??
Next
From: Rod Taylor
Date:
Subject: Re: HELP