[COMMITTERS] pgsql: Create the system catalog infrastructure needed for KNNGIST.

2010-11-24 Thread Tom Lane
Create the system catalog infrastructure needed for KNNGIST. This commit adds columns amoppurpose and amopsortfamily to pg_amop, and column amcanorderbyop to pg_am. For the moment all the entries in amcanorderbyop are "false", since the underlying support isn't there yet. Also, extend the CREATE

[COMMITTERS] pgsql: When reporting the server as not responding, if the hostname was

2010-11-24 Thread Bruce Momjian
When reporting the server as not responding, if the hostname was supplied, also print the IP address. This allows IPv4 and IPv6 failures to be distinguished. Also useful when a hostname resolves to multiple IP addresses. Also, remove use of inet_ntoa() and use our own inet_net_ntop() in all plac

[COMMITTERS] psqlodbc - psqlodbc: Applied a patch by Taizo Ito and correct the length

2010-11-24 Thread User Hinoue
Log Message: --- Applied a patch by Taizo Ito and correct the length of BIT type in Postgres. Modified Files: -- psqlodbc: info.c (r1.164 -> r1.165) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodbc/info.c?r1=1.164&r2=1.165) pgtypes.h (

[COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Peter Eisentraut
Remove useless whitespace at end of lines Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=fc946c39aeacdff7df60c83fca6582985e8546c8 Modified Files -- README |2 +- config/ac_func_accep

Re: [COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Alvaro Herrera
Excerpts from Peter Eisentraut's message of mar nov 23 17:52:18 -0300 2010: > Remove useless whitespace at end of lines This was stuck in the moderation queue because of message size limit (30 kB). Is it worth increasing that value? -- Álvaro Herrera The PostgreSQL Company - Command Prompt, In

Re: [COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Tom Lane
Alvaro Herrera writes: > Excerpts from Peter Eisentraut's message of mar nov 23 17:52:18 -0300 2010: >> Remove useless whitespace at end of lines > This was stuck in the moderation queue because of message size limit (30 > kB). Is it worth increasing that value? Evidently we should. pgindent a

Re: [COMMITTERS] pgsql: Provide hashing support for arrays.

2010-11-24 Thread Bruce Momjian
I assume this completes this TODO item, so I have marked it as done: Incomplete itemAllow hashing to be used on arrays, if the element type is hashable http://archives.postgresql.org/message-id/11087.1244905...@sss.pgh.pa.us -

Re: [COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Magnus Hagander
On Wed, Nov 24, 2010 at 23:45, Tom Lane wrote: > Alvaro Herrera writes: >> Excerpts from Peter Eisentraut's message of mar nov 23 17:52:18 -0300 2010: >>> Remove useless whitespace at end of lines > >> This was stuck in the moderation queue because of message size limit (30 >> kB).  Is it worth i

Re: [HACKERS] [COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Bruce Momjian
Magnus Hagander wrote: > On Wed, Nov 24, 2010 at 23:45, Tom Lane wrote: > > Alvaro Herrera writes: > >> Excerpts from Peter Eisentraut's message of mar nov 23 17:52:18 -0300 2010: > >>> Remove useless whitespace at end of lines > > > >> This was stuck in the moderation queue because of message si

Re: [COMMITTERS] pgsql: Remove useless whitespace at end of lines

2010-11-24 Thread Tom Lane
Magnus Hagander writes: > On Wed, Nov 24, 2010 at 23:45, Tom Lane wrote: >> Alvaro Herrera writes: >>> This was stuck in the moderation queue because of message size limit (30 >>> kB).  Is it worth increasing that value? >> >> Evidently we should.  pgindent and copyright-update commits are like

[COMMITTERS] pgsql: Document that a CHECKPOINT before taking a file system snapshot

2010-11-24 Thread Bruce Momjian
Document that a CHECKPOINT before taking a file system snapshot can reduce recovery time. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=7276ab5888d85782d988fc297ad2e176c7ad1bca Modified Files -- doc/src/sgml/backup.sgml |2 +

Re: [COMMITTERS] pgsql: Document that a CHECKPOINT before taking a file system snapshot

2010-11-24 Thread Cédric Villemain
2010/11/25 Bruce Momjian : > Document that a CHECKPOINT before taking a file system snapshot can > reduce recovery time. I didn't follow that on -hackers, but : * checkpoint take place in the pg_start_backup process (before it releases the hand, so before you can start snapshoting) * we used to

[COMMITTERS] pgsql: Properly add new inet_net_ntop file to libpq Makefile.

2010-11-24 Thread Bruce Momjian
Properly add new inet_net_ntop file to libpq Makefile. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=58dfb07b5d84c0088033e2d22fc44df812fa6eb5 Modified Files -- src/interfaces/libpq/Makefile |7 --- 1 files changed, 4 inse

Re: [COMMITTERS] pgsql: Document that a CHECKPOINT before taking a file system snapshot

2010-11-24 Thread Bruce Momjian
C?dric Villemain wrote: > 2010/11/25 Bruce Momjian : > > Document that a CHECKPOINT before taking a file system snapshot can > > reduce recovery time. > > I didn't follow that on -hackers, but : > > * checkpoint take place in the pg_start_backup process (before it > releases the hand, so before y

[COMMITTERS] pgsql: Remove belt-and-suspenders guards against buffer pin leaks.

2010-11-24 Thread Robert Haas
Remove belt-and-suspenders guards against buffer pin leaks. Forcibly releasing all leftover buffer pins should be unnecessary now that we have a robust ResourceOwner mechanism, and it significantly increases the cost of process shutdown. Instead, in an assert-enabled build, assert that no pins ar

[COMMITTERS] pgsql: Add inet_net_ntop.c to .gitignore.

2010-11-24 Thread Robert Haas
Add inet_net_ntop.c to .gitignore. Branch -- master Details --- http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2d1e426650fc93e5dfdd0178023485d38b03b102 Modified Files -- src/interfaces/libpq/.gitignore |1 + 1 files changed, 1 insertions(+), 0 deletions(-

[COMMITTERS] How strings are sorted by LC_COLLATE specifically?

2010-11-24 Thread Chang Chao
Hello Dear All. How strings are sorted when LC_COLLATE = ja_JP.UTF-8. I tried to read the documention on that,but there are just a few words, like LC_COLLATE determines string sort order, Is there a specific reference about this? So I can implement an equivalent string sort function in JAVA. becau