Thomas G. Lockhart [Wed, 2 Feb 2000 16:22:45 +0000 (16:22 +0000)]
Add info on debian package installation of sgml toolkits.
Thomas G. Lockhart [Wed, 2 Feb 2000 16:21:06 +0000 (16:21 +0000)]
Add detailed information on Australian time zones.
Thomas G. Lockhart [Wed, 2 Feb 2000 16:19:54 +0000 (16:19 +0000)]
Update with current summary information on pgadmin.
From pgadmin author on 99-12-24.
Peter Eisentraut [Wed, 2 Feb 2000 13:20:15 +0000 (13:20 +0000)]
*** empty log message ***
Jan Wieck [Mon, 31 Jan 2000 14:02:27 +0000 (14:02 +0000)]
Fixed bug in NO ACTION trigger proc entries.
Jan
Tom Lane [Mon, 31 Jan 2000 04:35:57 +0000 (04:35 +0000)]
Fix problems seen in parallel regress tests when SI buffer overruns (causing
syscache and relcache flushes). Relcache entry rebuild now preserves
original tupledesc, rewrite rules, and triggers if possible, so that pointers
to these things remain valid --- if these things change while relcache entry
has positive refcount, we elog(ERROR) to avoid later crash. Arrange for
xact-local rels to be rebuilt when an SI inval message is seen for them,
so that they are updated by CommandCounterIncrement the same as regular rels.
(This is useful because of Hiroshi's recent changes to process our own SI
messages at CommandCounterIncrement time.) This allows simplification of
some routines that previously hacked around the lack of an automatic update.
catcache now keeps its own copy of tupledesc for its relation, rather than
depending on the relcache's copy; this avoids needing to reinitialize catcache
during a cache flush, which saves some cycles and eliminates nasty circularity
problems that occur if a cache flush happens while trying to initialize a
catcache.
Eliminate a number of permanent memory leaks that used to happen during
catcache or relcache flush; not least of which was that catcache never
freed any cached tuples! (Rule parsetree storage is still leaked, however;
will fix that separately.)
Nothing done yet about code that uses tuples retrieved by SearchSysCache
for longer than is safe.
Tom Lane [Mon, 31 Jan 2000 01:21:39 +0000 (01:21 +0000)]
Hmm, equalfuncs didn't know about SortClause or GroupClause
nodes...
Byron Nikolaidis [Sun, 30 Jan 2000 21:14:25 +0000 (21:14 +0000)]
Added numeric and int8 types.
Bug fix for LongVarBinary -- begin transaction
Tom Lane [Sat, 29 Jan 2000 21:13:23 +0000 (21:13 +0000)]
Delete unused and long-dead header file.
Tom Lane [Sat, 29 Jan 2000 19:51:59 +0000 (19:51 +0000)]
Modify uses of RelationFlushRelation and RelationCacheInvalidate so that
we *always* rebuild, rather than deleting, an invalidated relcache entry
that has positive refcount. Otherwise an SI cache overrun leads to
dangling Relation pointers all over the place!
Bruce Momjian [Sat, 29 Jan 2000 17:25:46 +0000 (17:25 +0000)]
Update TODO list.
Peter Eisentraut [Sat, 29 Jan 2000 16:58:54 +0000 (16:58 +0000)]
A few minor psql enhancements
Initdb help correction
Changed end/abort to commit/rollback and changed related notices
Commented out way old printing functions in libpq
Fixed a typo in alter table / alter column
Bruce Momjian [Sat, 29 Jan 2000 08:53:10 +0000 (08:53 +0000)]
Update copyright file.
Bruce Momjian [Sat, 29 Jan 2000 01:58:50 +0000 (01:58 +0000)]
Attached is a uuencoded tarball that contains
3 new files and two patches for the plperl subdir.
These changes add the ability for plperl functions
to call 'elog'. It also sets up the frame work to
allow me to add access to the SPI functions.
--
Mark Hollomon
Bruce Momjian [Fri, 28 Jan 2000 17:23:47 +0000 (17:23 +0000)]
Patch from Hiroshi for overflow btree comparison.
Bruce Momjian [Fri, 28 Jan 2000 04:47:49 +0000 (04:47 +0000)]
Update TODO list.
Bruce Momjian [Fri, 28 Jan 2000 03:46:06 +0000 (03:46 +0000)]
Update TODO list.
Bruce Momjian [Fri, 28 Jan 2000 03:40:34 +0000 (03:40 +0000)]
Update TODO list.
Tom Lane [Fri, 28 Jan 2000 03:22:36 +0000 (03:22 +0000)]
Apply the heuristic proposed by Taral (see pgsql-general archives for
2-Oct-98 or TODO.detail/cnfify) to decide whether we want to reduce
WHERE clause to CNF form, DNF form, or neither. This is a HUGE win.
The heuristic conditions could probably still use a little tweaking to
make sure we don't pick CNF when DNF would be better, or vice versa,
but the risk of exponential explosion in cnfify() is gone. I was able
to run ten-thousand-AND-subclause queries through the planner in a
reasonable amount of time.
Michael Meskes [Thu, 27 Jan 2000 19:01:35 +0000 (19:01 +0000)]
*** empty log message ***
Tom Lane [Thu, 27 Jan 2000 18:11:50 +0000 (18:11 +0000)]
Redesign DISTINCT ON as discussed in pgsql-sql 1/25/00: syntax is now
SELECT DISTINCT ON (expr [, expr ...]) targetlist ...
and there is a check to make sure that the user didn't specify an ORDER BY
that's incompatible with the DISTINCT operation.
Reimplement nodeUnique and nodeGroup to use the proper datatype-specific
equality function for each column being compared --- they used to do
bitwise comparisons or convert the data to text strings and strcmp().
(To add insult to injury, they'd look up the conversion functions once
for each tuple...) Parse/plan representation of DISTINCT is now a list
of SortClause nodes.
initdb forced by querytree change...
Bruce Momjian [Thu, 27 Jan 2000 05:33:51 +0000 (05:33 +0000)]
fix for compile.
Tom Lane [Wed, 26 Jan 2000 23:48:05 +0000 (23:48 +0000)]
Remove duplicate extern declaration.
Bruce Momjian [Wed, 26 Jan 2000 16:10:01 +0000 (16:10 +0000)]
Update files.
Bruce Momjian [Wed, 26 Jan 2000 06:33:49 +0000 (06:33 +0000)]
Add include for float.h.
Bruce Momjian [Wed, 26 Jan 2000 05:58:53 +0000 (05:58 +0000)]
Add:
* Portions Copyright (c) 1996-2000, PostgreSQL, Inc
to all files copyright Regents of Berkeley. Man, that's a lot of files.
Bruce Momjian [Tue, 25 Jan 2000 23:53:56 +0000 (23:53 +0000)]
as attache of this mail is patch (to the main tree) with to_char's
family functions. Contain:
conversion from a datetype to formatted text:
to_char( datetime, text)
to_char( timestamp, text)
to_char( int4, text)
to_char( int8, text)
to_char( float4, text)
to_char( float8, text)
to_char( numeric, text)
vice versa:
to_date ( text, text)
to_datetime ( text, text)
to_timestamp ( text, text)
to_number ( text, text) (convert to numeric)
PostgreSQL to_char is very compatible with Oracle's to_char(), but not
total exactly (now). Small differentions are in number formating. It will
fix in next to_char() version.
! If will this patch aplly to the main tree, must be delete the current
to_char version in contrib (directory "dateformat" and note in contrib's
README), this patch not erase it (sorry Bruce).
The patch patching files:
doc/src/sgml/func.sgml
^^^^^^^^
Hmm, I'm not sure if my English... :( Check it anyone (volunteer)?
Thomas, it is right? SGML is not my primary lang and compile
the current PG docs tree is very happy job (hard variables setting in
docs/sgml/Makefile --> HSTYLE= /home/users/t/thomas/.... :-)
What add any definition to global configure.in and set Makefiles in docs
tree via ./configure?
src/backend/utils/adt/Makefile
src/backend/utils/adt/formatting.c
src/include/catalog/pg_proc.h
src/include/utils/formatting.h
Karel Zak <zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
Tom Lane [Tue, 25 Jan 2000 07:04:04 +0000 (07:04 +0000)]
Remove obsolete references to 8K query limit.
Tatsuo Ishii [Tue, 25 Jan 2000 02:12:27 +0000 (02:12 +0000)]
Fix pg_euccn_mblen() so that it always returns 2 if data is not ascii.
(EUC_CN does have only code set 0 and 1)
Tom Lane [Tue, 25 Jan 2000 01:59:27 +0000 (01:59 +0000)]
Forgot that expr assumes regexp is anchored-left; therefore need .*
in front of any platform name pattern that's not supposed to match
beginning at the start of the machine type name...
Peter Eisentraut [Mon, 24 Jan 2000 23:40:35 +0000 (23:40 +0000)]
Removed alter table drop column.
Bruce Momjian [Mon, 24 Jan 2000 22:27:59 +0000 (22:27 +0000)]
Update TODO list.
Peter Eisentraut [Mon, 24 Jan 2000 19:34:19 +0000 (19:34 +0000)]
Made abstime/reltime use int4 instead of time_t (TODO item)
Made type equivalency apply to aggregates (TODO item)
Fixed parsing bug in psql
Reverted some stupid options changes I made to pg_dump
Tom Lane [Mon, 24 Jan 2000 07:16:52 +0000 (07:16 +0000)]
First cut at making useful selectivity estimates for range queries
(ie, WHERE x > lowbound AND x < highbound). It's not very bright yet
but it does something useful. Also, rename intltsel/intgtsel to
scalarltsel/scalargtsel to reflect usage better. Extend convert_to_scalar
to do something a little bit useful with string data types. Still need
to make it do something with date/time datatypes, but I'll wait for
Thomas's datetime unification dust to settle first. Eventually the
routine ought not have any type-specific knowledge at all; it ought to
be calling a type-dependent routine found via a pg_type column; but
that's a task for another day.
Bruce Momjian [Mon, 24 Jan 2000 03:08:27 +0000 (03:08 +0000)]
Update for index change. Semes it didn't work the first time.
Bruce Momjian [Mon, 24 Jan 2000 02:12:58 +0000 (02:12 +0000)]
Remove Ops parameter from STATRELID cache lookup, for Tom Lane and
optimizer.
Bruce Momjian [Sun, 23 Jan 2000 17:30:18 +0000 (17:30 +0000)]
Update TODO list.
Tatsuo Ishii [Sun, 23 Jan 2000 08:20:24 +0000 (08:20 +0000)]
Change format of postmaster.opts.default.
Executable file name (postmaster) no more included in the file.
Tatsuo Ishii [Sun, 23 Jan 2000 08:16:37 +0000 (08:16 +0000)]
Fix error messages for the lack of multi-byte support.
Since --with-mb has been removed from configure, previous
messages were not appropriate.
Tatsuo Ishii [Sun, 23 Jan 2000 08:13:34 +0000 (08:13 +0000)]
char_length()/octet_length for char() type now returns length of
the charcter including trailing blanks.
Tom Lane [Sun, 23 Jan 2000 03:43:24 +0000 (03:43 +0000)]
Replace SearchSysCacheGetAttribute with SysCacheGetAttr, which fetches
an attribute of a tuple previously fetched with SearchSysCacheTuple.
This avoids a lot of redundant cache lookups, particularly in selfuncs.c.
Also, remove SearchSysCacheStruct, which was unused and grotty.
Bruce Momjian [Sun, 23 Jan 2000 03:28:54 +0000 (03:28 +0000)]
Update TODO list.
Bruce Momjian [Sun, 23 Jan 2000 03:19:05 +0000 (03:19 +0000)]
Update TODO list.
Tom Lane [Sun, 23 Jan 2000 02:07:00 +0000 (02:07 +0000)]
First cut at unifying regular selectivity estimation with indexscan
selectivity estimation wasn't right. This is better...
Peter Eisentraut [Sun, 23 Jan 2000 01:27:39 +0000 (01:27 +0000)]
updated install file
updated date/time types doc
fixed small psql bug
removed libpq code that lower-cased db names
make notice when long identifier is truncated
Tom Lane [Sat, 22 Jan 2000 23:51:20 +0000 (23:51 +0000)]
Update regress tests for change of pg_am/pg_amop.
Tom Lane [Sat, 22 Jan 2000 23:50:30 +0000 (23:50 +0000)]
Revise handling of index-type-specific indexscan cost estimation, per
pghackers discussion of 5-Jan-2000. The amopselect and amopnpages
estimators are gone, and in their place is a per-AM amcostestimate
procedure (linked to from pg_am, not pg_amop).
Tom Lane [Sat, 22 Jan 2000 23:05:14 +0000 (23:05 +0000)]
findoidjoins was suffering from bit rot (pginterface no
longer in expected location).
Peter Eisentraut [Sat, 22 Jan 2000 14:20:56 +0000 (14:20 +0000)]
added ALTER TABLE DROP COLUMN, early version
Bruce Momjian [Sat, 22 Jan 2000 04:29:46 +0000 (04:29 +0000)]
Update TODO list.
Tom Lane [Sat, 22 Jan 2000 03:52:04 +0000 (03:52 +0000)]
Change a few routines into macros to improve speed of COPY IN inner loop.
Tom Lane [Sat, 22 Jan 2000 01:22:48 +0000 (01:22 +0000)]
Forgot to handle column length defaults in ALTER TABLE ADD COLUMN.
Tom Lane [Fri, 21 Jan 2000 23:32:36 +0000 (23:32 +0000)]
Fix tab-complete so it works with old versions of readline that don't
have the rl_completion_append_character variable. The tab completion
behavior doesn't seem to be quite perfect in that situation, but it's
better than failing to build at all...
Tom Lane [Fri, 21 Jan 2000 04:21:12 +0000 (04:21 +0000)]
Fix handleCopyIn's response to EOF seen mid-line, that is, input file
does not end with a newline. I don't think this explains the recent
complaints, since this bug existed in 6.5 (and probably long before).
But might as well fix it now that I see it.
Bruce Momjian [Fri, 21 Jan 2000 03:55:22 +0000 (03:55 +0000)]
Update TODO list.
Tom Lane [Fri, 21 Jan 2000 01:48:02 +0000 (01:48 +0000)]
Simplify match patterns a little.
Tom Lane [Fri, 21 Jan 2000 01:39:54 +0000 (01:39 +0000)]
Bruce, you forgot to rename these files...
Bruce Momjian [Fri, 21 Jan 2000 00:45:29 +0000 (00:45 +0000)]
Update TODO list.
Bruce Momjian [Thu, 20 Jan 2000 23:00:40 +0000 (23:00 +0000)]
plperl Makefile cleanup. Doesn't work on BSDI yet.
Bruce Momjian [Thu, 20 Jan 2000 22:31:23 +0000 (22:31 +0000)]
Update plperl makefile.
Bruce Momjian [Thu, 20 Jan 2000 22:21:30 +0000 (22:21 +0000)]
Rename 7.0.0 to 7.0 to be consistent with prior release numbering.
Bruce Momjian [Thu, 20 Jan 2000 22:17:39 +0000 (22:17 +0000)]
Update install file for 7.0 to match new SGML version.
Peter Eisentraut [Thu, 20 Jan 2000 21:51:09 +0000 (21:51 +0000)]
Added new pg_id to fix initdb problems
New INSTALL file
Fixed a copyright notice
Bruce Momjian [Thu, 20 Jan 2000 20:01:25 +0000 (20:01 +0000)]
Cleanup vacuum names.
Bruce Momjian [Thu, 20 Jan 2000 15:29:20 +0000 (15:29 +0000)]
Fix typo in \z.
Bruce Momjian [Thu, 20 Jan 2000 15:21:23 +0000 (15:21 +0000)]
I have noticed that the geometry test's output for hppa1 and hppa2 are in
fact the same, so I suggest they could be the same file say
geometry-positive-zeros.out, as the main difference seems to be not printing
eg. (0,-0). In src/test/regress/expected, I propose
rm int2-i386-netbsd.out int4-i386-netbsd.out
mv geometry-hppa1.1.out geometry-positive-zeros.out
rm geometry-hppa2.0.out geometry-i386-netbsd.out
and the following patch to resultmap. I have only tested the netbsd results
on i386, but think that in all probability the differences will be the same
for other ports. If it turns out not to be the case, at least we might find
out.
Patrick Welche
Bruce Momjian [Thu, 20 Jan 2000 15:13:19 +0000 (15:13 +0000)]
Bruce,
Attached is a small fix for a stupid mistake I made in comment.c
- an attempt to drop a non-existent comment would dump core :-(.
Sometimes, I'm as sharp as a marble.
Sorry,
Mike Mascari
Tom Lane [Thu, 20 Jan 2000 05:44:34 +0000 (05:44 +0000)]
Clean up longstanding warnings. I think the remaining
'defined but not used' warnings would go away if the scanner didn't use
YY_REJECT.
Tom Lane [Thu, 20 Jan 2000 05:34:32 +0000 (05:34 +0000)]
Clean up longstanding gcc warnings by adding missing extern
declarations.
Tom Lane [Thu, 20 Jan 2000 05:26:54 +0000 (05:26 +0000)]
Clean up longstanding gcc warnings by adding missing extern
declarations.
Tom Lane [Thu, 20 Jan 2000 05:23:26 +0000 (05:23 +0000)]
ecpg shouldn't depend on parser/gramparse.h. Also, eliminate some
compiler warnings caused by lack of extern declarations in extern.h.
I believe the remaining gcc warnings here would go away if the ecpg
grammar could be tweaked so it doesn't use REJECT ...
Bruce Momjian [Thu, 20 Jan 2000 05:08:58 +0000 (05:08 +0000)]
Well, I finally solved the linking problem
that kept me from making perl secure.
Attached is uuencoded tarball to add PL/perl
to postgresql.
Things I know don't work.
-- triggers
-- SPI
The README file has a _VERY_ short tutorial.
Mark Hollomon
Tom Lane [Thu, 20 Jan 2000 04:11:52 +0000 (04:11 +0000)]
Tweak includes to avoid compiler warning on HPUX.
Tom Lane [Thu, 20 Jan 2000 02:24:50 +0000 (02:24 +0000)]
Assign a typmod of -1 to unadorned CHAR and NUMERIC type specs. This
allows casts without specific length requirements to continue to work
as they did before; that is, x::char will not truncate the value of x,
whereas x::char(1) will. Likewise for NUMERIC precision/scale.
The column length defaults of char(1) and numeric(30,6) are now inserted
in analyze.c's processing of CREATE TABLE.
Tom Lane [Thu, 20 Jan 2000 02:21:44 +0000 (02:21 +0000)]
Fix bugs in NUMERIC ceil() and floor() functions. ceil(0) returned 1,
and both would insert random junk digits if given an input that was an
exact multiple of 10.
Tom Lane [Wed, 19 Jan 2000 23:55:03 +0000 (23:55 +0000)]
Fix handling of NULL constraint conditions: per SQL92 spec, a NULL result
from a constraint condition does not violate the constraint (cf. discussion
on pghackers 12/9/99). Implemented by adding a parameter to ExecQual,
specifying whether to return TRUE or FALSE when the qual result is
really NULL in three-valued boolean logic. Currently, ExecRelCheck is
the only caller that asks for TRUE, but if we find any other places that
have the wrong response to NULL, it'll be easy to fix them.
Bruce Momjian [Wed, 19 Jan 2000 22:23:00 +0000 (22:23 +0000)]
Update vacuum comments.
Bruce Momjian [Wed, 19 Jan 2000 20:10:27 +0000 (20:10 +0000)]
Update pg_dumpall.
Peter Eisentraut [Wed, 19 Jan 2000 20:08:36 +0000 (20:08 +0000)]
another round of user interface cleanups
removed pg_id
fixed a few bugs in the scripts
Bruce Momjian [Wed, 19 Jan 2000 17:27:04 +0000 (17:27 +0000)]
autoconf
Bruce Momjian [Wed, 19 Jan 2000 17:18:12 +0000 (17:18 +0000)]
Fix >& csh-ism
Bruce Momjian [Wed, 19 Jan 2000 14:01:25 +0000 (14:01 +0000)]
The latest source does not compile on Solaris 7 due to
a missing include from a modified file.
Here is a patch to fix it:-
Keith Parks.
Peter Eisentraut [Wed, 19 Jan 2000 02:59:03 +0000 (02:59 +0000)]
Removed MBFLAGS from makefiles since it's now done in include/config.h.
Tatsuo Ishii [Wed, 19 Jan 2000 01:42:12 +0000 (01:42 +0000)]
Revert back Makefile.global
Add check for --with-mb. It is now obsoleted.
Tatsuo Ishii [Wed, 19 Jan 2000 01:33:16 +0000 (01:33 +0000)]
Fix for multibyte support. Since some function declarations
moved to miscadmin.h, we have to include it now.
Peter Eisentraut [Tue, 18 Jan 2000 23:30:24 +0000 (23:30 +0000)]
another set of cleanups
Bruce Momjian [Tue, 18 Jan 2000 19:08:13 +0000 (19:08 +0000)]
Since this patch is not big I send it here instead. I do not have the
complete source checked out so I cannot commit it myself.
Michael
Bruce Momjian [Tue, 18 Jan 2000 19:05:31 +0000 (19:05 +0000)]
Hi!
Here is a patch to bring both libpq and psql to a state where it compiles on
win32 (native) again. A lot of things have changed, and I have not been able
to keep up with them all, so it has been broken for quite a while.
After this patch, at least it compiles. It also talks "basic talk" to the
server, but I have not yet tested all things. Sending queries, and using
e.g. \d or \dt works fine. The rest will have to be tested further.
It also bumps the version on libpq.dll to 7.0.
Everything should be enclosed in #ifdef WIN32, unless I have missed
something. Except for one or maybe two places where I have moved a #include
that should not be used on win32 from the "global area" into a "#ifndef
WIN32 area".
//Magnus
Bruce Momjian [Tue, 18 Jan 2000 18:09:02 +0000 (18:09 +0000)]
Bruce,
Attached is a patch which patches cleanly against the Sunday afternoon
snapshot. It modifies pg_dump to dump COMMENT ON statements for
user-definable descriptions. In addition, it also modifies comment.c so
that the operator behavior is as Peter E. would like: a comment on an
operator is applied to the underlying function.
Thanks,
Mike Mascari
Tatsuo Ishii [Tue, 18 Jan 2000 13:46:10 +0000 (13:46 +0000)]
Fix minor comple error
Tatsuo Ishii [Tue, 18 Jan 2000 13:44:48 +0000 (13:44 +0000)]
Fix minor comping errors
Michael Meskes [Tue, 18 Jan 2000 13:03:49 +0000 (13:03 +0000)]
*** empty log message ***
Tom Lane [Tue, 18 Jan 2000 07:29:58 +0000 (07:29 +0000)]
Fix quoting bugs and incorrect trigger argument printout.
Bruce Momjian [Tue, 18 Jan 2000 06:12:03 +0000 (06:12 +0000)]
This corrects an error in current gram.y for ALTER TABLE ... ADD
CONSTRAINT
Oliver Elphick
Bruce Momjian [Tue, 18 Jan 2000 06:10:54 +0000 (06:10 +0000)]
Freebsd update for sgml, from Alfred Perlstein
Bruce Momjian [Tue, 18 Jan 2000 06:09:24 +0000 (06:09 +0000)]
Libpq non-blocking mode, from Alfred Perlstein
Tatsuo Ishii [Tue, 18 Jan 2000 05:14:24 +0000 (05:14 +0000)]
Remove compiler warnings
Tatsuo Ishii [Tue, 18 Jan 2000 05:11:38 +0000 (05:11 +0000)]
Show encoding name rather than encoding id in case of psql -l.
Tatsuo Ishii [Tue, 18 Jan 2000 05:10:29 +0000 (05:10 +0000)]
Add builtin functions:
pg_char_to_encoding()
pg_encoding_to_char()
Tom Lane [Tue, 18 Jan 2000 03:44:41 +0000 (03:44 +0000)]
numeric_in accepts exponents; numeric to int4 rounds; float4/8 to numeric
is considerably more robust and accurate than it used to be.
Also, get rid of numeric's private allocation freelist, which is no longer
a win since Jan rewrote palloc.