SHOW, RESET require quotes, SET doesn't

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SHOW, RESET require quotes, SET doesn't
Date: 2005-08-24 03:18:01
Message-ID: 20050824031801.GA32457@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2005-08-24 03:47:55 Work-in-progress referential action trigger timing patch
Previous Message Satoshi Nagayasu 2005-08-24 02:06:03 Re: Pre-allocated free space for row updating (like PCTFREE)