OSDN Git Service
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
Bruce Momjian [Fri, 20 Mar 1998 04:17:34 +0000 (04:17 +0000)]
Sorry. I made above mistakes. "__svr4" should be "__svr4__" or
"__SVR4" as you pointed out. There is another file that has the
same mistakes. Included is a patche for include/c.h.
t-ishii@sra.co.jp
Bruce Momjian [Fri, 20 Mar 1998 04:12:25 +0000 (04:12 +0000)]
Fix spelling of "including
Edward J. Huff
Bruce Momjian [Fri, 20 Mar 1998 04:07:11 +0000 (04:07 +0000)]
HPUX build does not build shared lib versions of libpq and libpq++
--------------------------------------------------------------------------
Test Case: ----------
--------------------------------------------------------------------------
Solution: --------- Add this to the libpq and libpq++ Makefiles
to build shared libs:
Mike Ferrara
Bruce Momjian [Fri, 20 Mar 1998 04:02:57 +0000 (04:02 +0000)]
In libpq-fe.h: #if defined(sun) && defined(sparc) && !defined(__svr4)
extern char *sys_errlist[]; #define strerror(A) (sys_errlist[(A)])
#endif /* sunos4
*/
is picked up by Solaris when the above is intended only for SunOS.
Fix Solaris. Albert Chin-A-Young
Bruce Momjian [Fri, 20 Mar 1998 03:55:52 +0000 (03:55 +0000)]
The real trick is to add -Dalpha to the CFLAGS setting. The changes
to main.c are only to add some extra includes to support some code
that's suddenly being used.
The #define ASSEMBLER is to prevent most of the code of sys/proc.h
from being included, as it ends up conflicting with some of the
postgresql definitions. This may or may not work on other versions
of Digital Unix.
Get alpha working. Yea. Dwayne Bailey
Bruce Momjian [Fri, 20 Mar 1998 03:44:19 +0000 (03:44 +0000)]
> > I'm using text[] arrays. Some of my array elements have '"'
> > characters in them. Dumping and reloading using pg_dumpall >
> doesn't work with this and dumping the entire array and > > then
trying to parse it is hopeless.
Doug Gibson
Bruce Momjian [Fri, 20 Mar 1998 03:08:11 +0000 (03:08 +0000)]
Here's my next patch to bring ecpg to version 1.1. It now correctly
handles all transaction commands and the exec sql include command.
Michael Meskes
Thomas G. Lockhart [Wed, 18 Mar 1998 16:50:25 +0000 (16:50 +0000)]
Allow parsing expressions with ") -" (scan.l, scan.c only).
Make "TABLE" optional in "LOCK TABLE" command
and "... INTO TABLE..." clause.
Explicitly parse CREATE SEQUENCE options to allow a negative integer
as an argument; this is an artifact of unary minus handling in scan.l.
Add "PASSWORD" as an allowed column identifier.
These fixes will require a "make clean install" but not a dump/reload.
Bruce Momjian [Wed, 18 Mar 1998 15:49:08 +0000 (15:49 +0000)]
Add checks for UNION target fields, and add optional TABLE to LOCK
and SELECT manual pages and psql help.
Bruce Momjian [Mon, 16 Mar 1998 15:14:50 +0000 (15:14 +0000)]
SunOS .similar cleanup.
Bruce Momjian [Mon, 16 Mar 1998 14:46:37 +0000 (14:46 +0000)]
Add SunOS entries.
Bruce Momjian [Mon, 16 Mar 1998 14:27:38 +0000 (14:27 +0000)]
Prevent \do from wrapping.
Bruce Momjian [Mon, 16 Mar 1998 05:58:46 +0000 (05:58 +0000)]
Make pg_user /xpg_user change complete.
Bruce Momjian [Mon, 16 Mar 1998 05:52:23 +0000 (05:52 +0000)]
Remove duplicates
Bruce Momjian [Mon, 16 Mar 1998 05:49:32 +0000 (05:49 +0000)]
Fix for Datasize = 0 error, from Vadim.
Bruce Momjian [Mon, 16 Mar 1998 05:41:39 +0000 (05:41 +0000)]
Fix for pg_dump of large objects, from alvin@camberlo.demon.co.uk.
Bruce Momjian [Mon, 16 Mar 1998 05:37:16 +0000 (05:37 +0000)]
subselect notes from Vadim.
Marc G. Fournier [Sun, 15 Mar 1998 08:33:59 +0000 (08:33 +0000)]
From: Jeroen van Vianen <jeroenv@design.nl>
tools.patch patches tools/find_static (use indices to increase
performance) and tools/ccsym (no hardcoded paths).
Marc G. Fournier [Sun, 15 Mar 1998 08:18:03 +0000 (08:18 +0000)]
From: hankin <hankin@consultco.com>
a while back I posted a patch for pg_ident, the patch worked but I didn't
diagnose the problem properly.
on my compiler(gcc2.7.2) this compiles with no errors...
char buf[1000]; if(buf != '\0') {
...but it doesn't compare '\0' with the first char of buf.
Marc G. Fournier [Sun, 15 Mar 1998 08:15:46 +0000 (08:15 +0000)]
Reply-To: Jordi MacDonald <jordi@spartanmedia.com>
There is an error in the configure script when using
--with-pgport= that will cause the compiled version of
PostgreSQL to no longer allow connections to the
new port and to treat shared memory improperly.
What happens is that if the port is changed, the configure
script defines DEF_PGPORT as "", which atoi() will return
as 0, which makes the IPC_KEY value 0. This then causes
semaphores to be allocated, but never released. Postgres
eventually returns from semget() with
"no space left on device". The source of this error could
easily be overlooked in version 6.3 since it is possible
to connect via UNIX domain sockets, and having DEF_PGPORT
defined as "0" would not be noticed until TCP was used.
Marc G. Fournier [Sun, 15 Mar 1998 08:11:11 +0000 (08:11 +0000)]
From: Randy Kunkee <kunkee@pluto.ops.NeoSoft.com>
The following patch is to src/interfaces/libpq of postgresql-6.3.
The purpose of the patch is to make the initialization of
const char *pgresStatus[] match the ExecStatusType enum.
Marc G. Fournier [Sun, 15 Mar 1998 08:09:37 +0000 (08:09 +0000)]
From: t-ishii@sra.co.jp
6.3 postmaster is supposed to work with pre 6.3 protocol. This is true
for little endian architecture servers. But for big endian machines
such as Sparc the backward compatibility function do not work.
Attached are patches to fix the problem.
Marc G. Fournier [Sun, 15 Mar 1998 08:07:01 +0000 (08:07 +0000)]
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
For substr() and substring() on the text data type, the relevant code is in
varlena.c. You are right, there is a problem. I have a patch which I will
apply to the source tree soon. The copy enclosed below probably does not
preserve tabs correctly so cannot be applied directly; the relevant change
is simply changing the ">=" to ">"...
Marc G. Fournier [Sun, 15 Mar 1998 08:03:00 +0000 (08:03 +0000)]
From: Randy Kunkee <kunkee@pluto.ops.NeoSoft.com>
It is my hope that the following "patches" to libpgtcl get included
in the next release.
See the update to the README file to get a full description of the changes.
This version of libpgtcl is completely interpreter-safe, implements the
database connection handle as a channel (no events yet, but will make it
a lot easier to do fileevents on it in the future), and supports the SQL
"copy table to stdout" and "copy table from stdin" commands, with the
I/O being from and to the connection handle. The connection and result
handles are formatted in a way to make access to the tables more efficient.
Marc G. Fournier [Sun, 15 Mar 1998 07:53:03 +0000 (07:53 +0000)]
From: t-ishii@sra.co.jp
Included are patches intended for allowing PostgreSQL to handle
multi-byte charachter sets such as EUC(Extende Unix Code), Unicode and
Mule internal code. With the MB patch you can use multi-byte character
sets in regexp and LIKE. The encoding system chosen is determined at
the compile time.
To enable the MB extension, you need to define a variable "MB" in
Makefile.global or in Makefile.custom. For further information please
take a look at README.mb under doc directory.
(Note that unlike "jp patch" I do not use modified GNU regexp any
more. I changed Henry Spencer's regexp coming with PostgreSQL.)
Marc G. Fournier [Sun, 15 Mar 1998 07:39:04 +0000 (07:39 +0000)]
From: t-ishii@sra.co.jp
Included are patches intended for allowing PostgreSQL to handle
multi-byte charachter sets such as EUC(Extende Unix Code), Unicode and
Mule internal code. With the MB patch you can use multi-byte character
sets in regexp and LIKE. The encoding system chosen is determined at
the compile time.
To enable the MB extension, you need to define a variable "MB" in
Makefile.global or in Makefile.custom. For further information please
take a look at README.mb under doc directory.
(Note that unlike "jp patch" I do not use modified GNU regexp any
more. I changed Henry Spencer's regexp coming with PostgreSQL.)
Marc G. Fournier [Sun, 15 Mar 1998 07:12:07 +0000 (07:12 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
Ok, this fixes three things:
1. It seems (from tests submitted by two people with JBuilder) that
JBuilder expects a responce from ResultSetMetaData.getPrecision() &
getScale() when used on non numeric types. This patch makes these
methods return 0, instead of throwing an exception.
2. Fixes a small bug where getting the postgresql type name returns null.
3. Fixes a problem with ResultSet.getObject() where getting it's string
value returns null if you case the object as (PGobject), but returns
the value if you case it as it's self.
Bruce Momjian [Sun, 15 Mar 1998 02:13:23 +0000 (02:13 +0000)]
CLUSTER cleanup
Bruce Momjian [Sat, 14 Mar 1998 22:55:21 +0000 (22:55 +0000)]
Cluster fixup.
Bruce Momjian [Sat, 14 Mar 1998 21:58:09 +0000 (21:58 +0000)]
Change Postgres95 to PostgreSQL. Update CLUSTER manual page.
Bruce Momjian [Sat, 14 Mar 1998 04:15:49 +0000 (04:15 +0000)]
Remove postgres95.
Marc G. Fournier [Thu, 12 Mar 1998 13:09:46 +0000 (13:09 +0000)]
Update Pgaccess to 0.83
Marc G. Fournier [Tue, 10 Mar 1998 05:24:33 +0000 (05:24 +0000)]
Get the ultrix4 ports back in sync...
Thomas G. Lockhart [Sat, 7 Mar 1998 06:04:59 +0000 (06:04 +0000)]
Repair "LIKE" behavior with two adjacent wildcard characters ("_").
Was ignoring second wildcard.
Thomas G. Lockhart [Sat, 7 Mar 1998 06:03:28 +0000 (06:03 +0000)]
Add one-line fix to allow redefining built-in functions.
Bug introduced in mid-January.
Bruce Momjian [Sat, 7 Mar 1998 04:49:57 +0000 (04:49 +0000)]
Fix bad oid in table.
Bruce Momjian [Fri, 6 Mar 1998 22:49:58 +0000 (22:49 +0000)]
xinv fix for tclsh
Bruce Momjian [Fri, 6 Mar 1998 18:03:38 +0000 (18:03 +0000)]
pg_user cleanup.
Bruce Momjian [Fri, 6 Mar 1998 17:25:51 +0000 (17:25 +0000)]
Rename pg_user to pg_shadow.
Marc G. Fournier [Thu, 5 Mar 1998 13:18:51 +0000 (13:18 +0000)]
Add ecpg back in again
Bruce Momjian [Wed, 4 Mar 1998 18:41:08 +0000 (18:41 +0000)]
Get rid of those pesky long constants, 'l'. Has no affect.
Marc G. Fournier [Mon, 2 Mar 1998 14:54:59 +0000 (14:54 +0000)]
One last change to configure for 'non-gcc' compiler
Marc G. Fournier [Mon, 2 Mar 1998 06:12:15 +0000 (06:12 +0000)]
From: Darren King <darrenk@insightdist.com>
Patch1:
Postgres thinks dist_pl (dist of a point to a line) is expecting a box (603)
for the right arg, but it really should be a line (628).
Otherwise the left & right args match those of dist_pb (dist of a point to a
box) two lines further down.
Patch2:
Anyways, these two functions take a path (602) whereas in pg_proc.h they are
listed as taking a lseg (601).
Bruce Momjian [Mon, 2 Mar 1998 05:52:57 +0000 (05:52 +0000)]
Reminder for next time.
Marc G. Fournier [Mon, 2 Mar 1998 05:42:15 +0000 (05:42 +0000)]
Last minute clean up for SunOS...
From: t-ishii@sra.co.jp
Marc G. Fournier [Mon, 2 Mar 1998 05:33:14 +0000 (05:33 +0000)]
Change configure to reflect v6.3 vs v6.2 :)
Marc G. Fournier [Mon, 2 Mar 1998 03:04:26 +0000 (03:04 +0000)]
Bring pgaccess up to 0.82 - last update before release
Thomas G. Lockhart [Mon, 2 Mar 1998 00:13:36 +0000 (00:13 +0000)]
Fix money type USE_LOCALE support at least for default "C" locale.
Still has questionable code for some locale-specific strings.
Bruce Momjian [Sun, 1 Mar 1998 22:26:42 +0000 (22:26 +0000)]
Update for release. Add mention of new manuals.
Bruce Momjian [Sun, 1 Mar 1998 21:13:30 +0000 (21:13 +0000)]
Install new 0.81 pgaccess release.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:50:46 +0000 (20:50 +0000)]
Update html tar files to include only necessary gif files.
Incorporate a few typo fixes.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:47:20 +0000 (20:47 +0000)]
Make this rely on a real Makefile in sgml/.
Implement installation and cleaning.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:46:10 +0000 (20:46 +0000)]
Fix a few typos. Try <Note><Title>Author</Title>... for author credit.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:44:37 +0000 (20:44 +0000)]
Try a fancier makefile. Allows real building of html and rtf output
rather than just executing ../Makefile.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:42:52 +0000 (20:42 +0000)]
Replace incorrect gif files.
Thomas G. Lockhart [Sun, 1 Mar 1998 20:37:44 +0000 (20:37 +0000)]
Allow installation of documentation packages.
Thomas G. Lockhart [Sun, 1 Mar 1998 08:18:09 +0000 (08:18 +0000)]
Stopgap makefile for new sgml source documentation.
Should redo this before v6.3 release if possible.
Thomas G. Lockhart [Sun, 1 Mar 1998 08:16:16 +0000 (08:16 +0000)]
SGML source for new documentation.
Thomas G. Lockhart [Sun, 1 Mar 1998 08:15:10 +0000 (08:15 +0000)]
Graphics sources and GIF bitmaps for new documentation.
Thomas G. Lockhart [Sun, 1 Mar 1998 08:14:01 +0000 (08:14 +0000)]
New documentation generated from SGML source.
Thomas G. Lockhart [Sun, 1 Mar 1998 08:10:34 +0000 (08:10 +0000)]
Fix boolean operator declarations for path to return boolean, not float8.
Bruce Momjian [Sun, 1 Mar 1998 05:41:01 +0000 (05:41 +0000)]
Prepare for release.
Bruce Momjian [Sun, 1 Mar 1998 05:27:47 +0000 (05:27 +0000)]
Prepare for 6.3 release.
Marc G. Fournier [Sun, 1 Mar 1998 04:53:54 +0000 (04:53 +0000)]
From: "Billy G. Allie" <Bill.Allie@mug.org>
The following patch will change the meaning of the isinf function in the
HAVE_FPCLASS section from "not finite" to "is infinity".
Marc G. Fournier [Sun, 1 Mar 1998 04:52:59 +0000 (04:52 +0000)]
From: Darren King <darrenk@insightdist.com>
1. Make 'all' works without complaint. Don't have to add the .exp
files to the files list. They are made automagically when
making the respective shared lib file.
Only port that actually uses EXPSUFF (from makefiles/Makefile.*)
is Aix, so if this breaks anybody else, let me know, asap.
2. Make 'clean' actually cleans up correctly. Previously, it would
leave the .o files in C-code directory.
3. Changed references to reflect new location of .c files.
4. Added DELETE statements to complex.source so that it tidies up
when done. Previously, it would leave things in pg_amop,
pg_amproc and pg_opclass. Only possible to do this with the
new SUBSELECT code in 6.3. Nice work, fellas...
Not deleting the index entries would cause a non-fatal error if
complex.sql was run again on the same database. Much tidier now.
5. Corrected the README. obj directory hasn't existed since Bryan
redid the make way back when. Also changed the snipet from psql
to match the current version. POSTGRES95?!? I don't think so. :)
Marc G. Fournier [Sun, 1 Mar 1998 04:51:16 +0000 (04:51 +0000)]
Move around files before applying Darren's second patch