OSDN Git Service
Bruce Momjian [Tue, 4 Aug 1998 18:42:39 +0000 (18:42 +0000)]
OR processing cleanup.
Bruce Momjian [Tue, 4 Aug 1998 18:29:41 +0000 (18:29 +0000)]
Add Indices display to \d command.
Bruce Momjian [Tue, 4 Aug 1998 17:37:48 +0000 (17:37 +0000)]
Fix encoding grammer problem.
Bruce Momjian [Tue, 4 Aug 1998 16:44:31 +0000 (16:44 +0000)]
MergeSort was sometimes called mergejoin and was confusing. Now
it is now only mergejoin.
Bruce Momjian [Tue, 4 Aug 1998 15:00:28 +0000 (15:00 +0000)]
EXPLAIN VERBOSE prints the plan, and now pretty-prints the plan to
the postmaster log file.
Bruce Momjian [Tue, 4 Aug 1998 04:50:15 +0000 (04:50 +0000)]
Make EXPLAIN show output more clearly.
Bruce Momjian [Tue, 4 Aug 1998 00:42:14 +0000 (00:42 +0000)]
Update flow chart.
Bruce Momjian [Mon, 3 Aug 1998 19:41:35 +0000 (19:41 +0000)]
Update mark/reset index code for multiple indexes, (OR code).
Thanks for Vadim for fixes.
Bruce Momjian [Mon, 3 Aug 1998 05:54:30 +0000 (05:54 +0000)]
Fix typo in man pages.
Bruce Momjian [Mon, 3 Aug 1998 05:49:24 +0000 (05:49 +0000)]
Cleanup of OR processing.
Thomas G. Lockhart [Sun, 2 Aug 1998 13:34:26 +0000 (13:34 +0000)]
Allows the following query to succeed: "SELECT NULL ORDER BY 1;"
There are three or four cases in transformSortClause() and I had fixed
only one case for UNION. A second case is now fixed, in the same way; I
assigned INT4OID to the column type for the "won't actually happen"
sort. Didn't want to skip the code entirely, since the backend needs to
_try_ a sort to get the NULLs right. I'm not certain under what
circumstances the other cases are invoked and these are not yet
fixed up, though perhaps they don't need to be...
Bruce Momjian [Sun, 2 Aug 1998 07:10:38 +0000 (07:10 +0000)]
Fix for OR handling with multiple indexes.
Bruce Momjian [Sun, 2 Aug 1998 00:34:05 +0000 (00:34 +0000)]
run autoconf
Bruce Momjian [Sun, 2 Aug 1998 00:21:39 +0000 (00:21 +0000)]
Fix MULTIBYTE typo.
Bruce Momjian [Sat, 1 Aug 1998 22:57:41 +0000 (22:57 +0000)]
Fix duplicate inside initdb.sh
Bruce Momjian [Sat, 1 Aug 1998 22:44:55 +0000 (22:44 +0000)]
Cleanup of OR fix.
Bruce Momjian [Sat, 1 Aug 1998 22:12:13 +0000 (22:12 +0000)]
Allow index use with OR clauses.
Marc G. Fournier [Sat, 1 Aug 1998 19:30:29 +0000 (19:30 +0000)]
Adrian Hall reported a problem to me that snprintf() doesn't exist in, at
least, Solaris 2.5.1. We use it in backend/utils/adt/int8.c.
Add a check to configure so that we see if it exists or not, and, if not,
compile in snprintf.c from backend/port, which was taken from, and falls under
the same Berkeley license as us, the FreeBSD libc/stdio ...
Vadim B. Mikheev [Sat, 1 Aug 1998 15:26:38 +0000 (15:26 +0000)]
Lmgr cleanup, new locking modes for LLL.
Vadim B. Mikheev [Fri, 31 Jul 1998 15:10:40 +0000 (15:10 +0000)]
Matching clauses to functional indices was broken, now fixed.
Vadim B. Mikheev [Thu, 30 Jul 1998 05:05:05 +0000 (05:05 +0000)]
Fix scan adjustment.
Thomas G. Lockhart [Wed, 29 Jul 1998 15:23:57 +0000 (15:23 +0000)]
Removed from distribution. Completely converted to SGML.
This was the Postgres95 documentation written by Jolly and Chu...
Thomas G. Lockhart [Wed, 29 Jul 1998 07:08:00 +0000 (07:08 +0000)]
Use libpq only once to avoid file naming conflicts in the html output.
Thomas G. Lockhart [Wed, 29 Jul 1998 07:01:58 +0000 (07:01 +0000)]
Somehow had substituted this file for the contents of allfiles.sgml.
This should be the right thing now...
Thomas G. Lockhart [Wed, 29 Jul 1998 06:50:04 +0000 (06:50 +0000)]
Add id field to chapter and book tags to allow output file names
to be meaningful.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:35:19 +0000 (06:35 +0000)]
Add port information for NS32532.
Fix Id tag in chapter headings to allow meaningful file names in html.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:33:37 +0000 (06:33 +0000)]
Include information on documentation products and sources.
Include tables of possible source files throughout tree.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:32:47 +0000 (06:32 +0000)]
Add missing information.
Fix examples for regex operators.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:29:04 +0000 (06:29 +0000)]
Use option to jade to produce html file names from id field in tag.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:23:26 +0000 (06:23 +0000)]
Add new files from Oliver Elphick.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:21:57 +0000 (06:21 +0000)]
Fix minor end-of-file formatting.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:13:48 +0000 (06:13 +0000)]
Information moved to doc/src/sgml/release.sgml.
Thomas G. Lockhart [Wed, 29 Jul 1998 06:07:54 +0000 (06:07 +0000)]
Information moved to doc/src/sgml/geqo.sgml.
Vadim B. Mikheev [Mon, 27 Jul 1998 19:38:40 +0000 (19:38 +0000)]
Use Snapshot in heap access methods.
Marc G. Fournier [Mon, 27 Jul 1998 03:21:58 +0000 (03:21 +0000)]
Missed a few files in the last round of commits from Tatsuo, as well
as needed to run autoconf ...
Marc G. Fournier [Sun, 26 Jul 1998 04:31:41 +0000 (04:31 +0000)]
From: t-ishii@sra.co.jp
As Bruce mentioned, this is due to the conflict among changes we made.
Included patches should fix the problem(I changed all MB to
MULTIBYTE). Please let me know if you have further problem.
P.S. I did not include pathces to configure and gram.c to save the
file size(configure.in and gram.y modified).
Marc G. Fournier [Sun, 26 Jul 1998 04:22:42 +0000 (04:22 +0000)]
I missed addding initdb.sh ...
Bruce Momjian [Sun, 26 Jul 1998 02:17:55 +0000 (02:17 +0000)]
Update flowchart. Add arrow.
Bruce Momjian [Sun, 26 Jul 1998 01:18:09 +0000 (01:18 +0000)]
Fix compile error. Make transaction/work optional on all transaction
statements. More cleanups of psql help. Fix for shift/reduce on
UNION in subselect.
Bruce Momjian [Sat, 25 Jul 1998 00:17:30 +0000 (00:17 +0000)]
Update psql help syntax to remove <> and uppercaese keywords.
Bruce Momjian [Fri, 24 Jul 1998 16:44:04 +0000 (16:44 +0000)]
Add mention of actual SQL command to create*/destroy* commands.
Bruce Momjian [Fri, 24 Jul 1998 16:36:56 +0000 (16:36 +0000)]
Add mention of SQL commands to create/destroy man pages.
Bruce Momjian [Fri, 24 Jul 1998 16:10:19 +0000 (16:10 +0000)]
Add mention of psql and template1 to create*, destroy* command
manual pages.
Bruce Momjian [Fri, 24 Jul 1998 15:54:10 +0000 (15:54 +0000)]
Fix HAVING patch missing cast.
Bruce Momjian [Fri, 24 Jul 1998 04:03:10 +0000 (04:03 +0000)]
I'm sorry, but I think I introduced a little bug with my last patch.
Everyone using an [NOT] EXISTS subquery will have noticed that
already.
The bug is in "subselect.c" in the function "SS_process_sublinks()".
Here the whole function as it *SHOULD BE*:
Stephan
Marc G. Fournier [Fri, 24 Jul 1998 03:32:46 +0000 (03:32 +0000)]
I really hope that I haven't missed anything in this one...
From: t-ishii@sra.co.jp
Attached are patches to enhance the multi-byte support. (patches are
against 7/18 snapshot)
* determine encoding at initdb/createdb rather than compile time
Now initdb/createdb has an option to specify the encoding. Also, I
modified the syntax of CREATE DATABASE to accept encoding option. See
README.mb for more details.
For this purpose I have added new column "encoding" to pg_database.
Also pg_attribute and pg_class are changed to catch up the
modification to pg_database. Actually I haved added pg_database_mb.h,
pg_attribute_mb.h and pg_class_mb.h. These are used only when MB is
enabled. The reason having separate files is I couldn't find a way to
use ifdef or whatever in those files. I have to admit it looks
ugly. No way.
* support for PGCLIENTENCODING when issuing COPY command
commands/copy.c modified.
* support for SQL92 syntax "SET NAMES"
See gram.y.
* support for LATIN2-5
* add UNICODE regression test case
* new test suite for MB
New directory test/mb added.
* clean up source files
Basic idea is to have MB's own subdirectory for easier maintenance.
These are include/mb and backend/utils/mb.
Byron Nikolaidis [Wed, 22 Jul 1998 23:47:48 +0000 (23:47 +0000)]
Version 06-30-0248
Vadim B. Mikheev [Wed, 22 Jul 1998 05:48:59 +0000 (05:48 +0000)]
Fix _lo_commit: core if LO memmory context was not created (LO were not used?)
Vadim B. Mikheev [Tue, 21 Jul 1998 06:17:39 +0000 (06:17 +0000)]
VariableCache (next XID generator) is placed in shmem.
Bruce Momjian [Tue, 21 Jul 1998 04:48:31 +0000 (04:48 +0000)]
Update.
Bruce Momjian [Tue, 21 Jul 1998 04:19:44 +0000 (04:19 +0000)]
Update.
Bruce Momjian [Tue, 21 Jul 1998 04:17:30 +0000 (04:17 +0000)]
Theses buffer leaks are caused by indexes that are kept open between
calls. Outside a transaction, the backend detects them as buffer
leaks; it sends a NOTICE, and frees them. This sometimes cause a
segmentation fault (at least on Linux). These indexes are initialized
on the first lo_read/lo_write/lo_tell call, and (normally) closed
on a lo_close call. Thus the buffer leaks appear when lo direct
access functions are used, and not with lo_import/lo_export functions
(libpq version calls lo_close before ending the command, and the
backend version uses another path).
The included patches (against recent snapshot, and against 6.3.2)
cause indexes to be closed on transaction end (that is on explicit
'END' statment, or on command termination outside trasaction blocks),
thus preventing the buffer leaks while increasing performance inside
transactions. Some (all?) 'classic' memory leaks are also removed.
I hope it will be ok.
--- Pascal ANDRE, graduated from Ecole Centrale Paris andre@via.ecp.fr
Bruce Momjian [Mon, 20 Jul 1998 21:18:35 +0000 (21:18 +0000)]
target list fixes.
Bruce Momjian [Mon, 20 Jul 1998 20:48:54 +0000 (20:48 +0000)]
makeTargetEntry cleanup.
Bruce Momjian [Mon, 20 Jul 1998 20:01:48 +0000 (20:01 +0000)]
Makefile removal of internal.c.
Bruce Momjian [Mon, 20 Jul 1998 19:53:53 +0000 (19:53 +0000)]
Cleanup makeTargetEntry and remove internal.c.
Bruce Momjian [Mon, 20 Jul 1998 19:21:45 +0000 (19:21 +0000)]
Use defines rather than constants for types.
Bruce Momjian [Mon, 20 Jul 1998 17:45:49 +0000 (17:45 +0000)]
Fix problem brought in with 32K machine.
Bruce Momjian [Mon, 20 Jul 1998 16:57:18 +0000 (16:57 +0000)]
Cleanup use of 16 that should be NAMEDATALEN.
Bruce Momjian [Mon, 20 Jul 1998 16:14:18 +0000 (16:14 +0000)]
Cleanup Name usage.
Bruce Momjian [Mon, 20 Jul 1998 11:28:12 +0000 (11:28 +0000)]
Fix temp name length.
Bruce Momjian [Mon, 20 Jul 1998 11:17:11 +0000 (11:17 +0000)]
Remove un-needed references to Name.
Bruce Momjian [Mon, 20 Jul 1998 10:01:51 +0000 (10:01 +0000)]
Update version.
Bruce Momjian [Mon, 20 Jul 1998 09:30:13 +0000 (09:30 +0000)]
Add contributor name to fulltextindex, and clean up contrib/README.
Bruce Momjian [Mon, 20 Jul 1998 02:45:03 +0000 (02:45 +0000)]
Update fti README and stopwords.
Bruce Momjian [Mon, 20 Jul 1998 02:31:10 +0000 (02:31 +0000)]
Update list of contrib directories.
Bruce Momjian [Sun, 19 Jul 1998 18:26:41 +0000 (18:26 +0000)]
I finally got the time to put together some stuff for fti for
inclusion in pgsql. I have included a README which should be enough
to start using it, plus a BENCH file that describes some timings
I have done.
Please have a look at it, and if you think everything is OK, I
would like it seen included in the contrib-section of pgsql.
I don't think I will do any more work in this, but maybe it inspires
somebody else to improve on it.
Maarten Boekhold
Bruce Momjian [Sun, 19 Jul 1998 10:08:15 +0000 (10:08 +0000)]
Remove unneeded strcpy() of timezone.
Bruce Momjian [Sun, 19 Jul 1998 10:05:19 +0000 (10:05 +0000)]
Remove un-needed psort close.
Bruce Momjian [Sun, 19 Jul 1998 09:44:36 +0000 (09:44 +0000)]
Lock fix from Tom Ivar Helbekkmo .
Bruce Momjian [Sun, 19 Jul 1998 05:49:26 +0000 (05:49 +0000)]
1) Queries using the having clause on base tables should work well
now. Here some tested features, (examples included in the patch):
1.1) Subselects in the having clause 1.2) Double nested subselects
1.3) Subselects used in the where clause and in the having clause
simultaneously 1.4) Union Selects using having 1.5) Indexes
on the base relations are used correctly 1.6) Unallowed Queries
are prevented (e.g. qualifications in the
having clause that belong to the where clause) 1.7) Insert
into as select
2) Queries using the having clause on view relations also work
but there are some restrictions:
2.1) Create View as Select ... Having ...; using base tables in
the select 2.1.1) The Query rewrite system:
2.1.2) Why are only simple queries allowed against a view from 2.1)
? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug
in ExecMergeJoin ??
Regards Stefan
Bruce Momjian [Sun, 19 Jul 1998 05:24:51 +0000 (05:24 +0000)]
pg_dump -z has gotten rather thoroughly broken in the last couple
of days --- it was emitting stuff like
REVOKE ALL on 'table' from PUBLIC; GRANT ALL on "table" to
"Public"; neither of which work. While I was at it I
cleaned up a few other things:
* \connect commands are issued only in -z mode. In this way,
reloading a pg_dump script made without -z will generate a simple
database wholly owned by the invoking user, rather than a mishmash
of tables owned by various people but lacking in access rights.
(Analogy: cp versus cp -p.)
* \connect commands are issued just before COPY FROM stdin commands;
without this, reloading a database containing non-world-writable
tables tended to fail because the COPY was not necessarily attempted
as the table owner.
* Redundant \connect commands are suppressed (each one costs a
backend launch, so...).
* Man page updated (-z wasn't ever documented).
The first two items were discussed in a pgsql-hackers thread around
6 May 98 ("An item for the TODO list: pg_dump and multiple table
owners") but no one had bothered to deal with 'em yet.
regards, tom lane
Bruce Momjian [Sun, 19 Jul 1998 05:02:51 +0000 (05:02 +0000)]
Make sparc/solaris not use complex macr.
Bruce Momjian [Sun, 19 Jul 1998 04:30:04 +0000 (04:30 +0000)]
Attached are the three patches that were needed to get PostgreSQL
6.3.2 to compile (and run) on my Sparc Solaris 2.5.1 box. Details
below:
pgsql.sparc.patch-template: Adds -D__sparc__ and -D__sun__,
defintions which gcc does define, but Sun's cc does not. :(
pgsql.sparc.patch-makefile: Adds a define so that 'lorder'
is not used, as it is not found on my machine.
Ryan Kirkpatrick
Bruce Momjian [Sun, 19 Jul 1998 04:17:13 +0000 (04:17 +0000)]
My mailer munged the intro text in my last post. Here is the text
in a more readable form. -- I am submitting the following patches
to the June 6, 1998 snapshot of PostgreSQL. These patches implement
a port of PostgreSQL to SCO UnixWare 7, and updates the Univel port
(UnixWare 2.x). The patched files, and the reason
for the patch are:
File Reason for the patch ---------------
---------------------------------------------------------------
src/backend/port/dynloader/unixware.c src/backend/port/dynloader/unixware.h
src/include/port/unixware.h src/makefiles/Makefile.unixware
src/template/unixware
Created for the UNIXWARE port.
src/include/port/univel.h
Modifed this file to work with the changes made to
s_lock.[ch].
src/backend/storage/buffer/s_lock.c src/include/storage/s_lock.h
Moved the UNIXWARE (and Univel) tas() function from
s_lock.c to s_lock.h. The UnixWare compiler asm
construct is treated as a macro and needs to be in
the s_lock.h file. I also reworked the tas()
function to correct some errors in the code.
src/include/version.h.in
The use of the ## operator with quoted strings in
the VERSION macro caused problems with the UnixWare
C compiler. I removed the ## operators since they
were not needed in this case. The macro expands
into a sequence of quoted strings that will be
concatenated by any ANSI C compiler.
src/config.guess
This script was modified to recognize SCO UnixWare
7.
src/configure src/configure.in
The configure script was modified to recognize SCO
UnixWare 7.
Billy G. Allie
Bruce Momjian [Sun, 19 Jul 1998 03:46:29 +0000 (03:46 +0000)]
Conditionally execute Junk filter only when ORDER BY of columns
not in target list.
Bruce Momjian [Sun, 19 Jul 1998 01:19:54 +0000 (01:19 +0000)]
Somewhere between 6.1 and 6.3 someone removed the support for the
NS32K machine I contributed. In any case, I now have postgresql-6.3
running again on NetBSD/pc532, a NS32532 machine. The following
changes are needed relative to the src directory. (It looks like
support was partially removed when the files were moved from the
src/backend/storage/.... tree to the src/include tree.)
If you need me to get a current development version of postgresql
for this change let me know. Also, let me know if this code needs
updating due to another code movement that deleted the old NS32K
support.
Thank you.
Phil Nelson
Bruce Momjian [Sun, 19 Jul 1998 01:11:01 +0000 (01:11 +0000)]
Add DISABLE_COMPLEX_MACRO to sco.
Bruce Momjian [Sat, 18 Jul 1998 18:34:34 +0000 (18:34 +0000)]
Add auto-size to screen to \d? commands. Use UNION to show all
\d? results in one query. Add \d? field search feature. Rename MB
to MULTIBYTE.
Bruce Momjian [Sat, 18 Jul 1998 14:58:58 +0000 (14:58 +0000)]
Move common lock code to their own section.
Bruce Momjian [Sat, 18 Jul 1998 14:51:10 +0000 (14:51 +0000)]
On architectures where we don't have any special inline code for
GCC, the inner "#if defined(__GNUC__)" can just be omitted in that
architecture's block.
The existing arrangement with an outer "#if defined(__GNUC__)"
doesn't have any obvious benefit, and it encourages missed cases
like this one.
BTW, I'd suggest making the definition of clear_lock for HPUX be
static const slock_t clear_lock = {{-1, -1, -1, -1}};
The extra braces are needed to suppress warnings from gcc, and
declaring it const just seems like good practice.
regards, tom lane
Bruce Momjian [Sat, 18 Jul 1998 14:38:12 +0000 (14:38 +0000)]
Thank you for testing and reporting this. It is my fault of course,
but as I don't have access to a sparc for testing I just did what
I could. I am guessing here, but please apply the following to your
pgsql and let me know what happens. Also, cd to src/storage/buffer
and do 'make s_lock_test' as well.
David Gould
Bruce Momjian [Sat, 18 Jul 1998 04:22:52 +0000 (04:22 +0000)]
Rename Rel to RelOptInfo.
Bruce Momjian [Fri, 17 Jul 1998 18:19:31 +0000 (18:19 +0000)]
update
Bruce Momjian [Thu, 16 Jul 1998 15:54:39 +0000 (15:54 +0000)]
Remove monitor mention and add psql.
Bruce Momjian [Thu, 16 Jul 1998 02:58:09 +0000 (02:58 +0000)]
Fix for Group ReScan suggested by Vadim.
Bruce Momjian [Thu, 16 Jul 1998 01:49:19 +0000 (01:49 +0000)]
Patch for ReScan of Group.
Bruce Momjian [Wed, 15 Jul 1998 22:16:21 +0000 (22:16 +0000)]
Allow UNION/UNION ALL in subselects.
Bruce Momjian [Wed, 15 Jul 1998 18:53:40 +0000 (18:53 +0000)]
Fix for COPY problem and atttypmod.
Bruce Momjian [Wed, 15 Jul 1998 17:34:06 +0000 (17:34 +0000)]
Update word.
Bruce Momjian [Wed, 15 Jul 1998 17:08:23 +0000 (17:08 +0000)]
Add PGUSER to man page.
Bruce Momjian [Wed, 15 Jul 1998 15:56:36 +0000 (15:56 +0000)]
Allow UNION in subselect.
Bruce Momjian [Wed, 15 Jul 1998 14:54:39 +0000 (14:54 +0000)]
Fix explain for union and inheritance. Rename Append structure
members to be clearer. Fix cost computation for these.
Thomas G. Lockhart [Tue, 14 Jul 1998 03:51:42 +0000 (03:51 +0000)]
Fix for UNION selects with constant NULL expressions; e.g.
SELECT 1 UNION SELECT NULL;
Thomas G. Lockhart [Tue, 14 Jul 1998 03:47:34 +0000 (03:47 +0000)]
First version of files from Oliver Elphick.
Bruce Momjian [Tue, 14 Jul 1998 03:02:53 +0000 (03:02 +0000)]
utoconf
Bruce Momjian [Tue, 14 Jul 1998 02:58:59 +0000 (02:58 +0000)]
Update for hpux and rint
Bruce Momjian [Tue, 14 Jul 1998 02:41:26 +0000 (02:41 +0000)]
More updates for typmod int32 change. From Tom Lane.
Bruce Momjian [Tue, 14 Jul 1998 01:45:25 +0000 (01:45 +0000)]
Major man page update from Tom Lane. c
Bruce Momjian [Mon, 13 Jul 1998 21:27:58 +0000 (21:27 +0000)]
Fix for AS name quotation problem.