PgSql

[HACKERS] Differential backup
Thinking about allowing a backup to tell which files have changed in the database since last backup. This would allow an external utility to copy away only changed files. Now there's a few ways of doing this and many will say this is already possible using file access times. An explicit mechanism where Postg... 27 Apr 2010 09:54

CP949 for EUC-KR?
Takahiro Itagaki wrote: I heard pg_get_encoding_from_locale() failed in kor locale. WARNING: could not determine encoding for locale "kor": codeset is "CP949" I found the following description in the web: CP949 is EUC-KR, extended with UHC (Unified Hangul Code). http://www.opensource... 5 May 2010 22:42

[HACKERS] CP949 for EUC-KR?
I heard pg_get_encoding_from_locale() failed in kor locale. WARNING: could not determine encoding for locale "kor": codeset is "CP949" I found the following description in the web: CP949 is EUC-KR, extended with UHC (Unified Hangul Code). http://www.opensource.apple.com/source/libiconv/libiconv-13.... 27 Apr 2010 06:32

Wierd quirk of HS/SR, probably not fixable
Josh Berkus wrote: Here's a way to trap yourself: (1) Set up an HS/SR master (2) pg_start_backup on the master (3) clone the master to 1 or more slaves (4) Fast shutdown the master (without pg_stop_backup) (5) Restart the master (6) Bring up the slaves Result: the slaves will come up fin... 27 Apr 2010 23:32

pg_migrator
On Mon, Apr 26, 2010 at 9:26 PM, Bruce Momjian <bruce(a)momjian.us> wrote: There was talk of including pg_migrator in Postgres 9.0 in /contrib.  Do we still want to do that? I think you articulated some pretty good reasons previously for keeping it separate and, at any rate, I'm not eager to do it at the 11th ... 29 Apr 2010 18:04

Discarding the resulting rows
"Murali M. Krishna" <murali1729(a)yahoo.com> wrote: Basically, I would like to discard the result rows after doing all the work required to execute the query. I would use EXPLAIN ANALYZE SELECT ... I looked at the documentation and I saw something about using the keyword PERFORM rather than SELECT. ... 26 Apr 2010 17:13

pgsql: Make CheckRequiredParameterValues() depend upon correct
On Fri, Apr 23, 2010 at 4:44 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Simon Riggs <simon(a)2ndQuadrant.com> writes: No intention of doing that. This change allows people to see what the dependency actually is once the bug has been fixed. Change needs to start from here, not from where we were before. ... 29 Apr 2010 16:56

INSERT and parentheses
On Mon, Apr 26, 2010 at 8:57 AM, Marko Tiikkaja <marko.tiikkaja(a)cs.helsinki.fi> wrote: Hi, This came up on IRC today and I recall several instances of this during the last two months or so, so I decided to send a patch.  The problem in question occurs when you have extra parentheses in an INSERT list: ... 26 Apr 2010 11:23

[HACKERS] INSERT and parentheses
Hi, This came up on IRC today and I recall several instances of this during the last two months or so, so I decided to send a patch. The problem in question occurs when you have extra parentheses in an INSERT list: INSERT INTO foo(a,b,c) SELECT (a,b,c) FROM ..; or INSERT INTO foo(a,b,c) VALUES((0,1,2)); Bo... 26 Apr 2010 09:09

CIText and pattern_ops
Rod Taylor <pg(a)rbt.ca> wrote: Is there any particular reason why the citext module doesn't have citext_pattern_ops operator family? Specifically, I wish to index for this type of query: ... WHERE citext_column LIKE 'Foo%'; I think it is a reasonable suggestion. =# \d tbl Table "publi... 26 Apr 2010 10:15