NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit4390b0b

committed

Add TEMP tables/indexes. Add COPY pfree(). Other cleanups.

1 parent7fc7551 commit4390b0bCopy full SHA for 4390b0b

File tree

69 files changed

+6841

-6497

lines changed

doc/src/sgml/ref
src
- Makefile.global.in
- backend
  - access
    - heap
      - hio.c
    - transam
      - xact.c
  - bootstrap
    - bootparse.y
  - catalog
  - commands
  - executor
  - nodes
  - parser
  - rewrite
    - rewriteHandler.c
  - storage
    - buffer
      - bufmgr.c
    - large_object
      - inv_api.c
  - tcop
    - postgres.c
  - utils
    - cache
    - init
      - enbl.c
    - sort
      - psort.c
- bin/psql
  - psqlHelp.h
- include
  - catalog
    - heap.h
  - nodes
    - parsenodes.h
  - optimizer
    - internal.h
  - utils
    - rel.h
    - temprel.h
- man
- pl/plpgsql/src
  - scan.c
- test/regress
- tools
  - make_ctags

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

69 files changed

+6841

-6497

lines changed

`‎doc/src/sgml/ref/copy.sgml`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -248,7 +248,7 @@ Specifies that output goes to a pipe or terminal.`
`248`	`248`	`</para>`
`249`	`249`	`<para>`
`250`	`250`	`The backslash character has other special meanings. NULL attributes are`
`251`		`-output as "\N". A literal backslash character isoutput as two`
	`251`	`+represented as "\N". A literal backslash character isrepresented as two`
`252`	`252`	`consecutive backslashes ("\\"). A literal tab character is represented`
`253`	`253`	`as a backslash and a tab. A literal newline character is`
`254`	`254`	`represented as a backslash and a newline. When loading text data`

`‎doc/src/sgml/ref/create_table.sgml`

Lines changed: 13 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -18,7 +18,7 @@`
`18`	`18`	`<DATE>1998-09-11</DATE>`
`19`	`19`	`</REFSYNOPSISDIVINFO>`
`20`	`20`	`<SYNOPSIS>`
`21`		`-CREATE TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> (`
	`21`	`+CREATE[TEMP]TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> (`
`22`	`22`	`<REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> <REPLACEABLE CLASS="PARAMETER">type</REPLACEABLE>`
`23`	`23`	`[ NULL \| NOT NULL ] [ UNIQUE ] [ DEFAULT <REPLACEABLE CLASS="PARAMETER">value</REPLACEABLE> ]`
`24`	`24`	`[<REPLACEABLE>column_constraint_clause</REPLACEABLE> \| PRIMARY KEY } [ ... ] ]`
`@@ -38,6 +38,18 @@ CREATE TABLE <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> (`
`38`	`38`	`</TITLE>`
`39`	`39`	`<PARA>`
`40`	`40`
	`41`	`+ <VARLISTENTRY>`
	`42`	`+ <TERM>`
	`43`	`+ TEMP`
	`44`	`+ </TERM>`
	`45`	`+ <LISTITEM>`
	`46`	`+ <PARA>`
	`47`	`+The table is created unique to this session, and is`
	`48`	`+automatically dropped on session exit.`
	`49`	`+ </PARA>`
	`50`	`+ </LISTITEM>`
	`51`	`+ </VARLISTENTRY>`
	`52`	`+`
`41`	`53`	`<VARIABLELIST>`
`42`	`54`	`<VARLISTENTRY>`
`43`	`55`	`<TERM>`

`‎doc/src/sgml/ref/select.sgml`

Lines changed: 14 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,7 +19,7 @@ SELECT`
`19`	`19`	`<synopsis>`
`20`	`20`	`SELECT [ALL\|DISTINCT [ON <replaceable class="PARAMETER">column</replaceable>] ]`
`21`	`21`	`<replaceable class="PARAMETER">expression</replaceable> [ AS <replaceable class="PARAMETER">name</replaceable> ] [, ...]`
`22`		`- [ INTO [TABLE] <replaceable class="PARAMETER">new_table</replaceable> ]`
	`22`	`+ [ INTO [TEMP] [TABLE] <replaceable class="PARAMETER">new_table</replaceable> ]`
`23`	`23`	`[ FROM <replaceable class="PARAMETER">table</replaceable> [<replaceable class="PARAMETER">alias</replaceable> ] [, ...] ]`
`24`	`24`	`[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]`
`25`	`25`	`[ GROUP BY <replaceable class="PARAMETER">column</replaceable> [, ...] ]`
`@@ -64,6 +64,18 @@ SELECT [ALL\|DISTINCT [ON <replaceable class="PARAMETER">column</replaceable>] ]`
`64`	`64`	`</listitem>`
`65`	`65`	`</varlistentry>`
`66`	`66`
	`67`	`+ <VARLISTENTRY>`
	`68`	`+ <TERM>`
	`69`	`+ TEMP`
	`70`	`+ </TERM>`
	`71`	`+ <LISTITEM>`
	`72`	`+ <PARA>`
	`73`	`+The table is created unique to this session, and is`
	`74`	`+automatically dropped on session exit.`
	`75`	`+ </PARA>`
	`76`	`+ </LISTITEM>`
	`77`	`+ </VARLISTENTRY>`
	`78`	`+`
`67`	`79`	`<varlistentry>`
`68`	`80`	`<term>`
`69`	`81`	`<replaceable class="PARAMETER">new_table</replaceable>`
`@@ -599,7 +611,7 @@ Create a new table from an existing table or view`
`599`	`611`	`</refsynopsisdivinfo>`
`600`	`612`	`<synopsis>`
`601`	`613`	`SELECT [ ALL \| DISTINCT ] <replaceable class="PARAMETER">expression</replaceable> [ AS <replaceable class="PARAMETER">name</replaceable> ] [, ...]`
`602`		`- INTO [ TABLE ] <replaceable class="PARAMETER">new_table</replaceable> ]`
	`614`	`+ INTO [TEMP] [ TABLE ] <replaceable class="PARAMETER">new_table</replaceable> ]`
`603`	`615`	`[ FROM <replaceable class="PARAMETER">table</replaceable> [<replaceable class="PARAMETER">alias</replaceable>] [, ...] ]`
`604`	`616`	`[ WHERE <replaceable class="PARAMETER">condition</replaceable> ]`
`605`	`617`	`[ GROUP BY <replaceable class="PARAMETER">column</replaceable> [, ...] ]`

`‎doc/src/sgml/ref/set.sgml`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -363,7 +363,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`363`	`363`	`<listitem>`
`364`	`364`	`<para>`
`365`	`365`	`enables the genetic optimizer algorithm`
`366`		`- for statements with8 or more tables.`
	`366`	`+ for statements with6 or more tables.`
`367`	`367`	`</para>`
`368`	`368`	`</listitem>`
`369`	`369`	`</varlistentry>`
`@@ -406,7 +406,7 @@ SET TIME ZONE { '<REPLACEABLE CLASS="PARAMETER">timezone</REPLACEABLE>' \| LOCAL`
`406`	`406`	`</para>`
`407`	`407`	`<para>`
`408`	`408`	`This algorithm is on by default, which used GEQO for`
`409`		`-statements ofeight or more tables.`
	`409`	`+statements ofsix or more tables.`
`410`	`410`	`(See the chapter on GEQO in the Programmer's Guide`
`411`	`411`	`for more information).`
`412`	`412`	`</para>`

`‎src/Makefile.global.in`

Lines changed: 25 additions & 25 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,31 +7,31 @@`
`7`	`7`	`#`
`8`	`8`	`#`
`9`	`9`	`# IDENTIFICATION`
`10`		`-# $Header: /cvsroot/pgsql/src/Makefile.global.in,v 1.54 1998/11/29 05:30:14 tgl Exp $`
	`10`	`+# $Header: /cvsroot/pgsql/src/Makefile.global.in,v 1.55 1999/02/02 03:43:56 momjian Exp $`
`11`	`11`	`#`
`12`	`12`	`# NOTES`
`13`		`-# Essentially all Postgres make files include this file and use the`
`14`		`-# variables it sets.`
	`13`	`+# Essentially all Postgres make files include this file and use the`
	`14`	`+# variables it sets.`
`15`	`15`	`#`
`16`	`16`	`# To override the default setting, create a Makefile.custom in this`
`17`	`17`	`# directory and put your defines there. (Makefile.custom is included`
`18`	`18`	`# near the end of this file). Sometimes, a variable gets set in`
`19`	`19`	`# Makefile.global after Makefile.custom has been included, so you can't`
`20`	`20`	`# simply set that variable in Makefile.custom. In those cases, there is`
`21`		`-# often another variable (like CUSTOM_COPT) that you can set in`
	`21`	`+# often another variable (like CUSTOM_COPT) that you can set in`
`22`	`22`	`# Makefile.custom that influences the later setting of the true variable`
`23`	`23`	`# of interest (like CFLAGS) by Makefile.global.`
`24`	`24`	`#`
`25`	`25`	`#`
`26`		`-# If you change any of these defines you probably have to`
	`26`	`+# If you change any of these defines you probably have to`
`27`	`27`	`# make clean; make`
`28`		`-# since no dependencies are created for these. (of course you can`
	`28`	`+# since no dependencies are created for these. (of course you can`
`29`	`29`	`# be crafty and check what files really depend on them and just remake`
`30`	`30`	`# those).`
`31`		`-#`
`32`		`-# Before including this file, you must set the SRCDIR variable to the`
`33`		`-# path of the top of the Postgres source tree (the directory that`
`34`		`-# contains this file).`
	`31`	`+#`
	`32`	`+# Before including this file, you must set the SRCDIR variable to the`
	`33`	`+# path of the top of the Postgres source tree (the directory that`
	`34`	`+# contains this file).`
`35`	`35`	`#`
`36`	`36`	`#-------------------------------------------------------------------------`
`37`	`37`
`@@ -40,8 +40,8 @@`
`40`	`40`	`#`
`41`	`41`	`# CONFIGURATION SECTION`
`42`	`42`	`#`
`43`		`-# Following are settings pertaining to the postgres build and`
`44`		`-# installation.`
	`43`	`+# Following are settings pertaining to the postgres build and`
	`44`	`+# installation.`
`45`	`45`	`# of the port.`
`46`	`46`	`#`
`47`	`47`	`# Ignore BSD_SHLIB if you're not using one of the BSD ports. But if you`
`@@ -55,8 +55,8 @@ ELF_SYSTEM= @ELF_SYS@`
`55`	`55`
`56`	`56`	`LIBPQDIR:= $(SRCDIR)/interfaces/libpq`
`57`	`57`
`58`		`-# For convenience, POSTGRESDIR is where BINDIR, and LIBDIR`
`59`		`-# and other target destinations are rooted. Of course, each of these is`
	`58`	`+# For convenience, POSTGRESDIR is where BINDIR, and LIBDIR`
	`59`	`+# and other target destinations are rooted. Of course, each of these is`
`60`	`60`	`# changable separately.`
`61`	`61`	`POSTGRESDIR= @prefix@`
`62`	`62`
`@@ -73,7 +73,7 @@ LIBDIR= $(POSTGRESDIR)/lib`
`73`	`73`	`# This is the directory where IPC utilities ipcs and ipcrm are located`
`74`	`74`	`#`
`75`	`75`	`IPCS=@ipcs@`
`76`		`-IPCRM=@ipcrm@`
	`76`	`+IPCRM=@ipcrm@`
`77`	`77`
`78`	`78`	`# Where the man pages (suitable for use with "man") get installed.`
`79`	`79`	`POSTMANDIR= $(POSTGRESDIR)/man`
`@@ -91,7 +91,7 @@ ODBCINST= $(POSTGRESDIR)`
`91`	`91`
`92`	`92`	`##############################################################################`
`93`	`93`	`#`
`94`		`-# FEATURES`
	`94`	`+# FEATURES`
`95`	`95`	`#`
`96`	`96`	`# To disable a feature, comment out the entire definition`
`97`	`97`	`# (that is, prepend '#', don't set it to "0" or "no").`
`@@ -167,7 +167,7 @@ endif`
`167`	`167`
`168`	`168`	`##############################################################################`
`169`	`169`	`#`
`170`		`-# Installation.`
	`170`	`+# Installation.`
`171`	`171`	`#`
`172`	`172`	`# For many ports, INSTALL is overridden below.`
`173`	`173`	`INSTALL= @INSTALL@`
`@@ -181,7 +181,7 @@ INSTL_SHLIB_OPTS= @INSTL_SHLIB_OPTS@`
`181`	`181`	`##############################################################################`
`182`	`182`	`#`
`183`	`183`	`# For building shell scripts:`
`184`		`-#`
	`184`	`+#`
`185`	`185`	`# For many ports, these are overridden below.`
`186`	`186`
`187`	`187`	`# DASH_N is what we put before the text on an echo command when we don't`
`@@ -191,7 +191,7 @@ INSTL_SHLIB_OPTS= @INSTL_SHLIB_OPTS@`
`191`	`191`	`# you do echo "no newline after this\c".`
`192`	`192`
`193`	`193`	`DASH_N= @DASH_N@`
`194`		`-BACKSLASH_C= @BACKSLASH_C@`
	`194`	`+BACKSLASH_C= @BACKSLASH_C@`
`195`	`195`
`196`	`196`
`197`	`197`
`@@ -204,7 +204,7 @@ YFLAGS= @YFLAGS@`
`204`	`204`	`YACC= @YACC@`
`205`	`205`	`LEX= @LEX@`
`206`	`206`	`AROPT= @AROPT@`
`207`		`-CFLAGS= -I$(SRCDIR)/include -I$(SRCDIR)/backend @CPPFLAGS@ @CFLAGS@`
	`207`	`+CFLAGS= -I$(SRCDIR)/include -I$(SRCDIR)/backend @CPPFLAGS@ @CFLAGS@`
`208`	`208`	`CFLAGS_SL= @SHARED_LIB@`
`209`	`209`	`LDFLAGS= @LDFLAGS@ @LIBS@`
`210`	`210`	`DLSUFFIX= @DLSUFFIX@`
`@@ -245,25 +245,25 @@ INSTALL= $(CUSTOM_INSTALL)`
`245`	`245`	`endif`
`246`	`246`
`247`	`247`	`#`
`248`		`-# Flags for CC and LD.`
	`248`	`+# Flags for CC and LD.`
`249`	`249`
`250`	`250`	`##############################################################################`
`251`	`251`	`# COPT`
`252`	`252`	`#`
`253`		`-# COPT is for options that the sophisticated builder might want to vary`
	`253`	`+# COPT is for options that the sophisticated builder might want to vary`
`254`	`254`	`# from one build to the next, like options to build Postgres with debugging`
`255`		`-# information included. COPT is meant to be set on the make command line,`
	`255`	`+# information included. COPT is meant to be set on the make command line,`
`256`	`256`	`# for example with the command "make COPT=-g". The value you see set here`
`257`	`257`	`# is the default that gets used if the builder does not give a value for`
`258`	`258`	`# COPT on his make command.`
`259`	`259`	`#`
`260`		`-# There is a nonobvious relationship between -O (optimization) and`
	`260`	`+# There is a nonobvious relationship between -O (optimization) and`
`261`	`261`	`# -Werror (consider all warnings fatal). On some systems, if you don't`
`262`	`262`	`# optimize, you will always get some warnings because the system header`
`263`	`263`	`# files will include some unreferenced functions in the code. These are`
`264`	`264`	`# functions that are supposed to be inline, so there wouldn't ordinarily`
`265`	`265`	`# be an "unreferenced" problem, but if you don't enable optimization, no`
`266`		`-# inlining can happen, and hence the problem. Therefore, we include`
	`266`	`+# inlining can happen, and hence the problem. Therefore, we include`
`267`	`267`	`# if you override -O, you override -Werror as well.`
`268`	`268`	`#`
`269`	`269`	`# CUSTOM_COPT is something the user may set in Makefile.custom`

`‎src/backend/access/heap/hio.c`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Id: hio.c,v 1.15 1998/12/15 12:45:14 vadim Exp $`
	`10`	`+ * $Id: hio.c,v 1.16 1999/02/02 03:43:57 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -110,7 +110,7 @@ RelationPutHeapTupleAtEnd(Relation relation, HeapTuple tuple)`
`110`	`110`	`ItemIditemId;`
`111`	`111`	`Itemitem;`
`112`	`112`
`113`		`-if (!relation->rd_islocal)`
	`113`	`+if (!relation->rd_myxactonly)`
`114`	`114`	`LockRelation(relation,ExtendLock);`
`115`	`115`
`116`	`116`	`/*`
`@@ -158,7 +158,7 @@ RelationPutHeapTupleAtEnd(Relation relation, HeapTuple tuple)`
`158`	`158`	`elog(ERROR,"Tuple is too big: size %d",len);`
`159`	`159`	`}`
`160`	`160`
`161`		`-if (!relation->rd_islocal)`
	`161`	`+if (!relation->rd_myxactonly)`
`162`	`162`	`UnlockRelation(relation,ExtendLock);`
`163`	`163`
`164`	`164`	`offnum=PageAddItem((Page)pageHeader, (Item)tuple->t_data,`

`‎src/backend/access/transam/xact.c`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/access/transam/xact.c,v 1.29 1999/01/29 09:22:53 vadim Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/access/transam/xact.c,v 1.30 1999/02/02 03:44:00 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`*Transaction aborts can now occur two ways:`
`@@ -850,7 +850,7 @@ StartTransaction()`
`850`	`850`	`are created in the course of the transactions`
`851`	`851`	`they need to be destroyed properly at the end of the transactions`
`852`	`852`	`*/`
`853`		`-InitTempRelList();`
	`853`	`+InitNoNameRelList();`
`854`	`854`
`855`	`855`	`/* ----------------`
`856`	`856`	`*done with start processing, set current transaction`
`@@ -917,7 +917,7 @@ CommitTransaction()`
`917`	`917`	`AtCommit_Notify();`
`918`	`918`
`919`	`919`	`CloseSequences();`
`920`		`-DestroyTempRels();`
	`920`	`+DestroyNoNameRels();`
`921`	`921`	`AtEOXact_portals();`
`922`	`922`	`RecordTransactionCommit();`
`923`	`923`	`RelationPurgeLocalRelation(true);`
`@@ -984,7 +984,7 @@ AbortTransaction()`
`984`	`984`	`AtEOXact_portals();`
`985`	`985`	`RecordTransactionAbort();`
`986`	`986`	`RelationPurgeLocalRelation(false);`
`987`		`-DestroyTempRels();`
	`987`	`+DestroyNoNameRels();`
`988`	`988`	`AtAbort_Cache();`
`989`	`989`	`AtAbort_Locks();`
`990`	`990`	`AtAbort_Memory();`

`‎src/backend/bootstrap/bootparse.y`

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $Header: /cvsroot/pgsql/src/backend/bootstrap/bootparse.y,v 1.22 1999/01/21 22:48:04 momjian Exp $`
	`11`	`+ * $Header: /cvsroot/pgsql/src/backend/bootstrap/bootparse.y,v 1.23 1999/02/02 03:44:03 momjian Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -164,7 +164,8 @@ Boot_CreateStmt:`
`164`	`164`	`if (DebugMode)`
`165`	`165`	`puts("creating bootstrap relation");`
`166`	`166`	`tupdesc = CreateTupleDesc(numattr,attrtypes);`
`167`		`-reldesc = heap_create(LexIDStr($3), tupdesc);`
	`167`	`+reldesc = heap_create(LexIDStr($3), tupdesc,`
	`168`	`+false,false);`
`168`	`169`	`if (DebugMode)`
`169`	`170`	`puts("bootstrap relation created ok");`
`170`	`171`	`}`
`@@ -175,7 +176,7 @@ Boot_CreateStmt:`
`175`	`176`
`176`	`177`	`tupdesc = CreateTupleDesc(numattr,attrtypes);`
`177`	`178`	`id = heap_create_with_catalog(LexIDStr($3),`
`178`		`-tupdesc, RELKIND_RELATION);`
	`179`	`+tupdesc, RELKIND_RELATION,false);`
`179`	`180`	`if (!Quiet)`
`180`	`181`	`printf("CREATED relation %s with OID %d\n",`
`181`	`182`	`LexIDStr($3), id);`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit4390b0b

File tree

69 files changed

Some content is hidden

69 files changed

`‎doc/src/sgml/ref/copy.sgml`

`‎doc/src/sgml/ref/create_table.sgml`

`‎doc/src/sgml/ref/select.sgml`

`‎doc/src/sgml/ref/set.sgml`

`‎src/Makefile.global.in`

`‎src/backend/access/heap/hio.c`

`‎src/backend/access/transam/xact.c`

`‎src/backend/bootstrap/bootparse.y`

0 commit comments