OSDN Git Service
Tom Lane [Thu, 20 May 1999 14:39:49 +0000 (14:39 +0000)]
Generate distinct error messages for trigger function not found
and trigger function found but returns wrong type.
Jan Wieck [Thu, 20 May 1999 12:12:55 +0000 (12:12 +0000)]
Fixed shift/reduce conflict
SelectStmt and CursorStmt tried to parse FOR UPDATE ... / FOR READ ONLY.
Cursor now checks that it is read only by looking at forUpdate of Query.
SelectStmt handles FOR READ ONLY too.
Jan
Tatsuo Ishii [Thu, 20 May 1999 09:30:36 +0000 (09:30 +0000)]
overwriting a large object now works
Thomas G. Lockhart [Thu, 20 May 1999 05:40:27 +0000 (05:40 +0000)]
Add reference pages on user interface applications.
Thomas G. Lockhart [Thu, 20 May 1999 05:39:29 +0000 (05:39 +0000)]
Rearrange and consolidate the Admin Guide.
Add reference pages for utilities and remove standalone chapters for same.
Add material for an appendix on date/time properties, but not yet
integrated with the User's Guide.
Break up the former chapter on pg_options
into Admin and Programmer's Guides.
Tom Lane [Thu, 20 May 1999 03:22:01 +0000 (03:22 +0000)]
Very minor improvements in CREATE OPERATOR docs.
Tom Lane [Thu, 20 May 1999 02:57:15 +0000 (02:57 +0000)]
Update CREATE FUNCTION docs: mention use of AS clause with
INTERNAL functions, add a warning about trying to overload function names
for dynamically loaded C functions (from old man page).
Tom Lane [Thu, 20 May 1999 02:46:40 +0000 (02:46 +0000)]
Update SGML docs with some changes I made to test/regress/README
many moons ago, but forgot to put here.
Tom Lane [Thu, 20 May 1999 02:44:53 +0000 (02:44 +0000)]
Doco updates for change to handling of INTERNAL function
entries (prosrc is now name of C-level function).
Tom Lane [Wed, 19 May 1999 23:30:43 +0000 (23:30 +0000)]
Minor improvements to postmaster/backend man pages.
Bruce Momjian [Wed, 19 May 1999 18:06:43 +0000 (18:06 +0000)]
Dec ALpha patches
Bruce Momjian [Wed, 19 May 1999 18:04:51 +0000 (18:04 +0000)]
Dec alpha patches.
Bruce Momjian [Wed, 19 May 1999 17:53:12 +0000 (17:53 +0000)]
Remove 4096 string limited key on block size
Bruce Momjian [Wed, 19 May 1999 16:46:12 +0000 (16:46 +0000)]
Upgrade to PyGreSQL (2.4)
Marc G. Fournier [Wed, 19 May 1999 14:46:54 +0000 (14:46 +0000)]
Bring python up to date ...
From: D'Arcy J.M. Cain <darcy@druid.net>
Tom Lane [Tue, 18 May 1999 23:40:05 +0000 (23:40 +0000)]
Add Aggref and ArrayRef to the set of node types that transformExpr
will pass through rather than spitting up. This is necessary to handle
cases where coerce_type causes a subexpression to be retransformed, as in
SELECT count(*) + 1.0 FROM table
Peter Mount [Tue, 18 May 1999 23:22:08 +0000 (23:22 +0000)]
Forgot the CHANGELOG
Peter Mount [Tue, 18 May 1999 23:17:46 +0000 (23:17 +0000)]
Internationalisation of error messages
Tom Lane [Tue, 18 May 1999 21:36:10 +0000 (21:36 +0000)]
Now that hashjoin is reliable for large joins (knock on wood),
remove optimizer's arbitrary limit on how large a join it will use hashing
for. (The limit was too large to prevent the problems we'd been seeing,
anyway...)
Tom Lane [Tue, 18 May 1999 21:34:29 +0000 (21:34 +0000)]
Remove no-longer-used fields in Hash and HashJoin nodes.
Tom Lane [Tue, 18 May 1999 21:33:06 +0000 (21:33 +0000)]
Rewrite hash join to use simple linked lists instead of a
fixed-size hashtable. This should prevent 'hashtable out of memory' errors,
unless you really do run out of memory. Note: target size for hashtable
is now taken from -S postmaster switch, not -B, since it is local memory
in the backend rather than shared memory.
Peter Mount [Tue, 18 May 1999 06:07:25 +0000 (06:07 +0000)]
Transactions in ImageViewer
Michael Meskes [Tue, 18 May 1999 05:20:17 +0000 (05:20 +0000)]
*** empty log message ***
Peter Mount [Mon, 17 May 1999 22:58:19 +0000 (22:58 +0000)]
Fixed Internationalization of error messages.
Peter Mount [Mon, 17 May 1999 22:43:30 +0000 (22:43 +0000)]
Minor bug fixes. Replaced DateStyle support with ISO.
Bruce Momjian [Mon, 17 May 1999 18:24:48 +0000 (18:24 +0000)]
All works on linux now by my tests and regression(with patch below).
ALTER TABLE RENAME with extents.
Ole Gjerde
Bruce Momjian [Mon, 17 May 1999 18:22:19 +0000 (18:22 +0000)]
Skip junk nodes when comparing UNION target list lengths.
Bruce Momjian [Mon, 17 May 1999 17:03:51 +0000 (17:03 +0000)]
Change resjunk to a boolean.
Jan Wieck [Mon, 17 May 1999 09:03:26 +0000 (09:03 +0000)]
Fixed latest regression diff's by omitting viewowner in SELECT from pg_views.
Jan
Bruce Momjian [Mon, 17 May 1999 06:38:41 +0000 (06:38 +0000)]
This is actually more of a fundamental problem with mdtruncate. It
looks
like someone just didn't add support for multiple segments for
truncation.
The following patch seems to do the right thing, for me at least.
It passed my tests, my data looks right(no data that shouldn't be in
there) and regression is ok.
Ole Gjerde
Bruce Momjian [Mon, 17 May 1999 06:27:07 +0000 (06:27 +0000)]
Add python
Bruce Momjian [Mon, 17 May 1999 06:15:31 +0000 (06:15 +0000)]
Re-add python.
Bruce Momjian [Mon, 17 May 1999 06:06:35 +0000 (06:06 +0000)]
Updates for 6.5.
Marc G. Fournier [Mon, 17 May 1999 04:58:19 +0000 (04:58 +0000)]
Update pointers to where the register/mailing list pages are found on the
wweb site ..
Tom Lane [Mon, 17 May 1999 04:50:07 +0000 (04:50 +0000)]
Prior patch added 2 more characters to string allocated
for SERIAL column's constraint, but forgot to increase space palloc'd...
Bruce Momjian [Mon, 17 May 1999 04:19:33 +0000 (04:19 +0000)]
SELECT * error message fix.
Marc G. Fournier [Mon, 17 May 1999 04:13:29 +0000 (04:13 +0000)]
Apply freebsd specific patches dealign with ELF system from FreeBSD's
ports collection ...
Bruce Momjian [Mon, 17 May 1999 01:01:06 +0000 (01:01 +0000)]
Move IN to proper place.
Bruce Momjian [Mon, 17 May 1999 00:31:49 +0000 (00:31 +0000)]
Cleanup
Bruce Momjian [Mon, 17 May 1999 00:27:45 +0000 (00:27 +0000)]
Fix typo in change.
Tom Lane [Mon, 17 May 1999 00:26:33 +0000 (00:26 +0000)]
Tighten coding in new_join_pathkey, which seems to be a hotspot
for GEQO ...
Tom Lane [Mon, 17 May 1999 00:25:34 +0000 (00:25 +0000)]
Change GEQO optimizer to release memory after each gene
is evaluated. This bounds memory usage to something reasonable even
when many tables are being joined.
Bruce Momjian [Mon, 17 May 1999 00:22:07 +0000 (00:22 +0000)]
Require IN in LOCK syntax.
Bruce Momjian [Mon, 17 May 1999 00:19:12 +0000 (00:19 +0000)]
Change md* call to smgr*.
Tom Lane [Sun, 16 May 1999 19:45:37 +0000 (19:45 +0000)]
Minor code cleanup in optimizer.
Tom Lane [Sun, 16 May 1999 19:45:00 +0000 (19:45 +0000)]
Fix some typos in geqo optimizer --- it now generates
reasonable plans again. Still eats memory like there's no tomorrow,
however :-(.
Tom Lane [Sun, 16 May 1999 14:56:17 +0000 (14:56 +0000)]
Undo collateral damage from recent patch: Makefile had
lost most of target list and thus 'make clean' didn't clean up very well.
Tom Lane [Sun, 16 May 1999 14:34:59 +0000 (14:34 +0000)]
Change iostream to iostream.h, strstream to strstream.h
for compatibility with older C++ libraries.
Bruce Momjian [Sat, 15 May 1999 22:31:07 +0000 (22:31 +0000)]
I made it so it rolled over files at 1MB. My table ended up with 120
segments, and my indexes had 3(Yes, it DOES work!).
DROP TABLE removed ALL segments from the table, but only the main index
segment.
So it looks like removing the table itself is using mdunlink in md.c,
while removing indexes uses FileNameUnlink() which only unlinks 1 file.
As far as I can tell, calling FileNameUnlink() and mdunlink() is basically
the same, except mdunlink() deletes any extra segments.
I've done some testing and it seems to work. It also passes regression
tests(except float8, geometry and rules, but that's normal).
If this patch is right, this fixes all known multi-segment problems on
Linux.
Ole Gjerde
Bruce Momjian [Sat, 15 May 1999 22:18:51 +0000 (22:18 +0000)]
I've got 2 pretty small patches.
configtype.patch simply fixes a typo in config.h.in
pg_dump.c.patch Updates a bunch of error messages to include a reason
from
the backend, and also removes a couple of unnecessary
if's
Ole Gjerde
Michael Meskes [Fri, 14 May 1999 06:56:18 +0000 (06:56 +0000)]
*** empty log message ***
Bruce Momjian [Thu, 13 May 1999 15:55:45 +0000 (15:55 +0000)]
Hi, Bruce!
These are my last changes to lmgr fixing deadlock handling.
Please apply them to cvs...
Vadim
Thomas G. Lockhart [Thu, 13 May 1999 15:01:32 +0000 (15:01 +0000)]
Add double quotes around the sequence name generated to support the
SERIAL data type DEFAULT clause.
This fixes a problem finding the sequence name when mixed case table names
are involved.
Thomas G. Lockhart [Thu, 13 May 1999 14:59:05 +0000 (14:59 +0000)]
Surround a variable declaration with ENABLE_OUTER_JOINS to suppress
compiler warnings about an unused variable.
Tatsuo Ishii [Thu, 13 May 1999 10:28:26 +0000 (10:28 +0000)]
set client_encoding to <nothing> crashes backend.
Tom Lane [Thu, 13 May 1999 07:29:22 +0000 (07:29 +0000)]
Rip out QueryTreeList structure, root and branch. Querytree
lists are now plain old garden-variety Lists, allocated with palloc,
rather than specialized expansible-array data allocated with malloc.
This substantially simplifies their handling and eliminates several
sources of memory leakage.
Several basic types of erroneous queries (syntax error, attempt to
insert a duplicate key into a unique index) now demonstrably leak
zero bytes per query.
Byron Nikolaidis [Thu, 13 May 1999 03:33:00 +0000 (03:33 +0000)]
Update driver to 6-40-0006
Bruce Momjian [Thu, 13 May 1999 02:35:44 +0000 (02:35 +0000)]
Here's a small patch to cause pg_dump to emit the
scale and precision for NUMERIC type column defs.
Keith Parks
Tom Lane [Thu, 13 May 1999 00:34:57 +0000 (00:34 +0000)]
Release allocated memory during AtAbort_Memory.
Tom Lane [Wed, 12 May 1999 23:26:03 +0000 (23:26 +0000)]
Do not refer to stdin in static variable initializer ...
apparently some systems choke on that :-(.
Jan Wieck [Wed, 12 May 1999 17:59:32 +0000 (17:59 +0000)]
Fixed small bug in ruleutils and added output of pg_views and
pg_rules to rules regression test.
Jan
Jan Wieck [Wed, 12 May 1999 17:04:47 +0000 (17:04 +0000)]
Fixed wrong hasAggs when aggregate columns of view aren't
selected.
Disabled ability of defining DISTINCT or ORDER BY on views.
Jan
Jan Wieck [Wed, 12 May 1999 15:02:39 +0000 (15:02 +0000)]
Replaced targetlist entry in GroupClause by reference number
in Resdom and GroupClause so changing of resno's doesn't confuse
the grouping any more.
Jan
Bruce Momjian [Wed, 12 May 1999 12:47:24 +0000 (12:47 +0000)]
I am sorry, I misinterpreted the still failing trigger regression test.
The
offending code
has been removed, the action is now always dependent :-)
I suggest the following patch, to finally make trigger regression happy
again:
<<refint1.patch>>
After that you can remove the following from TODO:
Remove ERROR: check_primary_key: even number of arguments should be
specified
Trigger regression test fails
Andreas
Jan Wieck [Wed, 12 May 1999 10:35:44 +0000 (10:35 +0000)]
Added installation of created procedural languages to initdb
Jan
Thomas G. Lockhart [Wed, 12 May 1999 07:34:02 +0000 (07:34 +0000)]
Minor wording change.
Thomas G. Lockhart [Wed, 12 May 1999 07:32:47 +0000 (07:32 +0000)]
Include mention of CASE, COALESCE, and IFNULL.
Add date/time parsing procedure (perhaps should be in appendix).
Add time zone information (ditto).
Update keyword list.
Thomas G. Lockhart [Wed, 12 May 1999 07:24:01 +0000 (07:24 +0000)]
Adjust elog NOTICE messages to surround table and column names with single
quotes.
Thomas G. Lockhart [Wed, 12 May 1999 07:22:52 +0000 (07:22 +0000)]
Add keywords to implement Vadim's transaction isolation
and lock syntax as fully parsed tokens.
Two keywords for isolation are non-reserved SQL92
(COMMITTED, SERIALIZABLE).
All other new keywords are non-reserved Postgres (not SQL92)
(ACCESS, EXCLUSIVE, MODE, SHARE).
Add syntax to allow CREATE [GLOBAL|LOCAL] TEMPORARY TABLE, throwing an
error if GLOBAL is specified.
Thomas G. Lockhart [Wed, 12 May 1999 07:17:18 +0000 (07:17 +0000)]
Fix problem with multiple indices defined if using column- and table-
constraints. Reported by Tom Lane.
Now, check for duplicate indices and retain the one which is a primary-key.
Adjust elog NOTICE messages to surround table and column names with single
quotes.
Thomas G. Lockhart [Wed, 12 May 1999 07:14:24 +0000 (07:14 +0000)]
Handle conversion of floating point constants to internal strings.
Thomas G. Lockhart [Wed, 12 May 1999 07:12:51 +0000 (07:12 +0000)]
Keep long non-quoted numeric strings *as* untyped strings if they fail
the obvious conversion.
Define a new pattern "decimal" which is non-exponential floating point
for use with numeric() and decimal() types.
Tom Lane [Wed, 12 May 1999 04:38:24 +0000 (04:38 +0000)]
Fix bogus assumption that MAXALIGN is at least sizeof(pointer).
Tom Lane [Tue, 11 May 1999 22:57:50 +0000 (22:57 +0000)]
Fix configure to generate correct expansion of library directory
in pl/plpgsql/src/mklang.sql.
Bruce Momjian [Tue, 11 May 1999 16:29:45 +0000 (16:29 +0000)]
Just a couple more files to untar in src/test/regress
(int2,int4,geometry).
Cheers,
Patrick Welche
Jan Wieck [Tue, 11 May 1999 09:06:35 +0000 (09:06 +0000)]
Changed debug options:
-d4 now prints compressed trees from nodeToString()
-d5 prints pretty trees via nodeDisplay()
new pg_options: pretty_plan, pretty_parse, pretty_rewritten
Jan
Bruce Momjian [Tue, 11 May 1999 03:30:41 +0000 (03:30 +0000)]
put back mklang.sql.in file.
Bruce Momjian [Tue, 11 May 1999 03:28:43 +0000 (03:28 +0000)]
clean up comments
Bruce Momjian [Mon, 10 May 1999 18:22:48 +0000 (18:22 +0000)]
Update man page for select
Jan Wieck [Mon, 10 May 1999 18:17:44 +0000 (18:17 +0000)]
Check for NUMERIC overflow a second time after rounding
Jan
Bruce Momjian [Mon, 10 May 1999 17:01:25 +0000 (17:01 +0000)]
Allow perl install as non-root, from Geoff Keating
Bruce Momjian [Mon, 10 May 1999 16:10:51 +0000 (16:10 +0000)]
Update to PyGreSQL 2.3.
Bruce Momjian [Mon, 10 May 1999 15:27:19 +0000 (15:27 +0000)]
libpq++ uses fe_setauthsvc which is deprecated and results in an error
on connection. This patch changes it to use PQconnectdb rather than
{fe_setauthsvc,PQsetdb}. This still isn't the complete solution, as
there
is no provision for user,password in class PgEnv, but it does get rid of
the error message. Tested with gcc version egcs-2.91.60
19981201
(egcs-1.1.1 release) under NetBSD-1.3K/i386.
Cheers,
Patrick Welche
Bruce Momjian [Mon, 10 May 1999 15:17:17 +0000 (15:17 +0000)]
Rename MAP_FILE to USERMAP_FILE for Digital Unix.
Bruce Momjian [Mon, 10 May 1999 15:12:29 +0000 (15:12 +0000)]
I send you a attach of my modified refint.c that
works with a new policy in cascade mode .
Please Read README.MAX .
I do not know if you are the author of refint.c ,
but if not please tell me who is .
Thank you ( excuse me for my bad english) .
Massimo Lambertini massimo.lambertini@everex.it
Bruce Momjian [Mon, 10 May 1999 04:57:07 +0000 (04:57 +0000)]
This patch is to add more comments
to postgres.init.sh , clairify the options
available, and to add easy support
for installation of postgres into the
runlevel system.
"sh postgres.init.sh install"
Will now install "postgres" in the
/etc/rc.d/init.d directory and execute
/sbin/chkconfig to hook up the symbolic
links. An uninstall option is also added.
Enclosed is the patch and the patched file
Clark
Bruce Momjian [Mon, 10 May 1999 04:19:30 +0000 (04:19 +0000)]
add mention of large object orphaning
Bruce Momjian [Mon, 10 May 1999 04:02:07 +0000 (04:02 +0000)]
Fix initdb problem introduced by recent patch.
Bruce Momjian [Mon, 10 May 1999 00:46:32 +0000 (00:46 +0000)]
Change error messages to oids come out as %u and not %d. Change has no
real affect now.
Tom Lane [Sun, 9 May 1999 23:43:25 +0000 (23:43 +0000)]
Correct type_sanity test so it doesn't spit up on new
definition of numeric_in.
Tom Lane [Sun, 9 May 1999 23:31:47 +0000 (23:31 +0000)]
Rearrange top-level rewrite operations so that EXPLAIN works
on queries involving UNION, EXCEPT, INTERSECT.
Tatsuo Ishii [Sun, 9 May 1999 15:00:18 +0000 (15:00 +0000)]
Running lo_read/lo_write under different memory context
cause troubles. See
Message-Id: <
199905090312.MAA00466@ext16.sra.co.jp>
for more details.
Vadim B. Mikheev [Sun, 9 May 1999 14:00:29 +0000 (14:00 +0000)]
Mistyping by me.
Fixed by Hiroshi.
Tom Lane [Sun, 9 May 1999 02:22:16 +0000 (02:22 +0000)]
Repair incorrect pg_proc entry for numeric_in.
Tom Lane [Sun, 9 May 1999 00:54:30 +0000 (00:54 +0000)]
Fix some miscellaneous places that were using raw open() or
fopen(), instead of going through fd.c ... naughty naughty.
Tom Lane [Sun, 9 May 1999 00:53:22 +0000 (00:53 +0000)]
Update hash and join routines to use fd.c's new temp-file
code, instead of not-very-bulletproof stuff they had before.
Tom Lane [Sun, 9 May 1999 00:52:08 +0000 (00:52 +0000)]
Add 'temporary file' facility to fd.c, and arrange for temp
files to be closed automatically at transaction abort or commit, should
they still be open. Also close any still-open stdio files allocated with
AllocateFile at abort/commit. This should eliminate problems with leakage
of file descriptors after an error. Also, put in some primitive buffered-IO
support so that psort.c can use virtual files without severe performance
penalties.
Bruce Momjian [Sat, 8 May 1999 19:28:20 +0000 (19:28 +0000)]
Add new netbsd file.
Michael Meskes [Fri, 7 May 1999 18:03:37 +0000 (18:03 +0000)]
*** empty log message ***
Bruce Momjian [Fri, 7 May 1999 02:46:24 +0000 (02:46 +0000)]
Remove unused Netbsd files.