]> granicus.if.org Git - postgresql/log
postgresql
26 years agoUse Snapshot in heap access methods.
Vadim B. Mikheev [Mon, 27 Jul 1998 19:38:40 +0000 (19:38 +0000)]
Use Snapshot in heap access methods.

26 years agoMissed a few files in the last round of commits from Tatsuo, as well
Marc G. Fournier [Mon, 27 Jul 1998 03:21:58 +0000 (03:21 +0000)]
Missed a few files in the last round of commits from Tatsuo, as well
as needed to run autoconf ...

26 years agoFrom: t-ishii@sra.co.jp
Marc G. Fournier [Sun, 26 Jul 1998 04:31:41 +0000 (04:31 +0000)]
From: t-ishii@sra.co.jp

As Bruce mentioned, this is due to the conflict among changes we made.
Included patches should fix the problem(I changed all MB to
MULTIBYTE). Please let me know if you have further problem.

P.S. I did not include pathces to configure and gram.c to save the
file size(configure.in and gram.y modified).

26 years agoI missed addding initdb.sh ...
Marc G. Fournier [Sun, 26 Jul 1998 04:22:42 +0000 (04:22 +0000)]
I missed addding initdb.sh ...

26 years agoUpdate flowchart. Add arrow.
Bruce Momjian [Sun, 26 Jul 1998 02:17:55 +0000 (02:17 +0000)]
Update flowchart.  Add arrow.

26 years agoFix compile error. Make transaction/work optional on all transaction
Bruce Momjian [Sun, 26 Jul 1998 01:18:09 +0000 (01:18 +0000)]
Fix compile error.  Make transaction/work optional on all transaction
statements.  More cleanups of psql help.  Fix for shift/reduce on
UNION in subselect.

26 years agoUpdate psql help syntax to remove <> and uppercaese keywords.
Bruce Momjian [Sat, 25 Jul 1998 00:17:30 +0000 (00:17 +0000)]
Update psql help syntax to remove <> and uppercaese keywords.

26 years agoAdd mention of actual SQL command to create*/destroy* commands.
Bruce Momjian [Fri, 24 Jul 1998 16:44:04 +0000 (16:44 +0000)]
Add mention of actual SQL command to create*/destroy* commands.

26 years agoAdd mention of SQL commands to create/destroy man pages.
Bruce Momjian [Fri, 24 Jul 1998 16:36:56 +0000 (16:36 +0000)]
Add mention of SQL commands to create/destroy man pages.

26 years agoAdd mention of psql and template1 to create*, destroy* command
Bruce Momjian [Fri, 24 Jul 1998 16:10:19 +0000 (16:10 +0000)]
Add mention of psql and template1 to create*, destroy* command
manual pages.

26 years agoFix HAVING patch missing cast.
Bruce Momjian [Fri, 24 Jul 1998 15:54:10 +0000 (15:54 +0000)]
Fix HAVING patch missing cast.

26 years agoI'm sorry, but I think I introduced a little bug with my last patch.
Bruce Momjian [Fri, 24 Jul 1998 04:03:10 +0000 (04:03 +0000)]
I'm sorry, but I think I introduced a little bug with my last patch.
Everyone using an [NOT] EXISTS subquery will have noticed that
already.

The bug is in "subselect.c" in the function "SS_process_sublinks()".

Here the whole function as it *SHOULD BE*:

Stephan

26 years agoI really hope that I haven't missed anything in this one...
Marc G. Fournier [Fri, 24 Jul 1998 03:32:46 +0000 (03:32 +0000)]
I really hope that I haven't missed anything in this one...

From: t-ishii@sra.co.jp

Attached are patches to enhance the multi-byte support.  (patches are
against 7/18 snapshot)

* determine encoding at initdb/createdb rather than compile time

Now initdb/createdb has an option to specify the encoding. Also, I
modified the syntax of CREATE DATABASE to accept encoding option. See
README.mb for more details.

For this purpose I have added new column "encoding" to pg_database.
Also pg_attribute and pg_class are changed to catch up the
modification to pg_database.  Actually I haved added pg_database_mb.h,
pg_attribute_mb.h and pg_class_mb.h. These are used only when MB is
enabled. The reason having separate files is I couldn't find a way to
use ifdef or whatever in those files. I have to admit it looks
ugly. No way.

* support for PGCLIENTENCODING when issuing COPY command

commands/copy.c modified.

* support for SQL92 syntax "SET NAMES"

See gram.y.

* support for LATIN2-5
* add UNICODE regression test case
* new test suite for MB

New directory test/mb added.

* clean up source files

Basic idea is to have MB's own subdirectory for easier maintenance.
These are include/mb and backend/utils/mb.

26 years agoVersion 06-30-0248
Byron Nikolaidis [Wed, 22 Jul 1998 23:47:48 +0000 (23:47 +0000)]
Version 06-30-0248

26 years agoFix _lo_commit: core if LO memmory context was not created (LO were not used?)
Vadim B. Mikheev [Wed, 22 Jul 1998 05:48:59 +0000 (05:48 +0000)]
Fix _lo_commit: core if LO memmory context was not created (LO were not used?)

26 years agoVariableCache (next XID generator) is placed in shmem.
Vadim B. Mikheev [Tue, 21 Jul 1998 06:17:39 +0000 (06:17 +0000)]
VariableCache (next XID generator) is placed in shmem.

26 years agoUpdate.
Bruce Momjian [Tue, 21 Jul 1998 04:48:31 +0000 (04:48 +0000)]
Update.

26 years agoUpdate.
Bruce Momjian [Tue, 21 Jul 1998 04:19:44 +0000 (04:19 +0000)]
Update.

26 years agoTheses buffer leaks are caused by indexes that are kept open between
Bruce Momjian [Tue, 21 Jul 1998 04:17:30 +0000 (04:17 +0000)]
Theses buffer leaks are caused by indexes that are kept open between
calls. Outside a transaction, the backend detects them as buffer
leaks; it sends a NOTICE, and frees them. This sometimes cause a
segmentation fault (at least on Linux). These indexes are initialized
on the first lo_read/lo_write/lo_tell call, and (normally) closed
on a lo_close call.  Thus the buffer leaks appear when lo direct
access functions are used, and not with lo_import/lo_export functions
(libpq version calls lo_close before ending the command, and the
backend version uses another path).

The included patches (against recent snapshot, and against 6.3.2)
cause indexes to be closed on transaction end (that is on explicit
'END' statment, or on command termination outside trasaction blocks),
thus preventing the buffer leaks while increasing performance inside
transactions. Some (all?) 'classic' memory leaks are also removed.

I hope it will be ok.

--- Pascal ANDRE, graduated from Ecole Centrale Paris andre@via.ecp.fr

26 years agotarget list fixes.
Bruce Momjian [Mon, 20 Jul 1998 21:18:35 +0000 (21:18 +0000)]
target list fixes.

26 years agomakeTargetEntry cleanup.
Bruce Momjian [Mon, 20 Jul 1998 20:48:54 +0000 (20:48 +0000)]
makeTargetEntry cleanup.

26 years agoMakefile removal of internal.c.
Bruce Momjian [Mon, 20 Jul 1998 20:01:48 +0000 (20:01 +0000)]
Makefile removal of internal.c.

26 years agoCleanup makeTargetEntry and remove internal.c.
Bruce Momjian [Mon, 20 Jul 1998 19:53:53 +0000 (19:53 +0000)]
Cleanup makeTargetEntry and remove internal.c.

26 years agoUse defines rather than constants for types.
Bruce Momjian [Mon, 20 Jul 1998 19:21:45 +0000 (19:21 +0000)]
Use defines rather than constants for types.

26 years agoFix problem brought in with 32K machine.
Bruce Momjian [Mon, 20 Jul 1998 17:45:49 +0000 (17:45 +0000)]
Fix problem brought in with 32K machine.

26 years agoCleanup use of 16 that should be NAMEDATALEN.
Bruce Momjian [Mon, 20 Jul 1998 16:57:18 +0000 (16:57 +0000)]
Cleanup use of 16 that should be NAMEDATALEN.

26 years agoCleanup Name usage.
Bruce Momjian [Mon, 20 Jul 1998 16:14:18 +0000 (16:14 +0000)]
Cleanup Name usage.

26 years agoFix temp name length.
Bruce Momjian [Mon, 20 Jul 1998 11:28:12 +0000 (11:28 +0000)]
Fix temp name length.

26 years agoRemove un-needed references to Name.
Bruce Momjian [Mon, 20 Jul 1998 11:17:11 +0000 (11:17 +0000)]
Remove un-needed references to Name.

26 years agoUpdate version.
Bruce Momjian [Mon, 20 Jul 1998 10:01:51 +0000 (10:01 +0000)]
Update version.

26 years agoAdd contributor name to fulltextindex, and clean up contrib/README.
Bruce Momjian [Mon, 20 Jul 1998 09:30:13 +0000 (09:30 +0000)]
Add contributor name to fulltextindex, and clean up contrib/README.

26 years agoUpdate fti README and stopwords.
Bruce Momjian [Mon, 20 Jul 1998 02:45:03 +0000 (02:45 +0000)]
Update fti README and stopwords.

26 years agoUpdate list of contrib directories.
Bruce Momjian [Mon, 20 Jul 1998 02:31:10 +0000 (02:31 +0000)]
Update list of contrib directories.

26 years agoI finally got the time to put together some stuff for fti for
Bruce Momjian [Sun, 19 Jul 1998 18:26:41 +0000 (18:26 +0000)]
I finally got the time to put together some stuff for fti for
inclusion in pgsql. I have included a README which should be enough
to start using it, plus a BENCH file that describes some timings
I have done.

Please have a look at it, and if you think everything is OK, I
would like it seen included in the contrib-section of pgsql.

I don't think I will do any more work in this, but maybe it inspires
somebody else to improve on it.

Maarten Boekhold

26 years agoRemove unneeded strcpy() of timezone.
Bruce Momjian [Sun, 19 Jul 1998 10:08:15 +0000 (10:08 +0000)]
Remove unneeded strcpy() of timezone.

26 years agoRemove un-needed psort close.
Bruce Momjian [Sun, 19 Jul 1998 10:05:19 +0000 (10:05 +0000)]
Remove un-needed psort close.

26 years agoLock fix from Tom Ivar Helbekkmo .
Bruce Momjian [Sun, 19 Jul 1998 09:44:36 +0000 (09:44 +0000)]
Lock fix from Tom Ivar Helbekkmo .

26 years ago1) Queries using the having clause on base tables should work well
Bruce Momjian [Sun, 19 Jul 1998 05:49:26 +0000 (05:49 +0000)]
1) Queries using the having clause on base tables should work well
   now. Here some tested features, (examples included in the patch):

1.1) Subselects in the having clause 1.2) Double nested subselects
1.3) Subselects used in the where clause and in the having clause
     simultaneously 1.4) Union Selects using having 1.5) Indexes
on the base relations are used correctly 1.6) Unallowed Queries
are prevented (e.g. qualifications in the
     having clause that belong to the where clause) 1.7) Insert
into as select

2) Queries using the having clause on view relations also work
   but there are some restrictions:

2.1) Create View as Select ... Having ...; using base tables in
the select 2.1.1) The Query rewrite system:

2.1.2) Why are only simple queries allowed against a view from 2.1)
? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug
in ExecMergeJoin ??

Regards Stefan

26 years agopg_dump -z has gotten rather thoroughly broken in the last couple
Bruce Momjian [Sun, 19 Jul 1998 05:24:51 +0000 (05:24 +0000)]
pg_dump -z has gotten rather thoroughly broken in the last couple
of days --- it was emitting stuff like
REVOKE ALL on 'table' from PUBLIC; GRANT ALL on "table" to
"Public"; neither of which work.  While I was at it I
cleaned up a few other things:

* \connect commands are issued only in -z mode.  In this way,
reloading a pg_dump script made without -z will generate a simple
database wholly owned by the invoking user, rather than a mishmash
of tables owned by various people but lacking in access rights.
(Analogy: cp versus cp -p.)

* \connect commands are issued just before COPY FROM stdin commands;
without this, reloading a database containing non-world-writable
tables tended to fail because the COPY was not necessarily attempted
as the table owner.

* Redundant \connect commands are suppressed (each one costs a
backend launch, so...).

* Man page updated (-z wasn't ever documented).

The first two items were discussed in a pgsql-hackers thread around
6 May 98 ("An item for the TODO list: pg_dump and multiple table
owners") but no one had bothered to deal with 'em yet.

regards, tom lane

26 years agoMake sparc/solaris not use complex macr.
Bruce Momjian [Sun, 19 Jul 1998 05:02:51 +0000 (05:02 +0000)]
Make sparc/solaris not use complex macr.

26 years agoAttached are the three patches that were needed to get PostgreSQL
Bruce Momjian [Sun, 19 Jul 1998 04:30:04 +0000 (04:30 +0000)]
Attached are the three patches that were needed to get PostgreSQL
6.3.2 to compile (and run) on my Sparc Solaris 2.5.1 box. Details
below:

pgsql.sparc.patch-template: Adds -D__sparc__ and -D__sun__,
defintions which gcc does define, but Sun's cc does not. :(
pgsql.sparc.patch-makefile: Adds a define so that 'lorder'
is not used, as it is not found on my machine.

Ryan Kirkpatrick

26 years agoMy mailer munged the intro text in my last post. Here is the text
Bruce Momjian [Sun, 19 Jul 1998 04:17:13 +0000 (04:17 +0000)]
My mailer munged the intro text in my last post.  Here is the text
in a more readable form.  -- I am submitting the following patches
to the June 6, 1998 snapshot of PostgreSQL.  These patches implement
a port of PostgreSQL to SCO UnixWare 7, and updates the Univel port
(UnixWare 2.x).  The patched files, and the reason
 for the patch are:

File            Reason for the patch ---------------
---------------------------------------------------------------
src/backend/port/dynloader/unixware.c src/backend/port/dynloader/unixware.h
src/include/port/unixware.h src/makefiles/Makefile.unixware
src/template/unixware
Created for the UNIXWARE port.

src/include/port/univel.h
Modifed this file to work with the changes made to
s_lock.[ch].

src/backend/storage/buffer/s_lock.c src/include/storage/s_lock.h
Moved the UNIXWARE (and Univel) tas() function from
s_lock.c to s_lock.h.  The UnixWare compiler asm
construct is treated as a macro and needs to be in
the s_lock.h file.  I also reworked the tas()
function to correct some errors in the code.

src/include/version.h.in
The use of the ## operator with quoted strings in
the VERSION macro caused problems with the UnixWare
C compiler.  I removed the ## operators since they
were not needed in this case.  The macro expands
into a sequence of quoted strings that will be
concatenated by any ANSI C compiler.

src/config.guess
This script was modified to recognize SCO UnixWare
7.

src/configure src/configure.in
The configure script was modified to recognize SCO
UnixWare 7.

Billy G. Allie

26 years agoConditionally execute Junk filter only when ORDER BY of columns
Bruce Momjian [Sun, 19 Jul 1998 03:46:29 +0000 (03:46 +0000)]
Conditionally execute Junk filter only when ORDER BY of columns
not in target list.

26 years agoSomewhere between 6.1 and 6.3 someone removed the support for the
Bruce Momjian [Sun, 19 Jul 1998 01:19:54 +0000 (01:19 +0000)]
Somewhere between 6.1 and 6.3 someone removed the support for the
NS32K machine I contributed.  In any case, I now have postgresql-6.3
running again on NetBSD/pc532, a NS32532 machine.  The following
changes are needed relative to the src directory.  (It looks like
support was partially removed when the files were moved from the
src/backend/storage/.... tree to the src/include tree.)

If you need me to get a current development version of postgresql
for this change let me know.  Also, let me know if this code needs
updating due to another code movement that deleted the old NS32K
support.

Thank you.

Phil Nelson

26 years agoAdd DISABLE_COMPLEX_MACRO to sco.
Bruce Momjian [Sun, 19 Jul 1998 01:11:01 +0000 (01:11 +0000)]
Add DISABLE_COMPLEX_MACRO to sco.

26 years agoAdd auto-size to screen to \d? commands. Use UNION to show all
Bruce Momjian [Sat, 18 Jul 1998 18:34:34 +0000 (18:34 +0000)]
Add auto-size to screen to \d? commands.  Use UNION to show all
\d? results in one query. Add \d? field search feature.  Rename MB
to MULTIBYTE.

26 years agoMove common lock code to their own section.
Bruce Momjian [Sat, 18 Jul 1998 14:58:58 +0000 (14:58 +0000)]
Move common lock code to their own section.

26 years agoOn architectures where we don't have any special inline code for
Bruce Momjian [Sat, 18 Jul 1998 14:51:10 +0000 (14:51 +0000)]
On architectures where we don't have any special inline code for
GCC, the inner "#if defined(__GNUC__)" can just be omitted in that
architecture's block.

The existing arrangement with an outer "#if defined(__GNUC__)"
doesn't have any obvious benefit, and it encourages missed cases
like this one.

BTW, I'd suggest making the definition of clear_lock for HPUX be

static const slock_t clear_lock = {{-1, -1, -1, -1}};

The extra braces are needed to suppress warnings from gcc, and
declaring it const just seems like good practice.

regards, tom lane

26 years agoThank you for testing and reporting this. It is my fault of course,
Bruce Momjian [Sat, 18 Jul 1998 14:38:12 +0000 (14:38 +0000)]
Thank you for testing and reporting this. It is my fault of course,
but as I don't have access to a sparc for testing I just did what
I could. I am guessing here, but please apply the following to your
pgsql and let me know what happens. Also, cd to src/storage/buffer
and do 'make s_lock_test' as well.

David Gould

26 years agoRename Rel to RelOptInfo.
Bruce Momjian [Sat, 18 Jul 1998 04:22:52 +0000 (04:22 +0000)]
Rename Rel to RelOptInfo.

26 years agoupdate
Bruce Momjian [Fri, 17 Jul 1998 18:19:31 +0000 (18:19 +0000)]
update

26 years agoRemove monitor mention and add psql.
Bruce Momjian [Thu, 16 Jul 1998 15:54:39 +0000 (15:54 +0000)]
Remove monitor mention and add psql.

26 years agoFix for Group ReScan suggested by Vadim.
Bruce Momjian [Thu, 16 Jul 1998 02:58:09 +0000 (02:58 +0000)]
Fix for Group ReScan suggested by Vadim.

26 years agoPatch for ReScan of Group.
Bruce Momjian [Thu, 16 Jul 1998 01:49:19 +0000 (01:49 +0000)]
Patch for ReScan of Group.

26 years agoAllow UNION/UNION ALL in subselects.
Bruce Momjian [Wed, 15 Jul 1998 22:16:21 +0000 (22:16 +0000)]
Allow UNION/UNION ALL in subselects.

26 years agoFix for COPY problem and atttypmod.
Bruce Momjian [Wed, 15 Jul 1998 18:53:40 +0000 (18:53 +0000)]
Fix for COPY problem and atttypmod.

26 years agoUpdate word.
Bruce Momjian [Wed, 15 Jul 1998 17:34:06 +0000 (17:34 +0000)]
Update word.

26 years agoAdd PGUSER to man page.
Bruce Momjian [Wed, 15 Jul 1998 17:08:23 +0000 (17:08 +0000)]
Add PGUSER to man page.

26 years agoAllow UNION in subselect.
Bruce Momjian [Wed, 15 Jul 1998 15:56:36 +0000 (15:56 +0000)]
Allow UNION in subselect.

26 years agoFix explain for union and inheritance. Rename Append structure
Bruce Momjian [Wed, 15 Jul 1998 14:54:39 +0000 (14:54 +0000)]
Fix explain for union and inheritance.  Rename Append structure
members to be clearer.  Fix cost computation for these.

26 years agoFix for UNION selects with constant NULL expressions; e.g.
Thomas G. Lockhart [Tue, 14 Jul 1998 03:51:42 +0000 (03:51 +0000)]
Fix for UNION selects with constant NULL expressions; e.g.
 SELECT 1 UNION SELECT NULL;

26 years agoFirst version of files from Oliver Elphick.
Thomas G. Lockhart [Tue, 14 Jul 1998 03:47:34 +0000 (03:47 +0000)]
First version of files from Oliver Elphick.

26 years agoutoconf
Bruce Momjian [Tue, 14 Jul 1998 03:02:53 +0000 (03:02 +0000)]
utoconf

26 years agoUpdate for hpux and rint
Bruce Momjian [Tue, 14 Jul 1998 02:58:59 +0000 (02:58 +0000)]
Update for hpux and rint

26 years agoMore updates for typmod int32 change. From Tom Lane.
Bruce Momjian [Tue, 14 Jul 1998 02:41:26 +0000 (02:41 +0000)]
More updates for typmod int32 change.  From Tom Lane.

26 years agoMajor man page update from Tom Lane. c
Bruce Momjian [Tue, 14 Jul 1998 01:45:25 +0000 (01:45 +0000)]
Major man page update from Tom Lane.  c

26 years agoFix for AS name quotation problem.
Bruce Momjian [Mon, 13 Jul 1998 21:27:58 +0000 (21:27 +0000)]
Fix for AS name quotation problem.

26 years agoCurrently, building on any platform that hasn't got getrusage()
Bruce Momjian [Mon, 13 Jul 1998 16:39:07 +0000 (16:39 +0000)]
Currently, building on any platform that hasn't got getrusage()
requires manual editing of src/backend/port/getrusage.c, because
its substitute version of getrusage is #if'd out.

There is no good reason for that, because configure won't even
include the file into the Makefile unless the platform hasn't got
getrusage.  Furthermore, we only have one working substitute version
of getrusage --- the alleged HPUX syscall-based code doesn't work.
(It causes a coredump because the syscall returns a struct rusage
that's much larger than the stub struct defined in
src/include/rusagestub.h.)  The times()-based emulation works fine
on HPUX, however.

I propose, therefore, that getrusage.c should just unconditionally
compile the times-based version, and rely on configure to include
the file only if needed.  This will be one less manual configuration
step on all platforms that need this code.

Patch attached.

Tom Lane.

26 years agoInline function, rename libpq variablees, change lrel to lockrel.
Bruce Momjian [Mon, 13 Jul 1998 16:35:04 +0000 (16:35 +0000)]
Inline function, rename libpq variablees, change lrel to lockrel.

26 years agoRename libpq to use more normal field names.
Bruce Momjian [Mon, 13 Jul 1998 02:41:59 +0000 (02:41 +0000)]
Rename libpq to use more normal field names.

26 years agoFix libpq because it was reading from the backend as a short.
Bruce Momjian [Mon, 13 Jul 1998 00:01:45 +0000 (00:01 +0000)]
Fix libpq because it was reading from the backend as a short.

26 years agoremoved unneeded long spec on constants.
Bruce Momjian [Sun, 12 Jul 1998 23:41:19 +0000 (23:41 +0000)]
removed unneeded long spec on constants.

26 years agoChange atttypmod from int16 to int32, for Thomas.
Bruce Momjian [Sun, 12 Jul 1998 21:29:40 +0000 (21:29 +0000)]
Change atttypmod from int16 to int32, for Thomas.

26 years agoFix distclean in libpq++.
Bruce Momjian [Sun, 12 Jul 1998 19:20:45 +0000 (19:20 +0000)]
Fix distclean in libpq++.

26 years agoUpdate linux_i386 fix.
Bruce Momjian [Sun, 12 Jul 1998 18:48:08 +0000 (18:48 +0000)]
Update linux_i386 fix.

26 years agoadd mention of DISTINCT ON attrN
Bruce Momjian [Sun, 12 Jul 1998 04:49:47 +0000 (04:49 +0000)]
add mention of DISTINCT ON attrN

26 years agoReverse out unused patch.
Bruce Momjian [Sun, 12 Jul 1998 04:43:28 +0000 (04:43 +0000)]
Reverse out unused patch.

26 years agoPrint relation name before vacuum, results after vacuum.
Bruce Momjian [Sun, 12 Jul 1998 04:37:55 +0000 (04:37 +0000)]
Print relation name before vacuum, results after vacuum.

26 years agoMoved to select_implicit.out.
Thomas G. Lockhart [Sat, 11 Jul 1998 12:46:20 +0000 (12:46 +0000)]
Moved to select_implicit.out.

26 years agochange <CODE> to <I>.
Bruce Momjian [Thu, 9 Jul 1998 17:59:49 +0000 (17:59 +0000)]
change <CODE> to <I>.

26 years agoupdate
Bruce Momjian [Thu, 9 Jul 1998 15:45:00 +0000 (15:45 +0000)]
update

26 years agoFix for views that use AS with two words.
Bruce Momjian [Thu, 9 Jul 1998 14:59:27 +0000 (14:59 +0000)]
Fix for views that use AS with two words.

26 years agoUpdate regression test run times for v6.4beta.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:36:51 +0000 (14:36 +0000)]
Update regression test run times for v6.4beta.

26 years agoFix typos. Refer to "open source" rather than "freeware".
Thomas G. Lockhart [Thu, 9 Jul 1998 14:35:52 +0000 (14:35 +0000)]
Fix typos. Refer to "open source" rather than "freeware".

26 years agoHandle case of GROUP BY target list column number out of range.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:34:05 +0000 (14:34 +0000)]
Handle case of GROUP BY target list column number out of range.

26 years ago"select_implicit" is renamed from "junkfilter" test.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:32:58 +0000 (14:32 +0000)]
"select_implicit" is renamed from "junkfilter" test.
Move from last test in list up to other "select_xxx" tests.

26 years agoRenamed from "junkfilter" test.
Thomas G. Lockhart [Thu, 9 Jul 1998 14:32:14 +0000 (14:32 +0000)]
Renamed from "junkfilter" test.

26 years agoFrom: Tom Lane <tgl@sss.pgh.pa.us>
Marc G. Fournier [Thu, 9 Jul 1998 03:35:39 +0000 (03:35 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>

I see someone missed an ancient bit of shell-scripting lore:
on some older shells, if your script's argument list is empty,
then "$@" generates an empty-string word rather than no word
at all.  You need to write ${1+"$@"} to get the latter behavior.
(Read your shell man page to see exactly how that works,
but it does the Right Thing on every Bourne shell.)

In particular, pg_dumpall fails when invoked without any switches
on HPUX 9.*, because pg_dump gets an empty-string argument that it
thinks is the name of the database to dump.  I expect this bug
also affects some other OSes, but couldn't tell you just which ones.
Patch attached.

26 years agoFrom: Tom Lane <tgl@sss.pgh.pa.us>
Marc G. Fournier [Thu, 9 Jul 1998 03:32:10 +0000 (03:32 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>

The attached patches respond to discussion that was on pgsql-hackers
around the beginning of June (see thread "libpgtcl bug (and symptomatic
treatment)").  The changes are:

1. Remove code in connectDB that throws away the password after making
a connection.  This doesn't really add much security IMHO --- a bad guy
with access to your client's address space can likely extract the
password anyway, to say nothing of what he might do directly.  And
there's the serious shortcoming that it prevents PQreset() from working
if the database requires a password.

2. Fix coredump problem: fe_sendauth did not guard against being handed
a NULL password pointer.  (This is the proximate cause of the coredump-
during-PQreset problem that Magosanyi Arpad complained of last month.)

3. Remove highly questionable "error recovery" logic in libpgtcl's
pg_exec statement.

I believe the consensus of the discussion last month was in favor of
#1 and #3, but I'm just now getting around to making the change.
I realized that #2 was a bug in process of looking at the change.

26 years agoFrom: Tom Lane <tgl@sss.pgh.pa.us>
Marc G. Fournier [Thu, 9 Jul 1998 03:30:49 +0000 (03:30 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>

Attached are diffs (from current cvs sources) to bring libpq.sgml
and libpq.3 up to date.

It appears that at various times in the past, people have made edits to
one or the other of these files but not both.  I propagated some changes
from each into the other, but I don't think I caught every
inconsistency.  It'd be real nice if the man pages could be
automatically generated from the SGML...

26 years agoFrom: Tom Lane <tgl@sss.pgh.pa.us>
Marc G. Fournier [Thu, 9 Jul 1998 03:29:11 +0000 (03:29 +0000)]
From: Tom Lane <tgl@sss.pgh.pa.us>

Making PQrequestCancel safe to call in a signal handler turned out to be
much easier than I feared.  So here are the diffs.

Some notes:
  * I modified the postmaster's packet "iodone" callback interface to allow
    the callback routine to return a continue-or-drop-connection return
    code; this was necessary to allow the connection to be closed after
    receiving a Cancel, rather than proceeding to launch a new backend...
    Being a neatnik, I also made the iodone proc have a typechecked
    parameter list.
  * I deleted all code I could find that had to do with OOB.
  * I made some edits to ensure that all signals mentioned in the code
    are referred to symbolically not by numbers ("SIGUSR2" not "2").
    I think Bruce may have already done at least some of the same edits;
    I hope that merging these patches is not too painful.

26 years agoSurround table and column names with double-quotes
Thomas G. Lockhart [Wed, 8 Jul 1998 14:33:19 +0000 (14:33 +0000)]
Surround table and column names with double-quotes
 in generated SQL code to preserve case (SQL92 syntax).

26 years agoInclude tests for new 8-byte integer.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:31:02 +0000 (14:31 +0000)]
Include tests for new 8-byte integer.
Include tests for HAVING clause.

26 years agoInclude int8_tbl from tests for new 8-byte integer.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:30:21 +0000 (14:30 +0000)]
Include int8_tbl from tests for new 8-byte integer.

26 years agoInclude tests for new 8-byte integer (minimal).
Thomas G. Lockhart [Wed, 8 Jul 1998 14:29:09 +0000 (14:29 +0000)]
Include tests for new 8-byte integer (minimal).
Include tests for HAVING clause.

26 years agoInclude int8 as a built-in data type.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:18:45 +0000 (14:18 +0000)]
Include int8 as a built-in data type.
Merge "resjunk" handling with automatic type conversion
 when selecting from another column.

26 years agoAdd int8 8-byte integer type.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:10:30 +0000 (14:10 +0000)]
Add int8 8-byte integer type.

26 years agoAdd int8 type for 8-byte integers.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:09:00 +0000 (14:09 +0000)]
Add int8 type for 8-byte integers.
Fix OID conflict between "line()" and "version()" by changing version OID.

26 years agoAllow floating point constants for "def_arg" numeric arguments.
Thomas G. Lockhart [Wed, 8 Jul 1998 14:04:11 +0000 (14:04 +0000)]
Allow floating point constants for "def_arg" numeric arguments.
 Used in the generic "CREATE xxx" parsing.
Do some automatic type conversion for inserts from other columns.
Previous trouble with "resjunk" regression test remains for now.

26 years agoInclude 8-byte integer type.
Thomas G. Lockhart [Wed, 8 Jul 1998 13:57:05 +0000 (13:57 +0000)]
Include 8-byte integer type.
At the moment, probably only works for i686/gcc and Alphas...