]> granicus.if.org Git - postgresql/log
postgresql
22 years agoRemove extra comma.
Peter Eisentraut [Thu, 25 Jul 2002 20:52:59 +0000 (20:52 +0000)]
Remove extra comma.

22 years agoImplement DROP CONVERSION
Tatsuo Ishii [Thu, 25 Jul 2002 10:07:13 +0000 (10:07 +0000)]
Implement DROP CONVERSION
Add regression test

22 years agoSecond phase of restructuring to add jdbc3 support.
Barry Lind [Wed, 24 Jul 2002 22:08:45 +0000 (22:08 +0000)]
Second phase of restructuring to add jdbc3 support.

22 years agoRemove _deadcode.
Peter Eisentraut [Wed, 24 Jul 2002 19:16:43 +0000 (19:16 +0000)]
Remove _deadcode.

22 years agoRemove unused system table columns:
Peter Eisentraut [Wed, 24 Jul 2002 19:11:14 +0000 (19:11 +0000)]
Remove unused system table columns:

pg_language.lancompiler
pg_operator.oprprec
pg_operator.oprisleft
pg_proc.proimplicit
pg_proc.probyte_pct
pg_proc.properbyte_cpu
pg_proc.propercall_cpu
pg_proc.prooutin_ratio
pg_shadow.usetrace
pg_type.typprtlen
pg_type.typreceive
pg_type.typsend

Attempts to use the obsoleted attributes of pg_operator or pg_proc
in the CREATE commands will be greeted by a warning.  For pg_type,
there is no warning (yet) because pg_dump scripts still contain these
attributes.

Also remove new but already obsolete spellings
isVolatile, isStable, isImmutable in WITH clause.  (Use new syntax
instead.)

22 years agoAdd mention of copyright year update.
Bruce Momjian [Wed, 24 Jul 2002 17:58:24 +0000 (17:58 +0000)]
Add mention of copyright year update.

22 years agoDone:
Bruce Momjian [Wed, 24 Jul 2002 17:42:12 +0000 (17:42 +0000)]
Done:

> * -Add Intimate Shared Memory(ISM) for Solaris

22 years agoAdd Japanese README explaining how to add new conversion.
Tatsuo Ishii [Wed, 24 Jul 2002 07:05:41 +0000 (07:05 +0000)]
Add Japanese README explaining how to add new conversion.
English README will come soon...

22 years agoAdd pg_conversion system catalog. Update description for multibyte support.
Tatsuo Ishii [Wed, 24 Jul 2002 05:51:56 +0000 (05:51 +0000)]
Add pg_conversion system catalog. Update description for multibyte support.

22 years agoDone:
Bruce Momjian [Tue, 23 Jul 2002 23:28:36 +0000 (23:28 +0000)]
Done:

> * -Allow UPDATE/DELETE on inherited table

22 years agoInitial restructuring to add jdbc3 support. There was a significant amount
Barry Lind [Tue, 23 Jul 2002 03:59:55 +0000 (03:59 +0000)]
Initial restructuring to add jdbc3 support.  There was a significant amount
of duplicated code between the jdbc1 and jdbc2.  This checkin restructures
the code so that the duplication is removed so that the jdbc3 support
can be added without adding yet another copy of everything.  Also many
classes were renamed to avoid confusion with multiple different objects
having the same name.  The timestamp tests were also updated to add support
for testing timestamp without time zone in addition to timestamp with time zone

 Modified Files:
  jdbc/Makefile jdbc/build.xml jdbc/example/ImageViewer.java
  jdbc/example/basic.java jdbc/example/blobtest.java
  jdbc/example/threadsafe.java
  jdbc/org/postgresql/Driver.java.in
  jdbc/org/postgresql/Field.java
  jdbc/org/postgresql/core/QueryExecutor.java
  jdbc/org/postgresql/fastpath/Fastpath.java
  jdbc/org/postgresql/jdbc1/CallableStatement.java
  jdbc/org/postgresql/jdbc1/DatabaseMetaData.java
  jdbc/org/postgresql/jdbc1/PreparedStatement.java
  jdbc/org/postgresql/jdbc2/Array.java
  jdbc/org/postgresql/jdbc2/CallableStatement.java
  jdbc/org/postgresql/jdbc2/DatabaseMetaData.java
  jdbc/org/postgresql/jdbc2/PreparedStatement.java
  jdbc/org/postgresql/jdbc2/UpdateableResultSet.java
  jdbc/org/postgresql/largeobject/LargeObjectManager.java
  jdbc/org/postgresql/largeobject/PGblob.java
  jdbc/org/postgresql/largeobject/PGclob.java
  jdbc/org/postgresql/test/jdbc2/BlobTest.java
  jdbc/org/postgresql/test/jdbc2/ConnectionTest.java
  jdbc/org/postgresql/test/jdbc2/DatabaseMetaDataTest.java
  jdbc/org/postgresql/test/jdbc2/TimestampTest.java
  jdbc/org/postgresql/test/jdbc2/UpdateableResultTest.java
  jdbc/org/postgresql/util/Serialize.java
 Added Files:
  jdbc/org/postgresql/PGConnection.java
  jdbc/org/postgresql/PGStatement.java
  jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
  jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
  jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
  jdbc/org/postgresql/jdbc1/Jdbc1Connection.java
  jdbc/org/postgresql/jdbc1/Jdbc1ResultSet.java
  jdbc/org/postgresql/jdbc1/Jdbc1Statement.java
  jdbc/org/postgresql/jdbc2/AbstractJdbc2Connection.java
  jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
  jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
  jdbc/org/postgresql/jdbc2/Jdbc2Connection.java
  jdbc/org/postgresql/jdbc2/Jdbc2ResultSet.java
  jdbc/org/postgresql/jdbc2/Jdbc2Statement.java
 Removed Files:
  jdbc/org/postgresql/Connection.java
  jdbc/org/postgresql/ResultSet.java
  jdbc/org/postgresql/Statement.java
  jdbc/org/postgresql/jdbc1/Connection.java
  jdbc/org/postgresql/jdbc1/ResultSet.java
  jdbc/org/postgresql/jdbc1/Statement.java
  jdbc/org/postgresql/jdbc2/Connection.java
  jdbc/org/postgresql/jdbc2/ResultSet.java
  jdbc/org/postgresql/jdbc2/Statement.java

22 years agoAdd unique index on pg_cast.oid, and document pg_cast table.
Peter Eisentraut [Mon, 22 Jul 2002 20:23:19 +0000 (20:23 +0000)]
Add unique index on pg_cast.oid, and document pg_cast table.

22 years agoFix typo.
Tatsuo Ishii [Mon, 22 Jul 2002 13:00:00 +0000 (13:00 +0000)]
Fix typo.

22 years agoAdd CREATE CONVERSION/DROP CONVERSOION reference manual
Tatsuo Ishii [Mon, 22 Jul 2002 08:57:15 +0000 (08:57 +0000)]
Add CREATE CONVERSION/DROP CONVERSOION reference manual

22 years agoFixed some minor typos.
Michael Meskes [Sun, 21 Jul 2002 11:09:41 +0000 (11:09 +0000)]
Fixed some minor typos.

22 years agoRe-Committed old file.
Michael Meskes [Sun, 21 Jul 2002 08:20:07 +0000 (08:20 +0000)]
Re-Committed old file.

22 years agoSchema TODO.detail file not needed anymore.
Bruce Momjian [Sun, 21 Jul 2002 04:39:52 +0000 (04:39 +0000)]
Schema TODO.detail file not needed anymore.

22 years agoTweak CreateTrigger() so that the OID used in the name of an
Tom Lane [Sat, 20 Jul 2002 19:55:38 +0000 (19:55 +0000)]
Tweak CreateTrigger() so that the OID used in the name of an
RI_ConstraintTrigger is the same OID assigned to the pg_trigger row.
This reduces consumption of OIDs and may ease debugging.

22 years agoMark items as done:
Bruce Momjian [Sat, 20 Jul 2002 16:45:07 +0000 (16:45 +0000)]
Mark items as done:

> * -Add GUC parameter for DATESTYLE
>  o -Allow specification of column names
>  o -Change syntax to WITH DELIMITER, (keep old syntax around?)
>  o -Remove SET KSQO option now that OR processing is improved (Tom)
>  o -Allow SHOW to output as a query result, like EXPLAIN
> * -Add SQL92 schemas (Tom)

22 years agoCode review for SHOW output changes; fix horology expected files for
Tom Lane [Sat, 20 Jul 2002 15:12:56 +0000 (15:12 +0000)]
Code review for SHOW output changes; fix horology expected files for
new SHOW output format.

22 years agoSynced parser yet again.
Michael Meskes [Sat, 20 Jul 2002 08:24:18 +0000 (08:24 +0000)]
Synced parser yet again.

Michael

22 years agoFix regression tests for new SHOW output.
Bruce Momjian [Sat, 20 Jul 2002 06:32:53 +0000 (06:32 +0000)]
Fix regression tests for new SHOW output.

22 years agoFix problems caused by code drift of API for without-oids.
Bruce Momjian [Sat, 20 Jul 2002 06:17:43 +0000 (06:17 +0000)]
Fix problems caused by code drift of API for without-oids.

22 years agoThe attached patch fixes 2 trivial warnings generated by bison 1.35,
Bruce Momjian [Sat, 20 Jul 2002 05:58:34 +0000 (05:58 +0000)]
The attached patch fixes 2 trivial warnings generated by bison 1.35,
as a result of Peter's recent CREATE CAST changes.

Neil Conway

22 years agoI can't remember who said they were working on schema related psql
Bruce Momjian [Sat, 20 Jul 2002 05:57:31 +0000 (05:57 +0000)]
I can't remember who said they were working on schema related psql
changes, but I kept finding myself wishing I could see what schema a
table or view exists in when I use \dt, \dv, etc. So, here is a patch
which does just that.

It sorts on "Schema" first, and "Name" second.

It also changes the test for system objects to key off the namespace
name starting with 'pg_' instead of the object name.

Sample output:

test=# create schema testschema;
CREATE SCHEMA
test=# create view testschema.ts_view as select 1;
CREATE VIEW
test=# \dv
                  List of relations
         Name        |   Schema   | Type |  Owner
--------------------+------------+------+----------
  __testpassbyval    | public     | view | postgres
  fooview            | public     | view | postgres
  master_pg_proc     | public     | view | postgres
  rmt_pg_proc        | public     | view | postgres
  vw_dblink_get_pkey | public     | view | postgres
  vw_dblink_replace  | public     | view | postgres
  ts_view            | testschema | view | postgres
(7 rows)

Joe Conway

22 years ago> 2. This patch includes the same Table Function API fixes that I
Bruce Momjian [Sat, 20 Jul 2002 05:49:28 +0000 (05:49 +0000)]
> 2. This patch includes the same Table Function API fixes that I
>    submitted on July 9:
>
>    http://archives.postgresql.org/pgsql-patches/2002-07/msg00056.php
>
>    Please disregard that one *if* this one is applied. If this one is
>    rejected please go ahead with the July 9th patch.

The July 9th Table Function API patch mentioned above is now in CVS, so
here is an updated version of the guc patch which should apply cleanly
against CVS tip.

Joe Conway

22 years agoHello, i noticed that win32 native stopped working/compiling after the SSL merge
Bruce Momjian [Sat, 20 Jul 2002 05:43:31 +0000 (05:43 +0000)]
Hello, i noticed that win32 native stopped working/compiling after the SSL merge
.
So i took the opportunity to fix some stuff:

1. Made the thing compile (typos & needed definitions) with the new pqsecure_* s
tuff, and added fe-secure.c to the win32.mak makefile.
2. Fixed some MULTIBYTE compile errors (when building without MB support).
3. Made it do that you can build with debug info: "nmake -f win32.mak DEBUG=1".
4. Misc small compiler speedup changes.

The resulting .dll has been tested in production, and everything seems ok.
I CC:ed -hackers because i'm not sure about two things:

1. In libpq-int.h I typedef ssize_t as an int because Visual C (v6.0)
doesn't de fine ssize_t. Is that ok, or is there any standard about what
type should be use d for ssize_t?

2. To keep the .dll api consistent regarding MULTIBYTE I just return -1
in fe-connect.c:PQsetClientEncoding() instead of taking away the whole
function. I wonder if i should do any compares with the
conn->client_encoding and return 0 if not hing would have changed (if so
how do i check that?).

Regards

Magnus Naeslund

22 years agoAdd new configure files for missing-oid patch.
Bruce Momjian [Sat, 20 Jul 2002 05:39:46 +0000 (05:39 +0000)]
Add new configure files for missing-oid patch.

22 years agoPatch problems caused by code drift since OID patch creation.
Bruce Momjian [Sat, 20 Jul 2002 05:37:45 +0000 (05:37 +0000)]
Patch problems caused by code drift since OID patch creation.

22 years agoManually apply part of oid patch that didn't apply cleanly.
Bruce Momjian [Sat, 20 Jul 2002 05:29:01 +0000 (05:29 +0000)]
Manually apply part of oid patch that didn't apply cleanly.

22 years agooid is needed, it is added at the end of the struct (after the null
Bruce Momjian [Sat, 20 Jul 2002 05:16:59 +0000 (05:16 +0000)]
oid is needed, it is added at the end of the struct (after the null
bitmap, if present).

Per Tom Lane's suggestion the information whether a tuple has an oid
or not is carried in the tuple descriptor.  For debugging reasons
tdhasoid is of type char, not bool.  There are predefined values for
WITHOID, WITHOUTOID and UNDEFOID.

This patch has been generated against a cvs snapshot from last week
and I don't expect it to apply cleanly to current sources.  While I
post it here for public review, I'm working on a new version against a
current snapshot.  (There's been heavy activity recently; hope to
catch up some day ...)

This is a long patch;  if it is too hard to swallow, I can provide it
in smaller pieces:

Part 1:  Accessor macros
Part 2:  tdhasoid in TupDesc
Part 3:  Regression test
Part 4:  Parameter withoid to heap_addheader
Part 5:  Eliminate t_oid from HeapTupleHeader

Part 2 is the most hairy part because of changes in the executor and
even in the parser;  the other parts are straightforward.

Up to part 4 the patched postmaster stays binary compatible to
databases created with an unpatched version.  Part 5 is small (100
lines) and finally breaks compatibility.

Manfred Koizar

22 years agoThe attached patch fixes a build problem with GEQO when using the
Bruce Momjian [Sat, 20 Jul 2002 04:59:10 +0000 (04:59 +0000)]
The attached patch fixes a build problem with GEQO when using the
PX recombination operator, changes some elog() messages from LOG
to DEBUG1, puts some debugging functions inside the appropriate
#ifdef (not enabled by default), and makes a few other minor
cleanups.

BTW, the elog() change is motivated by at least one user who
has sent a concerned email to -general asking exactly what the
"ERX recombination operator" is, and what it is doing to their
DBMS.

Neil Conway

22 years agoAdd new vacuum regression test files.
Bruce Momjian [Sat, 20 Jul 2002 04:58:14 +0000 (04:58 +0000)]
Add new vacuum regression test files.

22 years agoThis patch fixes a regression caused by my recent changes to heap
Bruce Momjian [Sat, 20 Jul 2002 04:57:13 +0000 (04:57 +0000)]
This patch fixes a regression caused by my recent changes to heap
tuple header.  The fix is based on the thought that HEAP_MOVED_IN is
not needed any more as soon as HEAP_XMIN_COMMITTED has been set.  So
in tqual.c and vacuum.c the HEAP_MOVED bits are cleared when
HEAP_XMIN_COMMITTED is set.

Vacuum robustness is enhanced by rearranging ifs, so that we have a
chance to elog(ERROR, ...) before an assertion fails.

A new regression test is included.

Manfred Koizar

22 years agoApply patches from Neil Conway.
Tatsuo Ishii [Sat, 20 Jul 2002 03:02:01 +0000 (03:02 +0000)]
Apply patches from Neil Conway.

> Hi Tatsuo,
>
> I've attached a patch for the version of pgbench in CVS. It includes the
> following changes:
>
>     - fix some spelling mistakes, indentation stuff, etc.
>
>     - minor code cleanup -- (void) args instead of (), etc.
>
>     - allocate the state array dynamically, so that it is only as
>     large as needed. This reduces the memory consumption of pgbench
>     slightly, and makes a larger MAXCLIENTS setting possible
>
>     - (the only controversial change) add an option "-l" to log
>     transaction latencies to a file. The "transaction latency"
>     is the time between when the BEGIN is issued and the transaction
>     commits. This is written to a file, along with the client #
>     and the transaction #. The data in the file can then be used
>     for things like:
>
>         - consistency analysis: is the TPS the same through the
>         entire run of pgbench, or does it change?
>
>         - more detailed stats: what is the average latency, worse-case
>         latency, best-case latency?
>
>         - graphs: feed the data to gnuplot, graph latency versus. time
>
>         - etc.
>
>     I was going to store this data in memory and write it to disk
>     at the end of the pgbench run, but that isn't feasible because
>     the data can be very large: for example, ~70MB if benchmarking
>     128 clients doing 100,000 transactions each.
>
> Cheers,
>
> Neil

22 years agoSmall performance improvement --- use indexscan not heapscan to find
Tom Lane [Fri, 19 Jul 2002 22:21:17 +0000 (22:21 +0000)]
Small performance improvement --- use indexscan not heapscan to find
pg_statistic rows to delete while dropping a relation.

22 years agoMake note that ALTER TABLE can change table owner these days.
Tom Lane [Fri, 19 Jul 2002 18:53:50 +0000 (18:53 +0000)]
Make note that ALTER TABLE can change table owner these days.

22 years agoComplete TODO item:
Bruce Momjian [Fri, 19 Jul 2002 17:35:11 +0000 (17:35 +0000)]
Complete TODO item:

* -Add BSD-licensed qsort() for Solaris

22 years agoDone:
Bruce Momjian [Fri, 19 Jul 2002 17:26:35 +0000 (17:26 +0000)]
Done:

> * -Add BSD-licensed qsort() for Solaris

22 years agoAnother "$@" cleanup with new syntax, ${1+"$@"}.
Bruce Momjian [Fri, 19 Jul 2002 15:31:43 +0000 (15:31 +0000)]
Another "$@" cleanup with new syntax, ${1+"$@"}.

22 years agoFix "$@" to ${1:+"$@"} for older shells.
Bruce Momjian [Fri, 19 Jul 2002 13:50:06 +0000 (13:50 +0000)]
Fix "$@" to ${1:+"$@"} for older shells.

22 years agoOops. Too much ifdef out.
Tatsuo Ishii [Fri, 19 Jul 2002 11:09:25 +0000 (11:09 +0000)]
Oops. Too much ifdef out.

22 years agoTemporary ifdef out migrating functions to avoid compiler warnings.
Tatsuo Ishii [Fri, 19 Jul 2002 00:22:24 +0000 (00:22 +0000)]
Temporary ifdef out migrating functions to avoid compiler warnings.

22 years agoDone:
Bruce Momjian [Fri, 19 Jul 2002 00:17:53 +0000 (00:17 +0000)]
Done:

> * -HOLDER/HOLDERTAB rename to PROCLOCK/PROCLOCKTAG (Bruce)

22 years agoComplete TODO item:
Bruce Momjian [Fri, 19 Jul 2002 00:17:40 +0000 (00:17 +0000)]
Complete TODO item:

* -HOLDER/HOLDERTAB rename to PROCLOCK/PROCLOCKTAG

22 years agopg_cast table, and standards-compliant CREATE/DROP CAST commands, plus
Peter Eisentraut [Thu, 18 Jul 2002 23:11:32 +0000 (23:11 +0000)]
pg_cast table, and standards-compliant CREATE/DROP CAST commands, plus
extension to create binary compatible casts.  Includes dependency tracking
as well.

pg_proc.proimplicit is now defunct, but will be removed in a separate
commit.

pg_dump provides a migration path from the previous scheme to declare
casts.  Dumping binary compatible casts is currently impossible, though.

22 years agoDone:
Bruce Momjian [Thu, 18 Jul 2002 23:07:09 +0000 (23:07 +0000)]
Done:

> * -Merge LockMethodCtl and LockMethodTable into one shared structure (Bruce)

22 years agoComplete TODO item:
Bruce Momjian [Thu, 18 Jul 2002 23:06:20 +0000 (23:06 +0000)]
Complete TODO item:

* Merge LockMethodCtl and LockMethodTable into one shared structure (Bruce)

22 years agoCreate directory before installing files.
Peter Eisentraut [Thu, 18 Jul 2002 22:58:08 +0000 (22:58 +0000)]
Create directory before installing files.

22 years agoNew depend code doesn't need sequence drop.
Bruce Momjian [Thu, 18 Jul 2002 22:31:44 +0000 (22:31 +0000)]
New depend code doesn't need sequence drop.

22 years agoSic transit src/utils.
Tom Lane [Thu, 18 Jul 2002 22:15:10 +0000 (22:15 +0000)]
Sic transit src/utils.

22 years agoBack out BETWEEN node patch, was causing initdb failure.
Bruce Momjian [Thu, 18 Jul 2002 17:14:20 +0000 (17:14 +0000)]
Back out BETWEEN node patch, was causing initdb failure.

22 years ago New depend code auto-drops sequence, fix copy2.out.
Bruce Momjian [Thu, 18 Jul 2002 17:11:49 +0000 (17:11 +0000)]
 New depend code auto-drops sequence, fix copy2.out.

22 years agoImplement DROP SCHEMA. It lacks support for dropping conversions and
Tom Lane [Thu, 18 Jul 2002 16:47:26 +0000 (16:47 +0000)]
Implement DROP SCHEMA.  It lacks support for dropping conversions and
operator classes, both of which are schema-local and so should really
be droppable.

22 years agoFix copy-and-pasteo (CASCADE/RESTRICT in wrong place).
Tom Lane [Thu, 18 Jul 2002 15:49:08 +0000 (15:49 +0000)]
Fix copy-and-pasteo (CASCADE/RESTRICT in wrong place).

22 years agoFix typo (PG_UNICODE -> PG_UTF8)
Tatsuo Ishii [Thu, 18 Jul 2002 05:07:30 +0000 (05:07 +0000)]
Fix typo (PG_UNICODE -> PG_UTF8)

22 years agoDone:
Bruce Momjian [Thu, 18 Jul 2002 05:01:51 +0000 (05:01 +0000)]
Done:

> * -Make sure all block numbers are unsigned to increase maximum table size

22 years agoUnique and primary key constraints are both dumped using ALTER TABLE
Bruce Momjian [Thu, 18 Jul 2002 04:50:51 +0000 (04:50 +0000)]
Unique and primary key constraints are both dumped using ALTER TABLE
statements.  Unique indexes with CREATE INDEX.

Basically, pg_constraint left outer'd to pg_index.

Rod Taylor

22 years agoREVOKE ALL ON FUNCTION nonexistant() FROM PUBLIC;
Bruce Momjian [Thu, 18 Jul 2002 04:50:10 +0000 (04:50 +0000)]
REVOKE ALL ON FUNCTION nonexistant() FROM PUBLIC;

Used to report that GRANT could not find function nonexistant.

Rod Taylor

22 years agoFix for PgTransaction class to make these visible to C apps:
Bruce Momjian [Thu, 18 Jul 2002 04:49:30 +0000 (04:49 +0000)]
Fix for PgTransaction class to make these visible to C apps:

   ExecStatusType BeginTransaction();
   ExecStatusType EndTransaction();

Piotr Klaban

22 years agoHere (finally ;-)) is a doc patch covering the Table Function C API. It
Bruce Momjian [Thu, 18 Jul 2002 04:47:17 +0000 (04:47 +0000)]
Here (finally ;-)) is a doc patch covering the Table Function C API. It
reflects the changes in the tablefunc-fix patch that I sent in the other
day. It also refers to "see contrib/tablefunc for more examples", which
is next on my list of things to finish and submit.

Joe Conway

22 years agoThe attached patch fixes a tiny memory leak in psql, when using
Bruce Momjian [Thu, 18 Jul 2002 04:46:24 +0000 (04:46 +0000)]
The attached patch fixes a tiny memory leak in psql, when using
the 'expanded' output mode (\x).

Neil Conway

22 years agohere are the copy2.sql and copy2.out files for the new regression
Bruce Momjian [Thu, 18 Jul 2002 04:45:51 +0000 (04:45 +0000)]
here are the copy2.sql and copy2.out files for the new regression
tests

Brent Verner

22 years agoThe attached patch (against HEAD) implements
Bruce Momjian [Thu, 18 Jul 2002 04:43:51 +0000 (04:43 +0000)]
The attached patch (against HEAD) implements

  COPY x (a,d,c,b) from stdin;
  COPY x (a,c) to stdout;

as well as the corresponding changes to pg_dump to use the new
functionality.  This functionality is not available when using
the BINARY option.  If a column is not specified in the COPY FROM
statement, its default values will be used.

In addition to this functionality, I tweaked a couple of the
error messages emitted by the new COPY <options> checks.

Brent Verner

22 years agoYou made a tiny little type in a comment in parsenodes.h (abotu instead
Bruce Momjian [Thu, 18 Jul 2002 04:42:29 +0000 (04:42 +0000)]
You made a tiny little type in a comment in parsenodes.h (abotu instead
of about).

Christopher Kings-Lynne

22 years agoFinished the Between patch Christopher started.
Bruce Momjian [Thu, 18 Jul 2002 04:41:46 +0000 (04:41 +0000)]
Finished the Between patch Christopher started.

Implements between (symmetric / asymmetric) as a node.

Executes the left or right expression once, makes a Const out of the
resulting Datum and executes the >=, <= portions out of the Const sets.

Of course, the parser does a fair amount of preparatory work for this to
happen.

Rod Taylor

22 years agoHere is a patch for the Table Function API. It fixes a bug found by Neil
Bruce Momjian [Thu, 18 Jul 2002 04:40:30 +0000 (04:40 +0000)]
Here is a patch for the Table Function API. It fixes a bug found by Neil

Conway (BuildTupleFromCStrings sets NULL for pass-by-value types when
intended value is 0). It also implements some other improvements
suggested by Neil.

Joe Conway

22 years agoContrib port/ usage is same as others so no need for rules.
Bruce Momjian [Thu, 18 Jul 2002 04:33:39 +0000 (04:33 +0000)]
Contrib port/ usage is same as others so no need for rules.

22 years agoAdd comment to file about port files.
Bruce Momjian [Thu, 18 Jul 2002 04:30:36 +0000 (04:30 +0000)]
Add comment to file about port files.

22 years agoFix breakage for pltcl modules. pg_get_enconv_by_encoding() has been
Tatsuo Ishii [Thu, 18 Jul 2002 04:16:07 +0000 (04:16 +0000)]
Fix breakage for pltcl modules. pg_get_enconv_by_encoding() has been
changed since CREATE CONVERSION supported.

22 years agoMove libc replacement files from src/backend/port to src/port.
Bruce Momjian [Thu, 18 Jul 2002 04:13:59 +0000 (04:13 +0000)]
Move libc replacement files from src/backend/port to src/port.

22 years agoMake src/backend/port/*.c file location dependent only on configure.in.
Bruce Momjian [Thu, 18 Jul 2002 03:59:49 +0000 (03:59 +0000)]
Make src/backend/port/*.c file location dependent only on configure.in.

22 years agoI have committed many support files for CREATE CONVERSION. Default
Tatsuo Ishii [Thu, 18 Jul 2002 02:02:30 +0000 (02:02 +0000)]
I have committed many support files for CREATE CONVERSION. Default
conversion procs and conversions are added in initdb. Currently
supported conversions are:

UTF-8(UNICODE) <--> SQL_ASCII, ISO-8859-1 to 16, EUC_JP, EUC_KR,
    EUC_CN, EUC_TW, SJIS, BIG5, GBK, GB18030, UHC,
    JOHAB, TCVN

EUC_JP <--> SJIS
EUC_TW <--> BIG5
MULE_INTERNAL <--> EUC_JP, SJIS, EUC_TW, BIG5

Note that initial contents of pg_conversion system catalog are created
in the initdb process. So doing initdb required is ideal, it's
possible to add them to your databases by hand, however. To accomplish
this:

psql -f your_postgresql_install_path/share/conversion_create.sql your_database

So I did not bump up the version in cataversion.h.

TODO:
Add more conversion procs
Add [CASCADE|RESTRICT] to DROP CONVERSION
Add tuples to pg_depend
Add regression tests
Write docs
Add SQL99 CONVERT command?
--
Tatsuo Ishii

22 years agoDone, not sure when, reported by Neil Conway:
Bruce Momjian [Wed, 17 Jul 2002 22:15:20 +0000 (22:15 +0000)]
Done, not sure when, reported by Neil Conway:

> * -Report failure to find readline or zlib at end of configure run

22 years agoImprove getopt_long search, per Peter:
Bruce Momjian [Wed, 17 Jul 2002 02:54:01 +0000 (02:54 +0000)]
Improve getopt_long search, per Peter:

AC_SEARCH_LIBS(getopt_long, [getopt])

22 years agoAdd more dependency insertions --- this completes the basic pg_depend
Tom Lane [Tue, 16 Jul 2002 22:12:20 +0000 (22:12 +0000)]
Add more dependency insertions --- this completes the basic pg_depend
functionality.  Of note: dropping a table that has a SERIAL column
defined now drops the associated sequence automatically.

22 years agofixed bug in support for timestamp without time zone reported by Yuva Chandolu (ychan...
Barry Lind [Tue, 16 Jul 2002 21:05:17 +0000 (21:05 +0000)]
fixed bug in support for timestamp without time zone reported by Yuva Chandolu (ychandolu@ebates.com)

22 years agoOops, sometimes strtol isn't called in pg_atoi, so we do need that badp
Bruce Momjian [Tue, 16 Jul 2002 18:34:16 +0000 (18:34 +0000)]
Oops, sometimes strtol isn't called in pg_atoi, so we do need that badp
check.

22 years agoFix tid to in/out as unsigned.
Bruce Momjian [Tue, 16 Jul 2002 17:55:25 +0000 (17:55 +0000)]
Fix tid to in/out as unsigned.

22 years agoAdd initdb code to set up initial contents of pg_depend, pinning all
Tom Lane [Tue, 16 Jul 2002 17:48:46 +0000 (17:48 +0000)]
Add initdb code to set up initial contents of pg_depend, pinning all
objects created during initdb (except for the system views, which I
think do not need to be pinned).

22 years ago> pgsql-bugs@postgresql.org wrote:
Bruce Momjian [Tue, 16 Jul 2002 17:05:46 +0000 (17:05 +0000)]
> pgsql-bugs@postgresql.org wrote:
>  > David Clark (dclarknospam@opsi.co.za) reports a bug with a severity
>  > Table 3-7 SQL Literal escaped octets shows the input escape
>  > representation for a single quote as '\\'' , but the third paragraph
>  > below table 3-8 SQL Output Escaped Octets says that the single quote
>  > must be input as '\''
>
> Nice catch. '\'' is correct as shown in the example in Table 3-7.
>
>  >
>  > Also in the same paragraph mentioned above it says input for the
>  > single quote must be '\'' (or '\\134') shouldn't this be (or '\\047')
>
> Also a bug. Should be '\\047', as you pointed out.
>

Here's a patch to fix the binary string doc errors.

Joe Conway

22 years agoAdd conversion procs for CREATE CONVERSION
Tatsuo Ishii [Tue, 16 Jul 2002 09:25:06 +0000 (09:25 +0000)]
Add conversion procs for CREATE CONVERSION

22 years agoFix typo
Tatsuo Ishii [Tue, 16 Jul 2002 06:58:44 +0000 (06:58 +0000)]
Fix typo

22 years agoAdd FindDefaultConversionProc
Tatsuo Ishii [Tue, 16 Jul 2002 06:58:14 +0000 (06:58 +0000)]
Add FindDefaultConversionProc

22 years agoAdd code to extract dependencies from an expression tree, and use it
Tom Lane [Tue, 16 Jul 2002 05:53:34 +0000 (05:53 +0000)]
Add code to extract dependencies from an expression tree, and use it
to build dependencies for rules, constraint expressions, and default
expressions.  Repair some problems in the original design of
recursiveDeletion() exposed by more complex dependency sets.  Fix
regression tests that were deleting things in illegal sequences.

22 years agoAdd DLLINIT mention in port/Makefile.
Bruce Momjian [Tue, 16 Jul 2002 05:49:38 +0000 (05:49 +0000)]
Add DLLINIT mention in port/Makefile.

22 years agoMove few remaining src/utils files to backend/port so everything is in
Bruce Momjian [Tue, 16 Jul 2002 05:46:36 +0000 (05:46 +0000)]
Move few remaining src/utils files to backend/port so everything is in
one place.  Everything may be moved to src/utils eventually.

Add DLLINIT variable to simplify makfiles.

22 years agoAdd mention of TOAST storage for character columns.
Bruce Momjian [Tue, 16 Jul 2002 04:45:59 +0000 (04:45 +0000)]
Add mention of TOAST storage for character columns.

22 years agoMark 'line' as 'not implemented' in SGML and psql \dT, per Thomas
Bruce Momjian [Tue, 16 Jul 2002 03:30:27 +0000 (03:30 +0000)]
Mark 'line' as 'not implemented' in SGML and psql \dT, per Thomas
Lockhart.  initdb not forced.

22 years agoThis fixes 2 inaccuracies in the recently added SQL99 feature list docs.
Bruce Momjian [Tue, 16 Jul 2002 00:51:37 +0000 (00:51 +0000)]
This fixes 2 inaccuracies in the recently added SQL99 feature list docs.
UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK,
neither is.

I also included another trivial patch which adds the default location
of the DSSSL stylesheets on my system (Debian unstable, docbook-dsssl
1.76) to the list of paths that configure looks for.

Neil Conway

22 years agoAdd comment for isbn,issn data type, from Pete St. Onge
Bruce Momjian [Tue, 16 Jul 2002 00:48:30 +0000 (00:48 +0000)]
Add comment for isbn,issn data type, from Pete St. Onge

22 years agoItem not needed:
Bruce Momjian [Mon, 15 Jul 2002 23:34:34 +0000 (23:34 +0000)]
Item not needed:

< * Use our own getopt() for FreeBSD/OpenBSD to allow --xxx flags (Bruce)

22 years agoRemove indenting of Makefile comments, per Peter.\
Bruce Momjian [Mon, 15 Jul 2002 23:32:28 +0000 (23:32 +0000)]
Remove indenting of Makefile comments, per Peter.\

22 years agoRemove utils/getopt.c file, not needed, it only allowed "--flag"
Bruce Momjian [Mon, 15 Jul 2002 22:48:54 +0000 (22:48 +0000)]
Remove utils/getopt.c file, not needed, it only allowed "--flag"
warnings, and we now look for getopt_long in libgetopt.a.

22 years agoAdd search for libgetopt.a in hopes of finding getopt_long().
Bruce Momjian [Mon, 15 Jul 2002 22:41:45 +0000 (22:41 +0000)]
Add search for libgetopt.a in hopes of finding getopt_long().

22 years agoRemove certain Makefile dependencies by using full pathnames in
Bruce Momjian [Mon, 15 Jul 2002 21:34:05 +0000 (21:34 +0000)]
Remove certain Makefile dependencies by using full pathnames in
configure.in.

22 years agoUse the dependency mechanism to manage column defaults. We need this
Tom Lane [Mon, 15 Jul 2002 16:33:32 +0000 (16:33 +0000)]
Use the dependency mechanism to manage column defaults.  We need this
so that dependencies in default expressions (on operators, functions,
etc) can be expressed properly.

22 years agoFix make_ctags for exhuberant tags.
Bruce Momjian [Mon, 15 Jul 2002 14:45:51 +0000 (14:45 +0000)]
Fix make_ctags for exhuberant tags.

22 years agoFix a bug about the handling of '.' in parse.c.
Hiroshi Inoue [Mon, 15 Jul 2002 02:56:39 +0000 (02:56 +0000)]
Fix a bug about the handling of '.' in parse.c.

22 years agoImprove relcache.c error reporting for the next guy who has to debug
Bruce Momjian [Mon, 15 Jul 2002 01:57:51 +0000 (01:57 +0000)]
Improve relcache.c error reporting for the next guy who has to debug
this thing.