[PATCHES] CREATE TABLE LIKE INCLUDING INDEXES support

2007-03-06 Thread Trevor Hardcastle
Greetings all, I wrote this patch about a week ago to introduce myself to coding on PostgreSQL. I wasn't entirely sure what the 'INCLUDING INDEXES' option was meant to do, so I held off submitting it until I could get around to asking about that and tweaking the documentation to reflect the pa

Re: [PATCHES] Heap page diagnostic/test functions (WIP)

2007-03-06 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Simon Riggs" <[EMAIL PROTECTED]> writes: >> I'll return the infomasks directly, for you to manipulate. >> >> Not happy with that, but open to suggestions. > Well the alternative would be a long list of boolean columns which would make > the output kind

Re: [PATCHES] Heap page diagnostic/test functions (WIP)

2007-03-06 Thread Gregory Stark
"Simon Riggs" <[EMAIL PROTECTED]> writes: > I'll return the infomasks directly, for you to manipulate. > > Not happy with that, but open to suggestions. Well the alternative would be a long list of boolean columns which would make the output kind of long. Perhaps a function pg_decode_infomask(va

Re: [PATCHES] Heap page diagnostic/test functions (WIP)

2007-03-06 Thread Simon Riggs
On Tue, 2007-03-06 at 09:33 +0530, Pavan Deolasee wrote: > Simon Riggs wrote: > > I'll happily code it as functions or system cols or any other way, as > > long as we can see everything there is to see. > With HOT, other useful information is about the line pointers. Done > It would be > cool t

Re: [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Mike Rylander
On 3/6/07, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote: On 3/6/07, Mike Rylander <[EMAIL PROTECTED]> wrote: > Attatched you'll find a patch that I've been kicking around for a > while that I'd like to propose for inclusion in 8.3. I attempted to > submit this through the original xml2 author (

Re: [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Mike Rylander
On 3/6/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Mike Rylander wrote: > The patch adds support for default XML namespaces in xml2 by providing > a mechanism for supplying a prefix to a named namespace URI. How does it support multiple namespaces in one document? It supports one default (

Re: [PATCHES] [DOCS] doc patch for Linux memory overcommit

2007-03-06 Thread Peter Eisentraut
Toru SHIMOGAKI wrote: > The attached is a doc patch for Linux memory overcommit and an > additional way of avoiding a problem that postmaster is suddenly > killed by OOM-Killer. Patch installed. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broa

Re: [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Nikolay Samokhvalov
On 3/6/07, Mike Rylander <[EMAIL PROTECTED]> wrote: Attatched you'll find a patch that I've been kicking around for a while that I'd like to propose for inclusion in 8.3. I attempted to submit this through the original xml2 author (as far back as the 7.4 days) but got no response. It's really

Re: [PATCHES] xml2 contrib patch supporting default XML namespaces

2007-03-06 Thread Peter Eisentraut
Mike Rylander wrote: > The patch adds support for default XML namespaces in xml2 by providing > a mechanism for supplying a prefix to a named namespace URI. How does it support multiple namespaces in one document? -- Peter Eisentraut http://developer.postgresql.org/~petere/

Re: [PATCHES] [DOCS] doc patch for Linux memory overcommit

2007-03-06 Thread Peter Eisentraut
Toru SHIMOGAKI wrote: > The attached is a doc patch for Linux memory overcommit and an > additional way of avoiding a problem that postmaster is suddenly > killed by OOM-Killer. The text needs some articles. -- Peter Eisentraut http://developer.postgresql.org/~petere/ --

[PATCHES] doc patch for Linux memory overcommit

2007-03-06 Thread Toru SHIMOGAKI
The attached is a doc patch for Linux memory overcommit and an additional way of avoiding a problem that postmaster is suddenly killed by OOM-Killer. http://archives.postgresql.org/pgsql-docs/2007-03/msg0.php Best regards, -- Toru SHIMOGAKI<[EMAIL PROTECTED]> *** runtime.sgml.orig 2007-0