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

1 files changed, 60 insertions, 60 deletions

diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql
index 5d1d773b05..2be9f021fc 100644
--- a/src/test/regress/sql/alter_table.sql
+++ b/src/test/regress/sql/alter_table.sql
@@ -1,60 +1,60 @@
 --
 -- add attribute
 --
-CREATE TABLE temp (initial int4);
+CREATE TABLE tmp (initial int4);
 
-ALTER TABLE temp ADD COLUMN a int4;
+ALTER TABLE tmp ADD COLUMN a int4;
 
-ALTER TABLE temp ADD COLUMN b name;
+ALTER TABLE tmp ADD COLUMN b name;
 
-ALTER TABLE temp ADD COLUMN c text;
+ALTER TABLE tmp ADD COLUMN c text;
 
-ALTER TABLE temp ADD COLUMN d float8;
+ALTER TABLE tmp ADD COLUMN d float8;
 
-ALTER TABLE temp ADD COLUMN e float4;
+ALTER TABLE tmp ADD COLUMN e float4;
 
-ALTER TABLE temp ADD COLUMN f int2;
+ALTER TABLE tmp ADD COLUMN f int2;
 
-ALTER TABLE temp ADD COLUMN g polygon;
+ALTER TABLE tmp ADD COLUMN g polygon;
 
-ALTER TABLE temp ADD COLUMN h abstime;
+ALTER TABLE tmp ADD COLUMN h abstime;
 
-ALTER TABLE temp ADD COLUMN i char;
+ALTER TABLE tmp ADD COLUMN i char;
 
-ALTER TABLE temp ADD COLUMN j abstime[];
+ALTER TABLE tmp ADD COLUMN j abstime[];
 
-ALTER TABLE temp ADD COLUMN k dt;
+ALTER TABLE tmp ADD COLUMN k dt;
 
-ALTER TABLE temp ADD COLUMN l tid;
+ALTER TABLE tmp ADD COLUMN l tid;
 
-ALTER TABLE temp ADD COLUMN m xid;
+ALTER TABLE tmp ADD COLUMN m xid;
 
-ALTER TABLE temp ADD COLUMN n oid8;
+ALTER TABLE tmp ADD COLUMN n oid8;
 
---ALTER TABLE temp ADD COLUMN o lock;
-ALTER TABLE temp ADD COLUMN p smgr;
+--ALTER TABLE tmp ADD COLUMN o lock;
+ALTER TABLE tmp ADD COLUMN p smgr;
 
-ALTER TABLE temp ADD COLUMN q point;
+ALTER TABLE tmp ADD COLUMN q point;
 
-ALTER TABLE temp ADD COLUMN r lseg;
+ALTER TABLE tmp ADD COLUMN r lseg;
 
-ALTER TABLE temp ADD COLUMN s path;
+ALTER TABLE tmp ADD COLUMN s path;
 
-ALTER TABLE temp ADD COLUMN t box;
+ALTER TABLE tmp ADD COLUMN t box;
 
-ALTER TABLE temp ADD COLUMN u tinterval;
+ALTER TABLE tmp ADD COLUMN u tinterval;
 
-ALTER TABLE temp ADD COLUMN v datetime;
+ALTER TABLE tmp ADD COLUMN v datetime;
 
-ALTER TABLE temp ADD COLUMN w timespan;
+ALTER TABLE tmp ADD COLUMN w timespan;
 
-ALTER TABLE temp ADD COLUMN x float8[];
+ALTER TABLE tmp ADD COLUMN x float8[];
 
-ALTER TABLE temp ADD COLUMN y float4[];
+ALTER TABLE tmp ADD COLUMN y float4[];
 
-ALTER TABLE temp ADD COLUMN z int2[];
+ALTER TABLE tmp ADD COLUMN z int2[];
 
-INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
+INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
 	v, w, x, y, z)
    VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 
         'Mon May  1 00:30:30 1995', 'c', '{Mon May  1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}', 
@@ -63,67 +63,67 @@ INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
 	'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
 	'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
 
-SELECT * FROM temp;
+SELECT * FROM tmp;
 
-DROP TABLE temp;
+DROP TABLE tmp;
 
 -- the wolf bug - schema mods caused inconsistent row descriptors 
-CREATE TABLE temp (
+CREATE TABLE tmp (
 	initial 	int4
 );
 
-ALTER TABLE temp ADD COLUMN a int4;
+ALTER TABLE tmp ADD COLUMN a int4;
 
-ALTER TABLE temp ADD COLUMN b name;
+ALTER TABLE tmp ADD COLUMN b name;
 
-ALTER TABLE temp ADD COLUMN c text;
+ALTER TABLE tmp ADD COLUMN c text;
 
-ALTER TABLE temp ADD COLUMN d float8;
+ALTER TABLE tmp ADD COLUMN d float8;
 
-ALTER TABLE temp ADD COLUMN e float4;
+ALTER TABLE tmp ADD COLUMN e float4;
 
-ALTER TABLE temp ADD COLUMN f int2;
+ALTER TABLE tmp ADD COLUMN f int2;
 
-ALTER TABLE temp ADD COLUMN g polygon;
+ALTER TABLE tmp ADD COLUMN g polygon;
 
-ALTER TABLE temp ADD COLUMN h abstime;
+ALTER TABLE tmp ADD COLUMN h abstime;
 
-ALTER TABLE temp ADD COLUMN i char;
+ALTER TABLE tmp ADD COLUMN i char;
 
-ALTER TABLE temp ADD COLUMN j abstime[];
+ALTER TABLE tmp ADD COLUMN j abstime[];
 
-ALTER TABLE temp ADD COLUMN k dt;
+ALTER TABLE tmp ADD COLUMN k dt;
 
-ALTER TABLE temp ADD COLUMN l tid;
+ALTER TABLE tmp ADD COLUMN l tid;
 
-ALTER TABLE temp ADD COLUMN m xid;
+ALTER TABLE tmp ADD COLUMN m xid;
 
-ALTER TABLE temp ADD COLUMN n oid8;
+ALTER TABLE tmp ADD COLUMN n oid8;
 
---ALTER TABLE temp ADD COLUMN o lock;
-ALTER TABLE temp ADD COLUMN p smgr;
+--ALTER TABLE tmp ADD COLUMN o lock;
+ALTER TABLE tmp ADD COLUMN p smgr;
 
-ALTER TABLE temp ADD COLUMN q point;
+ALTER TABLE tmp ADD COLUMN q point;
 
-ALTER TABLE temp ADD COLUMN r lseg;
+ALTER TABLE tmp ADD COLUMN r lseg;
 
-ALTER TABLE temp ADD COLUMN s path;
+ALTER TABLE tmp ADD COLUMN s path;
 
-ALTER TABLE temp ADD COLUMN t box;
+ALTER TABLE tmp ADD COLUMN t box;
 
-ALTER TABLE temp ADD COLUMN u tinterval;
+ALTER TABLE tmp ADD COLUMN u tinterval;
 
-ALTER TABLE temp ADD COLUMN v datetime;
+ALTER TABLE tmp ADD COLUMN v datetime;
 
-ALTER TABLE temp ADD COLUMN w timespan;
+ALTER TABLE tmp ADD COLUMN w timespan;
 
-ALTER TABLE temp ADD COLUMN x float8[];
+ALTER TABLE tmp ADD COLUMN x float8[];
 
-ALTER TABLE temp ADD COLUMN y float4[];
+ALTER TABLE tmp ADD COLUMN y float4[];
 
-ALTER TABLE temp ADD COLUMN z int2[];
+ALTER TABLE tmp ADD COLUMN z int2[];
 
-INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
+INSERT INTO tmp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
 	v, w, x, y, z)
    VALUES (4, 'name', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)', 
 	'Mon May  1 00:30:30 1995', 'c', '{Mon May  1 00:30:30 1995, Monday Aug 24 14:43:07 1992, epoch}',
@@ -132,9 +132,9 @@ INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
 	'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
 	'1/3', '1,name', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
 
-SELECT * FROM temp;
+SELECT * FROM tmp;
 
-DROP TABLE temp;
+DROP TABLE tmp;
 
 
 --