OSDN Git Service
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
Marc G. Fournier [Sun, 1 Mar 1998 04:47:38 +0000 (04:47 +0000)]
From: "Billy G. Allie" <Bill.Allie@mug.org>
The following patches will allow postgreSQL 6.3 to compile and run on a
UNIXWARE 2.1.2 system with the native C compiler with the following library
change:
The alloca function must be copied from the libucb.a archive and added
to the libgen.a archive.
Also, the GNU flex program is needed to successfully build postgreSQL.
Marc G. Fournier [Sat, 28 Feb 1998 23:37:10 +0000 (23:37 +0000)]
From: Darren King <darrenk@insightdist.com>
Seem to remember someone posting to one of the lists a while back
that the tutorial code wouldn't compile and/or run. Found four
problems with it that will let it run.
1. Tutorial makefile had a recursive use of DLOBJS.
2. Some tutorial needed semi-colons added to many statements.
3. Complex tutorial didn't clean up after itself.
4. Advanced had a time-travel example. Commented it out and
put a line pointing the user to contrib/spi/README.
Marc G. Fournier [Sat, 28 Feb 1998 21:28:30 +0000 (21:28 +0000)]
Further updated regression output for FreeBSD
Marc G. Fournier [Sat, 28 Feb 1998 20:05:09 +0000 (20:05 +0000)]
Convert the -enable/-with options to use proper m4 macros and provide
-help messages
Suggested by: Tom I Helbekkmo <tih@Hamartun.Priv.NO>
Bruce Momjian [Sat, 28 Feb 1998 15:08:15 +0000 (15:08 +0000)]
Update for 6.3 release.
Vadim B. Mikheev [Sat, 28 Feb 1998 13:53:18 +0000 (13:53 +0000)]
Fix scan adjusting for marked index tuples.
Bruce Momjian [Fri, 27 Feb 1998 22:20:09 +0000 (22:20 +0000)]
Prepare for 6.3 release.
Bruce Momjian [Fri, 27 Feb 1998 22:01:58 +0000 (22:01 +0000)]
Prepare for final release.
Marc G. Fournier [Fri, 27 Feb 1998 21:55:22 +0000 (21:55 +0000)]
Add for port hppa-??-hpux...
Marc G. Fournier [Fri, 27 Feb 1998 19:44:51 +0000 (19:44 +0000)]
From: Darren King <darrenk@insightdist.com>
Two incorrect printf formats in parser/parse_type.c. Prolly done
by me a long time ago when I cleaned up int's and Oid's...
Format flag is really just %u, not %ud. Harmless, but results in
"type id lookup of 25d failed" instead of only "...25 failed"
Vadim B. Mikheev [Fri, 27 Feb 1998 16:12:09 +0000 (16:12 +0000)]
ExecReScan for MergeJoin.
Vadim B. Mikheev [Fri, 27 Feb 1998 16:11:28 +0000 (16:11 +0000)]
ExecReScan for MergeJoin.
Marked inner tuple now is copied into mergestate->mj_MarkedTupleSlot -
no more tricks arround ttc_shouldfree.
Vadim B. Mikheev [Fri, 27 Feb 1998 16:07:02 +0000 (16:07 +0000)]
In '(a,b,...) Op [ANY|ALL] (SubSelect)' Op is restricted to
'=' and '<>'.
Marc G. Fournier [Fri, 27 Feb 1998 12:59:33 +0000 (12:59 +0000)]
From: Michael Meskes <meskes@topsystem.de>
No more shift/reduce conflicts. Also all other bugs I know about are fixed.
Vadim B. Mikheev [Fri, 27 Feb 1998 08:43:53 +0000 (08:43 +0000)]
Check SELECT permissions in subqueries.
Marc G. Fournier [Fri, 27 Feb 1998 03:25:43 +0000 (03:25 +0000)]
Update regression output for FreeBSD
Marc G. Fournier [Fri, 27 Feb 1998 03:17:54 +0000 (03:17 +0000)]
New regression test output for Aix from Darren
Marc G. Fournier [Fri, 27 Feb 1998 03:07:35 +0000 (03:07 +0000)]
Add <sys/types.h> for SunOS
From: t-ishii@sra.co.jp
Marc G. Fournier [Fri, 27 Feb 1998 02:41:21 +0000 (02:41 +0000)]
From: Darren King <darrenk@insightdist.com>
This patch will...
1. Remove the "-Wall" option from the ecpg/lib and ecpg/preproc Makefile.
2. Remove the addition of $(SRCDIR)/include and-or $(SRCDIR)/backend from
ecpg/lib, ecpg/preproc, libpq and utils Makefiles. Already in CFLAGS...
3. Set MK_NO_LORDER and RANLIB in Makefile.aix to avoid a couple of extra
steps taken care of by the 'ld' command anyways.
Marc G. Fournier [Fri, 27 Feb 1998 02:38:15 +0000 (02:38 +0000)]
From: Jan Wieck <jwieck@debis.com>
I thought it would be a good idea to ensure that the new view
permission model will not get broken by subsequent
fixes/changes. So I wrote a little regression test for it.
There is an ugly thing in this regression test. It creates
temporary a test user that is required for the tests. The
user is removed at the end of the test, but if sometimes the
regression suite is aborted or crashes exactly here, the test
user will lay around in the pg_shadow. Don't have a clue how
to get around.
Marc G. Fournier [Fri, 27 Feb 1998 02:34:33 +0000 (02:34 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Sorry, I just repeated the last call and send out a stupid should be empty
mail. Anyway, my last patch missed one change:
Marc G. Fournier [Fri, 27 Feb 1998 02:31:20 +0000 (02:31 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Subject: [PATCHES] ecpg: correct whenever statement
Marc G. Fournier [Fri, 27 Feb 1998 02:30:09 +0000 (02:30 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Here's a small patch to ecpg's man page to make it list all known bugs.
Bruce Momjian [Thu, 26 Feb 1998 16:14:31 +0000 (16:14 +0000)]
Remove data/*.orig files
Bruce Momjian [Thu, 26 Feb 1998 16:06:20 +0000 (16:06 +0000)]
Remove compile warning.
Vadim B. Mikheev [Thu, 26 Feb 1998 12:14:54 +0000 (12:14 +0000)]
index_markpos()/index_restrpos() are in use now.
Vadim B. Mikheev [Thu, 26 Feb 1998 12:13:11 +0000 (12:13 +0000)]
execScan.c: in the end of scan projInfo->pi_slot must be
return, not a slot returned from access method (they have
different TupleDesc and MergeJoin node was broken).
nodeIndexscan.c: index_markpos()/index_restrpos() call index-specific
mark/restr funcs and are in use now (instead of
IndexScanMarkPosition()/ExecIndexRestrPos()).
Vadim B. Mikheev [Thu, 26 Feb 1998 12:07:10 +0000 (12:07 +0000)]
index_markpos()/index_restrpos are used now.
Bruce Momjian [Thu, 26 Feb 1998 04:46:47 +0000 (04:46 +0000)]
pgindent run before 6.3 release, with Thomas' requested changes.
Bruce Momjian [Thu, 26 Feb 1998 02:18:09 +0000 (02:18 +0000)]
Fix permist on libs.
Vadim B. Mikheev [Wed, 25 Feb 1998 23:40:32 +0000 (23:40 +0000)]
Fix 6.X vacuum bug in shrinking code.
Marc G. Fournier [Wed, 25 Feb 1998 20:51:10 +0000 (20:51 +0000)]
Add updated regression output for Solaris-Sparc
Remove SunOS
Marc G. Fournier [Wed, 25 Feb 1998 15:06:47 +0000 (15:06 +0000)]
Commit Solaris-i386 regression.diffs file for comparisons
Marc G. Fournier [Wed, 25 Feb 1998 15:02:18 +0000 (15:02 +0000)]
Change from -u to -wC3 ...
Marc G. Fournier [Wed, 25 Feb 1998 14:54:44 +0000 (14:54 +0000)]
pg_user.h is obseleted in favor of pg_shadow.h
Marc G. Fournier [Wed, 25 Feb 1998 14:50:36 +0000 (14:50 +0000)]
Make changes to psql so that it sees pg_user again instead of db_user
Marc G. Fournier [Wed, 25 Feb 1998 13:09:49 +0000 (13:09 +0000)]
From: Jan Wieck <jwieck@debis.com>
seems that my last post didn't make it through. That's good
since the diff itself didn't covered the renaming of
pg_user.h to pg_shadow.h and it's new content.
Here it's again. The complete regression test passwd with
only some float diffs. createuser and destroyuser work.
pg_shadow cannot be read by ordinary user.
Bruce Momjian [Wed, 25 Feb 1998 00:31:23 +0000 (00:31 +0000)]
pgindent changes for Thomas proc/lock cleanup
Bruce Momjian [Tue, 24 Feb 1998 19:58:26 +0000 (19:58 +0000)]
Fix for locking problems an dpriority.
Marc G. Fournier [Tue, 24 Feb 1998 15:56:45 +0000 (15:56 +0000)]
Change -c to -u for regress.sh...should shrink regression.<portname> somewhat
at the same time...
Suggested by: Frank Ridderbusch <ridderbusch.pad@sni.de>
Marc G. Fournier [Tue, 24 Feb 1998 15:53:54 +0000 (15:53 +0000)]
Forgot to run autoconf after updatign configure.in for Cyrillic patch
Marc G. Fournier [Tue, 24 Feb 1998 15:52:13 +0000 (15:52 +0000)]
+ Sat Feb 21 19:10:55 CET 1998
+
+ - use char[] as string not as array of bytes that is integers
+
+ Sun Feb 22 16:37:36 CET 1998
+
+ - use long for all size variables
+ - added execute immediate statement
+
+ Sun Feb 22 20:41:32 CET 1998
+
+ - use varcharsize = 1 for all simple types, 0 means pointer, > 1
+ means array if type is char resp. unsigned char
+
+ Thu Feb 24 12:26:12 CET 1998
+
+ - allow 'go to' in whenever statement as well as 'goto'
+ - new argument 'stop' for whenever statement
From: Michael Meskes <meskes@topsystem.de>
Marc G. Fournier [Tue, 24 Feb 1998 15:27:04 +0000 (15:27 +0000)]
From: "Denis V. Dmitrienko" <denis@null.net>
What it does:
It solves stupid problem with cyrillic charsets IP-based on-fly recoding.
take a look at /data/charset.conf for details.
You can use any tables for any charset.
Tables are from Russian Apache project.
Tables in this patch contains also Ukrainian characters.
Then run ./configure --enable-recode
Marc G. Fournier [Tue, 24 Feb 1998 06:04:55 +0000 (06:04 +0000)]
From: t-ishii@sra.co.jp
Ok. I have decided to use:
#if defined(sun) && if defined(sparc) && !defined(__svr4)
instead of defined(sunos4). interfaces/libpq/libpq-fe.h and
include/c.h have been modified(see included patches).
Another porblems I have found are:
o SunOS lacks strtoul(). to fix this I stole strtoul.c from FreeBSD
and place it under backend/port. necessary modifications have been
also made to backend/port/Makefile.in, include/config.h.in and
configure.in (see included patches).
Marc G. Fournier [Tue, 24 Feb 1998 04:02:20 +0000 (04:02 +0000)]
Various fixes for string.h vs strings.h
From: Frank Ridderbusch <ridderbusch.pad@sni.de>
Marc G. Fournier [Tue, 24 Feb 1998 03:47:26 +0000 (03:47 +0000)]
Remove #include "port-protos.h", since we no longer use it
From: Frank Ridderbusch <ridderbusch.pad@sni.de>
Marc G. Fournier [Tue, 24 Feb 1998 03:45:10 +0000 (03:45 +0000)]
There is no more 'port-protos.h', so don't try to include it
From: Frank Ridderbusch <ridderbusch.pad@sni.de>
Marc G. Fournier [Tue, 24 Feb 1998 03:41:58 +0000 (03:41 +0000)]
Forgot about the svr4 dynloader stuff
From: Frank Ridderbusch <ridderbusch.pad@sni.de>
Marc G. Fournier [Tue, 24 Feb 1998 03:31:50 +0000 (03:31 +0000)]
From: Jan Wieck <jwieck@debis.com>
So if the relname is given to acldefault() in
utils/adt/acl.c, it can do a IsSystemRelationName() on it and
return ACL_RD instead of ACL_WORLD_DEFAULT.
Marc G. Fournier [Tue, 24 Feb 1998 03:23:52 +0000 (03:23 +0000)]
Various fixes for ecpg to remove compiler dependency...
From: Darren King <darrenk@insightdist.com>
Marc G. Fournier [Tue, 24 Feb 1998 03:16:52 +0000 (03:16 +0000)]
Slight change to GUESS for finding the right entry in .similar
Marc G. Fournier [Tue, 24 Feb 1998 03:12:55 +0000 (03:12 +0000)]
Add an '#include <sys/types.h>' for the netinet/in.h section
Marc G. Fournier [Tue, 24 Feb 1998 03:09:47 +0000 (03:09 +0000)]
Install spi.h and trigger.in
Marc G. Fournier [Mon, 23 Feb 1998 20:32:40 +0000 (20:32 +0000)]
Create a RULE wrapper around pg_user for the password entry
Marc G. Fournier [Mon, 23 Feb 1998 20:15:23 +0000 (20:15 +0000)]
Document ACL_RD -> ACL_NO change on default table creation
Marc G. Fournier [Mon, 23 Feb 1998 19:53:08 +0000 (19:53 +0000)]
Note that table permissions are no longer defaulted to ACL_RD, but ACL_NO
instead
Marc G. Fournier [Mon, 23 Feb 1998 19:26:36 +0000 (19:26 +0000)]
Modify initdb.sh so that it makes pg_user readable through view db_user
Modify psql so that it uses db_user instead of pg_user
GRANT SELECT on pg_class
Marc G. Fournier [Mon, 23 Feb 1998 18:43:13 +0000 (18:43 +0000)]
Quick cleanups
Marc G. Fournier [Mon, 23 Feb 1998 17:44:24 +0000 (17:44 +0000)]
From: Jan Wieck <jwieck@debis.com>
The diff looks so simple and easy. But to find it wasn't fun.
It must have been there for a long time. What happened:
When a tuple in one of some central catalogs was updated, the
referenced relation got flushed, so it would be reopened on
the next access (to reflect new triggers, rules and table
structure changes into the relation cache).
Some data (the tupleDescriptor e.g.) is used in the system
cache too. So when a relation is subject to the system cache,
this must know too that a cached system relation got flushed
because the tupleDesc data gets freed during the flush!
For the GRANT/REVOKE on pg_class it was slightly different.
There is some local data in inval.c that gets initialized on
the first invalidation of a tuple in some central catalogs.
This needs a SysCache lookup in pg_class. But when the first
of all commands is a GRANT on pg_class, exactly the needed
tuple is the one actually invalidated. So I added little code
snippets that the initialization of the local variables in
inval.c will already happen during InitPostgres().
Bruce Momjian [Mon, 23 Feb 1998 16:51:14 +0000 (16:51 +0000)]
Remove libpq README.
Marc G. Fournier [Mon, 23 Feb 1998 15:44:25 +0000 (15:44 +0000)]
A few misc fixes brought up by Andrew
Vadim B. Mikheev [Mon, 23 Feb 1998 13:59:34 +0000 (13:59 +0000)]
Second query in select_views.sql is replaced.
Vadim B. Mikheev [Mon, 23 Feb 1998 13:58:04 +0000 (13:58 +0000)]
Fix relation path constraction in mdblindwrt().
Bruce Momjian [Mon, 23 Feb 1998 13:10:53 +0000 (13:10 +0000)]
Remind people of view permissions, and install libpq README.
Vadim B. Mikheev [Mon, 23 Feb 1998 06:28:16 +0000 (06:28 +0000)]
ExecReScan for Unique & Sort nodes.
Bruce Momjian [Mon, 23 Feb 1998 02:54:11 +0000 (02:54 +0000)]
Partial fix for select distinct in subselect.
Bruce Momjian [Sun, 22 Feb 1998 20:02:34 +0000 (20:02 +0000)]
Configure patches from Brook Milligan.
Marc G. Fournier [Sun, 22 Feb 1998 18:03:26 +0000 (18:03 +0000)]
The getColumns() method in DataBaseMetaData.java returns a column size
of -1 for varchar's.
From: CNT systemen BV <cntsys@cistron.nl>
Marc G. Fournier [Sun, 22 Feb 1998 00:02:18 +0000 (00:02 +0000)]
From: Darren King <darrenk@insightdist.com>
Enclosed is the regression.diffs file from running the Feb 21st
snapshot regression tests for inclusion in src/test/regression
as regression.Aix41. Appears to be standard differences to me,
error messages, fp accuracy and times off by an hour due to PST
vs PDT.
Marc G. Fournier [Sat, 21 Feb 1998 19:23:14 +0000 (19:23 +0000)]
Change:
#define TAPETEMP "pg_btsortXXXXXX"
to:
#define TAPETEMP "pg_btsortXXXXXXX"
For some reason, under FreeBSD, it appears that the mktemp() value needs the
extra 'X' to improve/ensure uniqueness
Bruce Momjian [Sat, 21 Feb 1998 18:17:58 +0000 (18:17 +0000)]
Add handling for new RangeTblEntry column name.
Bruce Momjian [Sat, 21 Feb 1998 16:58:49 +0000 (16:58 +0000)]
Constlen can be -1, so make it a signed type.
Marc G. Fournier [Sat, 21 Feb 1998 06:32:15 +0000 (06:32 +0000)]
First step done,
below is the patch to have views to override the permission
checks for the accessed tables. Now we can do the following:
CREATE VIEW db_user AS SELECT
usename,
usesysid,
usecreatedb,
usetrace,
usecatupd,
'**********'::text as passwd,
valuntil
FROM pg_user;
REVOKE ALL ON pg_user FROM public;
REVOKE ALL ON db_user FROM public;
GRANT SELECT ON db_user TO public;
Edmund Mergl [Fri, 20 Feb 1998 21:26:08 +0000 (21:26 +0000)]
1.7.01.7.0
Edmund Mergl [Fri, 20 Feb 1998 21:25:47 +0000 (21:25 +0000)]
1.7.0
Marc G. Fournier [Fri, 20 Feb 1998 14:28:56 +0000 (14:28 +0000)]
From: Michael Meskes <meskes@topsystem.de>
Please remove src/interfaces/ecpg/prproc/y.tab.h from cvs. It is generated
by make anyway.
Marc G. Fournier [Fri, 20 Feb 1998 13:11:26 +0000 (13:11 +0000)]
Missign a comma...
From: AA van Raalte <alvin@camberlo.demon.co.uk>