Thomas G. Lockhart [Tue, 8 Dec 1998 06:20:48 +0000 (06:20 +0000)]
Clean up a few elog() messages for aggregates and functions.
Thomas G. Lockhart [Tue, 8 Dec 1998 06:19:15 +0000 (06:19 +0000)]
Define routines and catalog entries for string min()/max() functions.
Extend new type coersion techniques to aggregates.
Clean up a few elog() messages.
Thomas G. Lockhart [Tue, 8 Dec 1998 06:18:34 +0000 (06:18 +0000)]
Define routines and catalog entries for string min()/max() functions.
Extend new type coersion techniques to aggregates.
Tom Lane [Sat, 5 Dec 1998 22:09:57 +0000 (22:09 +0000)]
Fix coredumping bug in pg_dump -z; also eliminate memory leaks
in the ACL code, and spell "GRANT RULE" correctly.
Apply patch from Oliver Elphick to not dump inherited constraints.
Apply patch from Constantin Teodorescu to dump table definitions with a
readable layout.
Thomas G. Lockhart [Fri, 4 Dec 1998 15:52:45 +0000 (15:52 +0000)]
These data types were removed before the last release.
Thomas G. Lockhart [Fri, 4 Dec 1998 15:36:51 +0000 (15:36 +0000)]
Include test for CASE expression.
Thomas G. Lockhart [Fri, 4 Dec 1998 15:34:49 +0000 (15:34 +0000)]
Implement CASE expression.
Tom Lane [Mon, 30 Nov 1998 00:30:05 +0000 (00:30 +0000)]
Portability fixes found needed for SunOS 4.1.x:
SunOS has tas(), but not memmove or strerror, and its sprintf() doesn't
return int. Also, older versions of GNU Make don't like rules with
empty left-hand sides...
Tom Lane [Sun, 29 Nov 1998 05:30:25 +0000 (05:30 +0000)]
Use autoconf to determine whether system has POSIX signals,
instead of relying on port's os.h to tell us. (Needed for HPUX
where system major version is not enough info.)
configure unsets USE_TK if X libraries not found.
doc/Makefile uses gzcat or zcat as found by autoconf.
Tom Lane [Sun, 29 Nov 1998 01:57:59 +0000 (01:57 +0000)]
Change exp() behavior to generate error on underflow rather
than silently returning zero on some machines. Correct float8 regress test
to agree. Also fix pow() overflow/underflow check to work correctly on
HPUX.
Tom Lane [Sun, 29 Nov 1998 01:53:54 +0000 (01:53 +0000)]
Portability fix for old SunOS releases: realloc(NULL, ...)
doesn't work there.
Tom Lane [Sun, 29 Nov 1998 01:51:56 +0000 (01:51 +0000)]
Portability fix for old SunOS releases: fflush(NULL)
doesn't work there. Fortunately the postmaster only has stdout and
stderr to flush.
Tom Lane [Sun, 29 Nov 1998 01:47:42 +0000 (01:47 +0000)]
pq_getstr didn't handle buffer overrun correctly; it would
fail to consume the rest of the input string, and worse it would write
one more byte than it should into the buffer, probably resulting in coredump.
Fortunately there's a correct implementation next door in pqcomprim.c.
Tom Lane [Sat, 28 Nov 1998 23:12:50 +0000 (23:12 +0000)]
Add link to HPUX platform FAQ.
Tom Lane [Sat, 28 Nov 1998 23:10:22 +0000 (23:10 +0000)]
New platform-specific FAQ for HP-UX sites.
Vadim B. Mikheev [Fri, 27 Nov 1998 20:09:56 +0000 (20:09 +0000)]
New HeapTuple structure/interface.
Vadim B. Mikheev [Fri, 27 Nov 1998 19:52:36 +0000 (19:52 +0000)]
New HeapTuple structure/interface.
Vadim B. Mikheev [Fri, 27 Nov 1998 19:33:35 +0000 (19:33 +0000)]
New HeapTuple structure/interface.
Thomas G. Lockhart [Wed, 25 Nov 1998 02:57:27 +0000 (02:57 +0000)]
csh and sh examples were reversed.
Update the csh example with new comments and fixes from Thomas' linux box.
Bruce Momjian [Tue, 24 Nov 1998 03:48:22 +0000 (03:48 +0000)]
Update platform FAQ's.
Jan Wieck [Mon, 23 Nov 1998 16:50:54 +0000 (16:50 +0000)]
Fixed bug in the unknown module. Module still tried to call
builtin SPI commands by their old SPI_* names. New names are spi_*.
Jan - 11/23/1998
Tom Lane [Mon, 23 Nov 1998 04:40:58 +0000 (04:40 +0000)]
modify configure so that template/.similar entries can be
selected when they match a prefix of the value. The previous method,
which stripped all version data from and then tried to match that
against .similar entries, was entirely useless when .similar contained
several entries for different version numbers of a single OS name.
Vadim B. Mikheev [Sun, 22 Nov 1998 10:48:45 +0000 (10:48 +0000)]
Fix using indices in OR.
EXPLAIN all indices used.
Vadim B. Mikheev [Sun, 22 Nov 1998 10:45:09 +0000 (10:45 +0000)]
Added indxqualorig to IndexScan: fix for using indices in OR.
Marc G. Fournier [Thu, 19 Nov 1998 02:39:51 +0000 (02:39 +0000)]
Updating and addign files...
Tom Lane [Wed, 18 Nov 1998 00:47:28 +0000 (00:47 +0000)]
Performance improvement for libpq: avoid calling malloc separately
for each field of each tuple. Makes more difference than you'd think...
Thomas G. Lockhart [Tue, 17 Nov 1998 14:36:51 +0000 (14:36 +0000)]
Add text<->float8 and text<->float4 conversion functions.
This will fix the problem reported by Jose' Soares
when trying to cast a float to text.
Thomas G. Lockhart [Tue, 17 Nov 1998 14:26:39 +0000 (14:26 +0000)]
Additional fixes for mixed-case table names from Billy Allie.
Marc G. Fournier [Tue, 17 Nov 1998 03:10:36 +0000 (03:10 +0000)]
From: Taral <taral@cyberjunkie.com>
More COS Query Service support.
Marc G. Fournier [Mon, 16 Nov 1998 18:03:34 +0000 (18:03 +0000)]
Start defining the Corba work...
From: Taral <taral@cyberjunkie.com>
Tom Lane [Sun, 15 Nov 1998 07:09:13 +0000 (07:09 +0000)]
Fix a couple of bugs involving calling fmtID() twice in
a single printf() ... it'd work if fmtId() didn't use a static return area...
Thomas G. Lockhart [Sat, 14 Nov 1998 02:04:16 +0000 (02:04 +0000)]
Add new "-N" flag to force double quotes around identifiers.
Fix missing mention of "-n" flag in synopsis.
Thomas G. Lockhart [Sat, 14 Nov 1998 02:02:53 +0000 (02:02 +0000)]
Add id attribute to reftitle to allow cross referencing from the new
vaccumdb reference page.
Thomas G. Lockhart [Sat, 14 Nov 1998 02:01:40 +0000 (02:01 +0000)]
Add reference page for new vacuumdb utility.
Thomas G. Lockhart [Sat, 14 Nov 1998 01:58:15 +0000 (01:58 +0000)]
Add "vacuumdb" utility to make it easier to clean databases.
Also supports the "analyze" mode, with or without specifying tables
and columns.
Thomas G. Lockhart [Sat, 14 Nov 1998 01:56:36 +0000 (01:56 +0000)]
Add "vacuumdb" utility.
Thomas G. Lockhart [Thu, 12 Nov 1998 15:39:06 +0000 (15:39 +0000)]
Fix test for table existance to allow mixed-case and whitespace in
the table name. Problem reported by Billy Allie.
Tom Lane [Thu, 12 Nov 1998 05:27:01 +0000 (05:27 +0000)]
Fix at least a few shared-library problems on Linux.
We have not seen the end of this issue :-(.
Byron Nikolaidis [Wed, 11 Nov 1998 21:54:01 +0000 (21:54 +0000)]
Update for version 06-40-0001
Bruce Momjian [Mon, 9 Nov 1998 02:49:13 +0000 (02:49 +0000)]
Fix for NOT in where clause causing crash.
Tom Lane [Sun, 8 Nov 1998 19:38:34 +0000 (19:38 +0000)]
EXPLAIN VERBOSE had a very high probability of triggering
a backend core dump, because it was concatenating a potentially long
string onto another string that didn't necessarily have enough room.
Shame, shame.
Tom Lane [Sun, 8 Nov 1998 19:22:24 +0000 (19:22 +0000)]
Fix a potential infinite loop in appendStringInfo: would lock
up if first string to be appended to an empty StringInfo was longer
than the initial space allocation.
Also speed it up slightly.
Bruce Momjian [Sat, 7 Nov 1998 03:19:54 +0000 (03:19 +0000)]
Update todo.
Thomas G. Lockhart [Fri, 6 Nov 1998 15:54:47 +0000 (15:54 +0000)]
Add "-N" flag to force double quotes around identifiers.
This is the default, but the new flag will allow overriding an alias,
for example. So psql -n -N will put in the double quotes,
and psql -n can be an alias for psql.
Also, add a few braces around a nested single-line conditional construct
to suppress compiler warnings about "an ambiguous else".
Thomas G. Lockhart [Fri, 6 Nov 1998 15:04:31 +0000 (15:04 +0000)]
August version of docs superceded by sgml version from Jan.
Marc G. Fournier [Fri, 6 Nov 1998 04:11:52 +0000 (04:11 +0000)]
Upgrade to 0.91 ...
Marc G. Fournier [Wed, 4 Nov 1998 22:27:05 +0000 (22:27 +0000)]
Change the README file to show the upcoming 6.5 release...
Thomas G. Lockhart [Wed, 4 Nov 1998 16:24:32 +0000 (16:24 +0000)]
Test for and handle NULL arguments to mylog() print statements.
Include definition for _IN_ADDR_T if INADDR_NONE is not defined.
Thomas G. Lockhart [Wed, 4 Nov 1998 16:22:09 +0000 (16:22 +0000)]
Somehow had the solaris template names reversed. Probably was something
fixed in src/configure.in a while ago.
Thomas G. Lockhart [Mon, 2 Nov 1998 15:54:27 +0000 (15:54 +0000)]
Fix email addres for Dan Horak per his request.
Thomas G. Lockhart [Mon, 2 Nov 1998 15:53:02 +0000 (15:53 +0000)]
Move configuration info to after installation procedure.
Include only the current release in the release notes section.
Thomas G. Lockhart [Mon, 2 Nov 1998 15:52:14 +0000 (15:52 +0000)]
Include instructions on perl installation.
Already in product docs since they were built on my machine.
Bruce Momjian [Mon, 2 Nov 1998 15:28:36 +0000 (15:28 +0000)]
Fix for relname.data from SHIOZAKI Takehiko
Marc G. Fournier [Mon, 2 Nov 1998 05:30:10 +0000 (05:30 +0000)]
slight mods required for freebsd (elf vs aout stuff)
Marc G. Fournier [Sun, 1 Nov 1998 16:55:02 +0000 (16:55 +0000)]
Remove various files that were moved to various subdirectories...
Requested by: Peter T Mount peter@retep.org.uk
Thomas G. Lockhart [Sat, 31 Oct 1998 09:36:38 +0000 (09:36 +0000)]
Cleanup for v6.4 release.
Make new file current.sgml to hold release info for the current release.
Should be moved to release.sgml before filling with next release info.
Thomas G. Lockhart [Sat, 31 Oct 1998 09:35:19 +0000 (09:35 +0000)]
Try to get only html and gif files into tarballs.
Was picking up subdirectories and other garbage.
Thomas G. Lockhart [Sat, 31 Oct 1998 09:32:55 +0000 (09:32 +0000)]
New versions for v6.4 release.
Thomas G. Lockhart [Sat, 31 Oct 1998 09:31:58 +0000 (09:31 +0000)]
Generate from installation.sgml -> installation.rtf -> ApplixWare
-> INSTALL with some cleanup in vi.
Marc G. Fournier [Sat, 31 Oct 1998 04:10:53 +0000 (04:10 +0000)]
Thanks to Vince Vielhaber <vev@michvhf.com>
Here is an os2 psql client, with libpq.a library
Marc G. Fournier [Sat, 31 Oct 1998 04:07:00 +0000 (04:07 +0000)]
oops, forgot one part of the patch...remove 'false' setting to ELF_SYS...
Marc G. Fournier [Sat, 31 Oct 1998 03:58:55 +0000 (03:58 +0000)]
Minor FreeBSD fixes put in place
From: SHIOZAKI Takehiko <takehi-s@ascii.co.jp>
I tried snapshot(Oct30) and made some patches.
# I think that it is confused to manage both Makefile.shlib and
# makefiles/Makefile.*, don't you?
* configure
Now FreeBSD 2.X is not supported..., so I added its entry.
If ELF_SYSTEM is set, gmake treat it defined even though
it is "false". So nothing should be set to use "ifdef".
BSD_SHLIB etc. may have same problems.
* Makefile.shlib
As you said, FreeBSD entry is much like BSD's.
I only added ELF_SYSTEM code.
* makefiles/Makefile.freebsd
Ifdef/else/endif can not be indented with TABs.
Bruce Momjian [Sat, 31 Oct 1998 02:06:08 +0000 (02:06 +0000)]
s_lock patch from Ryan.
Tom Lane [Fri, 30 Oct 1998 22:36:00 +0000 (22:36 +0000)]
Mention --without-CXX option in online help.
Thomas G. Lockhart [Fri, 30 Oct 1998 19:37:19 +0000 (19:37 +0000)]
Minor editing and markup changes as a result of preparing the Postscript
documentation for v6.4.
Bigger updates to the installation instructions (install and config).
Thomas G. Lockhart [Fri, 30 Oct 1998 19:34:40 +0000 (19:34 +0000)]
Minor cleanup in markup, especially in the Output section.
Bruce Momjian [Fri, 30 Oct 1998 17:14:35 +0000 (17:14 +0000)]
Updated TODO.
Tom Lane [Fri, 30 Oct 1998 15:05:23 +0000 (15:05 +0000)]
Behave reasonably on a system without shared libraries.
Thomas G. Lockhart [Fri, 30 Oct 1998 08:08:50 +0000 (08:08 +0000)]
Remove obsolete file listing support resources which has not been updated
in a year an a half. Much of the info was wrong and is covered more
correctly elsewhere.
Thomas G. Lockhart [Fri, 30 Oct 1998 08:04:52 +0000 (08:04 +0000)]
Minor fix for Jan to remove claim in SPI and trigger chapters that
Postgres is missing a procedural language. He correctly points out
that we now have two (thanks to him, but he modestly didn't mention
that).
Thomas G. Lockhart [Fri, 30 Oct 1998 07:56:11 +0000 (07:56 +0000)]
User's Guide for v6.4.
Has three pages of goofy layout at the end. Can't figure out what Applix
doesn't like about it, so giving up for now.
Marc G. Fournier [Fri, 30 Oct 1998 04:54:06 +0000 (04:54 +0000)]
Okay, this shoudl provide a fix for the freebsd problem...
Added a ELF_SYS variable and check to configure.in...
Tom Lane [Thu, 29 Oct 1998 19:03:50 +0000 (19:03 +0000)]
oid8neq => oid8ne
Tom Lane [Thu, 29 Oct 1998 18:15:28 +0000 (18:15 +0000)]
Drat. Should test a few more cases before committing.
Thomas G. Lockhart [Thu, 29 Oct 1998 18:13:03 +0000 (18:13 +0000)]
Add tests for comparison operators.
Thomas G. Lockhart [Thu, 29 Oct 1998 18:12:50 +0000 (18:12 +0000)]
Fix regression test now that code seems to work.
Add tests for comparison operators.
Thomas G. Lockhart [Thu, 29 Oct 1998 18:11:28 +0000 (18:11 +0000)]
Very minor cleanup of no-op code.
Thomas G. Lockhart [Thu, 29 Oct 1998 18:10:23 +0000 (18:10 +0000)]
Fix discrepency in "@" operator for point and path.
Bruce Momjian [Thu, 29 Oct 1998 18:07:09 +0000 (18:07 +0000)]
Add oid8neq.
Tom Lane [Thu, 29 Oct 1998 17:58:21 +0000 (17:58 +0000)]
Run autoconf.
Tom Lane [Thu, 29 Oct 1998 17:57:52 +0000 (17:57 +0000)]
Run AC_PROG_GCC_TRADITIONAL only when running AC_PROG_CC,
ie, not when user specifies --with-CC. This corrects a scripting error
that I'm surprised hasn't been reported more often. Moving the macro call
to the earlier point in the script is correct anyway: if -traditional is needed,
it should get added to CFLAGS before we start using the compiler for
other tests.
Tom Lane [Thu, 29 Oct 1998 16:13:07 +0000 (16:13 +0000)]
Re-fix test for negative-integer return code that should be
testing for null-pointer return code...
Bruce Momjian [Thu, 29 Oct 1998 04:41:44 +0000 (04:41 +0000)]
D'Arcy INET fix.
Tom Lane [Thu, 29 Oct 1998 04:32:57 +0000 (04:32 +0000)]
I suspect that there is no longer a need for a platform-
specific version of this result, now that tintervals actually sort
correctly. We can always add it back if NetBSD really is different.
Tom Lane [Thu, 29 Oct 1998 04:29:12 +0000 (04:29 +0000)]
Update tinterval test to have correctly sorted results,
now that bugs in pg_operator that caused wrongly sorted results have
been corrected (I hope ... it works here, anyway).
Tom Lane [Thu, 29 Oct 1998 04:27:11 +0000 (04:27 +0000)]
Add new regression test to catch some simple kinds of
mistakes in creating pg_operator table. NOTE: right now, this will
fail because of conflicting definitions for point @ path operator.
I trust we're gonna fix that.
Tom Lane [Thu, 29 Oct 1998 04:25:23 +0000 (04:25 +0000)]
Add new regression test to catch some simple kinds of
mistakes in creating pg_operator table.
Tom Lane [Thu, 29 Oct 1998 04:22:52 +0000 (04:22 +0000)]
Fix a veritable boatload of errors in oprcom, oprnegate,
oprlsortop and oprrsortop links. There's still a bug involving
conflicting definitions for point @ path, but I'm not taking
responsibility for deciding which one is right...
Bruce Momjian [Thu, 29 Oct 1998 04:04:17 +0000 (04:04 +0000)]
Remove bad pg_operator entry, found by Tom Lane.
Tom Lane [Wed, 28 Oct 1998 19:40:08 +0000 (19:40 +0000)]
Autoconf...
Tom Lane [Wed, 28 Oct 1998 19:39:33 +0000 (19:39 +0000)]
Remove unreliable test for how to do cpp from stdin.
Tom Lane [Wed, 28 Oct 1998 19:38:47 +0000 (19:38 +0000)]
Eliminate need for cpp-from-stdin by using a temp file.
Tom Lane [Wed, 28 Oct 1998 19:32:43 +0000 (19:32 +0000)]
Add ORDER BY to ensure platform-independent results in rules test.
Thomas G. Lockhart [Wed, 28 Oct 1998 17:09:22 +0000 (17:09 +0000)]
Fix macro declarations to allow disabling mylog() and qlog() on Unix boxes.
Fix spelling of "DIRSEPARATOR".
Bruce Momjian [Wed, 28 Oct 1998 17:07:17 +0000 (17:07 +0000)]
Make these file generated in distribution.
Bruce Momjian [Wed, 28 Oct 1998 16:06:54 +0000 (16:06 +0000)]
Fix for serial creation.
Bruce Momjian [Wed, 28 Oct 1998 16:00:08 +0000 (16:00 +0000)]
This looks like a wrong entry in one of the system tables. Any ideas
which one it is, and how to correct this ?
lseg_eq -> lseq_neq
Guido Weber
Bruce Momjian [Wed, 28 Oct 1998 15:58:34 +0000 (15:58 +0000)]
s_lock aix patch.
Marc G. Fournier [Wed, 28 Oct 1998 14:47:54 +0000 (14:47 +0000)]
Updated "expected" regression output for Solaris-Sparc
Thomas G. Lockhart [Wed, 28 Oct 1998 06:49:10 +0000 (06:49 +0000)]
Include appropriate flags for resolved shared library LDFLAGS_ODBC
to allow ODBC library to be linked.