OSDN Git Service
Thomas G. Lockhart [Tue, 22 Sep 1998 15:48:03 +0000 (15:48 +0000)]
Editing and markup cleanup.
Bruce Momjian [Mon, 21 Sep 1998 15:41:28 +0000 (15:41 +0000)]
Fix for AND/OR handling.
Marc G. Fournier [Mon, 21 Sep 1998 05:55:23 +0000 (05:55 +0000)]
From: Michael Meskes <meskes@usa.net>
docs improvement for ecpg..
Marc G. Fournier [Mon, 21 Sep 1998 05:52:55 +0000 (05:52 +0000)]
From: Michael Meskes <meskes@usa.net>
+ Mon Aug 31 09:40:04 CEST 1998
+
+ - Minor patch to Makefile
+ - Put pgc.l in sync with scan.l
+
+ Tue Sep 1 11:31:05 CEST 1998
+
+ - Fixed another bug in preproc.y
+
+ Thu Sep 3 12:21:16 CEST 1998
+
+ - Sync preproc.y with gram.y
+
+ Mon Sep 14 09:21:02 CEST 1998
+
+ - Sync preproc.y with gram.y yet again
+
+ Thu Sep 17 08:55:33 CEST 1998
+
+ - Synced preproc.y and gram.y one more time
+
+ Thu Sep 17 19:23:24 CEST 1998
+
+ - Added missing ´;´ in preproc.y
+ - Set version to 2.4.2
Bruce Momjian [Mon, 21 Sep 1998 02:25:29 +0000 (02:25 +0000)]
Fix for \z formatting from Tom Lane.
Bruce Momjian [Mon, 21 Sep 1998 01:02:04 +0000 (01:02 +0000)]
This patch covers several to-do items that I had for libpgtcl:
* It works under both Tcl 7.6 and Tcl 8.0 now. (The code claims to
work under Tcl 7.5 as well, but I have no way to test that ---
if anyone still cares, please check it with 7.5.)
* pg_listen suppresses extra LISTEN commands and correctly sends an
UNLISTEN when the last listen request for a relation is cancelled.
(Note this means it will not work with pre-6.4 backends, but that
was true already because it depends on the current libpq, which
only speaks protocol 2.0.)
* Added -error option to pg_result so that there's some way to find
out what you did wrong ;-)
* Miscellaneous cleanups of code comments and overenthusiastic #includes.
BTW, I bumped the package version number from 1.2 to 1.3. Is this
premature? Does someone run around and do that routinely before
each pgsql release?
regards, tom lane
Bruce Momjian [Sun, 20 Sep 1998 05:01:04 +0000 (05:01 +0000)]
autoconf
Bruce Momjian [Sun, 20 Sep 1998 04:57:40 +0000 (04:57 +0000)]
Fix for memory leak, configure path fix, from Tom Lane.
Bruce Momjian [Sun, 20 Sep 1998 04:51:12 +0000 (04:51 +0000)]
Fix memory leak from Tom Lane.
Bruce Momjian [Sun, 20 Sep 1998 03:18:43 +0000 (03:18 +0000)]
I also noticed that pg_dump contains a copy of the same
prompt_for_password code that psql does. We fixed psql a month or
two back to permit usernames and passwords longer than 8 characters.
I propagated the same fix into pg_dump.
Tom Lane
Bruce Momjian [Fri, 18 Sep 1998 21:47:27 +0000 (21:47 +0000)]
Regression test cleanup.
Bruce Momjian [Fri, 18 Sep 1998 17:18:41 +0000 (17:18 +0000)]
NS32K lock patch reversed.
Bruce Momjian [Fri, 18 Sep 1998 16:46:07 +0000 (16:46 +0000)]
Fixes for VC and libpq.
Magnus Hagander
Bruce Momjian [Fri, 18 Sep 1998 05:36:24 +0000 (05:36 +0000)]
Fix for NS32K machine.
Bruce Momjian [Fri, 18 Sep 1998 05:20:22 +0000 (05:20 +0000)]
fix for aix snprintf
Bruce Momjian [Fri, 18 Sep 1998 05:00:52 +0000 (05:00 +0000)]
Remove /usr/local/* from templates.
Bruce Momjian [Fri, 18 Sep 1998 04:43:20 +0000 (04:43 +0000)]
Fix for \df.
Bruce Momjian [Fri, 18 Sep 1998 03:02:47 +0000 (03:02 +0000)]
New gram.c
Thomas G. Lockhart [Wed, 16 Sep 1998 14:48:41 +0000 (14:48 +0000)]
Update entries for MkLinux and Linux/ix86 for Postgres v6.4.
Thomas G. Lockhart [Wed, 16 Sep 1998 14:44:00 +0000 (14:44 +0000)]
Add Unix-specific installation and configuration info for psqlodbc.
Thomas G. Lockhart [Wed, 16 Sep 1998 14:43:12 +0000 (14:43 +0000)]
Markup and editing adjustments...
Thomas G. Lockhart [Wed, 16 Sep 1998 14:35:37 +0000 (14:35 +0000)]
Consolidate Jan's rules test into one file.
Remove dependency on a specific Postgres user name in the results
(Check result against CURRENT_USER with a boolean instead).
Thomas G. Lockhart [Wed, 16 Sep 1998 14:29:35 +0000 (14:29 +0000)]
Support specifying PRIMARY KEY for the SERIAL type.
Change DEFAULT NULL to send back a NULL pointer
rather than a string "NULL". This seems to work, where sending
the string led to type conversion problems (and probably the wrong
thing anyway).
Thomas G. Lockhart [Wed, 16 Sep 1998 14:25:37 +0000 (14:25 +0000)]
Support specifying PRIMARY KEY for the SERIAL type.
Check for a constraint if is_sequence is set and omit making
a UNIQUE index if so, since the primary key will cover that for us.
Thomas G. Lockhart [Wed, 16 Sep 1998 14:22:22 +0000 (14:22 +0000)]
Use oper_select_candidate() for unary operators
rather than func_select_candidate().
Fix oper_select_candidate() to work with a single operator argument.
Repair left operator checking for null return from candidate list.
Marc G. Fournier [Tue, 15 Sep 1998 02:25:09 +0000 (02:25 +0000)]
Forgot to remove README-1ST from the repository ...
Marc G. Fournier [Mon, 14 Sep 1998 04:45:27 +0000 (04:45 +0000)]
tabularized a little bit...
Marc G. Fournier [Mon, 14 Sep 1998 04:38:41 +0000 (04:38 +0000)]
A sort of 'log' of what operating systems are supported, and the date
last tested...
Marc G. Fournier [Mon, 14 Sep 1998 04:17:40 +0000 (04:17 +0000)]
Change order of install...installing interfaces is the last to be done,
as, if not installing as root (which nobody *should* be doing, of course),
the perl install fails, which means that both bin and man directories
are not installed :(
This way, only thing that doesn't get installed is perl interface...
Bruce Momjian [Mon, 14 Sep 1998 01:14:49 +0000 (01:14 +0000)]
Add new make_oidjoin_check utility and template1_check.sql. Fix some
pg_operator problems.
Thomas G. Lockhart [Sun, 13 Sep 1998 14:29:06 +0000 (14:29 +0000)]
Remove remnant from obsolete char16 data type.
Thomas G. Lockhart [Sun, 13 Sep 1998 04:20:16 +0000 (04:20 +0000)]
Update to new DECLARE and FETCH features in gram.y.
Thomas G. Lockhart [Sun, 13 Sep 1998 04:19:33 +0000 (04:19 +0000)]
Support SQL92-ish DECLARE and FETCH commands.
Adds a few new keywords, but all are allowed as column names etc.
Bruce Momjian [Sun, 13 Sep 1998 04:00:44 +0000 (04:00 +0000)]
Here are some additional patches needed to get the UnixWare 7 C++
compiler to
attempt to compile libpq++. The patches address the following problems:
1. In my first pass at changing the libpq++ makefile, I forgot to
include the
PORTNAME in the Makefile.in file.
2. The UnixWare 7 C++ compiler did not like the '-K alloca' option in
CXXFLAGS.
Billy G. Allie
Bruce Momjian [Sat, 12 Sep 1998 17:26:04 +0000 (17:26 +0000)]
rename java file for Peter.
Bruce Momjian [Sat, 12 Sep 1998 16:07:53 +0000 (16:07 +0000)]
Irix lock fix from Robert Bruccoleri
Bruce Momjian [Sat, 12 Sep 1998 16:04:35 +0000 (16:04 +0000)]
The pg_atoi() function uses strtol() to convert the string to numbers. Some
implementations of strtol() treat empty strings ("") as invalid arguments
while others convert this (erroneously, IHMO) to zero (0). Assuming that the
expected behaviour of pg_atoi() is to return 0 if it is passed an empty
string, I am supplying the following patch to explictly check for an empty
string in pg_atoi() and return 0 if the string is empty. The patch will also
trap a NULL character pointer being passed to pg_atoi() and will use elog() to
print out an error message if the input char pointer is NULL.
Billy G. Allie
Bruce Momjian [Fri, 11 Sep 1998 17:21:20 +0000 (17:21 +0000)]
autoconf
Bruce Momjian [Fri, 11 Sep 1998 17:16:11 +0000 (17:16 +0000)]
Remove lld from LONG LONG name
Bruce Momjian [Fri, 11 Sep 1998 17:08:22 +0000 (17:08 +0000)]
autoconf
Bruce Momjian [Fri, 11 Sep 1998 16:56:24 +0000 (16:56 +0000)]
The attached patches fix the following problems:
1. The UnixWare tas macro was reformatted (by indent or it like?) which caused
it to break. The asm macro construct is very particular about the %mem
construct -- it has to start in column 1.
2. When compiling libpq++, g++ was used even if configure found the C++ com-
piler to be CC.
3. When compiling libpq++, '-Wno-error' was added to CXXFLAGS, even if the
compiler wasn't g++.
Billy G. Allie
Bruce Momjian [Fri, 11 Sep 1998 16:50:20 +0000 (16:50 +0000)]
autoconf
Bruce Momjian [Fri, 11 Sep 1998 16:43:26 +0000 (16:43 +0000)]
Remove %qd.
Bruce Momjian [Fri, 11 Sep 1998 16:39:59 +0000 (16:39 +0000)]
Tatsuo Ishii fix for pg_user crash, with slight modification.
Bruce Momjian [Fri, 11 Sep 1998 14:10:53 +0000 (14:10 +0000)]
%lld fix.
Bruce Momjian [Fri, 11 Sep 1998 05:18:12 +0000 (05:18 +0000)]
update pginterface
Bruce Momjian [Fri, 11 Sep 1998 05:14:08 +0000 (05:14 +0000)]
Update pginterface for 6.4. add manual page.
Bruce Momjian [Thu, 10 Sep 1998 21:10:51 +0000 (21:10 +0000)]
long long cleanup
Vadim B. Mikheev [Thu, 10 Sep 1998 15:32:32 +0000 (15:32 +0000)]
Added attributes for primary/unique/foreign keys...
Bruce Momjian [Thu, 10 Sep 1998 15:18:06 +0000 (15:18 +0000)]
Fix for length in libpq from Tom Lane.
Bruce Momjian [Thu, 10 Sep 1998 05:40:16 +0000 (05:40 +0000)]
autoconf
Bruce Momjian [Thu, 10 Sep 1998 05:36:00 +0000 (05:36 +0000)]
%lld not %Ld
Bruce Momjian [Thu, 10 Sep 1998 04:59:01 +0000 (04:59 +0000)]
More bsdi 4.0 additions.
Bruce Momjian [Thu, 10 Sep 1998 04:46:45 +0000 (04:46 +0000)]
bsdi 4.0.
Bruce Momjian [Thu, 10 Sep 1998 04:39:47 +0000 (04:39 +0000)]
Add some support for BSDI 4.0.
Vadim B. Mikheev [Thu, 10 Sep 1998 04:11:52 +0000 (04:11 +0000)]
Porting efforts... :)
Vadim B. Mikheev [Thu, 10 Sep 1998 04:07:59 +0000 (04:07 +0000)]
flock --> fcntl
Bruce Momjian [Thu, 10 Sep 1998 03:54:07 +0000 (03:54 +0000)]
cleanup
Bruce Momjian [Thu, 10 Sep 1998 03:42:19 +0000 (03:42 +0000)]
Cleanup of configure.in
Bruce Momjian [Thu, 10 Sep 1998 03:33:32 +0000 (03:33 +0000)]
autoconf
Bruce Momjian [Thu, 10 Sep 1998 03:27:09 +0000 (03:27 +0000)]
Allow long long on BSDI.
Bruce Momjian [Wed, 9 Sep 1998 18:39:33 +0000 (18:39 +0000)]
Aix4 fixes from Andreas Zeugswetter
Bruce Momjian [Wed, 9 Sep 1998 18:32:05 +0000 (18:32 +0000)]
>
> Open portability issues:
>
> /usr/local should be searched for lib and include for all ports if
present
> (currently not working, I have libreadline there)
>
> the stream functions on AIX need a size_t for addrlen's in
fe-connect.c and pqcomm.c.
>
> lock.c still has an incompatible TPRINTF(flags, args...) definition
Massimo
Bruce Momjian [Wed, 9 Sep 1998 18:16:36 +0000 (18:16 +0000)]
Hi patchers/hackers.
Here's a patch for initdb that does two things.
1) Encloses the created rulenames in quotes to preserve case
in the creation step. (stores _RETpg... instead of _retpg...)
I believe _RET is standard for views.
2) Renames pg_view to pg_views and pg_rule to pg_rules.
I believe Jan and myself agreed this would be a "good idea"
Keith Parks
Vadim B. Mikheev [Wed, 9 Sep 1998 03:48:17 +0000 (03:48 +0000)]
Fix using GroupBy/non-GroupBy expressions in HAVING.
Vadim B. Mikheev [Wed, 9 Sep 1998 03:42:52 +0000 (03:42 +0000)]
Fix for indexing problem (?): heap tuple was pfree-d before CatalogIndexInsert()...
Bruce Momjian [Tue, 8 Sep 1998 22:15:42 +0000 (22:15 +0000)]
AIX align fix.
Bruce Momjian [Tue, 8 Sep 1998 15:24:11 +0000 (15:24 +0000)]
Fix for macro for AIX.
Vadim B. Mikheev [Tue, 8 Sep 1998 02:50:20 +0000 (02:50 +0000)]
Fix GroupBY func broken by HAVING.
Thomas G. Lockhart [Mon, 7 Sep 1998 15:58:31 +0000 (15:58 +0000)]
Very minor formatting fixup in the refentry id field to remove
the trailing "-1". This makes a cleaner html output file name.
Clean up a few refpurpose fields.
Thomas G. Lockhart [Mon, 7 Sep 1998 15:56:20 +0000 (15:56 +0000)]
Fix Postgres to support SQL92 syntax. Old syntax still works too.
Thomas G. Lockhart [Mon, 7 Sep 1998 15:54:08 +0000 (15:54 +0000)]
Minor wording and formatting cleanups.
Thomas G. Lockhart [Mon, 7 Sep 1998 15:53:12 +0000 (15:53 +0000)]
Add new reference pages. This completes the first cut at a full set
for SQL commands.
Bruce Momjian [Mon, 7 Sep 1998 05:35:48 +0000 (05:35 +0000)]
Alignment cleanup so no more massive switch statements for alignment,
just two macros.
Bruce Momjian [Sun, 6 Sep 1998 04:49:51 +0000 (04:49 +0000)]
BTW, in catalog/pg_type.h:
#define Anum_pg_index_indisunique 8
I think this should be 9.
Tatsuo Ishii
Thomas G. Lockhart [Sat, 5 Sep 1998 06:02:57 +0000 (06:02 +0000)]
Add new reference pages adapted from Jose'.
Thomas G. Lockhart [Sat, 5 Sep 1998 06:01:56 +0000 (06:01 +0000)]
Minor fix to add paragraph break.
Thomas G. Lockhart [Sat, 5 Sep 1998 01:19:38 +0000 (01:19 +0000)]
Use alternate form for long-long-int to be compatible with AIX.
%Ld worked with gcc, but %lld works with both gcc and AIX.
Bruce Momjian [Fri, 4 Sep 1998 18:21:11 +0000 (18:21 +0000)]
offsetof cleanup.
Bruce Momjian [Fri, 4 Sep 1998 18:05:39 +0000 (18:05 +0000)]
t_bits alignment fix from Tatsuo Ishii
Marc G. Fournier [Fri, 4 Sep 1998 14:34:23 +0000 (14:34 +0000)]
Try this snprintf() implementation, used in sendmail...
Marc G. Fournier [Fri, 4 Sep 1998 12:52:23 +0000 (12:52 +0000)]
From: David Hartwig <daybee@bellatlantic.net>
I put some extra checks to make sure a query was a good candidate for
rewrite into a UNION. Besides the existing checks:
1. Make sure the AND/OR tree was rectangular. ( i.e. 3 X 4 or 10 X
3)
2. Only one table.
3. Must have an AND dimension.
4. At least 9 OP expressions total
Also cleaned up and commented.
Bruce Momjian [Fri, 4 Sep 1998 05:03:05 +0000 (05:03 +0000)]
libpgtcl cleanups for Tom Lane.
Thomas G. Lockhart [Thu, 3 Sep 1998 14:21:06 +0000 (14:21 +0000)]
Allow insert statements to have every column
supplied by a DEFAULT clause. Enables INSERT INTO TABLE DEFAULT VALUES...
Thomas G. Lockhart [Thu, 3 Sep 1998 12:26:20 +0000 (12:26 +0000)]
Update to match newest gram.c since both are generated from gram.y.
Should be done every time gram.c is refreshed.
Bruce Momjian [Thu, 3 Sep 1998 05:09:27 +0000 (05:09 +0000)]
Oops missing file.
Bruce Momjian [Thu, 3 Sep 1998 05:08:28 +0000 (05:08 +0000)]
patch cleanups.
Bruce Momjian [Thu, 3 Sep 1998 02:34:35 +0000 (02:34 +0000)]
[Part #1: Type: text/plain, Encoding: 7bit, Size: 59]
I will be cleaning this up more before the Oct 1 deadline.
David Hartwig. AND/OR fix.
Bruce Momjian [Thu, 3 Sep 1998 02:32:41 +0000 (02:32 +0000)]
Fix ifdef.
Bruce Momjian [Thu, 3 Sep 1998 02:31:38 +0000 (02:31 +0000)]
New stuff from Peter Mount for jdbc.
Bruce Momjian [Thu, 3 Sep 1998 02:29:45 +0000 (02:29 +0000)]
New stuff for 6.4 jdbc.
Peter mount
Bruce Momjian [Thu, 3 Sep 1998 02:20:30 +0000 (02:20 +0000)]
> Yikes, that is certainly not standard C. I have never seen that
before.
> Looks like a GNU-ism. I nice one, but still a GNU-ism.
Sorry, I didn't know it is a GNU extension. I have written this patch
which should fix the problem. Let me know if you still have problems.
Massimo Dal Zotto
Bruce Momjian [Thu, 3 Sep 1998 02:16:27 +0000 (02:16 +0000)]
Remove \r\n in windows makefile.
Bruce Momjian [Thu, 3 Sep 1998 02:14:39 +0000 (02:14 +0000)]
O2. Seems tas() for PPC (storage/buffer/s_lock.c) never works if
compiled with -O0. Included are patches that should fix the problem
(of course I have confirmed -O2 works with this patch).
BTW, here is a platforms/regression test failure(serious one--backend
death) matrix.
Tatsuo Ishii
Bruce Momjian [Thu, 3 Sep 1998 02:12:14 +0000 (02:12 +0000)]
Oops. I'll fix this.
Here are patches for bin/createdb/createdb.sh.
--
Tatsuo Ishii
t-ishii@sra.co.jp
Bruce Momjian [Thu, 3 Sep 1998 02:10:56 +0000 (02:10 +0000)]
Attached is a patch to remove the definitions of libpq's internal
structs from libpq-fe.h, as we previously discussed.
There turned out to be sloppy coding practices in more places than
I had realized :-(, but all in all I think it was a well-worth-while
exercise.
I ended up adding several routines to libpq's API in order to respond
to application requirements that were exposed by this work. I owe the
docs crew updates for libpq.sgml to describe these changes. I'm way too
tired to work on the docs tonight, however.
This is the last major change I intend to submit for 6.4. I do want
to see if I can make libpgtcl work with Tcl 8.0 before we go final,
but hopefully that will be a minor bug fix.
Bruce Momjian [Wed, 2 Sep 1998 23:37:13 +0000 (23:37 +0000)]
> David Hartwig wrote:
>
> Please apply this HAVING regression patch.
> > My bad. It is caused by a known bug having to do with GROUP BY.
It ain't$
> > nothing to do with HAVING. For some reason the bug went away for a
while, $
> > script. It must have, because that is how I created the expected
file. :(
> >
> > A patch to the regression will be forthcoming.
>
Bruce Momjian [Wed, 2 Sep 1998 23:05:37 +0000 (23:05 +0000)]
Fix for indexing problems.
Thomas G. Lockhart [Wed, 2 Sep 1998 15:48:28 +0000 (15:48 +0000)]
Update to support the CREATE TABLE DEFAULT VALUES statement in gram.y.
Thomas G. Lockhart [Wed, 2 Sep 1998 15:47:30 +0000 (15:47 +0000)]
Support CREATE TABLE DEFAULT VALUES statement.