Re: [HACKERS] Syntax for partitioning

2011-11-09 Thread Thom Brown
On 15 December 2009 02:31, Jaime Casanova wrote: > On Mon, Dec 14, 2009 at 7:29 PM, Simon Riggs wrote: >> On Fri, 2009-12-04 at 09:00 +, Simon Riggs wrote: >>> On Fri, 2009-12-04 at 11:54 +0900, Itagaki Takahiro wrote: >>> > Here is an update partitioning syntax patch. >>> > >>> > A bug repor

[HACKERS] a modest improvement to get_object_address()

2011-11-09 Thread Robert Haas
I'd like to propose the attached patch, which changes get_object_address() in a manner similar to what we did in RangeVarGetRelid() in commit 4240e429d0c2d889d0cda23c618f94e12c13ade7. The basic idea is that, if we look up an object name, acquire the corresponding lock, and then find that the objec

Re: [HACKERS] Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers

2011-11-09 Thread Robert Haas
On Wed, Nov 9, 2011 at 4:56 AM, Nikhil Sontakke wrote: > Consider the following sequence of events: > > s1 #> CREATE SCHEMA test_schema; > > s1 #> CREATE TABLE test_schema.c1(x int); > > Now open another session s2 and via gdb issue a breakpoint on > heap_create_with_catalog() which is called by D

Re: [HACKERS] Measuring relation free space

2011-11-09 Thread Alvaro Herrera
Excerpts from Jaime Casanova's message of mar nov 08 18:12:25 -0300 2011: > On Sun, Nov 6, 2011 at 5:38 AM, Magnus Hagander wrote: > > > > Looks pretty useful. > > thanks for the review, attached is a new version of it Note that AFAIK you shouldn't update the 1.0 extension script ... you have t

[HACKERS] [Feature Request] \dx show "options"

2011-11-09 Thread Emanuel Calvo
Hi guys, I was thinking that could be great to add a column in \dx showing the available options for each foreign data wrapper. Seems reasonable? -- --               Emanuel Calvo               Helpame.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes t

Re: [HACKERS] pg_comments (was: Allow \dd to show constraint comments)

2011-11-09 Thread Robert Haas
On Wed, Nov 9, 2011 at 3:38 AM, Thom Brown wrote: > On 9 November 2011 02:42, Robert Haas wrote: >> On Tue, Nov 8, 2011 at 8:12 PM, Thom Brown wrote: >>> Why is this marked as done on with Wiki's todo list? >> >> I assume you're referring to this item: >> >> -- >> \dd is missing comments for sev

Re: [HACKERS] Disable OpenSSL compression

2011-11-09 Thread Albe Laurenz
Christopher Browne wrote: >> I think that JDBC and Npgsql should also support disabling compression. > > That's the *real* problem here... > > You're quite right that if we allow controlling this on the libpq > side, it is surely desirable to allow controlling this via JDBC, > Npgsql, and other me

[HACKERS] Concurrent CREATE TABLE/DROP SCHEMA leaves inconsistent leftovers

2011-11-09 Thread Nikhil Sontakke
Hi, Consider the following sequence of events: s1 #> CREATE SCHEMA test_schema; s1 #> CREATE TABLE test_schema.c1(x int); Now open another session s2 and via gdb issue a breakpoint on heap_create_with_catalog() which is called by DefineRelation(). s2 #> CREATE TABLE test_schema.c2(y int); The

Re: [HACKERS] pg_comments (was: Allow \dd to show constraint comments)

2011-11-09 Thread Thom Brown
On 9 November 2011 02:42, Robert Haas wrote: > On Tue, Nov 8, 2011 at 8:12 PM, Thom Brown wrote: >> Why is this marked as done on with Wiki's todo list? > > I assume you're referring to this item: > > -- > \dd is missing comments for several types of objects.  Comments are > not handled at all fo

<    1   2