Bugs with like_option in CREATE TABLE

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Bugs with like_option in CREATE TABLE
Date: 2015-09-09 23:51:48
Message-ID: CANu8Fiw16nem=UZ78yyeYt-8-vzTEaFiL4gOVhE5dPipGt0q9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

*O/S = Windows 10PostgreSQL 9.2.10, compiled by Visual C++ build 1600,
32-bit*
http://www.postgresql.org/docs/9.1/interactive/sql-createtable.html

and like_option is:

{ INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES | STORAGE |
COMMENTS | ALL }

*1. INCLUDING CONSTRAINTS does not bring over the Foreign Keys2. INCLUDING
ALL does not work and generates an ERROR;*

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2015-09-10 00:51:05 Re: Bugs with like_option in CREATE TABLE
Previous Message David G. Johnston 2015-09-09 23:19:06 Re: Any thoughts on a better approach to this query?