[PATCHES] Sort psql output

2005-03-13 Thread Christopher Kings-Lynne
This patch makes \d on tables and views sort fk constraints, triggers and rules alphabetically in the output. This makes it the same as for indexes and stops the irritating random or reverse ordering it currently has. Chris Index: src/bin/psql/describe.c ===

Re: [PATCHES] Clean up SGML for openjade

2005-03-13 Thread Neil Conway
David Fetter wrote: Please find enclosed a patch that fixes the SGML so openjade doesn't complain :) Thanks, applied. BTW, what version of openjade are you using? I'm using 1.4devel, and it didn't complain about the markup mistakes. -Neil ---(end of broadcast)-

[PATCHES] [EMAIL PROTECTED]: Clean up SGML for openjade]

2005-03-13 Thread David Fetter
> Please find enclosed a patch that fixes the SGML so openjade doesn't > complain :) Oops. Here's one without the extra dross. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! Index: doc/src/sgml/charset.sgml

Re: [GENERAL] [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

2005-03-13 Thread Tom Lane
Bruce Momjian writes: > Ron Mayer wrote: >> My reasoning why I thought the log file was more useful was >> that only an admin with access to the log files could really >> do anything about the message anyway. > The log file is useful, but I think showing the VACUUM user is _more_ > useful than th

[PATCHES] Clean up SGML for openjade

2005-03-13 Thread David Fetter
Folks, Please find enclosed a patch that fixes the SGML so openjade doesn't complain :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ? GNUmakefile ? clean_sgml.diff ? config.log ? config.status ? upsert.diff ?

Re: [PATCHES] Cache last known per-tuple offsets to speed long tuple

2005-03-13 Thread Tom Lane
a_ogawa <[EMAIL PROTECTED]> writes: > I remaked patch for "Cache last known per-tuple offsets to speed > long tuple access" that is in TODO list. I've applied this patch with some revisions (mostly to put the functionality in places that seemed more appropriate than execQual.c). Many thanks!

Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

2005-03-13 Thread Bruce Momjian
Ron Mayer wrote: > Bruce Momjian wrote: > > > > You didn't like server_min_messages = 'notify'? > > I merely don't have a feeling for how much additional stuff > verbose would be putting in the log files. You will probably see the creation of indexes and sequences, like this: te

Re: [PATCHES] ALTER FUNCTION / STRICT

2005-03-13 Thread Neil Conway
Neil Conway wrote: Attached is a revised patch that also allows security definer and function volatility to be changed. Applied. -Neil ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] pgcrypto: openssl digest fix

2005-03-13 Thread Neil Conway
Marko Kreen wrote: The patch itself is simply "cvs diff -r1.10 -r1.11 openssl.c", so there should not be any recent typos in it. Now I also tested it with both REL7_3_STABLE and REL7_2_STABLE and found no problems. So I think its fine. I've applied both this patch and the original patch (fix-opens

[PATCHES] COPY CSV header line feature

2005-03-13 Thread Andrew Dunstan
The attached patch implements the previously discussed header line feature for CSV mode COPY. It is triggered by the keyword HEADER (blame Bruce - he chose it ;-) ). On input this feature causes the first line to be ignored; on output it generates a line of column names. This will make playing w

Re: [PATCHES] Continue transactions after errors in psql

2005-03-13 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: > I don't have a good solution, but I do think that you need to set things > up so that an application or script must invoke the new behavior > explicitly. Hidden defaults that silently change such behavior look > like land mines wai

Re: [PATCHES] pgcrypto: openssl digest fix

2005-03-13 Thread Marko Kreen
On Sun, Mar 13, 2005 at 09:43:02PM +1100, Neil Conway wrote: > Marko Kreen wrote: > >Ah, ofcourse. > > The patch seems rather large to be applying to 7.3 and 7.2 -- but it's > your contrib/ module, so I'll assume you're pretty confident this > doesn't cause any regressions... The patch itself i

Re: [PATCHES] ALTER FUNCTION / STRICT

2005-03-13 Thread Neil Conway
Tom Lane wrote: You realize of course that that can already be done with CREATE OR REPLACE FUNCTION. Good point; that makes me less wary of breaking dependencies on existing functions via ALTER, since in any case that can already be done. Incidentally, is there a reason that DROP FUNCTION doesn't

Re: [PATCHES] pgcrypto: openssl digest fix

2005-03-13 Thread Neil Conway
Marko Kreen wrote: Ah, ofcourse. The patch seems rather large to be applying to 7.3 and 7.2 -- but it's your contrib/ module, so I'll assume you're pretty confident this doesn't cause any regressions... I'll apply the patch to 7.3 and 7.2 stable branches tomorrow. -Neil -

Re: [PATCHES] default to WITHOUT OIDS

2005-03-13 Thread Neil Conway
Neil Conway wrote: This patch makes default_with_oids disabled by default, per earlier discussion, and updates the documentation accordingly. Applied. -Neil ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] pgcrypto: openssl digest fix

2005-03-13 Thread Marko Kreen
On Sun, Mar 13, 2005 at 11:12:42AM +1100, Neil Conway wrote: > Marko Kreen wrote: > >Would you apply this one aswell? I see that the original > >patch (openssl.c r1.11) applies to both branches without problems. > >It is a bit larger than this one tho'. > > Should there have been a patch attached