OSDN Git Service
Bruce Momjian [Thu, 11 Nov 2004 03:59:14 +0000 (03:59 +0000)]
Cleaups:
< * Allow GRANT/REVOKE permissions to be given to all schema objects with one
> * Allow GRANT/REVOKE permissions to be applied to all schema objects with one
60c60
< specifications. This is because new databases are created by copying
> specifications. This is because new databases are created by copying
63c63
< directory would create a new database with tables that had incorrect
> directory would create a new database with tables that had incorrect
72c72
<
>
85c85
< By not showing commented-out variables, we discourage people from
> By not showing commented-out variables, we discourage people from
91c91
< * Allow point-in-time recovery to archive partially filled write-ahead
> * Allow point-in-time recovery to archive partially filled write-ahead
102c102
< Currently all schemas are owned by the super-user because they are
> Currently all schemas are owned by the super-user because they are
128c128
< * Allow INET subnet tests with non-constants to be indexed
> * Allow INET subnet tests using non-constants to be indexed
143,
144c143,144
< * Allow to_char to print localized month names
< * Allow functions to have a search path specified at creation time
> * Allow to_char() to print localized month names
> * Allow functions to have a schema search path specified at creation time
146c146
< * Add GUC variable to allow output of interval values in ISO8601 format
> * Add a GUC variable to allow output of interval values in ISO8601 format
154,
155c154,155
< * Prevent inet cast to cidr if the unmasked bits are not zero, or
< zero bits
> * Prevent INET cast to CIDR if the unmasked bits are not zero, or
> zero the bits
158c158
< o Allow nulls in arrays
> o Allow NULLs in arrays
160,
161c160,161
< o Delay resolution of array expression type so assignment coercion
< can be performed on empty array expressions
> o Delay resolution of array expression's data type so assignment
> coercion can be performed on empty array expressions
218,
219c218,219
< key, foreign key [inheritance]
< * UNIQUE INDEX on base column not honored on inserts/updates from
> key, foreign key
> * UNIQUE INDEX on base column not honored on INSERTs/UPDATEs from
221c221
< (dup) should fail [inheritance]
> (dup) should fail
246c246
< * Fetch heap pages matching index entries in sequential order [performance]
> * Fetch heap pages matching index entries in sequential order
307c307
< functionality in DELETE. It's been agreed that the keyword should
> functionality in DELETE. It's been agreed that the keyword should
318c318
< * Allow PREPARE to automatically determine parameter types based on the SQL
> * Allow PREPARE to automatically determine parameter types based on the SQL
340,
342d339
< * Allow CREATE TABLE foo (f1 INT CHECK (f1 > 0) CHECK (f1 < 10)) to work
< by searching for non-conflicting constraint names, and prefix with
< table name?
347c344
< new database.
> a new database.
350,
351d346
< * Ignore temporary tables from other sessions when processing
< inheritance?
354,
355c349,351
< * Add a session mode to warn about non-standard SQL usage in queries
< * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules, triggers?)
> * Add a GUC variable to warn about non-standard SQL usage in queries
> * Add MERGE command that does UPDATE/DELETE, or on failure, INSERT (rules,
> triggers?)
357,
359c353,356
< * Add NOVICE output level for helpful messages like automatic sequence/index creation
< * Add COMMENT ON for all cluster global objects (users, groups,
< databases and tablespaces)
> * Add NOVICE output level for helpful messages like automatic sequence/index
> creation
> * Add COMMENT ON for all cluster global objects (users, groups, databases
> and tablespaces)
363c360
< When enabled, this would allow errors in multi-statement transactions
> When enabled, this would allow errors in multi-statement transactions
417c414
< o Allow COPY to optionally include column headings as the first line
> o Allow COPY to optionally include column headings in the first line
450c447
<
>
462c459
< o Handle references to temporary tables that are created, destroyed,
> o Handle references to temporary tables that are created, destroyed,
464c461
<
>
469d465
< o Improve PL/PgSQL exception handling using savepoints
488c484
<
>
503d498
<
518c513
< o Add pg_dumpall custom format dumps.
> o Add pg_dumpall custom format dumps.
520c515
< This is probably best done by combining pg_dump and pg_dumpall
> This is probably best done by combining pg_dump and pg_dumpall
532d526
< o Improve error handling (?)
555c549
< Adding shared locks requires recording the table/rows numbers in a
> Adding shared locks requires recording the table/rows numbers in a
643c637
< Posix_fadvise() can control both sequential/random file caching and
> Posix_fadvise() can control both sequential/random file caching and
703c697
< from distributted.net, http://www1.distributed.net/source,
> from distributted.net, http://www1.distributed.net/source,
729c723
< * Add connection pooling [pool]
> * Add connection pooling
755d748
<
759c752
<
>
768c761
< so an abrupt operating system restart might lose a few seconds of
> so an abrupt operating system restart might lose a few seconds of
785c778
< * Add utility to compute accurate random_page_cost value
> * Create utility to compute accurate random_page_cost value
787,
789d779
< * Allow sorting, temp files, temp tables to use multiple work directories
<
< This allows the I/O load to be spread across multiple disk drives.
795a786
>
808,
809c799,800
<
< * Use mmap() rather than SYSV shared memory or to write WAL files (?) [mmap]
>
> * Use mmap() rather than SYSV shared memory or to write WAL files (?)
812,
813c803,804
< portability issues. Anonymous mmap (or mmap to /dev/zero) is required
< to prevent I/O overhead.
> portability issues. Anonymous mmap (or mmap to /dev/zero) is required
> to prevent I/O overhead.
817,
819c808,810
< Doing I/O to large tables would consume a lot of address space or
< require frequent mapping/unmapping. Extending the file also causes
< mapping problems that might require mapping only individual pages,
> Doing I/O to large tables would consume a lot of address space or
> require frequent mapping/unmapping. Extending the file also causes
> mapping problems that might require mapping only individual pages,
821c812
< way to _prevent_ I/O to disk from the dirty shared buffers so changes
> way to _prevent_ I/O to disk from the dirty shared buffers so changes
826c817
< tuple overhead
> per-tuple overhead
829,
831c820,822
< This would involve using multiple threads or processes to do optimization,
< sorting, or execution of single query. The major advantage of such a
< feature would be to allow multiple CPUs to work together to process a
> This would involve using multiple threads or processes to do optimization,
> sorting, or execution of single query. The major advantage of such a
> feature would be to allow multiple CPUs to work together to process a
834c825
< * Research the use of larger pages sizes
> * Research the use of larger page sizes
842a834
> * Move some /contrib modules out to their own project sites
845d836
< * Improve access-permissions check on data directory in Cygwin (Tom)
847,
848c838
< * Clarify use of 'application' and 'command' tags in SGML docs
< * Better document ability to build only certain interfaces (Marc)
> * Improve documentation to build only interfaces (Marc)
852,
853d841
< * Research interaction of setitimer() and sleep() used by statement_timeout
< * Rename /scripts directory because they are all C programs now
856,
857d843
< * Allow binaries to be statically linked so they are more easily relocated
< * Move some /contrib modules out to their own project sites
862c848
< o Remove per-backend parameter file and move into shared memory?
> o Remove per-backend parameter file and move into shared memory
877,
878c863,864
< o Update clients to use data types, typmod, schema.table.column names of
< result sets using new query protocol
> o Update clients to use data types, typmod, schema.table.column names
> of result sets using new query protocol
900d885
< * Kris is Kris Jurka
910c895
< * Simon is Simon Riggs
> * Simon is Simon Riggs <simon@2ndquadrant.com>
913d897
< * Teodor is
Neil Conway [Thu, 11 Nov 2004 00:32:50 +0000 (00:32 +0000)]
Remove obsolete comment from btbuild() and hashbuild(): we no longer use
a global variable to control building indexes.
Peter Eisentraut [Wed, 10 Nov 2004 23:01:47 +0000 (23:01 +0000)]
Add character set declaration to HTML files, so they have a chance to
validate and display correctly.
Peter Eisentraut [Wed, 10 Nov 2004 21:54:23 +0000 (21:54 +0000)]
Fix some spacing problems.
Bruce Momjian [Wed, 10 Nov 2004 21:43:50 +0000 (21:43 +0000)]
Add SGML markup to 8.0 release notes.
Michael Meskes [Wed, 10 Nov 2004 13:48:10 +0000 (13:48 +0000)]
List VALUE as a keyword.
Bruce Momjian [Wed, 10 Nov 2004 06:13:12 +0000 (06:13 +0000)]
Fix sgml markup tags.
Bruce Momjian [Wed, 10 Nov 2004 06:09:59 +0000 (06:09 +0000)]
Update release notes to match CVS.
Bruce Momjian [Wed, 10 Nov 2004 05:47:07 +0000 (05:47 +0000)]
Done:
<
< * psql tab completion
<
< o Provide a list of conversions after ALTER CONVERSION?
< o Support for ALTER SEQUENCE clauses
< o Add RENAME TO to ALTER TRIGGER
< o Support for ALTER USER
< o Fix ALTER (GROUP|DOMAIN|...) <sth> DROP
< o Support for ALTER LANGUAGE <sth> RENAME TO
< o Improve support for COPY
< o Improve support for ALTER TABLE
Bruce Momjian [Wed, 10 Nov 2004 02:48:59 +0000 (02:48 +0000)]
Remove performance TODO.detail. In TODO.
Bruce Momjian [Wed, 10 Nov 2004 02:48:41 +0000 (02:48 +0000)]
Add bitmap info:
< heap page to find matching rows.
> heap page to find matching rows, or perhaps use a mixed solution where
> tids are recorded for pages with only a few matches and per-page bitmaps
> are used for more dense pages. Another idea is to use a 32-bit bitmap
> for every page and set a bit based on the item number mod(32).
Tom Lane [Tue, 9 Nov 2004 21:42:53 +0000 (21:42 +0000)]
Allow planner to fold "stable" functions to constants when forming
selectivity estimates, per recent discussion.
Tom Lane [Tue, 9 Nov 2004 21:30:18 +0000 (21:30 +0000)]
Put in place some defenses against being fooled by accidental match of
shared memory segment ID. If we can't access the existing shmem segment,
it must not be relevant to our data directory. If we can access it,
then attach to it and check for an actual match to the data directory.
This should avoid some cases of failure-to-restart-after-boot without
introducing any significant risk of failing to detect a still-running
old backend.
Bruce Momjian [Tue, 9 Nov 2004 16:50:59 +0000 (16:50 +0000)]
Add:
>
> * Research the use of larger pages sizes
Peter Eisentraut [Tue, 9 Nov 2004 15:57:57 +0000 (15:57 +0000)]
Get rid of perror(), substitute some better phrased error messages.
malloc() doesn't set errno, so most uses were buggy anyway.
Bruce Momjian [Tue, 9 Nov 2004 15:11:11 +0000 (15:11 +0000)]
Update bitmap index description:
< Such indexes could be more compact if there are only a few unique values.
> Such indexes could be more compact if there are only a few distinct values.
> Such indexes can also be compressed. Keeping such indexes updated can be
> costly.
Peter Eisentraut [Tue, 9 Nov 2004 14:46:37 +0000 (14:46 +0000)]
Translation updates
Peter Eisentraut [Tue, 9 Nov 2004 14:39:44 +0000 (14:39 +0000)]
Clarify some strings
Peter Eisentraut [Tue, 9 Nov 2004 14:38:48 +0000 (14:38 +0000)]
Translation update
Peter Eisentraut [Tue, 9 Nov 2004 13:01:27 +0000 (13:01 +0000)]
Clarify some error messages
Peter Eisentraut [Tue, 9 Nov 2004 13:00:05 +0000 (13:00 +0000)]
Translation update
Neil Conway [Tue, 9 Nov 2004 06:23:50 +0000 (06:23 +0000)]
Delete the `remove-old-headers' target, as it is no longer useful. Patch
from Alvaro Herrera.
Neil Conway [Tue, 9 Nov 2004 06:09:40 +0000 (06:09 +0000)]
This patch makes some cleanups to contrib/ to silence some sparse
warnings:
- remove pointless "extern" keyword from some function definitions in
contrib/tsearch2
- use "NULL" not "0" as NULL pointer in contrib/tsearch,
contrib/tsearch2, contrib/pgbench, and contrib/vacuumlo
Bruce Momjian [Tue, 9 Nov 2004 04:14:07 +0000 (04:14 +0000)]
Fix typo:
< Such indexes could be more compact if there are few unique value.
> Such indexes could be more compact if there are only a few unique values.
Bruce Momjian [Tue, 9 Nov 2004 03:57:42 +0000 (03:57 +0000)]
Update mmap details:
< portability issues. Anonymous mmap is required to prevent I/O
< overhead.
> portability issues. Anonymous mmap (or mmap to /dev/zero) is required
> to prevent I/O overhead.
>
> * Consider mmap()'ing files into a backend?
>
> Doing I/O to large tables would consume a lot of address space or
> require frequent mapping/unmapping. Extending the file also causes
> mapping problems that might require mapping only individual pages,
> leading to thousands of mappings. Another problem is that there is no
> way to _prevent_ I/O to disk from the dirty shared buffers so changes
> could hit disk before WAL is written.
Bruce Momjian [Tue, 9 Nov 2004 03:57:16 +0000 (03:57 +0000)]
Remove mmap TODO.detail, now in TODO.
Bruce Momjian [Tue, 9 Nov 2004 03:01:48 +0000 (03:01 +0000)]
Remove inheritance, already in TODO.
Tom Lane [Tue, 9 Nov 2004 00:34:46 +0000 (00:34 +0000)]
Use a hopefully-more-reliable method of detecting default selectivity
estimates when combining the estimates for a range query. As pointed out
by Miquel van Smoorenburg, the existing check for an impossible combined
result would quite possibly fail to detect one default and one non-default
input. It seems better to use the default range query estimate in such
cases. To do so, add a check for an estimate of exactly DEFAULT_INEQ_SEL.
This is a bit ugly because it introduces additional coupling between
clauselist_selectivity and scalarltsel/scalargtsel, but it's not like
there wasn't plenty already...
Bruce Momjian [Mon, 8 Nov 2004 20:16:43 +0000 (20:16 +0000)]
Remove fadvise TODO.detail. Merged into TODO.
Bruce Momjian [Mon, 8 Nov 2004 20:16:20 +0000 (20:16 +0000)]
Update:
< posix_fadvise() [fadvise]
> posix_fadvise()
>
> Posix_fadvise() can control both sequential/random file caching and
> free-behind behavior, but it is unclear how the setting affects other
> backends that also have the file open, and the feature is not supported
> on all operating systems.
>
Tom Lane [Mon, 8 Nov 2004 18:01:28 +0000 (18:01 +0000)]
Recommend that archive_command be coded to not overwrite existing files.
Add explicit documentation of the recovery configuration settings. Other
minor improvements in the PITR docs. Simon Riggs, some editorialization
by Tom Lane.
Bruce Momjian [Mon, 8 Nov 2004 16:34:23 +0000 (16:34 +0000)]
Update workding on why we use is_absolute_path() as a macro.
Peter Eisentraut [Mon, 8 Nov 2004 15:57:05 +0000 (15:57 +0000)]
Use correct function name in example
Bruce Momjian [Mon, 8 Nov 2004 15:35:52 +0000 (15:35 +0000)]
Remove count TODO.detail now that info is in TODO.
Bruce Momjian [Mon, 8 Nov 2004 15:32:40 +0000 (15:32 +0000)]
Remove count TODO.detail.
Bruce Momjian [Mon, 8 Nov 2004 15:19:31 +0000 (15:19 +0000)]
Remove atttypmod TODO.detail and merge into TODO list.
Bruce Momjian [Mon, 8 Nov 2004 15:18:16 +0000 (15:18 +0000)]
Update item description:
< * CREATE TABLE AS can not determine column lengths from expressions [atttypmod]
> * Allow CREATE TABLE AS to determine column lengths for complex
> expressions like SELECT col1 || col2
Bruce Momjian [Mon, 8 Nov 2004 14:55:05 +0000 (14:55 +0000)]
Remove view TODO.detail.
Bruce Momjian [Mon, 8 Nov 2004 14:54:00 +0000 (14:54 +0000)]
Update view info:
< * Automatically create rules on views so they are updateable, per SQL99 [view]
> * Automatically create rules on views so they are updateable, per SQL99
>
> We can only auto-create rules for simple views. For more complex
> cases users will still have to write rules.
>
Bruce Momjian [Mon, 8 Nov 2004 14:46:52 +0000 (14:46 +0000)]
Remove win32 TODO.detail.
Bruce Momjian [Mon, 8 Nov 2004 05:23:26 +0000 (05:23 +0000)]
Allow win32/cygwin link against the first matching library symbol rather
than erroring out. This is the Unix behavior.
Tom Lane [Mon, 8 Nov 2004 04:02:20 +0000 (04:02 +0000)]
Kris Jurka pointed out that the qualified_name production wasn't
working as intended --- for some reason, FROM a.b.c was getting
parsed as if it were a function name and not a qualified name.
I think there must be a bug in bison, because it should have
complained that the grammar was ambiguous. Anyway, fix it along
the same lines previously used for func_name vs columnref, and get
rid of the right-recursion in attrs that seems to have confused
bison.
Tom Lane [Mon, 8 Nov 2004 01:54:40 +0000 (01:54 +0000)]
Fix unportable code in SockAddr_cidr_mask: you can't assume that
shifting left by full word width gives zero. Per bug report from
Tyson Thomson.
Peter Eisentraut [Sun, 7 Nov 2004 23:38:19 +0000 (23:38 +0000)]
New translation
Peter Eisentraut [Sun, 7 Nov 2004 23:29:35 +0000 (23:29 +0000)]
Translation update
Peter Eisentraut [Sun, 7 Nov 2004 23:28:20 +0000 (23:28 +0000)]
Translation updates
Bruce Momjian [Sun, 7 Nov 2004 02:12:17 +0000 (02:12 +0000)]
Removes duplicate slashes from the path in canonicalize_path(). It
preserve double leading slashes on Win32.
e.g. ////a////b => /a/b
Tom Lane [Sat, 6 Nov 2004 23:06:29 +0000 (23:06 +0000)]
Add code to find_my_exec() to resolve a symbolic link down to the
actual executable location. This allows people to continue to use
setups where, eg, postmaster is symlinked from a convenient place.
Per gripe from Josh Berkus.
Tom Lane [Sat, 6 Nov 2004 21:39:45 +0000 (21:39 +0000)]
Simplify relative-path logic, on the assumption that compiled-in paths
won't have trivial differences in their common prefix.
Tom Lane [Sat, 6 Nov 2004 19:36:02 +0000 (19:36 +0000)]
Update pg_dump to use SET DEFAULT_TABLESPACE instead of explicit
tablespace clauses; this should improve compatibility of dump files.
Philip Warner, some rework by Tom Lane.
Bruce Momjian [Sat, 6 Nov 2004 17:56:40 +0000 (17:56 +0000)]
Remove directory from cmd.exe default shell.
Tom Lane [Sat, 6 Nov 2004 17:46:38 +0000 (17:46 +0000)]
When implementing a coercion to a domain type with a combined
type-and-length coercion function, make sure that the coercion function
is told the correct typmod. Fixes Kris Jurka's example of a domain
over bit(N).
Peter Eisentraut [Sat, 6 Nov 2004 14:32:10 +0000 (14:32 +0000)]
Reduce formatting entropy
Bruce Momjian [Sat, 6 Nov 2004 05:38:19 +0000 (05:38 +0000)]
Remove:
* Allow database recovery where tablespaces can't be created
When a pg_dump is restored, all tablespaces will attempt to be created
in their original locations. If this fails, the user must be able to
adjust the restore process.
Bruce Momjian [Sat, 6 Nov 2004 05:32:05 +0000 (05:32 +0000)]
Now that we advertize only CIDR address in pg_hba.conf, remove
duplicates sample entries from comments.
Bruce Momjian [Sat, 6 Nov 2004 05:20:41 +0000 (05:20 +0000)]
Variable initializer no longer necessary.
Bruce Momjian [Sat, 6 Nov 2004 04:29:40 +0000 (04:29 +0000)]
Tests for COMSPEC in the right place and supply a reasonable shell
default on Win32.
Tom Lane [Sat, 6 Nov 2004 04:24:14 +0000 (04:24 +0000)]
Fix sizeof(EXE) arithmetic, per Andrew Dunstan.
Bruce Momjian [Sat, 6 Nov 2004 03:25:20 +0000 (03:25 +0000)]
*** empty log message ***
Bruce Momjian [Sat, 6 Nov 2004 03:24:21 +0000 (03:24 +0000)]
Update "dash" to "hyphen".
Tom Lane [Sat, 6 Nov 2004 01:16:22 +0000 (01:16 +0000)]
Code cleanup in path.c and exec.c. Handle Windows drive and network specs
everywhere not just some places, get rid of . and .. when joining path
sections together. This should eliminate most of the ugly paths like
/foo/bar/./baz that we've been generating.
Tom Lane [Fri, 5 Nov 2004 20:45:10 +0000 (20:45 +0000)]
pred_test() logic was being too narrow-minded about where it might find
RestrictInfo nodes in the query expression. Per example from James Robinson.
Tom Lane [Fri, 5 Nov 2004 19:17:13 +0000 (19:17 +0000)]
Create 'default_tablespace' GUC variable that supplies a TABLESPACE
clause implicitly whenever one is not given explicitly. Remove concept
of a schema having an associated tablespace, and simplify the rules for
selecting a default tablespace for a table or index. It's now just
(a) explicit TABLESPACE clause; (b) default_tablespace if that's not an
empty string; (c) database's default. This will allow pg_dump to use
SET commands instead of tablespace clauses to determine object locations
(but I didn't actually make it do so). All per recent discussions.
Peter Eisentraut [Fri, 5 Nov 2004 17:11:34 +0000 (17:11 +0000)]
Small message clarifications
Peter Eisentraut [Fri, 5 Nov 2004 17:08:11 +0000 (17:08 +0000)]
Translation update
Bruce Momjian [Fri, 5 Nov 2004 03:11:54 +0000 (03:11 +0000)]
Fix typo:
< one column or expression indexes, perhaps using per=index statistics
> one column or expression indexes, perhaps using per-index statistics
Bruce Momjian [Fri, 5 Nov 2004 03:04:36 +0000 (03:04 +0000)]
Add items:
< * Add transaction_timestamp(), statement_timestamp(), clock_timestamp() functionality
> * Add transaction_timestamp(), statement_timestamp(), clock_timestamp()
> functionality
278c279
< one column
> one column or expression indexes, perhaps using per=index statistics
846a848
> * Remove kerberos4 from source tree?
Bruce Momjian [Thu, 4 Nov 2004 22:25:14 +0000 (22:25 +0000)]
Fix psql \e and \! for Win32.
Tom Lane [Thu, 4 Nov 2004 19:08:42 +0000 (19:08 +0000)]
Minor documentation updates from Simon Riggs.
Bruce Momjian [Thu, 4 Nov 2004 17:09:54 +0000 (17:09 +0000)]
Add:
>
> * Add fillfactor to control reserved free space during index creation
Bruce Momjian [Thu, 4 Nov 2004 16:53:58 +0000 (16:53 +0000)]
Add:
> * Allow accurate statistics to be collected on indexes with more than
> one column
Bruce Momjian [Thu, 4 Nov 2004 16:49:53 +0000 (16:49 +0000)]
Updates from Simon Riggs:
< that can spam more than one table.
> that can span more than one table.
239c239
< rather than just col1
> rather than just col1; also called skip-scanning.
641c641,642
< * Add free-behind capability for large sequential scans [fadvise]
> * Allow free-behind capability for large sequential scans, perhaps using
> posix_fadvise() [fadvise]
Bruce Momjian [Thu, 4 Nov 2004 16:19:46 +0000 (16:19 +0000)]
Update bitmap index entries:
< * Allow the creation of bitmap indexes which can be quickly combined
< with other bitmap indexes
> * Allow non-bitmap indexes to be combined by creating bitmaps in memory
259,
261c258,259
< combined. Such indexes could be more compact if there are few unique
< value. Also, perhaps they can be lossy requiring a scan of the heap page
< to find matching rows.
> combined. They can index by tid or can be lossy requiring a scan of the
> heap page to find matching rows.
263c261,262
< * Allow non-bitmap indexes to be combined
> * Allow the creation of on-disk bitmap indexes which can be quickly
> combined with other bitmap indexes
265,
266c264
< Do lookups on non-bitmap indexes and create bitmaps in memory that can be
< combined with other indexes.
> Such indexes could be more compact if there are few unique value.
Neil Conway [Thu, 4 Nov 2004 09:12:35 +0000 (09:12 +0000)]
Fix build break, per report from Kris Jurka. Rename README to README.mysql,
for consistency.
Neil Conway [Thu, 4 Nov 2004 06:09:26 +0000 (06:09 +0000)]
Contrib build fixes:
- add some additional files to the dbmirror install (approved by
ssinger)
- add a makefile for contrib/mysql, and add mysql to the list of
contribs build by default
- use xml2-config to pickup -I flags for libxml2 in contrib/xml and
contrib/xml2
Original work from Martin Pitt of Debian, minor cleanups by Neil
Conway.
Bruce Momjian [Thu, 4 Nov 2004 03:57:58 +0000 (03:57 +0000)]
Update:
< * Use bitmaps to combine existing indexes [performance]
> * Allow the creation of bitmap indexes which can be quickly combined
> with other bitmap indexes
255,
257c256,266
< Bitmap indexes allow single indexed columns to be combined to
< dynamically create a composite index to match a specific query. Each
< index is a bitmap, and the bitmaps are AND'ed or OR'ed to be combined.
> Bitmap indexes index single columns that can be combined with other bitmap
> indexes to dynamically create a composite index to match a specific query.
> Each index is a bitmap, and the bitmaps are bitwise AND'ed or OR'ed to be
> combined. Such indexes could be more compact if there are few unique
> value. Also, perhaps they can be lossy requiring a scan of the heap page
> to find matching rows.
>
> * Allow non-bitmap indexes to be combined
>
> Do lookups on non-bitmap indexes and create bitmaps in memory that can be
> combined with other indexes.
Bruce Momjian [Thu, 4 Nov 2004 02:04:10 +0000 (02:04 +0000)]
Honor TMPDIR.
Add the script name to the tmp directory name.
Move trap up now that the dir is more unique.
Bruce Momjian [Wed, 3 Nov 2004 23:06:52 +0000 (23:06 +0000)]
Move trap to after the directory is created.
Bruce Momjian [Wed, 3 Nov 2004 22:46:15 +0000 (22:46 +0000)]
Create temporary files securely.
Bruce Momjian [Wed, 3 Nov 2004 22:20:52 +0000 (22:20 +0000)]
Update tablespace temp usage item:
< This perhaps should use a round-robin allocation system where several
< tablespaces are used in a cycle. The cycle pointer should be global.
> It could start with a random tablespace from a supplied list and cycle
> through the list.
Bruce Momjian [Wed, 3 Nov 2004 19:38:20 +0000 (19:38 +0000)]
Add idea on auto-cluster:
< store heap rows in hashed groups.
> store heap rows in hashed groups, perhaps using a user-supplied
> hash function.
Bruce Momjian [Wed, 3 Nov 2004 19:28:11 +0000 (19:28 +0000)]
Add idea on auto-cluster:
< automatically access the heap data too.
> automatically access the heap data too. A third idea would be to
> store heap rows in hashed groups.
Neil Conway [Wed, 3 Nov 2004 07:38:08 +0000 (07:38 +0000)]
Don't create $DESTDIR/include/internal/lib, as it is no longer used.
Peter Eisentraut [Tue, 2 Nov 2004 16:10:05 +0000 (16:10 +0000)]
Tab completion for CREATE TABLESPACE arguments. Patch by Joachim Wieland.
Bruce Momjian [Tue, 2 Nov 2004 14:49:27 +0000 (14:49 +0000)]
Update:
< * Add a GUC variable to control the tablespace for temporary objects
> * Add a GUC variable to control the tablespace for temporary objects and
> sort files
>
> This perhaps should use a round-robin allocation system where several
> tablespaces are used in a cycle. The cycle pointer should be global.
>
Peter Eisentraut [Tue, 2 Nov 2004 09:28:41 +0000 (09:28 +0000)]
Translation updates
Peter Eisentraut [Tue, 2 Nov 2004 09:20:22 +0000 (09:20 +0000)]
Translation updates
Bruce Momjian [Tue, 2 Nov 2004 05:44:45 +0000 (05:44 +0000)]
Move pthread.h test up to use PTHREAD_CFLAGS.
Kris Jurka
Bruce Momjian [Tue, 2 Nov 2004 03:34:50 +0000 (03:34 +0000)]
Add comment to postc that get_progname() will call exit if it
can't strdup().
Bruce Momjian [Tue, 2 Nov 2004 03:09:06 +0000 (03:09 +0000)]
Add comment about memory failure of get_progname exiting the postmaster:
exit(1); /* This could exit the postmaster */
Tom Lane [Mon, 1 Nov 2004 22:00:30 +0000 (22:00 +0000)]
timestamptz_trunc() should only recalculate the timezone when truncating
to DAY precision or coarser; leave the timezone alone when precision is
HOUR or less. This avoids surprises for inputs near a DST transition
time, as per example from Matthew Gabeler-Lee. (The only reason we
recalculate at all is so that outputs that are supposed to represent
days will come out as local midnight, and that's not relevant for sub-day
precision.)
Tom Lane [Mon, 1 Nov 2004 21:34:44 +0000 (21:34 +0000)]
Invent pg_next_dst_boundary() and rewrite DetermineLocalTimeZone() to
use it, as per my proposal of yesterday. This gives us a means of
determining the zone offset to impute to an unlabeled timestamp that
is both efficient and reliable, unlike all our previous tries involving
mktime() and localtime(). The behavior for invalid or ambiguous times
at a DST transition is fixed to be really and truly "assume standard
time", fixing a bug that has come and gone repeatedly but was back
again in 7.4. (There is some ongoing discussion about whether we should
raise an error instead, but for the moment I'll make it do what it was
previously intended to do.)
Bruce Momjian [Mon, 1 Nov 2004 19:21:50 +0000 (19:21 +0000)]
That's just the lovely way windows handles a "segfault". Gotta be really
interesting for MS to catch all those dumps...
Anyway. Oops. Seems I ran my regression tests with the old psql, and
just managed to update the backend, when I tested that patch. Turns out
there are codepaths where we'd access the Critical Section before it was
initialized. Attached patch breaks the initializeation off to a separate
part and adds that one to a much earlier position in the program.
Magnus Hagander
Bruce Momjian [Mon, 1 Nov 2004 14:33:10 +0000 (14:33 +0000)]
Update comment to point to proper file.
Dave Cramer [Mon, 1 Nov 2004 13:17:12 +0000 (13:17 +0000)]
fixed bug in segfault REVOKE statement
Neil Conway [Mon, 1 Nov 2004 11:11:13 +0000 (11:11 +0000)]
Trivial fixes for English grammar in contrib/btree_gist and contrib/rtree_gist
documentation.
Bruce Momjian [Mon, 1 Nov 2004 04:46:56 +0000 (04:46 +0000)]
Adjust use of sizeof(EXE).
Bruce Momjian [Mon, 1 Nov 2004 04:25:18 +0000 (04:25 +0000)]
Clarify coding of .exe patch
Bruce Momjian [Mon, 1 Nov 2004 02:22:05 +0000 (02:22 +0000)]
Update:
< * Add a GUC variable to control temporary and TOAST tablespace usage
> * Add a GUC variable to control the tablespace for temporary objects
Bruce Momjian [Mon, 1 Nov 2004 00:28:40 +0000 (00:28 +0000)]
Add:
> * Add a GUC variable to control temporary and TOAST tablespace usage