PgSql

Surprising syntax error
Marc Munro wrote: -- Start of PGP signed section. The statement: revoke all on view internal.all_objects from public; yields a syntax error. The docs show that the word "view" is not acceptable in this statement which is fine but the surprising thing is that: ? revoke all on table int... 30 Jun 2008 18:55

odd output in restore mode
Andrew Dunstan wrote: I have just been working on setting up a continuous recovery failover system, and noticed some odd log lines, shown below. (Using 8.3). First note that our parsing of recovery.conf in xlog.c is pretty bad, and at least we need to document the quirks if it's not going to be ... 28 Jul 2008 13:05

Fairly serious bug induced by latest guc enum changes
Bruce Momjian <bruce(a)momjian.us> writes: Tom Lane wrote: No, my point was that there are three possible states of sync_bit and your patch only accounted for transitions between two of 'em. Did this every get addressed? I don't see a commit for it. I thought it got fixed here: 2008-05-14 10:02 mh... 2 Jul 2008 08:48

Fairly serious bug induced by latest guc enumchanges
Tom Lane wrote: Magnus Hagander <magnus(a)hagander.net> writes: Right, but I still need the other part of the check, right? This one still fails the same check as my patch, no? Because I assume the hole you found there was that get_sync_bit() will return 0 for two different sync methods as long as ... 30 Jun 2008 16:51

Remove redundant extra_desc info for enum GUC variables?
Tom Lane wrote: Magnus Hagander <magnus(a)hagander.net> writes: Tom Lane wrote: Yeah: LOG level sorts differently in the two cases; it's fairly high priority for server log output and much lower for client output. Ok, easy fix if we break them apart. Should we continue to accept values that w... 30 Jun 2008 16:51

psql wrapped format default for backslash-dcommands
Bryce Nesbitt wrote: Brendan Jurd wrote: I really like the idea of wrapping, but after playing with the format a bit myself, I have to agree with Tom that breaking in the middle of words produces some very nasty output. If the format could be improved to only wrap on word boudaries, that... 30 Jun 2008 15:49

Fragments in tsearch2 headline
1. Respects ShortWord and MinWords 2. Uses hlCover instead of Cover 3. Does not store norm (or lexeme) for headline marking 4. Removes ts_rank.h 5. Earlier it was counting even NONWORDTOKEN in the headline. Now it only counts the actual words and excludes spaces etc. I have also changed NumFra... 23 Jul 2008 17:25

WIP patch: reducing overhead for repeat de-TOASTing
"Tom Lane" <tgl(a)sss.pgh.pa.us> writes: After playing with it for a little bit, I'm not convinced that it buys enough performance win to be worth applying --- the restriction of cache lifespan to one tuple cycle of a TupleTableSlot is awfully restrictive. (For example, sorts that involve toasted sort keys ... 3 Jul 2008 06:21

Auto-explain patch
On 6/30/08, Dean Rasheed <dean_rasheed(a)hotmail.com> wrote: This is a small patch I posted a few months back, and then kinda forgot about / got distracted with other things. Is there any interest in this? If so I am willing to put more work into it, if people like it or have suggested improvements. Ot... 2 Sep 2008 07:35

Processing database query-results piecemeal
I'm looking at the most efficient and lean way to interface with the DB in a least-overhead scenario to process large(r) amounts of binary data. For simplicity, I want to avoid using the Large-Object facility. It seems that the most efficient way to communicate with the DB would be through PQexecParams(), whic... 30 Jun 2008 07:35