PgSql

Nice hint on table aliasing!
Josh Berkus wrote: All, Not sure when this happened, but someone added a very informative hint for the case where you ambiguously refer to a base table name when you needed to refer to the alias. Nice work, we should do more of this helpful hinting. I agree. I see this hint was added in Postgres... 13 Apr 2010 20:42

How to generate specific WAL records?
Koichi Suzuki escribi�: Hi, Does anyone know how to generate the following WAL records from psql? I'm now fixing pg_lesslog, which I reported a bug. Now code is almost okay and I'd like to add test tools to show pg_lesslog can handle all the WAL record correctly. XLOG_MULTIXACT_ZERO_OFF_... 18 Apr 2010 20:50

[HACKERS] hash indexes and HS was:(Re: [HACKERS] testing hot standby)
On Mon, Apr 12, 2010 at 1:23 AM, Jaime Casanova <jcasanov(a)systemguards.com.ec> wrote: another point, what happened with this: http://archives.postgresql.org/message-id/1229549172.4793.105.camel(a)ebony..2ndQuadrant? Obviously we still have the problem with hash indexes, and in that thread Tom advice was j... 13 Apr 2010 12:49

[HACKERS] Timezone matching script (win32)
I'm breaking this out to a separate email thread, since i think the original question may hvae been lost in the "I've applied this patch" part that made people ignore it at the end of a long thread ;) There are usually people who have thoughts about this kind of thing :-) So, thoughts/suggestions on location? - ... 13 Apr 2010 08:21

[HACKERS] How to generate specific WAL records?
Hi, Does anyone know how to generate the following WAL records from psql? I'm now fixing pg_lesslog, which I reported a bug. Now code is almost okay and I'd like to add test tools to show pg_lesslog can handle all the WAL record correctly. XLOG_MULTIXACT_ZERO_OFF_PAGE XLOG_MULTIXACT_ZERO_MEM_PAGE XLOG_MU... 13 Apr 2010 08:21

non-reproducible failure of random test on HEAD
"Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> writes: I got a failure on the random test. This used to be common. Peter tweaked the test a few years ago to reduce the probability of failure, but IIRC it's still not zero (and probably can't be made zero without rendering the test meaningless). I think most li... 13 Apr 2010 02:56

debugger question
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Mon, Apr 12, 2010 at 08:31:38PM -0700, Murali M. Krishna wrote: Hello: I am brand new to Postgresql. I ran the following commands. ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /us... 13 Apr 2010 04:00

[HACKERS] Naming of new EXCLUDE constraints
Simon Riggs wrote: On Sun, 2010-04-04 at 22:12 -0400, Bruce Momjian wrote: Simon Riggs wrote: How about we call it "exclusivity constraints". Not much of a change, but helps to differentiate. Well, the keyword is EXCLUDE so we could call it "EXCLUDE contraints". I... 12 Apr 2010 22:34

ECPG check variables hidden by locals v2
FYI, I think Michael Meskes applied this patch, though I didn't see you emailed that it was applied. --------------------------------------------------------------------------- Boszormenyi Zoltan wrote: Hi, here's a little beautified patch: - more logical parameter order in ECPGdump_a_type() - ... 13 Apr 2010 00:47

[HACKERS] non-reproducible failure of random test on HEAD
I just did a checkout from HEAD (a few minutes ago) and ran this: make distclean ; ./configure --prefix=/usr/local/pgsql-serializable --enable-integer-datetimes --enable-debug --enable-cassert --enable-depend --with-libxml && make check I got a failure on the random test. Unfortunately I didn't check the lo... 12 Apr 2010 12:32