OSDN Git Service
Tom Lane [Thu, 5 Oct 2000 19:11:39 +0000 (19:11 +0000)]
Reimplementation of UNION/INTERSECT/EXCEPT. INTERSECT/EXCEPT now meet the
SQL92 semantics, including support for ALL option. All three can be used
in subqueries and views. DISTINCT and ORDER BY work now in views, too.
This rewrite fixes many problems with cross-datatype UNIONs and INSERT/SELECT
where the SELECT yields different datatypes than the INSERT needs. I did
that by making UNION subqueries and SELECT in INSERT be treated like
subselects-in-FROM, thereby allowing an extra level of targetlist where the
datatype conversions can be inserted safely.
INITDB NEEDED!
Peter Eisentraut [Thu, 5 Oct 2000 16:57:23 +0000 (16:57 +0000)]
Allow overriding HSTYLE and PSTYLE from environment
Bruce Momjian [Thu, 5 Oct 2000 05:14:58 +0000 (05:14 +0000)]
Update FAQ.
Bruce Momjian [Thu, 5 Oct 2000 04:58:24 +0000 (04:58 +0000)]
Update FAQ.
Bruce Momjian [Thu, 5 Oct 2000 04:57:27 +0000 (04:57 +0000)]
Update FAQ.
Bruce Momjian [Thu, 5 Oct 2000 04:52:18 +0000 (04:52 +0000)]
Update FAQ.
Bruce Momjian [Thu, 5 Oct 2000 04:49:12 +0000 (04:49 +0000)]
Update FAQ.
Peter Eisentraut [Wed, 4 Oct 2000 19:25:34 +0000 (19:25 +0000)]
Update soundex to new fmgr interface and fix algorithm
Peter Eisentraut [Wed, 4 Oct 2000 15:47:45 +0000 (15:47 +0000)]
Convert macaddr documentation to DocBook, update outdated information.
Michael Meskes [Wed, 4 Oct 2000 12:39:45 +0000 (12:39 +0000)]
Added patch by Cristof for catching yet another NOTICE.
Michael Meskes [Wed, 4 Oct 2000 10:11:33 +0000 (10:11 +0000)]
removed binary file
CV: ----------------------------------------------------------------------
Vadim B. Mikheev [Wed, 4 Oct 2000 00:04:43 +0000 (00:04 +0000)]
Btree WAL logging.
Peter Eisentraut [Tue, 3 Oct 2000 19:50:21 +0000 (19:50 +0000)]
Better coding of readline tests
Peter Eisentraut [Tue, 3 Oct 2000 19:37:39 +0000 (19:37 +0000)]
Fix to make output format identical on echo -n and echo \c platforms. This
had caused the test counts to be wrong on the latter group.
Peter Eisentraut [Tue, 3 Oct 2000 19:16:17 +0000 (19:16 +0000)]
Treat empty connection parameters as is, in particular to enable overriding
environment variables with "nothing". Empty host parameter indicates
Unix socket.
Peter Eisentraut [Tue, 3 Oct 2000 13:39:24 +0000 (13:39 +0000)]
One check for sys/un.h ought to be enough. Zero checks for sys/shm.h are not.
Bruce Momjian [Tue, 3 Oct 2000 03:39:46 +0000 (03:39 +0000)]
Cleanup of fe-connect ifdef platform problem added with beos.
Bruce Momjian [Tue, 3 Oct 2000 03:20:13 +0000 (03:20 +0000)]
autoconf
Bruce Momjian [Tue, 3 Oct 2000 03:20:00 +0000 (03:20 +0000)]
Update configure.in
Bruce Momjian [Tue, 3 Oct 2000 03:15:44 +0000 (03:15 +0000)]
autoconf
Bruce Momjian [Tue, 3 Oct 2000 03:14:53 +0000 (03:14 +0000)]
Add configure.in change.
Bruce Momjian [Tue, 3 Oct 2000 03:11:26 +0000 (03:11 +0000)]
New diff that now covers the entire tree. Applying this gets postgresql
working on the VERY latest version of BeOS. I'm sure there will be
alot of comments, but then if there weren't I'd be disappointed!
Thanks for your continuing efforts to get this into your tree.
Haven't bothered with the new files as they haven't changed.
BTW Peter, the compiler is "broken" about the bool define and so on.
I'm filing a bug report to try and get it addressed. Hopefully then we
can tidy up the code a bit.
I await the replies with interest :)
David Reid
Peter Eisentraut [Mon, 2 Oct 2000 22:21:21 +0000 (22:21 +0000)]
"installcheck" doesn't need to depend on "all" since we depend on the user
to start up a postmaster anyway.
Peter Eisentraut [Mon, 2 Oct 2000 21:45:33 +0000 (21:45 +0000)]
Mop up from caddr_t -> Datum conversion to make things extra type safe
Peter Eisentraut [Mon, 2 Oct 2000 19:42:56 +0000 (19:42 +0000)]
Banish caddr_t (mostly), use Datum where appropriate.
Bruce Momjian [Mon, 2 Oct 2000 17:36:56 +0000 (17:36 +0000)]
Update TODO list.
Bruce Momjian [Mon, 2 Oct 2000 17:18:50 +0000 (17:18 +0000)]
autoconf
Bruce Momjian [Mon, 2 Oct 2000 17:16:01 +0000 (17:16 +0000)]
Here is the first batch of files and diffs for the BeOS port. I've run into
problems with some bits of it, but when all the patches are in it'll build
and we can fix it from there :) I've got a version that builds and runs and
that is the basis for these patches.
The first file has the new additional files that are required,
template/beos
backend/port/dynloader/beos.c
backend/port/dynloader/beos.h
include/port/beos.h
makefiles/Makefile.beos
The second is a tarball of diffs against a few files. I've added sys/ipc.h
to configure and config.h via configure.in and config.h.in and then started
adding the check as this file isn't needed on BeOS and having loads of
#ifdef BEOS isn't as obvious as #ifdef HAVE_SYS_IPC_H and isn't as
autconf'ish :)
Files touched are
include/c.h
configure.in
include/config.h.in
include/storage/ipc.h
include/utils/int8.h
Let me know how these go. I'll await a response before submitting any more.
Any problems just get in touch.
David Reid
Bruce Momjian [Mon, 2 Oct 2000 16:15:53 +0000 (16:15 +0000)]
In the meaning of bug-fix, the patch is not needed. Because you
have already modified "next_insert()" in 7.0-ecpglib. However
in the meaning of speed-up, the patch will be needed.
--
Regards,
SAKAIDA Masaaki -- Osaka, Japan
Peter Eisentraut [Mon, 2 Oct 2000 11:47:30 +0000 (11:47 +0000)]
Communicate PGPORT and PGHOST via environment, not command line
Tom Lane [Mon, 2 Oct 2000 06:07:25 +0000 (06:07 +0000)]
Honor $(SHELL) when invoking pg_regress.
Tom Lane [Mon, 2 Oct 2000 06:03:25 +0000 (06:03 +0000)]
Fix silly typo that prevented resultmap from being honored by
pg_regress.
Tom Lane [Mon, 2 Oct 2000 04:49:28 +0000 (04:49 +0000)]
Make default ACL be consistent --- ie, starting point for ChangeAcl
is the same as the access permissions granted when a relation's relacl
field is NULL, ie, owner=all rights, world=no rights.
Bruce Momjian [Mon, 2 Oct 2000 03:59:36 +0000 (03:59 +0000)]
autoconf
Bruce Momjian [Mon, 2 Oct 2000 03:58:31 +0000 (03:58 +0000)]
Fix configure types.h
Bruce Momjian [Mon, 2 Oct 2000 03:55:15 +0000 (03:55 +0000)]
Add sys/types include for sockaddr test to configure
Bruce Momjian [Mon, 2 Oct 2000 03:46:24 +0000 (03:46 +0000)]
Add missing python files.
Bruce Momjian [Mon, 2 Oct 2000 03:27:33 +0000 (03:27 +0000)]
Update for PyGreSQL 3.0, from D'Arcy J.M. Cain
Peter Eisentraut [Sun, 1 Oct 2000 22:23:14 +0000 (22:23 +0000)]
Fix quoting bug
Peter Eisentraut [Sun, 1 Oct 2000 21:19:09 +0000 (21:19 +0000)]
Fix test order
Tom Lane [Sat, 30 Sep 2000 18:28:53 +0000 (18:28 +0000)]
Fix nasty TRUNCATE bug reported by Darrin Ladd. RelationTruncateIndexes
would close and then re-open rel being truncated. Depending on the
luck of the draw, the re-opened relcache entry might or might not be
at the same physical location as before. Unfortunately, if it wasn't
then heap_truncate would crash and burn, because it still had a pointer
at the old location. Fix is to open and then close rel in
RelationTruncateIndexes, so that rel's refcount never goes to zero
until heap_truncate is done.
Peter Eisentraut [Sat, 30 Sep 2000 16:58:20 +0000 (16:58 +0000)]
Convert more charset/locale documentation to DocBook
Peter Eisentraut [Sat, 30 Sep 2000 10:45:17 +0000 (10:45 +0000)]
fix shell bug
Bruce Momjian [Sat, 30 Sep 2000 03:04:39 +0000 (03:04 +0000)]
Update FAQ.
Bruce Momjian [Sat, 30 Sep 2000 02:20:53 +0000 (02:20 +0000)]
Update TODO list.
Bruce Momjian [Fri, 29 Sep 2000 22:01:56 +0000 (22:01 +0000)]
autoconf
Bruce Momjian [Fri, 29 Sep 2000 22:00:49 +0000 (22:00 +0000)]
Please apply the following patch to fix problems with the AIX port
and the fmgr redesign.
It makes the homebrewn dl*() functions for more recent Versions of AIX
obsolete
by using the system dl*() functions instead.
It also fixes the expected file for the horology regression test.
Please regenerate configure from configure.in, I don't have the
environment/time.
Andreas
Peter Eisentraut [Fri, 29 Sep 2000 20:21:34 +0000 (20:21 +0000)]
Add `id' attributes to all `chapter' and `sect1' tags, to generate useful
names for the HTML files (e.g., not x4856.htm).
Tom Lane [Fri, 29 Sep 2000 18:21:41 +0000 (18:21 +0000)]
Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.
(Don't forget that an alias is required.) Views reimplemented as expanding
to subselect-in-FROM. Grouping, aggregates, DISTINCT in views actually
work now (he says optimistically). No UNION support in subselects/views
yet, but I have some ideas about that. Rule-related permissions checking
moved out of rewriter and into executor.
INITDB REQUIRED!
Peter Eisentraut [Fri, 29 Sep 2000 17:17:41 +0000 (17:17 +0000)]
New unified regression test driver, test/regress makefile cleanup,
add "check" and "installcheck" targets, straighten out make variable naming
of host_os, host_cpu, etc.
Peter Eisentraut [Fri, 29 Sep 2000 13:53:35 +0000 (13:53 +0000)]
Standardize on __CYGWIN__ rather than __CYGWIN32__ macro. Doesn't matter
either way (although the former is preferred by the Cygwin folks
themselves), but using only one seems nicer.
Peter Eisentraut [Fri, 29 Sep 2000 13:38:02 +0000 (13:38 +0000)]
Enable initdb to create several levels of directories for PGDATA, if
`mkdir -p' works.
Peter Eisentraut [Fri, 29 Sep 2000 13:36:50 +0000 (13:36 +0000)]
Linking with -lc or -lm crashes on Cygwin; filter out those libraries from
the LIBS variable.
Peter Eisentraut [Fri, 29 Sep 2000 13:35:26 +0000 (13:35 +0000)]
Cygwin uses _sys_nerr for sys_nerr
Hiroshi Inoue [Fri, 29 Sep 2000 03:55:45 +0000 (03:55 +0000)]
BufferAlloc() doesn't allocate write error buffers.
Remove compiler waring(my fault).
Hiroshi Inoue [Fri, 29 Sep 2000 01:23:47 +0000 (01:23 +0000)]
avoid database-wide restart on write error
Peter Eisentraut [Thu, 28 Sep 2000 08:53:32 +0000 (08:53 +0000)]
Cygwin doesn't have DST before 1970 either
Peter Eisentraut [Wed, 27 Sep 2000 15:17:57 +0000 (15:17 +0000)]
Fixes for Cygwin, with help from Pete Forman <gsez020@kryten.bedford.waii.com>.
Update the installation instructions (formerly misnamed "FAQ"), add configure
checks for some headers rather than having users copy stubs manually (ugh!).
Use Autoconf check for exe extension. This also avoids inheriting the value
of $(X) from the environment.
Bruce Momjian [Wed, 27 Sep 2000 11:56:16 +0000 (11:56 +0000)]
Change with delimiters to using delimiters in psql manual page.
Peter Eisentraut [Wed, 27 Sep 2000 10:41:55 +0000 (10:41 +0000)]
Reset current user id to session user id during transaction abort
Michael Meskes [Tue, 26 Sep 2000 11:41:45 +0000 (11:41 +0000)]
- Synced preproc.y with gram.y.
- Synced keyword.c.
- Added patch by Christof Petig <christof.petig@wtal.de> to fix NOT
FOUND problem on update/insert/delete.
Tatsuo Ishii [Tue, 26 Sep 2000 05:42:15 +0000 (05:42 +0000)]
Fix compile error in ecpg when enable-multibyte is on. This is due to
illegal call to pg_mbclipen() that is for backend only. However I
have not remove the entire part of the problem, rather mark it with
#ifdef MULTIBYTE_NOTUSED since we should come back with a long range
solution someday.
Peter Eisentraut [Mon, 25 Sep 2000 22:52:49 +0000 (22:52 +0000)]
document configure --without-tk
Peter Eisentraut [Mon, 25 Sep 2000 22:34:20 +0000 (22:34 +0000)]
When the RI triggers lock the PK table, temporarily switch the current user
id to the owner of the PK table, to avoid permission problems.
Peter Eisentraut [Mon, 25 Sep 2000 22:23:01 +0000 (22:23 +0000)]
Revise Tcl/Tk configuration. Make missing Tcl after --with-tcl an error,
add --without-tk option to disable Tk. We don't need the AC_PATH_XTRA
test because tkConfig.sh already contains all the information about how to
compile and link with X. Also make sure that libpq is up to date for
libpgtcl. Remove executable bits from pgaccess.sh, but add it to pgaccess.
Tom Lane [Mon, 25 Sep 2000 18:38:39 +0000 (18:38 +0000)]
Correct error in grammar for subselect-in-FROM: SQL spec does not allow
omission of alias_clause for a subselect.
Tom Lane [Mon, 25 Sep 2000 18:14:55 +0000 (18:14 +0000)]
Use variable aliases, if supplied, rather than real column names in
complaints about ungrouped variables. This is for consistency with
behavior elsewhere, notably the fact that the relname is reported as
an alias in these same complaints. Also, it'll work with subselect-
in-FROM where old code didn't.
Tom Lane [Mon, 25 Sep 2000 18:09:28 +0000 (18:09 +0000)]
System neglected to complain about ungrouped variables passed to
sublinks when outer query contained aggregates but no GROUP clause.
Tom Lane [Mon, 25 Sep 2000 16:36:36 +0000 (16:36 +0000)]
Karel missed an ichar->chr ...
Bruce Momjian [Mon, 25 Sep 2000 14:40:27 +0000 (14:40 +0000)]
Change // to /*.
Bruce Momjian [Mon, 25 Sep 2000 12:58:47 +0000 (12:58 +0000)]
the patch include:
- rename ichar() to chr() (discussed with Tom)
- add docs for oracle compatible routines:
btrim()
ascii()
chr()
repeat()
- fix bug with timezone in to_char()
- all to_char() variants return NULL instead textin("")
if it's needful.
The contrib/odbc is without changes and contains same routines as main
tree ... because I not sure how plans are Thomas with this :-)
Karel
---------------------------------------------------------------------------
This effectively one line patch should fix the fact that
foreign key definitions in create table were erroring if
a primary key was defined. I was using the columns
list to get the columns of the table for comparison, but
it got reused as a temporary list inside the primary key
stuff.
Stephan Szabo
Bruce Momjian [Mon, 25 Sep 2000 12:43:24 +0000 (12:43 +0000)]
disable plperl again.
Tom Lane [Mon, 25 Sep 2000 04:11:09 +0000 (04:11 +0000)]
Acquire read lock on a buffer while writing it out, to prevent
concurrent modifications to the page by other backends.
Tom Lane [Sun, 24 Sep 2000 04:07:11 +0000 (04:07 +0000)]
Tweak resultmap so that geometry regress test selects the right comparison
file on LinuxPPC, which is identified by config.guess as
powerpc-unknown-linux-gnu (not ...-gnulibc1).
Tom Lane [Sat, 23 Sep 2000 22:40:12 +0000 (22:40 +0000)]
Clean up some ugly coding (hardwired constants) in index_formtuple.
Peter Eisentraut [Sat, 23 Sep 2000 00:42:36 +0000 (00:42 +0000)]
These are obsolete.
Peter Eisentraut [Fri, 22 Sep 2000 23:02:00 +0000 (23:02 +0000)]
Don't free() the result of getpwuid().
Discovered by Jason Tishler <Jason.Tishler@dothill.com>.
Tom Lane [Fri, 22 Sep 2000 15:34:31 +0000 (15:34 +0000)]
SetPGVariable() crashed on SET DateStyle TO DEFAULT and related cases.
Tom Lane [Fri, 22 Sep 2000 15:33:31 +0000 (15:33 +0000)]
Add check of 'SET DateStyle TO DEFAULT'.
Peter Eisentraut [Thu, 21 Sep 2000 20:17:43 +0000 (20:17 +0000)]
Replace brain-dead Autoconf macros AC_ARG_{ENABLE,WITH} with something
that's actually useful, robust, consistent.
Better plan to generate aclocal.m4 as well: use m4 include directives,
rather than cat.
Michael Meskes [Thu, 21 Sep 2000 11:56:08 +0000 (11:56 +0000)]
*** empty log message ***
Tom Lane [Wed, 20 Sep 2000 15:28:01 +0000 (15:28 +0000)]
Fix coredump in copyCommentStmt().
Michael Meskes [Wed, 20 Sep 2000 13:25:52 +0000 (13:25 +0000)]
*** empty log message ***
Tom Lane [Tue, 19 Sep 2000 19:30:03 +0000 (19:30 +0000)]
Make sure that FlushRelationBuffers() is invoked by all paths through
vacuum.c. This is needed to make the world safe for pg_upgrade.
Tom Lane [Tue, 19 Sep 2000 18:42:34 +0000 (18:42 +0000)]
Fix GEQO optimizer to work correctly with new outer-join-capable
query representation. Note that GEQO_RELS setting is now interpreted
as the number of top-level items in the FROM list, not necessarily the
number of relations in the query. This seems appropriate since we are
only doing join-path searching over the top-level items.
Peter Eisentraut [Tue, 19 Sep 2000 18:18:04 +0000 (18:18 +0000)]
Implement differentiation between CURRENT_USER and SESSION_USER as per SQL.
There is still no effective difference but it will kick in once setuid
functions exist (not included here). Make old getpgusername() alias for
current_user.
Michael Meskes [Tue, 19 Sep 2000 11:47:16 +0000 (11:47 +0000)]
*** empty log message ***
Tom Lane [Mon, 18 Sep 2000 20:14:23 +0000 (20:14 +0000)]
Make rule lister use aliases from FROM clause when a table column has
been given an alias. Otherwise, results are incorrect.
Peter Eisentraut [Mon, 18 Sep 2000 20:11:37 +0000 (20:11 +0000)]
Move contrib/odbc/odbc.sql together with odbc driver, remove old files;
revise ODBC "installation instructions"; update some other outdated
documentation; update contrib documentation
Philip Warner [Mon, 18 Sep 2000 06:47:46 +0000 (06:47 +0000)]
Only retrieve view definition if relation is a view (case statement)
Philip Warner [Mon, 18 Sep 2000 03:24:03 +0000 (03:24 +0000)]
Uses column select expressions to get object object owners and tests for blank names
Tom Lane [Sun, 17 Sep 2000 22:21:27 +0000 (22:21 +0000)]
Parse JOIN/ON conditions with the proper visibility of input columns,
ie, consider only the columns coming from the JOIN clause's sub-clauses.
Also detect attempts to reference columns belonging to other tables
(which would still be possible using an explicitly-qualified name).
I'm not sure this implements the spec's semantics 100% accurately, but
at least it gives plausible behavior.
Peter Eisentraut [Sun, 17 Sep 2000 20:35:27 +0000 (20:35 +0000)]
Add a blurb about what tools are required to build.
Peter Eisentraut [Sun, 17 Sep 2000 20:33:45 +0000 (20:33 +0000)]
psql forgot to close connection before re-issuing password prompt.
([BUGS] psql can crash the backend on login, 2000-09-03)
Tom Lane [Sun, 17 Sep 2000 20:01:28 +0000 (20:01 +0000)]
Improve error message for dumpRules() failure
Peter Eisentraut [Sun, 17 Sep 2000 13:02:52 +0000 (13:02 +0000)]
Support for DESTDIR make variable. This is used as in `make install
DESTDIR=/else/where' and prepends the value of DESTDIR to the full
installation paths (e.g., /else/where/usr/local/pgsql/bin). This allows
users to install the package into a location different from the one that
was configured and hard-coded into various scripts, e.g., for creating
binary packages.
DESTDIR is in many cases preferrable over `make install
prefix=/else/where' because
a) `prefix' affects the path that is hard-coded into the files, which can
lead to a `make install prefix=xxx' (as done by the regression test
driver) corrupting the files in the source tree with wrong paths.
b) it doesn't work at all if a directory was overridden to not depend on
`prefix', e.g., --sysconfdir=/etc.
(Updating the regression test driver to use DESTDIR is a separate
undertaking.)
See also autoconf@gnu.org, From: Akim Demaille <akim@epita.fr>, Date: 08
Sep 2000 12:48:59 +0200, Message-ID:
<mv4em2vb1lw.fsf@nostromo.lrde.epita.fr>, Subject: Re: HTML format
documentation.
Tom Lane [Fri, 15 Sep 2000 20:20:11 +0000 (20:20 +0000)]
Add ILIKE operators ~~*, !~~* to documentation.
Tom Lane [Fri, 15 Sep 2000 19:37:49 +0000 (19:37 +0000)]
Variant horology resultfiles are inconsistent with the test, again.
Tom Lane [Fri, 15 Sep 2000 18:45:31 +0000 (18:45 +0000)]
Reimplement LIKE/ESCAPE as operators so that indexscan optimization
can still work, per recent discussion on pghackers. Correct some bugs
in ILIKE implementation.
Tatsuo Ishii [Fri, 15 Sep 2000 11:59:40 +0000 (11:59 +0000)]
Allow PL/pgSQL accept non ascii identifiers