[DOCS] CREATE TABLE LIKE
In postgresql-7.4.1-US.pdf, CREATE TABLE, Parameters, Like, Unlike INHERITS, the new table and inherited table ... ^ I don't understand this sentence (but english is not my language). Shouldn't it be? Unlike INHERITS, the new table and inherited columns ... __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [DOCS] CREATE TABLE LIKE
Patrick Samson <[EMAIL PROTECTED]> writes: > Unlike INHERITS, the new table and inherited table ... > ^ > I don't understand this sentence (but english is not > my language). It doesn't seem to have been the language of the author of that paragraph, either :-( I've cleaned this up to read Unlike INHERITS, the new table and original table are completely decoupled after creation is complete. Changes to the original table will not be applied to the new table, and it is not possible to include data of the new table in scans of the original table. and added this to the description of INHERITS, just below: Use of INHERITS creates a persistent relationship between the new child table and its parent table(s). Schema modifications to the parent(s) normally propagate to children as well, and by default the data of the child table is included in scans of the parent(s). regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] [SQL] special integrity constraints
On Mon, Mar 22, 2004 at 17:21:21 +0100, Erik Thiele <[EMAIL PROTECTED]> wrote: > > there is no such thing as a deferred check constraint: > > DEFERRABLE > NOT DEFERRABLE > > This controls whether the constraint can be deferred. A constraint that > is not deferrable will be checked immediately after every command. > Checking of constraints that are deferrable may be postponed until the > end of the transaction (using the SET CONSTRAINTS command). NOT > DEFERRABLE is the default. > > !!! Only foreign key constraints currently accept > this clause. All other constraint types are not deferrable. !!! Sorry, I checked the syntax for CREATE TABLE in the documentation and it shows DEFERRABLE as allowed on any column constraint. However, that is apparently not correct. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
