Re: [SPAM]Re: Questions about 9.0 release note
Re: [SPAM]Re: Questions about 9.0 release note
От:
Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Дата:
"Robert Haas" wrote: > > * (seq_page_cost/(random_page_cost)) > > * EXCLUDE constraints has no tags to be linked. > > * "EXCLUDE constraints" is not indexed from the Index page. > CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE > CONSTRAINT ... EXCLUDE. Here is a patch to fix the documentation. For exclusion constraints, I added a tag "SQL-CREATETABLE-exclude" to of EXCLUDE in CREATE TABLE documentation. Also, "Exclusion constraints" section is added to the constraints doc. But the section is very short and just links to the CREATE TABLE doc. We could move some contents from CREATE TABLE to the constraints doc. Regards, --- Takahiro Itagaki NTT Open Source Software Center
Re: [SPAM]Re: Questions about 9.0 release note
От:
Bruce Momjian <bruce@momjian.us>
Дата:
Takahiro Itagaki wrote:
>
> "Robert Haas" wrote:
>
> > > * (seq_page_cost/(random_page_cost))
> > > * EXCLUDE constraints has no tags to be linked.
> > > * "EXCLUDE constraints" is not indexed from the Index page.
>
> > CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE
> > CONSTRAINT ... EXCLUDE.
>
> Here is a patch to fix the documentation.
>
> For exclusion constraints, I added a tag "SQL-CREATETABLE-exclude"
> to of EXCLUDE in CREATE TABLE documentation. Also,
> "Exclusion constraints" section is added to the constraints doc.
> But the section is very short and just links to the CREATE TABLE doc.
> We could move some contents from CREATE TABLE to the constraints doc.
I applied a clarified version of your submitted patch, attached.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v
retrieving revision 2.144
diff -c -c -r2.144 backup.sgml
*** doc/src/sgml/backup.sgml 22 Feb 2010 17:15:10 -0000 2.144
--- doc/src/sgml/backup.sgml 31 Mar 2010 23:34:20 -0000
***************
*** 604,614 ****
directory).
It is advisable to test your proposed archive command to ensure that it
indeed does not overwrite an existing file, and that it returns
! nonzero status in this case</>. We have found that cp -i</> does
! this correctly on some platforms but not others. If the chosen command
! does not itself handle this case correctly, you should add a command
! to test for existence of the archive file. For example, something
! like:
archive_command = 'test ! -f .../%f && cp %p .../%f'
--- 604,615 ----
directory).
It is advisable to test your proposed archive command to ensure that it
indeed does not overwrite an existing file, and that it returns
! nonzero status in this case</>. On many Unix platforms, cp
! -i</> causes copy to prompt before overwriting a file, and
! < /dev/null</> causes the prompt (and overwriting) to
! fail. If your platform does not support this behavior, you should
! add a command to test for the existence of the archive file. For
! example, something like:
archive_command = 'test ! -f .../%f && cp %p .../%f'
Re: [SPAM]Re: Questions about 9.0 release note
От:
Bruce Momjian <bruce@momjian.us>
Дата:
Takahiro Itagaki wrote:
>
> "Robert Haas" wrote:
>
> > > * (seq_page_cost/(random_page_cost))
> > > * EXCLUDE constraints has no tags to be linked.
> > > * "EXCLUDE constraints" is not indexed from the Index page.
>
> > CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE
> > CONSTRAINT ... EXCLUDE.
>
> Here is a patch to fix the documentation.
>
> For exclusion constraints, I added a tag "SQL-CREATETABLE-exclude"
> to of EXCLUDE in CREATE TABLE documentation. Also,
> "Exclusion constraints" section is added to the constraints doc.
> But the section is very short and just links to the CREATE TABLE doc.
> We could move some contents from CREATE TABLE to the constraints doc.
[ Apologies, proper patch now attached.]
I applied a clarified version of your submitted patch.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
diff -cprN head/doc/src/sgml/ddl.sgml work/doc/src/sgml/ddl.sgml
*** head/doc/src/sgml/ddl.sgml 2010-02-25 09:58:18.518068000 +0900
--- work/doc/src/sgml/ddl.sgml 2010-03-31 15:46:11.748532000 +0900
*************** CREATE TABLE order_items (
*** 845,850 ****
--- 845,880 ----
.
+
+
+ Exclusion constraints
+
+
+ exclusion constraint
+
+
+
+ constraint
+ exclusion
+
+
+
+ Exclusion constraints ensure that if any two rows are compared on
+ the specified columns or expressions using the specified operators,
+ at least one of these operator comparisons will be false. The syntax is:
+
+ CREATE TABLE circles (
+ c circle,
+ EXCLUDE USING gist (c WITH &&)
+ );
+
+
+
+
+ See also CREATE
+ TABLE ... CONSTRAINT ... EXCLUDE</> for details.
+
+
Re: [SPAM]Re: Questions about 9.0 release note
От:
Bruce Momjian <bruce@momjian.us>
Дата:
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> Bruce Momjian writes:
> >>> + Exclusion constraints ensure that if any two rows are compared on
> >>> + the specified columns or expressions using the specified operators,
> >>> + at least one of these operator comparisons will be false. The syntax is:
> >>
> >> Isn't that phrasing outright incorrect? Consider nulls.
>
> > Well, doesn't a comparison returning null really behave as false?
> > Should I reword it as "not true" or "false or null"?
>
> Either one.
I used "false or null".
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
Index: doc/src/sgml/ddl.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ddl.sgml,v
retrieving revision 1.91
diff -c -c -r1.91 ddl.sgml
*** doc/src/sgml/ddl.sgml 1 Apr 2010 01:18:17 -0000 1.91
--- doc/src/sgml/ddl.sgml 6 Apr 2010 02:13:57 -0000
***************
*** 861,867 ****
Exclusion constraints ensure that if any two rows are compared on
the specified columns or expressions using the specified operators,
! at least one of these operator comparisons will be false. The syntax is:
CREATE TABLE circles (
c circle,
--- 861,868 ----
Exclusion constraints ensure that if any two rows are compared on
the specified columns or expressions using the specified operators,
! at least one of these operator comparisons will return false or null.
! The syntax is:
CREATE TABLE circles (
c circle,
Re: [SPAM]Re: Questions about 9.0 release note
От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
