OSDN Git Service
Thomas G. Lockhart [Sat, 9 May 1998 22:44:38 +0000 (22:44 +0000)]
Make lines more visible to the user.
Thomas G. Lockhart [Sat, 9 May 1998 22:43:50 +0000 (22:43 +0000)]
Add bit flags to support timezonehour and minute in data retrieval.
Thomas G. Lockhart [Sat, 9 May 1998 22:39:55 +0000 (22:39 +0000)]
Make a few line routines visible.
Incorporate patches from Gautam for line/point intersection.
Thomas G. Lockhart [Sat, 9 May 1998 22:38:18 +0000 (22:38 +0000)]
Define "tz_hour" and "tz_minute" arguments to date_part().
Fix up "ISO-style" timespan decoding and encoding.
Thomas G. Lockhart [Sat, 9 May 1998 22:32:03 +0000 (22:32 +0000)]
Allow building a source tarball.
Try to generalize the gzip/tar usage for more portability.
Thomas G. Lockhart [Sat, 9 May 1998 22:23:38 +0000 (22:23 +0000)]
Minor markup change.
Bruce Momjian [Thu, 7 May 1998 16:17:18 +0000 (16:17 +0000)]
Add missing includes.
Bruce Momjian [Thu, 7 May 1998 14:52:52 +0000 (14:52 +0000)]
Add missing file from Tom Lane.
Bruce Momjian [Wed, 6 May 1998 23:53:48 +0000 (23:53 +0000)]
It seems the regression tests don't cover copy in/out at all, so
code that I had assumed was working had not been tested. Naturally,
it was broken ...
Tom Lane
Bruce Momjian [Wed, 6 May 1998 23:51:16 +0000 (23:51 +0000)]
What I've done:
1. Rewritten libpq to allow asynchronous clients.
2. Implemented client side of cancel protocol in library,
and patched psql.c to send a cancel request upon SIGINT. The
backend doesn't notice it yet :-(
3. Implemented 'Z' protocol message addition and renaming of
copy in/out start messages. These are implemented conditionally,
ie, the client protocol version is checked; so the code should
still work with 1.0 clients.
4. Revised protocol and libpq sgml documents (don't have an SGML
compiler, though, so there may be some markup glitches here).
What remains to be done:
1. Implement addition of atttypmod field to RowDescriptor messages.
The client-side code is there but ifdef'd out. I have no idea
what to change on the backend side. The field should be sent
only if protocol >= 2.0, of course.
2. Implement backend response to cancel requests received as OOB
messages. (This prolly need not be conditional on protocol
version; just do it if you get SIGURG.)
3. Update libpq.3. (I'm hoping this can be generated mechanically
from libpq.sgml... if not, will do it by hand.) Is there any
other doco to fix?
4. Update non-libpq interfaces as necessary. I patched libpgtcl
so that it would compile, but haven't tested it. Dunno what
needs to be done with the other interfaces.
Have at it!
Tom Lane
Bruce Momjian [Wed, 6 May 1998 23:25:19 +0000 (23:25 +0000)]
Remove extra paren in __alpha so it compiles.
Marc G. Fournier [Wed, 6 May 1998 13:03:47 +0000 (13:03 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Tue Apr 28 14:48:41 CEST 1998
- Put operator "->" back into parser. Note that :foo->bar means the
C term, but :foo ->bar means the operator "->".
Tue Apr 28 15:49:07 CEST 1998
- Added exec sql disconnect command.
- Allow varchar in C to be written in uppercase too.
- Added whenever option "do break;"
Wed Apr 29 09:17:53 CEST 1998
- Corrected parsing of C comments.
- Also allow C++ style comments.
- Make sure not found is only checked after commands that could
return it.
- Added error codes, see ecpgerror.h for details.
- Added "exec sql <TransactionStmt> release" as disconnect statement
for compatibility issues.
Thu Apr 30 10:42:10 CEST 1998
- Added a -t option to disable automatic transaction start.
- Added sqlerrd[] to sqlca struct.
- Give back number of tuples affect in sqlca.sqlerrd[2].
Thu Apr 30 13:36:02 CEST 1998
- Make the return code different in case of different errors.
Wed May 6 11:42:48 CEST 1998
- Free memory if possible
- Some bugfixes for bugs I found while changing the memory
allocation code
- Now able to fill complete array with one call (see test1.pgc for
an example)
- Set version to 2.3.0
- Set library version to 2.1
Marc G. Fournier [Mon, 4 May 1998 23:49:17 +0000 (23:49 +0000)]
Missed the __alpha__ to __alpha change...
From: David Gould <dg@illustra.com>
Marc G. Fournier [Mon, 4 May 1998 16:58:59 +0000 (16:58 +0000)]
Okay...this should fix the s_lock() patches from David to what he
currently has...
From: David Gould <dg@illustra.com>
Marc G. Fournier [Mon, 4 May 1998 15:45:03 +0000 (15:45 +0000)]
Major screwed up s_lock patches...need to be fixed...
Bruce Momjian [Mon, 4 May 1998 02:09:33 +0000 (02:09 +0000)]
return to normal values
Bruce Momjian [Mon, 4 May 1998 02:02:09 +0000 (02:02 +0000)]
Fix for missing parens with \g causing psql to get completely
confused.
Bruce Momjian [Fri, 1 May 1998 04:33:58 +0000 (04:33 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:31:02 +0000 (04:31 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:28:03 +0000 (04:28 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:26:52 +0000 (04:26 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:22:24 +0000 (04:22 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:19:55 +0000 (04:19 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:18:15 +0000 (04:18 +0000)]
test
Bruce Momjian [Fri, 1 May 1998 04:15:50 +0000 (04:15 +0000)]
test
Bruce Momjian [Thu, 30 Apr 1998 14:54:27 +0000 (14:54 +0000)]
test
Bruce Momjian [Thu, 30 Apr 1998 14:25:13 +0000 (14:25 +0000)]
No reason to show flags in root error message.
Marc G. Fournier [Wed, 29 Apr 1998 12:41:29 +0000 (12:41 +0000)]
From: Jeroen van Vianen <jeroenv@design.nl>
Attached patch will add a version() function to Postges, e.g.
template1=> select version();
version
------------------------------------------------------------
PostgreSQL 6.3.2 on i586-pc-linux-gnu, compiled by gcc 2.8.1
(1 row)
Marc G. Fournier [Wed, 29 Apr 1998 12:26:22 +0000 (12:26 +0000)]
Missed adding two files from the MultiByte patch...
Marc G. Fournier [Wed, 29 Apr 1998 02:04:01 +0000 (02:04 +0000)]
From: Oliver Elphick <olly@lfix.co.uk>
If PQfn() receives NOTICEs from the backend, it fails because there is no
provision to deal with them.
This patch (supplied by Anders Hammarquist <iko@netg.se> to me as Debian
maintainer of postgresql) cures the problem:
Bruce Momjian [Wed, 29 Apr 1998 01:47:40 +0000 (01:47 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 01:29:31 +0000 (01:29 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 01:21:08 +0000 (01:21 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:56:13 +0000 (00:56 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:28:56 +0000 (00:28 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:25:42 +0000 (00:25 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:24:30 +0000 (00:24 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:13:10 +0000 (00:13 +0000)]
test
Bruce Momjian [Wed, 29 Apr 1998 00:10:35 +0000 (00:10 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 21:51:34 +0000 (21:51 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 19:50:22 +0000 (19:50 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 19:24:08 +0000 (19:24 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 19:20:22 +0000 (19:20 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 18:59:46 +0000 (18:59 +0000)]
test
Bruce Momjian [Tue, 28 Apr 1998 18:39:11 +0000 (18:39 +0000)]
Add cursor name to man page.
Thomas G. Lockhart [Tue, 28 Apr 1998 14:57:48 +0000 (14:57 +0000)]
Include full tools installation instructions from Tom Helbekkmo.
Include small section on authoring and Makefile configuration.
Rearrange section order.
Thomas G. Lockhart [Tue, 28 Apr 1998 14:55:45 +0000 (14:55 +0000)]
Include info on setting compiler options on the command line
when building executables.
Thomas G. Lockhart [Tue, 28 Apr 1998 14:54:24 +0000 (14:54 +0000)]
Fix some typos.
Thomas G. Lockhart [Tue, 28 Apr 1998 14:52:46 +0000 (14:52 +0000)]
Include e-mail exchange between Jan and Andreas to start info on rules.
Bruce Momjian [Tue, 28 Apr 1998 03:25:33 +0000 (03:25 +0000)]
Make Linux startup support sh and csh.
Marc G. Fournier [Mon, 27 Apr 1998 17:10:50 +0000 (17:10 +0000)]
From: t-ishii@sra.co.jp
Hi, here are patches I promised (against 6.3.2):
* character_length(), position(), substring() are now aware of
multi-byte characters
* add octet_length()
* add --with-mb option to configure
* new regression tests for EUC_KR
(contributed by "Soonmyung. Hong" <hong@lunaris.hanmesoft.co.kr>)
* add some test cases to the EUC_JP regression test
* fix problem in regress/regress.sh in case of System V
* fix toupper(), tolower() to handle 8bit chars
note that:
o patches for both configure.in and configure are
included. maybe the one for configure is not necessary.
o pg_proc.h was modified to add octet_length(). I used OIDs
(1374-1379) for that. Please let me know if these numbers are not
appropriate.
Marc G. Fournier [Mon, 27 Apr 1998 16:59:12 +0000 (16:59 +0000)]
From: Jun Kuwamura <juk@rccm.co.jp>
I do not know about these contributions well as I only made the binaries
to contribute to a Japanese Linux package.(I did not test them.) But I
try to make some brief introduction about the contrib directory with my
poor English. Here is a draft of README about contrib directory:
Marc G. Fournier [Mon, 27 Apr 1998 16:57:09 +0000 (16:57 +0000)]
show the index used in an explain
From: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
Marc G. Fournier [Mon, 27 Apr 1998 14:55:46 +0000 (14:55 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>
HP-UX (all versions) requires shared libraries to have execute
permission, and really needs them to be exactly mode 555 for
performance reasons. The standard configure/install procedure
installs libpq.sl as mode 644, which DOES NOT WORK.
The attached patch modifies the makefiles to distinguish
INSTL_LIB_OPTS (install mode for ordinary libraries) from
INSTL_SHLIB_OPTS (mode for shared libs), and adds a test
to configure to set INSTL_SHLIB_OPTS="-m 555" when on HP-UX.
Marc G. Fournier [Mon, 27 Apr 1998 14:46:51 +0000 (14:46 +0000)]
From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
Ok, I have finally gotten all of the defines for Dec/Alpha and
Linux/Alpha sorted out as Marc asked. There is no longer any need for
'-Dalpha' or '-Dlinuxalpha' in either the Dec/Alpha or the Linux/Alpha
template files (./src/template/{alpha,linuxalpha}). I have replaced every
instance of 'alpha' or '__alpha__' with '__alpha', as that appears to be
the common symbol between C compilers on both operating systems (RH4.2 &
DecUnix 4.0b) for alpha.
Marc G. Fournier [Mon, 27 Apr 1998 14:35:58 +0000 (14:35 +0000)]
From: Michael Meskes <meskes@topsystem.de>
And the next update. Now you can use only parts of a struct like this:
exec sql select a into :struct.string from foo;
Bruce Momjian [Mon, 27 Apr 1998 13:50:03 +0000 (13:50 +0000)]
Add Darren's char2-16 files.
Bruce Momjian [Mon, 27 Apr 1998 04:08:07 +0000 (04:08 +0000)]
This patch...
1. Removes the unnecessary "#define AbcRegProcedure 123"'s from
pg_proc.h.
2. Changes those #defines to use the names already defined in
fmgr.h.
3. Forces the make of fmgr.h in backend/Makefile instead of having
it
made as a dependency in access/common/Makefile *hack*hack*hack*
4. Rearranged the #includes to a less helter-skelter arrangement,
also
changing <file.h> to "file.h" to signify a non-system header.
5. Removed "pg_proc.h" from files where its only purpose was for
the
#defines removed in item #1.
6. Added "fmgr.h" to each file changed for completeness sake.
Turns out that #6 was not necessary for some files because fmgr.h
was being included in a roundabout way SIX levels deep by the first
include.
"access/genam.h"
->"access/relscan.h"
->"utils/rel.h"
->"access/strat.h"
->"access/skey.h"
->"fmgr.h"
So adding fmgr.h really didn't add anything to the compile, hopefully
just made it clearer to the programmer.
S Darren.
Bruce Momjian [Mon, 27 Apr 1998 03:56:59 +0000 (03:56 +0000)]
Add prper perl config testing.
Bruce Momjian [Mon, 27 Apr 1998 03:41:33 +0000 (03:41 +0000)]
manual page update from Oliver Elphick
Oliver.Elphick@lfix.co.uk
Bruce Momjian [Mon, 27 Apr 1998 03:32:11 +0000 (03:32 +0000)]
Fix cc-specifc compiler flags in templatees.
Bruce Momjian [Mon, 27 Apr 1998 03:19:10 +0000 (03:19 +0000)]
Fixed table type lengths for Maurice.
Bruce Momjian [Mon, 27 Apr 1998 03:07:18 +0000 (03:07 +0000)]
Improved version from Claudiu
Bruce Momjian [Mon, 27 Apr 1998 02:58:07 +0000 (02:58 +0000)]
FIx confusion over SORT and SORTCLAUSE in node handling.
Bruce Momjian [Sun, 26 Apr 1998 23:14:39 +0000 (23:14 +0000)]
Included is a patch for ecpg which seems to have some compiling
problems on non POSIX systems such as SunOS 4.1.x. -- Tatsuo Ishii
t-ishii@sra.co.jp -
Bruce Momjian [Sun, 26 Apr 1998 04:18:06 +0000 (04:18 +0000)]
Doc updates from Darren on char2-16 removal
Bruce Momjian [Sun, 26 Apr 1998 04:12:15 +0000 (04:12 +0000)]
Re-apply Darren's char2-16 removal code.
Bruce Momjian [Fri, 24 Apr 1998 15:58:17 +0000 (15:58 +0000)]
template cleanup
Bruce Momjian [Fri, 24 Apr 1998 14:43:33 +0000 (14:43 +0000)]
Inline some small functions called for every row.
Marc G. Fournier [Fri, 24 Apr 1998 12:10:20 +0000 (12:10 +0000)]
From: Michael Meskes <meskes@topsystem.de>
+ Thu Apr 23 09:27:16 CEST 1998
+
+ - Also allow call in whenever statement with the same functionality
+ as do.
+
+ Thu Apr 23 12:29:28 CEST 1998
+
+ - Also rewrote variable declaration part. It is now possible to
+ declare more than one variable per line.
+ - Set version to 2.1.0
+
+ Fri Apr 24 13:50:15 CEST 1998
+
+ - Fixed some bugs.
+ - Set version to 2.1.1
Marc G. Fournier [Fri, 24 Apr 1998 01:19:00 +0000 (01:19 +0000)]
Clean up configure so that it properly (I hope?) GUESSes the template to
use, if not stipulated via --with-template
Bruce Momjian [Thu, 23 Apr 1998 17:25:29 +0000 (17:25 +0000)]
pginterface cleanup
Marc G. Fournier [Wed, 22 Apr 1998 04:20:55 +0000 (04:20 +0000)]
Missed a few files that were added with the lib/modules patch...
Marc G. Fournier [Wed, 22 Apr 1998 04:16:46 +0000 (04:16 +0000)]
From: Jun Kuwamura <juk@rccm.co.jp>
This patch fix the Makefiles in contrib/{pginterface, spi,
miscutil, int8, ip_and_mac, sequence, soundex, string, userlock,
array, datetime} to install their modules in one directory(lib/modules/).
Bruce Momjian [Tue, 21 Apr 1998 16:18:30 +0000 (16:18 +0000)]
Add hpux patch for cpp.
Marc G. Fournier [Tue, 21 Apr 1998 13:23:24 +0000 (13:23 +0000)]
Upgrade ECPG to 2.0
Michael Meskes <meskes@topsystem.de>
Marc G. Fournier [Tue, 21 Apr 1998 12:38:46 +0000 (12:38 +0000)]
Try for a LINUX_ELF fix (bandage?)
Marc G. Fournier [Tue, 21 Apr 1998 04:00:06 +0000 (04:00 +0000)]
From: Bryan Henderson <bryanh@giraffe-data.com>
Here's a fix for a tiny memory leak in PQsetdb/PQfinish.
(Analysis of a running program indicates there are several others, but
this is the only obvious one I saw in the code).
Bruce Momjian [Mon, 20 Apr 1998 18:11:42 +0000 (18:11 +0000)]
Try to find cpp failure and report it.
Marc G. Fournier [Sat, 18 Apr 1998 18:32:44 +0000 (18:32 +0000)]
From: Peter T Mount <patches@maidast.demon.co.uk>
This fixes a problem in ResultSet.getDate() when the column is NULL
(reported by Vincent Partington <Vincent.Partington@nmg.nl>)
And fixes a problem with Field's (ResultSet.getObject() was proving to be
slow as it repetedly send queries for oid -> name mapping - fixed by
creating a cache. (reported by Mario Ellebrecht <ellebrec@nads.de>)
Bruce Momjian [Fri, 17 Apr 1998 14:54:16 +0000 (14:54 +0000)]
UPdate TODO list.
Bruce Momjian [Fri, 17 Apr 1998 04:12:56 +0000 (04:12 +0000)]
Update HISTORY/TODO. Disable HAVING.
Thomas G. Lockhart [Fri, 17 Apr 1998 03:58:11 +0000 (03:58 +0000)]
Use POSTGRESDIR to set initial PGDOCS destination directory.
PGDOCS in Makefile.custom will supercede defaults here, I think...
Thomas G. Lockhart [Fri, 17 Apr 1998 03:56:08 +0000 (03:56 +0000)]
Update info to reflect success on Alpha/Linux and Alpha/DUnix ports.
Thomas G. Lockhart [Fri, 17 Apr 1998 03:55:01 +0000 (03:55 +0000)]
Fix typos in a couple of examples.
Marc G. Fournier [Fri, 17 Apr 1998 03:06:35 +0000 (03:06 +0000)]
A few minor mods:
gram.c updated
scan.c updated
ecpg/Makefile added LDFLAGS
configure requires sfio for those systems with it installed...
Marc G. Fournier [Fri, 17 Apr 1998 02:44:01 +0000 (02:44 +0000)]
From: Darren King <darrenk@insightdist.com>
This will force the aix compiler to insert trapping code to
check for division by zero for the 4.1 port.
Marc G. Fournier [Fri, 17 Apr 1998 01:55:31 +0000 (01:55 +0000)]
Get rid of the TEMPLATE verbosity and make it so that --with-template is
documented in ./configure --help
Marc G. Fournier [Fri, 17 Apr 1998 01:30:21 +0000 (01:30 +0000)]
From: Brook Milligan <brook@trillium.NMSU.Edu>
Here is a pair of patches that (I hope) finish the configuration
issues with tcl/tk and make the recognition of the two packages
completely parallel in organization. This should make future changes
easier to maintain.
Hope to see this in 6.2.2.
Marc G. Fournier [Wed, 15 Apr 1998 21:56:54 +0000 (21:56 +0000)]
From: David Hartwig <daveh@insightdist.com>
Marc, I overlooked this file it should be included in the source. Oops
Also the binary file is only 1.2 meg not 2.5 meg. Oops again.
Bruce Momjian [Wed, 15 Apr 1998 16:50:32 +0000 (16:50 +0000)]
Update FAQ.
Bruce Momjian [Wed, 15 Apr 1998 16:44:36 +0000 (16:44 +0000)]
pgintro now has a list of all manual pages.
Bruce Momjian [Wed, 15 Apr 1998 15:29:57 +0000 (15:29 +0000)]
Move HAVING function to proper file.
Edmund Mergl [Tue, 14 Apr 1998 21:14:52 +0000 (21:14 +0000)]
1.7.3
Bruce Momjian [Tue, 14 Apr 1998 03:28:50 +0000 (03:28 +0000)]
Update gram.c.nd *.h files.
Bruce Momjian [Tue, 14 Apr 1998 01:52:47 +0000 (01:52 +0000)]
Update gram.c scan.c.
Bruce Momjian [Mon, 13 Apr 1998 21:07:15 +0000 (21:07 +0000)]
Cleanup up code.
Bruce Momjian [Mon, 13 Apr 1998 16:34:48 +0000 (16:34 +0000)]
What was LINUX_ELF doing in there?
Marc G. Fournier [Mon, 13 Apr 1998 15:02:05 +0000 (15:02 +0000)]
Replace old PostODBC driver with new one...
This one is based on an older PostODBC driver, rewritten and maintained by
InsightDist(?)
Marc G. Fournier [Mon, 13 Apr 1998 14:46:48 +0000 (14:46 +0000)]
From: Diab Jerius <dj@pelf.harvard.edu>
Fix for Solaris/cc problem