PgSql

[HACKERS] ERROR: record type has not been registered
This was a random attempt to figure something out about min/max on row types: => select min(a) from (values (row(1,2,3)), (row(3,4,5))) as x(a); ERROR: 42809: record type has not been registered LOCATION: lookup_rowtype_tupdesc_internal, typcache.c:341 I don't know whether it's supposed to work, but the erro... 3 Jan 2010 16:04

Testing with concurrent sessions
On Jan 1, 2010, at 6:01 PM, Kevin Grittner wrote: It's very soon going to be critical that I be able to test particular interleavings of statements in particular concurrent transaction sets to be able to make meaningful progress on the serializable transaction work. It would be wonderful if some of these... 14 Feb 2010 07:22

invalid UTF-8 via pl/perl
Hannu Krosing wrote: [plperl can return data that is not valid in the server encoding and it is not caught] This results in a table, which has invalid utf sequence in it and consequently does not pass dump/load What would be the best place to fix this ? Should there be checks in all text ty... 6 Jan 2010 09:08

[HACKERS] invalid UTF-8 via pl/perl
It is possible to get an invalid byte sequence into a text field via pl, in this case pl/perl : ---8<------8<------8<------8<------8<------8<--- CREATE TABLE utf_test ( id serial PRIMARY KEY, data character varying ); CREATE OR REPLACE FUNCTION invalid_utf_seq() RETURNS character varying AS $BODY$... 2 Jan 2010 18:17

[HACKERS] psql tab completion for DO blocks
Folks, Please find enclosed a patch which adds tab completion for DO blocks. Thanks to Andrew Gierth and Stefan Kaltenbrunner for help putting it together :) Cheers, David. -- David Fetter <david(a)fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter ... 2 Jan 2010 17:11

[BUG?] strange behavior in ALTER TABLE ... RENAME TOon inherited columns
(2009/12/30 10:38), Robert Haas wrote: 2009/12/16 KaiGai Kohei<kaigai(a)ak.jp.nec.com>: It is a patch for the matter which I reported before. When a column is inherited from multiple relations, ALTER TABLE with RENAME TO option is problematic. This patch fixes the matter. In correctly, it prevent t... 2 Feb 2010 22:22

[HACKERS] More frame options in window functions
Attached is the fix pointed out in the previous CommitFest plus RANGE offset support. *fix - move window regression test to another parallel group, but regarding the limitation of 20 per group the union test goes to the group the window test belonged to. - allow NULL iswindowagg as an argument of AggGetMemoryCo... 31 Dec 2009 05:33

pg_read_file() and non-ascii input file
On Mon, Nov 30, 2009 at 4:36 AM, Itagaki Takahiro <itagaki.takahiro(a)oss.ntt.co.jp> wrote: If we want to keep backward compatibility, the issue can be fixed by adding pg_verifymbstr() to the function. We can also have the binary version in another name, like pg_read_binary_file(). I don't feel good about ch... 3 Jan 2010 22:40

update_process_title=off and logger, wal, ...processes
* Rod Taylor (rod.taylor(a)gmail.com) wrote: I (stupidly?) installed PostgreSQL into a hostile environment which didn't like this and decided to kill the processes as a result. Unfortunately, I cannot change the environment. That's not hostile, that's broken. Stephen ... 30 Dec 2009 17:37

[HACKERS] Thread safety and libxml2
We got an interesting report on the testers list today: http://archives.postgresql.org/pgsql-testers/2009-12/msg00000.php Basically, configure failed on their OpenBSD system because thread safety is on but the libxml2 wasn't compiled with threaded support: http://xmlsoft.org/threads.html Disabling either ... 30 Dec 2009 13:09