OSDN Git Service
Bruce Momjian [Sun, 12 Apr 1998 14:17:40 +0000 (14:17 +0000)]
New book to FAQ.
Marc G. Fournier [Sun, 12 Apr 1998 02:58:22 +0000 (02:58 +0000)]
More work in the right direction on linux/alpha
From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
Bruce Momjian [Sun, 12 Apr 1998 01:18:35 +0000 (01:18 +0000)]
Fix for PROFILE env.
Marc G. Fournier [Sat, 11 Apr 1998 21:14:50 +0000 (21:14 +0000)]
linuxalpha patches from Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
Marc G. Fournier [Fri, 10 Apr 1998 22:07:41 +0000 (22:07 +0000)]
Oops...I used Relation->rd_fd->relname exactly, instead of using the actual
variable name *blush* *grin*
Marc G. Fournier [Fri, 10 Apr 1998 21:59:30 +0000 (21:59 +0000)]
Okay, add relation name to the file generating the error...
Marc G. Fournier [Fri, 10 Apr 1998 18:43:30 +0000 (18:43 +0000)]
See if I can determine where the BTP_CHAIN error is coming from...
Marc G. Fournier [Fri, 10 Apr 1998 02:59:38 +0000 (02:59 +0000)]
make --with-libs == --with-libraries
Bruce Momjian [Fri, 10 Apr 1998 02:48:08 +0000 (02:48 +0000)]
Clean up HISTORY file so I can generate cleaner HTML.
Bruce Momjian [Thu, 9 Apr 1998 04:42:56 +0000 (04:42 +0000)]
Oops reverse patch. no need for it.
Bruce Momjian [Thu, 9 Apr 1998 04:24:52 +0000 (04:24 +0000)]
Allow -lib-dir to find libreadline.a
Thomas G. Lockhart [Wed, 8 Apr 1998 06:42:17 +0000 (06:42 +0000)]
Still mostly empty but add info on PAGER env variable and general paging
behavior from Brett McCormick.
Thomas G. Lockhart [Wed, 8 Apr 1998 06:40:09 +0000 (06:40 +0000)]
Fix incorrect second argument type for dpow() declaration.
Thomas G. Lockhart [Wed, 8 Apr 1998 06:39:01 +0000 (06:39 +0000)]
Prepare the EXTRACT() clause for supporting TIMEZONE_HOUR
and TIMEZONE_MINUTE but don't introduce until v6.4.
Fix SET TIMEZONE LOCAL to pass null pointer
rather than older "default" string.
Fix handling of NULL pointer returns from FOREIGN KEY clauses
which are currently ignored.
Allow START as a table/column name.
Thomas G. Lockhart [Wed, 8 Apr 1998 06:35:02 +0000 (06:35 +0000)]
Temporarily back out fixes for unary minus parsing.
Will re-introduce for v6.4 but requires fixes for automatic type
conversion beforehand.
Bruce Momjian [Wed, 8 Apr 1998 02:32:52 +0000 (02:32 +0000)]
Remove name.* files.
Marc G. Fournier [Wed, 8 Apr 1998 02:06:37 +0000 (02:06 +0000)]
From: Bruce Stephens <bruce@cenderis.demon.co.uk>
fix for the tk problem...
Bruce Momjian [Tue, 7 Apr 1998 22:36:38 +0000 (22:36 +0000)]
Re-add pg_dump fix.
Bruce Momjian [Tue, 7 Apr 1998 22:00:37 +0000 (22:00 +0000)]
Reverse out pg_dump changes.
Bruce Momjian [Tue, 7 Apr 1998 21:26:52 +0000 (21:26 +0000)]
Update configure.
Bruce Momjian [Tue, 7 Apr 1998 21:01:28 +0000 (21:01 +0000)]
Update for 6.3.2
Bruce Momjian [Tue, 7 Apr 1998 18:14:38 +0000 (18:14 +0000)]
Back out char2-char16 removal. Add later.
Bruce Momjian [Tue, 7 Apr 1998 16:41:11 +0000 (16:41 +0000)]
Fix for ACL's from Thomas A. Szybist.
Bruce Momjian [Mon, 6 Apr 1998 17:52:35 +0000 (17:52 +0000)]
Assert fix
Bruce Momjian [Mon, 6 Apr 1998 17:27:54 +0000 (17:27 +0000)]
ASSERT fixes.
Bruce Momjian [Mon, 6 Apr 1998 17:02:13 +0000 (17:02 +0000)]
distclean cleanup
Bruce Momjian [Mon, 6 Apr 1998 16:53:15 +0000 (16:53 +0000)]
DESTDIR removed, again.
Thomas G. Lockhart [Mon, 6 Apr 1998 15:33:53 +0000 (15:33 +0000)]
Older html conversion of original docs to html
superceded by the new sgml/docbook versions.
Bruce Momjian [Mon, 6 Apr 1998 04:57:32 +0000 (04:57 +0000)]
destdir cleanup.
Bruce Momjian [Mon, 6 Apr 1998 03:23:01 +0000 (03:23 +0000)]
Makefile cleanup./
Bruce Momjian [Mon, 6 Apr 1998 03:10:32 +0000 (03:10 +0000)]
confiure cleanup
Bruce Momjian [Mon, 6 Apr 1998 02:38:26 +0000 (02:38 +0000)]
Cleanup of compiler warnings.
Bruce Momjian [Mon, 6 Apr 1998 02:10:49 +0000 (02:10 +0000)]
Cleanup initdb
Bruce Momjian [Mon, 6 Apr 1998 02:03:08 +0000 (02:03 +0000)]
cleanup and possible alpha-linux fix.
Bruce Momjian [Mon, 6 Apr 1998 01:36:41 +0000 (01:36 +0000)]
Make DESTDIR consistent, and verious Linux cleanups.
Bruce Momjian [Mon, 6 Apr 1998 01:16:55 +0000 (01:16 +0000)]
Re-introduce $DISTDIR.
Bruce Momjian [Mon, 6 Apr 1998 01:05:54 +0000 (01:05 +0000)]
Move initdb.sh to initdb
Bruce Momjian [Mon, 6 Apr 1998 00:32:26 +0000 (00:32 +0000)]
Hi,
Attached you'll find a (big) patch that fixes make dep and make
depend in all Makefiles where I found it to be appropriate.
It also removes the dependency in Makefile.global for NAMEDATALEN
and OIDNAMELEN by making backend/catalog/genbki.sh and bin/initdb/initdb.sh
a little smarter.
This no longer requires initdb.sh that is turned into initdb with
a sed script when installing Postgres, hence initdb.sh should be
renamed to initdb (after the patch has been applied :-) )
This patch is against the 6.3 sources, as it took a while to
complete.
Please review and apply,
Cheers,
Jeroen van Vianen
Bruce Momjian [Sun, 5 Apr 1998 22:02:56 +0000 (22:02 +0000)]
Remove DISTDIR.
Bruce Momjian [Sun, 5 Apr 1998 21:29:49 +0000 (21:29 +0000)]
this patch solve 2 problemes :
probleme number 1 :
- configure can find the library readline , but don't
find the header file . so in this case we don't use lib readline
.
probleme number 2 :
- when you have postgres 6.2.1 and readline installed
with the same prefix( and generally all your software ) . you
can compile the version 6.3 . I use this prefix , when configure
ask me for "Additional directories to search for include files"
.
( because there a conflict in the header when you
compile psql.c ) In this case, you must permut the sequence of
directive -I .
Erwan MAS
Bruce Momjian [Sun, 5 Apr 1998 21:18:03 +0000 (21:18 +0000)]
configure cleanup.
Bruce Momjian [Sun, 5 Apr 1998 21:04:50 +0000 (21:04 +0000)]
Remove GetDatabaseName/Path and use globals. Make consts later.
Bruce Momjian [Sun, 5 Apr 1998 20:54:38 +0000 (20:54 +0000)]
confiugre.in cleanup.
Bruce Momjian [Sun, 5 Apr 1998 20:28:23 +0000 (20:28 +0000)]
Here are 3 patches (all relative to the src directory) to help with
the configuration of v6.3.1. I have replaced the queries for
include/lib directories with --with configuration options. I have
also included a list of potential tcl/tk include directories directly
in the CPPFLAGS variable. As new versions are needed, these should
be added to the list in reverse numerical order (libraries are in
a separate list near the end). This greatly simplifies the later
checks if --with-tcl is set. I hope this solution works for
everyone.
I also added a check to disable the perl support if postgres was
not already installed (as per the instructions in the directory).
By the way, why must there be an installed pgsql to compile perl
support? This seems odd, at best.
Finally, I changed the Makefile in the libpgtcl interface to place
the shared libraries at the end of the list of files, not at the
beginning. With NetBSD at least, libraries are linked in order,
so the original sequence does not work.
Brook Milligan
Thomas G. Lockhart [Sun, 5 Apr 1998 17:10:41 +0000 (17:10 +0000)]
Information completely translated to the SGML/DocBook source files
pgtcl.sgml, spi.sgml, trigger.sgml.
Online docs in html and postscript are the current versions.
Thomas G. Lockhart [Sun, 5 Apr 1998 17:07:32 +0000 (17:07 +0000)]
Include complete Makefile.global if available,
rather than just Makefile.custom.
Bruce Momjian [Sun, 5 Apr 1998 05:52:10 +0000 (05:52 +0000)]
Fix for memory leak.
Thomas G. Lockhart [Sat, 4 Apr 1998 16:35:22 +0000 (16:35 +0000)]
Clean up formatting.
Add more URL links for GiST information.
Thomas G. Lockhart [Sat, 4 Apr 1998 16:34:23 +0000 (16:34 +0000)]
Include example of table loading using the COPY command.
Thomas G. Lockhart [Sat, 4 Apr 1998 16:32:01 +0000 (16:32 +0000)]
Convert body of chapter to SGML. Was embedded text from original doc.
Thomas G. Lockhart [Sat, 4 Apr 1998 16:30:31 +0000 (16:30 +0000)]
Small corrections from Phil Thompson, the original author.
Thomas G. Lockhart [Sat, 4 Apr 1998 16:26:05 +0000 (16:26 +0000)]
Include the stub docs for the rules system. Omission in original versions.
Bruce Momjian [Fri, 3 Apr 1998 20:21:51 +0000 (20:21 +0000)]
A couple of weeks ago I submitted a patch to fix configure --with-tcl.
However somebody else also applied a patch to the same part of
configure to fix a different problem. So part of my patch was not
applied or got reversed or ... whatever.
The attached patch will restore configure --with-tcl to working
order and should remove a lot of the messages complaining about
tcl not working.
Alvin
Vadim B. Mikheev [Thu, 2 Apr 1998 07:27:15 +0000 (07:27 +0000)]
Fix merging pathes of pruned rels ("indices are unused" problem).
Marc G. Fournier [Wed, 1 Apr 1998 18:47:47 +0000 (18:47 +0000)]
resync configure
Marc G. Fournier [Wed, 1 Apr 1998 15:35:33 +0000 (15:35 +0000)]
From: Maurice Gittens <mgittens@david.gits.nl>
After applying the following patch there remain two
probable buffer overruns detected by Electric Fence during
the regression test.
I'll try find out what causes the remain two ones.
This patch also corrects a typo in smgr.c.
Marc G. Fournier [Wed, 1 Apr 1998 03:13:37 +0000 (03:13 +0000)]
remove the call to port-protos.h ...
Bruce Momjian [Tue, 31 Mar 1998 23:31:10 +0000 (23:31 +0000)]
Small HAVING cleanup.
Bruce Momjian [Tue, 31 Mar 1998 15:53:51 +0000 (15:53 +0000)]
Fix macro read violation for Maurice.
Bruce Momjian [Tue, 31 Mar 1998 04:44:35 +0000 (04:44 +0000)]
Merge rename name page into alter table. Fix UNION with DISTINCT
or ORDER BY bug.
Marc G. Fournier [Tue, 31 Mar 1998 03:00:20 +0000 (03:00 +0000)]
Pointed out by: Doug Winterburn <dlw@seavme.xroads.com>
3) Add "#include "config.h" to src/interfaces/ecpg/preproc/pgc.l
to correct "strings.h not found". config.h has the proper define to
make this work and should probably be near the top of pgc.l before
the first include.
Marc G. Fournier [Tue, 31 Mar 1998 02:59:07 +0000 (02:59 +0000)]
Pointed out by: Doug Winterburn <dlw@seavme.xroads.com>
2) Add "#define gettimeofday(a,b) gettimeofday(a) to src/include/config.h
On the 88k SVR4, gettimeofday only has one argument. This is
checked for in a few other packages by configure, so there should
be some examples of the configure test out there.
Bruce Momjian [Mon, 30 Mar 1998 19:05:10 +0000 (19:05 +0000)]
documentation for HAVING, clean up UNION comment.
Bruce Momjian [Mon, 30 Mar 1998 17:46:45 +0000 (17:46 +0000)]
This simple patch to catalog/pg_type.c fixes a buffer overrun. It
was detected by Electric Fence and triggered by statements like:
SELECT * into table t from pg_database;
The system would crash on a memmove call in DataFile() with arguments
like this:
memmove(0x0, 0x0, 0);
Maurice Gittens
Bruce Momjian [Mon, 30 Mar 1998 17:39:16 +0000 (17:39 +0000)]
This problem had nothing to do with the upgrades I made. There
was a 2000 character buffer allocated for results, and the files
you refer to produce a 2765 byte column called formsource. This
should not have worked with any version of libpgtcl.
Nevertheless, the limit is an artificial one, since there is no
need to use this intermediate buffer where it is being used and
abused.
Randy Kunkee <kunkee@pluto.ops.NeoSoft.com>
Bruce Momjian [Mon, 30 Mar 1998 17:28:21 +0000 (17:28 +0000)]
The following uuencoded, gzip'd file will ...
1. Remove the char2, char4, char8 and char16 types from postgresql
2. Change references of char16 to name in the regression tests.
3. Rename the char16.sql regression test to name.sql. 4. Modify
the regression test scripts and outputs to match up.
Might require new regression.{SYSTEM} files...
Darren King
Bruce Momjian [Mon, 30 Mar 1998 17:15:26 +0000 (17:15 +0000)]
The buffer overrun while creating sequences turns out to be a read
access overrun. For the sake of doing things properly here is a
patch which fixes it.
This patch is for the file backend/commands/sequence.c.
Maurice Gittens
Bruce Momjian [Mon, 30 Mar 1998 16:47:35 +0000 (16:47 +0000)]
There's a patch attached to fix gcc 2.8.x warnings, except for the
yyerror ones from bison. It also includes a few 'enhancements' to
the C programming style (which are, of course, personal).
The other patch removes the compilation of backend/lib/qsort.c, as
qsort() is a standard function in stdlib.h and can be used any
where else (and it is). It was only used in
backend/optimizer/geqo/geqo_pool.c, backend/optimizer/path/predmig.c,
and backend/storage/page/bufpage.c
> > Some or all of these changes might not be appropriate for v6.3,
since we > > are in beta testing and since they do not affect the
current functionality. > > For those cases, how about submitting
patches based on the final v6.3 > > release?
There's more to come. Please review these patches. I ran the
regression tests and they only failed where this was expected
(random, geo, etc).
Cheers,
Jeroen
Bruce Momjian [Mon, 30 Mar 1998 16:36:43 +0000 (16:36 +0000)]
I started adding the Having Clause and it works quite fine for
sequential scans! (I think it will also work with hash, index, etc
but I did not check it out! I made some High level changes which
should work for all access methods, but maybe I'm wrong. Please
let me know.)
Now it is possible to make queries like:
select s.sname, max(p.pid), min(p.pid) from part p, supplier s
where s.sid=p.sid group by s.sname having max(pid)=6 and min(pid)=1
or avg(pid)=4;
Having does not work yet for queries that contain a subselect
statement in the Having clause, I'll try to fix this in the next
days.
If there are some bugs, please let me know, I'll start to read the
mailinglists now!
Now here is the patch against the original 6.3 version (no snapshot!!):
Stefan
Marc G. Fournier [Sun, 29 Mar 1998 21:52:54 +0000 (21:52 +0000)]
Upgrade to v0.86
Bruce Momjian [Sat, 28 Mar 1998 02:24:49 +0000 (02:24 +0000)]
Prevent pgindent from being run on odbc in the future.
Bruce Momjian [Thu, 26 Mar 1998 23:46:14 +0000 (23:46 +0000)]
I have been troubled by a segmentation fault when reloading from
a dumpall. This has been happening when a second \connect is
encountered.
The faulty code was in fe-connect.c, where the memory for the user
password was freed, but the pointer itself was not set to NULL.
Later, the memory was reused and the password appeared not to be
empty, so that an attempt was made to reference it.
Oliver Elphick
Bruce Momjian [Thu, 26 Mar 1998 21:08:10 +0000 (21:08 +0000)]
BETWEEN and LIKE patch from Thomas
Bruce Momjian [Thu, 26 Mar 1998 21:01:47 +0000 (21:01 +0000)]
Update manual
Bruce Momjian [Wed, 25 Mar 1998 01:54:53 +0000 (01:54 +0000)]
Mention rollback instead of abort.
Bruce Momjian [Wed, 25 Mar 1998 01:45:33 +0000 (01:45 +0000)]
install cleanup
Bruce Momjian [Mon, 23 Mar 1998 17:54:47 +0000 (17:54 +0000)]
FAQ_Irix update
Bruce Momjian [Mon, 23 Mar 1998 16:14:50 +0000 (16:14 +0000)]
update for 6.3.1
Bruce Momjian [Mon, 23 Mar 1998 15:09:43 +0000 (15:09 +0000)]
Manual page fixes.
Bruce Momjian [Mon, 23 Mar 1998 06:08:51 +0000 (06:08 +0000)]
autoconf again.
Bruce Momjian [Mon, 23 Mar 1998 06:03:04 +0000 (06:03 +0000)]
more tcl/tk fixes
Bruce Momjian [Mon, 23 Mar 1998 04:08:05 +0000 (04:08 +0000)]
Another tcl/tk fix.
Bruce Momjian [Mon, 23 Mar 1998 03:48:32 +0000 (03:48 +0000)]
oops, forgot to run autoconf.
Bruce Momjian [Mon, 23 Mar 1998 03:45:10 +0000 (03:45 +0000)]
another tcl/tk patch
another tcl/tk patch
Bruce Momjian [Mon, 23 Mar 1998 03:27:07 +0000 (03:27 +0000)]
fix for tcl/tk in configure
Marc G. Fournier [Sun, 22 Mar 1998 19:46:45 +0000 (19:46 +0000)]
Add NetBSD specific expected files
Marc G. Fournier [Sun, 22 Mar 1998 19:40:33 +0000 (19:40 +0000)]
Slightly updated regression output for FreeBSD 3.0-CURRENT
Marc G. Fournier [Sun, 22 Mar 1998 19:35:30 +0000 (19:35 +0000)]
Made some changes to clean up how initdb works...just more made a 'PGSQL_OPTS'
variable that can be set in one place to affect everything...
Marc G. Fournier [Sun, 22 Mar 1998 18:28:39 +0000 (18:28 +0000)]
Change 2>$1 to -o /dev/null instead...
From: Andreas Klemm <andreas@klemm.gtn.com>
Marc G. Fournier [Sun, 22 Mar 1998 04:18:17 +0000 (04:18 +0000)]
Moved sys/types.h to before netdb.h
From: Vince Vielhaber <vev@michvhf.com>
Bruce Momjian [Sun, 22 Mar 1998 03:22:50 +0000 (03:22 +0000)]
Cleanup for Thomas
Marc G. Fournier [Sun, 22 Mar 1998 02:03:00 +0000 (02:03 +0000)]
Contribution for logging Apache Web stats to PostgreSQL
From: Terry Mackintosh <terry@terrym.com>
Bruce Momjian [Sat, 21 Mar 1998 15:17:30 +0000 (15:17 +0000)]
change in item person;
Bruce Momjian [Sat, 21 Mar 1998 15:01:32 +0000 (15:01 +0000)]
cleanup instructions for patch upgrade.
Bruce Momjian [Sat, 21 Mar 1998 05:28:27 +0000 (05:28 +0000)]
Update for 6.3p1 release.
Bruce Momjian [Sat, 21 Mar 1998 04:42:58 +0000 (04:42 +0000)]
Better identify tcl and tk.
Bruce Momjian [Fri, 20 Mar 1998 22:03:55 +0000 (22:03 +0000)]
This patch fixes a couple of minor bugs:
1) DatabaseMetaData.getPrimaryKeys() would fail saying that there
is no
table t.
2) PreparedStatement.getObject() was missing some break statements,
which
was causing updates not to work with JBuilder (supplied by Aaron
Dunlop).
jdbc fixes from Peter.
Bruce Momjian [Fri, 20 Mar 1998 18:47:15 +0000 (18:47 +0000)]
Disable -lbsd on alpha.
Bruce Momjian [Fri, 20 Mar 1998 17:24:37 +0000 (17:24 +0000)]
Add missing file.
Bruce Momjian [Fri, 20 Mar 1998 04:22:54 +0000 (04:22 +0000)]
OK...here is a patch that will cause the magnetic disk storage
manager to not try to split files in 2 gig chunks. It will just
try to get another block.
If applied, everything is just as before. But if LET_OS_MANAGE_FILESIZE
is defined, the chaining disappears and the file just keeps on
going, and going, and going, til the OS barfs.
Darren King