Re: CREATE FOREGIN TABLE LACUNA

On Tue, Mar 13, 2012 at 08:24:47AM -0700, David Fetter wrote:
> Folks,
> 
> This is for 9.3, of course.
> 
> I noticed that CREATE FOREIGN TABLE (LIKE some_table) doesn't work.  I
> believe it should, as it would:
> 
> - Remove a POLA violation
> - Make data loading into an extant table even easier, especially if
>   there need to be filtering or other cleanup steps
> 
> Come to think of it, which CREATE TABLE options are inappropriate to
> CREATE FOREIGN TABLE?
> 
> Cheers,
> David.

Here's a WIP patch (lots of cut/paste, no docs, no tests), but it does
work.  Still to do in addition: decide whether ALTER FOREIGN TABLE
should also handle LIKE.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate