From: | Ronan Dunklau <ronan(dot)dunklau(at)dalibo(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: IMPORT FOREIGN SCHEMA statement |
Date: | 2014-07-07 12:00:27 |
Message-ID: | 4850817.cuqnKY7HUU@ronan.dunklau.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Le lundi 7 juillet 2014 07:58:33 Robert Haas a écrit :
> On Mon, May 26, 2014 at 12:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> writes:
> >> In addition to data type mapping questions (which David already raised)
> >> I have one problem when I think of the Oracle FDW:
> >>
> >> Oracle follows the SQL standard in folding table names to upper case.
> >> So this would normally result in a lot of PostgreSQL foreign tables
> >> with upper case names, which would be odd and unpleasant.
> >>
> >> I cannot see a way out of that, but I thought I should mention it.
> >
> > It seems like it would often be desirable for the Oracle FDW to smash
> > all-upper-case names to all-lower-case while importing, so that no quoting
> > is needed on either side. I doubt though that this is so desirable that
> > it should happen unconditionally.
> >
> > Between this and the type-mapping questions, it seems likely that
> > we're going to need a way for IMPORT FOREIGN SCHEMA to accept
> > user-supplied control options, which would in general be specific
> > to the FDW being used. (Another thing the SQL committee failed to
> > think about.)
>
> Is this part of the SQL standard? What is it defined to do about
> non-table objects?
The OPTIONS clause is not part of the SQL Standard.
Regarding non-table objects, the standard only talks about tables, and nothing
else.
--
Ronan Dunklau
http://dalibo.com - http://dalibo.org
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2014-07-07 12:20:52 | Re: "RETURNING PRIMARY KEY" syntax extension |
Previous Message | Robert Haas | 2014-07-07 11:58:33 | Re: IMPORT FOREIGN SCHEMA statement |