SHOW, RESET require quotes, SET doesn't - Mailing list pgsql-hackers

From Michael Fuhr
Subject SHOW, RESET require quotes, SET doesn't
Date
Msg-id 20050824031801.GA32457@winnie.fuhr.org
Whole thread Raw
Responses Re: SHOW, RESET require quotes, SET doesn't  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
SHOW and RESET require quoting in cases where SET doesn't:

test=> SHOW plperl.use_strict;
ERROR:  syntax error at or near "." at character 12
LINE 1: SHOW plperl.use_strict;                  ^
test=> SHOW "plperl.use_strict";plperl.use_strict 
-------------------on
(1 row)

test=> SET plperl.use_strict TO off;
SET
test=> RESET plperl.use_strict;
ERROR:  syntax error at or near "." at character 13
LINE 1: RESET plperl.use_strict;                   ^
test=> RESET "plperl.use_strict";
RESET

I see in gram.y that SHOW and RESET take a ColId but SET takes a
var_name, which is ColId or var_name.ColId.  Is there a reason for
the inconsistency or is it just an oversight?

-- 
Michael Fuhr


pgsql-hackers by date:

Previous
From: Satoshi Nagayasu
Date:
Subject: Re: Pre-allocated free space for row updating (like PCTFREE)
Next
From: Tom Lane
Date:
Subject: Re: 8.1 release notes