OSDN Git Service
Bruce Momjian [Sat, 17 Dec 2005 20:39:16 +0000 (20:39 +0000)]
Update s_lock.c comments.
Bruce Momjian [Sat, 17 Dec 2005 20:15:43 +0000 (20:15 +0000)]
Update ASM comments.
Bruce Momjian [Sat, 17 Dec 2005 19:03:24 +0000 (19:03 +0000)]
Remove item:
< * Allow star join optimizations
<
< While our bitmap scan allows multiple indexes to be joined to get
< to heap rows, a star joins allows multiple dimension _tables_ to
< be joined to index into a larger main fact table. The join is
< usually performed by either creating a cartesian product of all
< the dimmension tables and doing a single join on that product or
< using subselects to create bitmaps of each dimmension table match
< and merge the bitmaps to perform the join on the fact table. Some
< of these algorithms might be patented.
Bruce Momjian [Sat, 17 Dec 2005 18:07:01 +0000 (18:07 +0000)]
Update:
< * Flush cached query plans when the dependent objects change or
< when the cardinality of parameters changes dramatically
> * Flush cached query plans when the dependent objects change,
> when the cardinality of parameters changes dramatically, or
> when new ANALYZE statistics are available
Bruce Momjian [Sat, 17 Dec 2005 17:04:41 +0000 (17:04 +0000)]
Add mention of possible patent problems with star joins, per Joshua
Drake:
< and merge the bitmaps to perform the join on the fact table.
> and merge the bitmaps to perform the join on the fact table. Some
> of these algorithms might be patented.
Bruce Momjian [Sat, 17 Dec 2005 16:43:11 +0000 (16:43 +0000)]
Add:
* Allow star join optimizations
While our bitmap scan allows multiple indexes to be joined to get
to heap rows, a star joins allows multiple dimension _tables_ to
be joined to index into a larger main fact table. The join is
usually performed by either creating a cartesian product of all
the dimmension tables and doing a single join on that product or
using subselects to create bitmaps of each dimmension table match
and merge the bitmaps to perform the join on the fact table.
Bruce Momjian [Sat, 17 Dec 2005 14:18:33 +0000 (14:18 +0000)]
Add more function to TODO:
< * %Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef()
> * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(),
> pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
Bruce Momjian [Sat, 17 Dec 2005 04:10:47 +0000 (04:10 +0000)]
Update:
< * Flush cached query plans when the dependent objects change
> * Flush cached query plans when the dependent objects change or
> when the cardinality of parameters changes dramatically
Bruce Momjian [Sat, 17 Dec 2005 03:21:00 +0000 (03:21 +0000)]
Update FAQ, second version.
J.Kuwamura
Bruce Momjian [Sat, 17 Dec 2005 03:20:12 +0000 (03:20 +0000)]
Update Japanese FAQ.
J.Kuwamura
Bruce Momjian [Sat, 17 Dec 2005 01:48:37 +0000 (01:48 +0000)]
Add:
> * Allow the count returned by SELECT, etc to be to represent as an int64
> to allow a higher range of values
Bruce Momjian [Sat, 17 Dec 2005 00:35:50 +0000 (00:35 +0000)]
Add URL for Solaris qsort() bug.
Bruce Momjian [Sat, 17 Dec 2005 00:33:33 +0000 (00:33 +0000)]
Update doc mention that Solaris qsort() might be fixed.
Alvaro Herrera [Fri, 16 Dec 2005 21:55:27 +0000 (21:55 +0000)]
Add a note to Win32 gettimeofday() emulation, per Qingqing Zhou.
Bruce Momjian [Fri, 16 Dec 2005 18:56:55 +0000 (18:56 +0000)]
Force update.
Neil Conway [Fri, 16 Dec 2005 18:44:07 +0000 (18:44 +0000)]
Fix some typos in the TODO list.
Tom Lane [Fri, 16 Dec 2005 04:03:40 +0000 (04:03 +0000)]
Rethink prior patch to filter out dead backend entries from the pgstats
file. The original code probed the PGPROC array separately for each PID,
which was not good for large numbers of backends: not only is the runtime
O(N^2) but most of it is spent holding ProcArrayLock. Instead, take the
lock just once and copy the active PIDs into an array, then use qsort
and bsearch so that the lookup time is more like O(N log N).
Tom Lane [Wed, 14 Dec 2005 17:06:28 +0000 (17:06 +0000)]
Defend against crash while processing Describe Statement or Describe Portal
messages, when client attempts to execute these outside a transaction (start
one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK
statements which we can handle). Per report from Francisco Figueiredo Jr.
Tom Lane [Wed, 14 Dec 2005 16:28:32 +0000 (16:28 +0000)]
Fix problem with whole-row Vars referencing sub-select outputs, per
example from Jim Dew. Add some simple regression tests, since this is
an area we seem to break regularly :-(
Bruce Momjian [Mon, 12 Dec 2005 15:48:04 +0000 (15:48 +0000)]
Use a proper enum for tri-valued variables.
Bruce Momjian [Mon, 12 Dec 2005 15:41:52 +0000 (15:41 +0000)]
Document tri-valued variables in createdb, +1, -1, 0.
Bruce Momjian [Mon, 12 Dec 2005 13:36:36 +0000 (13:36 +0000)]
Update wording, query -> statement:
< * %Allow pooled connections to list all prepared queries
> * %Allow pooled connections to list all prepared statements
28c28
< the queries prepared in the current session.
> the statements prepared in the current session.
143c143
< o Allow a warm standby system to also allow read-only queries
> o Allow a warm standby system to also allow read-only statements
404c404
< * Add GUC to issue notice about queries that use unjoined tables
> * Add GUC to issue notice about statements that use unjoined tables
490c490
< Another idea would be to allow actual SELECT queries in a COPY.
> Another idea would be to allow actual SELECT statements in a COPY.
554c554
< o Allow function argument names to be queries from PL/PgSQL
> o Allow function argument names to be statements from PL/PgSQL
591c591
< o Improve psql's handling of multi-line queries
> o Improve psql's handling of multi-line statements
< Currently, while \e saves a single query as one entry, interactive
< queries are saved one line at a time. Ideally all queries
> Currently, while \e saves a single statement as one entry, interactive
> statements are saved one line at a time. Ideally all statements
665c665
< o Allow query results to be automatically batched to the client
> o Allow statement results to be automatically batched to the client
667c667
< Currently, all query results are transfered to the libpq
> Currently, all statement results are transfered to the libpq
672c672
< One complexity is that a query like SELECT 1/col could error
> One complexity is that a statement like SELECT 1/col could error
739c739
< * Allow queries across databases or servers with transaction
> * Allow statements across databases or servers with transaction
< inheritance, allow it to work for UPDATE and DELETE queries, and allow
< it to be used for all queries with little performance impact
> inheritance, allow it to work for UPDATE and DELETE statements, and allow
> it to be used for all statements with little performance impact
876c876
< * Consider automatic caching of queries at various levels:
> * Consider automatic caching of statements at various levels:
947c947
< a single session using multiple threads to execute a query faster.
> a single session using multiple threads to execute a statement faster.
1025c1025
< * Log queries where the optimizer row estimates were dramatically
> * Log statements where the optimizer row estimates were dramatically
1146c1146
< of result sets using new query protocol
> of result sets using new statement protocol
Teodor Sigaev [Mon, 12 Dec 2005 11:10:12 +0000 (11:10 +0000)]
Improve support of multibyte encoding:
- tsvector_(in|out)
- tsquery_(in|out)
- to_tsvector
- to_tsquery, plainto_tsquery
- 'simple' dictionary
Tom Lane [Sun, 11 Dec 2005 21:02:18 +0000 (21:02 +0000)]
Divide the lock manager's shared state into 'partitions', so as to
reduce contention for the former single LockMgrLock. Per my recent
proposal. I set it up for 16 partitions, but on a pgbench test this
gives only a marginal further improvement over 4 partitions --- we need
to test more scenarios to choose the number of partitions.
Neil Conway [Sun, 11 Dec 2005 10:54:28 +0000 (10:54 +0000)]
Implement IS NOT DISTINCT FROM, update the regression tests and docs.
Patch from Pavel Stehule, minor fixups by myself.
Bruce Momjian [Sun, 11 Dec 2005 02:16:25 +0000 (02:16 +0000)]
Remove item:
< * Add GUC variable to run a command on database panic or
< smart/fast/immediate shutdown
Tom Lane [Sat, 10 Dec 2005 19:21:03 +0000 (19:21 +0000)]
Teach deparsing of CASE expressions to cope with the simplified forms
that simplify_boolean_equality() may leave behind. This is only relevant
if the user writes something a bit silly, like CASE x=y WHEN TRUE THEN.
Per example from Michael Fuhr; may or may not explain bug #2106.
Tom Lane [Sat, 10 Dec 2005 01:09:07 +0000 (01:09 +0000)]
Remove incorrect increment of lineno, per David Fetter.
Sync HEAD and 8.1 branches of pgbench.
Bruce Momjian [Fri, 9 Dec 2005 21:46:07 +0000 (21:46 +0000)]
Done:
< * Allow installing to directories containing spaces
> * -Allow installing to directories containing spaces
Peter Eisentraut [Fri, 9 Dec 2005 21:19:36 +0000 (21:19 +0000)]
Allow installation into directories containing spaces in the name.
Tom Lane [Fri, 9 Dec 2005 20:40:12 +0000 (20:40 +0000)]
Add release notes for back branches (7.3 and up).
Also minor improvements to 8.1.1 release notes.
Bruce Momjian [Fri, 9 Dec 2005 19:39:41 +0000 (19:39 +0000)]
Add documentation about the behavior of BEFORE triggers and referential
integrity actions.
Stephan Szabo
Bruce Momjian [Fri, 9 Dec 2005 19:19:17 +0000 (19:19 +0000)]
Remove mention that history is _now_ automatically saved on exit. It
has been that way for a long time.
Tom Lane [Fri, 9 Dec 2005 18:07:49 +0000 (18:07 +0000)]
Fix broken markup.
Tom Lane [Fri, 9 Dec 2005 17:08:49 +0000 (17:08 +0000)]
Fix core dump in error path of plpgsql_parse_tripwordtype. Somebody
introduced a copy-and-pasteo while trying to simplify the code.
Bruce Momjian [Fri, 9 Dec 2005 16:35:20 +0000 (16:35 +0000)]
Completed:
* -Have initdb set the input DateStyle (MDY or DMY) based on locale
Peter Eisentraut [Fri, 9 Dec 2005 15:51:14 +0000 (15:51 +0000)]
Let initdb detect the date order of the lc_time locale and initialize the
datestyle parameter of the new cluster accordingly.
Bruce Momjian [Fri, 9 Dec 2005 04:50:40 +0000 (04:50 +0000)]
I reconfirmed MS-VC6. Thank you for wonderful correspondence.
However, Another problem newly occurred.
This solves the problem of snprintf and vsnprintf.
Patch to HEAD and 8.1.X.
Hiroshi Saito
Bruce Momjian [Fri, 9 Dec 2005 02:49:09 +0000 (02:49 +0000)]
Stamp libraries for 8.2 by updating minor library version numbers and
Win32 library files.
Tom Lane [Fri, 9 Dec 2005 01:22:04 +0000 (01:22 +0000)]
Simplify lock manager data structures by making a clear separation between
the data defining the semantics of a lock method (ie, conflict resolution
table and ancillary data, which is all constant) and the hash tables
storing the current state. The only thing we give up by this is the
ability to use separate hashtables for different lock methods, but there
is no need for that anyway. Put some extra fields into the LockMethod
definition structs to clean up some other uglinesses, like hard-wired
tests for DEFAULT_LOCKMETHOD and USER_LOCKMETHOD. This commit doesn't
do anything about the performance issues we were discussing, but it clears
away some of the underbrush that's in the way of fixing that.
Bruce Momjian [Thu, 8 Dec 2005 23:22:20 +0000 (23:22 +0000)]
Release note wording improvements.
Bruce Momjian [Thu, 8 Dec 2005 22:44:55 +0000 (22:44 +0000)]
Wrap UTF-8 paragraph.
Bruce Momjian [Thu, 8 Dec 2005 22:35:44 +0000 (22:35 +0000)]
Update wording of translation bug item.
Bruce Momjian [Thu, 8 Dec 2005 22:26:18 +0000 (22:26 +0000)]
Update for 8.1.1.
Bruce Momjian [Thu, 8 Dec 2005 22:21:26 +0000 (22:21 +0000)]
Update release notes for 8.1.1.
Bruce Momjian [Thu, 8 Dec 2005 22:10:25 +0000 (22:10 +0000)]
Add Teodor:
> * Teodor is Teodor Sigaev <teodor@sigaev.ru>
Bruce Momjian [Thu, 8 Dec 2005 22:08:20 +0000 (22:08 +0000)]
Remove a few people:
< * Claudio is Claudio Natoli <claudio.natoli@memetrics.com>
1166d1164
< * Hiroshi is Hiroshi Inoue <Inoue@tpf.co.jp>
Bruce Momjian [Thu, 8 Dec 2005 21:36:50 +0000 (21:36 +0000)]
FAQ_AIX in 8.1.0 contains outdated information about how to deal with
postgres problems due to readline. The attached patch replaces that
section of it with better ways of handling the problem.
Seneca Cunningham
Bruce Momjian [Thu, 8 Dec 2005 21:35:36 +0000 (21:35 +0000)]
there's a paragraph in the ALTER TABLE reference page that reads:
DROP CONSTRAINT
This form drops constraints on a table. Currently, constraints on tables
are not required to have unique names, so there may be more than one
constraint matching the specified name. All matching constraints will be
dropped.
To my knowledge, it is no longer possible to create constraints with the
same name for the same relation. When you create a constraint and specify
the same name explictly, an error is raised. Implicit constraint creation
won't choose an existing name either and up to now you could not rename a
constraint. Renaming works with the patch I sent in a few hours ago but this
patch as well won't allow constraints with identical names on the same
relation.
The attached patch thus removes the note in the docs.
Joachim Wieland
Bruce Momjian [Thu, 8 Dec 2005 21:33:58 +0000 (21:33 +0000)]
> 1) I'm proposing a patch to do the DROP FUNCTION argument tab completion.
> Now, the arguments of the drop function can be tab completed. for example
>
> drop function strpos (
> <press tab>
> drop FUNCTION strpos (text, text)
>
> or:
>
> wsdb=# drop FUNCTION length (
> bit) bytea) character) lseg) path) text)
> <press c>
> wsdb# DROP FUNCTION length ( character)
>
> I think that this patch should be rather useful. At it least I hate
> always to type all the arguments of the dropped functions.
>
> 2) Also some fixes applied for the
> CREATE INDEX syntax
>
> now the parenthesises are inserted by tab pressing.
> suppose I have the table q3c:
Sergey E. Koposov
Peter Eisentraut [Thu, 8 Dec 2005 21:29:25 +0000 (21:29 +0000)]
Put [] around default value for port number.
Bruce Momjian [Thu, 8 Dec 2005 21:23:09 +0000 (21:23 +0000)]
Remove empty heading row in error table.
Peter Eisentraut [Thu, 8 Dec 2005 21:18:22 +0000 (21:18 +0000)]
Add missing translation marker
Bruce Momjian [Thu, 8 Dec 2005 21:01:52 +0000 (21:01 +0000)]
Add "Constant" column to error code table.
Also, better mark section headings.
kdio@uenf.br
Peter Eisentraut [Thu, 8 Dec 2005 20:48:10 +0000 (20:48 +0000)]
Documentation fix: s/event_object_name/event_object_table/g
Tom Lane [Thu, 8 Dec 2005 19:19:22 +0000 (19:19 +0000)]
Fix bgwriter's failure to release buffer pins and open files after an
error. This probably explains bug #2099 and could also account for
mysterious VACUUM hangups.
Bruce Momjian [Thu, 8 Dec 2005 18:04:33 +0000 (18:04 +0000)]
I recently received the Debian bug report below about missing iconv
support for the dbf2pg contrib module.
The submitter created a patch which replaces the silent ignoring of -F
(when iconv support is disabled) with a meaningful warning.
Martin Pitt
Bruce Momjian [Thu, 8 Dec 2005 18:02:04 +0000 (18:02 +0000)]
Add documentation about the inability of plpsql to use parameter names
that are the same as column names used in the function.
Bruce Momjian [Thu, 8 Dec 2005 17:52:11 +0000 (17:52 +0000)]
Disble some Win32-specific code in win32-client-only builds:
I have the problem, when building by MS-VC6.
An error occurs in the 8.1.0 present source codes.
nmake -f win32.mak
..\..\port\getaddrinfo.c(244) : error C2065: 'WSA_NOT_ENOUGH_MEMORY'
..\..\port\getaddrinfo.c(342) : error C2065: 'WSATYPE_NOT_FOUND'
This is used by winsock2.h. However, Construction of a windows base is
winsock.h.
Then, Since MinGW has special environment, this is right. but, it is not
found in VC6.
Furthermore, in getaddrinfo.c, IPV6-API is used by
LoadLibraryA("ws2_32");
Referring to of dll the external memory generates this violation by VC6
specification.
I considered whether the whole should have been converted into winsock2.
However, Now, DLL of MinGW creation operates wonderfully as it is.
That's right, it has pliability by replacement of simple DLL.
Then, I propose the system using winsock(non IPV6) in construction of
VC6.
Hiroshi Saito
Tom Lane [Thu, 8 Dec 2005 15:38:29 +0000 (15:38 +0000)]
Fix thinko in comment.
Teodor Sigaev [Thu, 8 Dec 2005 09:11:19 +0000 (09:11 +0000)]
Improve tag recognizing
Tom Lane [Wed, 7 Dec 2005 19:37:53 +0000 (19:37 +0000)]
Push the responsibility for handling ignore_killed_tuples down into
_bt_checkkeys(), instead of checking it in the top-level nbtree.c routines
as formerly. This saves a little bit of loop overhead, but more importantly
it lets us skip performing the index key comparisons for dead tuples.
Tom Lane [Wed, 7 Dec 2005 18:03:48 +0000 (18:03 +0000)]
A couple of tiny performance hacks in _bt_step(). Remove PageIsEmpty
checks, which were once needed because PageGetMaxOffsetNumber would
fail on empty pages, but are now just redundant. Also, don't set up
local variables that aren't needed in the fast path --- most of the
time, we only need to advance offnum and not step across a page boundary.
Motivated by noticing _bt_step at the top of OProfile profile for a
pgbench run.
Bruce Momjian [Wed, 7 Dec 2005 17:29:14 +0000 (17:29 +0000)]
Update:
< at initdb time or optionally later.
> at initdb time or optionally later. Consider O_SYNC when
> O_DIRECT exists.
Tom Lane [Wed, 7 Dec 2005 15:39:25 +0000 (15:39 +0000)]
Fix incorrect SPI example, per Yoshihisa Nakano.
Tom Lane [Wed, 7 Dec 2005 15:27:42 +0000 (15:27 +0000)]
Fix a couple of lingering references to POSTQUEL query syntax, per Simon.
Tom Lane [Wed, 7 Dec 2005 15:20:56 +0000 (15:20 +0000)]
Spell "explicitly" correctly, per Simon.
Bruce Momjian [Wed, 7 Dec 2005 14:35:45 +0000 (14:35 +0000)]
Improve lazy vacuum wording.
Teodor Sigaev [Wed, 7 Dec 2005 13:30:15 +0000 (13:30 +0000)]
Fix small memory leak
Teodor Sigaev [Wed, 7 Dec 2005 13:12:54 +0000 (13:12 +0000)]
Improve word parser.
- allow ~ in filenames
- -8.2.1 now is '-' and '8.2.1' instead of '-8.2' '.' '3'
- '.text' now is not a file
Bruce Momjian [Wed, 7 Dec 2005 05:35:53 +0000 (05:35 +0000)]
Clarify vacuum lazy can shrink a file under certain circumstances.
Tom Lane [Tue, 6 Dec 2005 23:08:34 +0000 (23:08 +0000)]
Get rid of slru.c's hardwired insistence on a fixed number of slots per
SLRU area. The number of slots is still a compile-time constant (someday
we might want to change that), but at least it's a different constant for
each SLRU area. Increase number of subtrans buffers to 32 based on
experimentation with a heavily subtrans-bashing test case, and increase
number of multixact member buffers to 16, since it's obviously silly for
it not to be at least twice the number of multixact offset buffers.
Bruce Momjian [Tue, 6 Dec 2005 21:00:53 +0000 (21:00 +0000)]
Update iconv wording, per Peter.
Bruce Momjian [Tue, 6 Dec 2005 20:47:05 +0000 (20:47 +0000)]
Add:
> * Add GUC variable to run a command on database panic or
> smart/fast/immediate shutdown
Bruce Momjian [Tue, 6 Dec 2005 20:25:42 +0000 (20:25 +0000)]
Highlight diff idea for iconv.
Bruce Momjian [Tue, 6 Dec 2005 20:19:17 +0000 (20:19 +0000)]
iconv uses UTF-8, not UTF8.
Bruce Momjian [Tue, 6 Dec 2005 19:26:43 +0000 (19:26 +0000)]
Document method of removing invalid UTF8 escape sequences from dump
file. Backpatch to 8.1.X.
Paul Lindner
Bruce Momjian [Tue, 6 Dec 2005 18:45:18 +0000 (18:45 +0000)]
Documentation cleanup mention:
non-ascii convert to & escapes
Bruce Momjian [Tue, 6 Dec 2005 18:43:26 +0000 (18:43 +0000)]
Since my name has a non-ascii-letter in it, it's often spelled wrong. In
the latest release notes there is a latin1 character that shouldn't be
there so I made a patch to fix that. This patch also fixes some old
entries that uses o instead of ö (which is also wrong but not as
bad as including a latin1 character in the sgml file).
Dennis Bj?rklund
Bruce Momjian [Tue, 6 Dec 2005 18:35:10 +0000 (18:35 +0000)]
Add documentation on the use of *printf() macros and libintl.
Backpatch to 8.1.X.
Teodor Sigaev [Tue, 6 Dec 2005 18:22:33 +0000 (18:22 +0000)]
Fix stupid bug with sizeof
Tom Lane [Tue, 6 Dec 2005 18:10:06 +0000 (18:10 +0000)]
Arrange for read-only accesses to SLRU page buffers to take only a shared
lock, not exclusive, if the desired page is already in memory. This can
be demonstrated to be a significant win on the pg_subtrans cache when there
is a large window of open transactions. It should be useful for pg_clog
as well. I didn't try to make GetMultiXactIdMembers() use the code, as
that would have taken some restructuring, and what with the local cache
for multixact contents it probably wouldn't really make a difference.
Per my recent proposal.
Tom Lane [Tue, 6 Dec 2005 16:50:36 +0000 (16:50 +0000)]
In a nestloop inner indexscan, it's OK to use pushed-down baserestrictinfo
clauses even if it's an outer join. This is a corner case since such
clauses could only arise from weird OUTER JOIN ON conditions, but worth
fixing. Per example from Ron at cheapcomplexdevices.com.
Tom Lane [Tue, 6 Dec 2005 05:26:21 +0000 (05:26 +0000)]
ecpg/pgtypeslib seems to need snprintf.c pulled in, too.
Tom Lane [Tue, 6 Dec 2005 05:13:46 +0000 (05:13 +0000)]
Put undef's before extern declarations that need 'em, per Andrew Dunstan.
Bruce Momjian [Tue, 6 Dec 2005 04:53:02 +0000 (04:53 +0000)]
Add comment on why pg *printf functions are used unconditionally on
Win32.
Backpatch to 8.1.X.
Tom Lane [Tue, 6 Dec 2005 02:29:04 +0000 (02:29 +0000)]
Make Win32 build use our port/snprintf.c routines, instead of depending
on libintl which may or may not provide what we need. Make a few marginal
cleanups to ensure this works. Andrew Dunstan and Tom Lane.
Tom Lane [Mon, 5 Dec 2005 21:57:00 +0000 (21:57 +0000)]
Document return-value conventions used by this implementation, per
suggestion from Bruce.
Teodor Sigaev [Mon, 5 Dec 2005 18:13:22 +0000 (18:13 +0000)]
Improve word parser.
- improve file and path recognition
- fix misspeling
- improve tag recognition
Tom Lane [Mon, 5 Dec 2005 04:13:38 +0000 (04:13 +0000)]
Add regression test to see if the min/max values of int8 convert correctly.
Tom Lane [Mon, 5 Dec 2005 02:39:38 +0000 (02:39 +0000)]
Fix a rather sizable number of problems in our homegrown snprintf, such as
incorrect implementation of argument reordering, arbitrary limit of output
size for sprintf and fprintf, willingness to access more bytes than "%.Ns"
specification allows, wrong formatting of LONGLONG_MIN, various field-padding
bugs and omissions. I believe it now accurately implements a subset of
the Single Unix Spec requirements (remaining unimplemented features are
documented, too). Bruce Momjian and Tom Lane.
Bruce Momjian [Sun, 4 Dec 2005 21:16:51 +0000 (21:16 +0000)]
Update:
< Win32 API, and we have to make sure MinGW handles it.
> Win32 API, and we have to make sure MinGW handles it. Another
> option is to wait for the MinGW project to fix it, or use the
> code from the LibGW32C project as a guide.
Bruce Momjian [Sun, 4 Dec 2005 04:33:18 +0000 (04:33 +0000)]
Add:
> o Add long file support for binary pg_dump output
>
> While Win32 supports 64-bit files, the MinGW API does not,
> meaning we have to build an fseeko replacement on top of the
> Win32 API, and we have to make sure MinGW handles it.
Bruce Momjian [Sun, 4 Dec 2005 04:14:43 +0000 (04:14 +0000)]
Add:
> * Add SPI_gettypmod() to return the typemod for a TupleDesc
Bruce Momjian [Sun, 4 Dec 2005 04:02:55 +0000 (04:02 +0000)]
Add for autovacuum:
> o Consider logging activity either to the logs or a system view
Bruce Momjian [Sun, 4 Dec 2005 03:52:29 +0000 (03:52 +0000)]
Add configure flag to allow libedit to be preferred over GNU readline:
--with-libedit-preferred prefer BSD Libedit over GNU Readline
Tom Lane [Sat, 3 Dec 2005 21:06:18 +0000 (21:06 +0000)]
Treat procedural languages as owned by the bootstrap superuser, rather
than owned by nobody. This results in cleaner display of language ACLs,
since the backend's aclchk.c uses the same convention. AFAICS there is
no practical difference but it's nice to avoid emitting SET SESSION
AUTHORIZATION; also this will make it easier to transition pg_dump to
some future version in which we may include an explicit ownership column
in pg_language. Per gripe from David Begley.
Tom Lane [Sat, 3 Dec 2005 20:16:31 +0000 (20:16 +0000)]
Fix out-of-order inclusion of -L switches from LDFLAGS on AIX and HPUX.
Per example from Dirk Pirschel.
Bruce Momjian [Sat, 3 Dec 2005 16:45:06 +0000 (16:45 +0000)]
Allow to_char(interval) and to_char(time) to use AM/PM specifications.
Map them to a single day, so '30 hours' is 'AM'.
Have to_char(interval) and to_char(time) use "HH", "HH12" as 12-hour
intervals, rather than bypass and print the full interval hours. This
is neeeded because to_char(time) is mapped to interval in this function.
Intervals should use "HH24", and document suggestion.
Allow "D" format specifiers for interval/time.
Bruce Momjian [Sat, 3 Dec 2005 13:03:41 +0000 (13:03 +0000)]
Item removed:
< * Add function to return the thread safety status of libpq and ecpg