tighten generic_option_name, or store more carefully in catalog? - Mailing list pgsql-hackers

From Chapman Flack
Subject tighten generic_option_name, or store more carefully in catalog?
Date
Msg-id 6830EB30.8090904@acm.org
Whole thread Raw
List pgsql-hackers
Hi,

generic_option_name is a ColLabel, therefore a fully general SQL identifier.

But a command like CREATE FOREIGN DATA WRAPPER w ... OPTIONS ("a=b" 'c=d')
stores {a=b=c=d} in fdwoptions, from which the original intent can't be
recovered.

Should generic_option_name be restricted to be a regular identifier,
or allowed to be a delimited identifier but with = forbidden within it,
or should it be represented as delimited in the catalog when necessary
so it can be recovered faithfully?

SQL rules would also make its case-sensitivity dependent on faithfully
recovering whether it was delimited or not.

Regards,
-Chap



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Next
From: Michael Paquier
Date:
Subject: Re: Retiring some encodings?