PgSql
in [SQL]
|
[HACKERS] Parallel pg_restore versus old dump files I've dug into the problem reported by Igor Neyman: http://archives.postgresql.org/pgsql-admin/2010-06/msg00148.php Unlike previous complainants, Igor was kind enough to supply a pg_dump archive file that triggers the problem. What I find is that his dump file contains no data offsets, ie, dataState == K_OFFSET_POS... 22 Jun 2010 17:09
TCP keepalive support for libpq On Mon, Feb 15, 2010 at 8:58 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Tue, Feb 16, 2010 at 1:18 AM, Robert Haas <robertmhaas(a)gmail.com> wrote: I'm all for this as a 9.1 submission, but let's not commit to trying to debug it now. �I would like a green buildfarm for awhile before we wrap alpha4... 24 Jun 2010 10:44
what exactly is a PlaceHolderVar? Robert Haas <robertmhaas(a)gmail.com> writes: ...but I'm still having a hard time wrapping my head around it. The fundamental point is to be able to force a value to go to NULL when outer-join logic says it ought to. Consider CREATE VIEW foo AS SELECT x,y,'zed' FROM bar; SELECT * FROM baz LEFT JOIN foo ON... 22 Jun 2010 00:41
[HACKERS] missing "else" in postmaster.c? In pmdie(), we have the following code, which doesn't seem to make much sense. If the state is PM_RECOVERY at the top of this section it will get changed to PM_WAIT_BACKENDS and then to PM_WAIT_BACKENDS again. Either the two "if" statements should be merged (and both bits should be handled with the same block of ... 21 Jun 2010 23:36
[HACKERS] what exactly is a PlaceHolderVar? I can't find any good documentation of this in the source tree anywhere. placeholder.c just says: * PlaceHolderVar and PlaceHolderInfo manipulation routines and placeholder.h says: * prototypes for optimizer/util/placeholder.c. ....which is less than informative. The commit message that i... 21 Jun 2010 16:55
[HACKERS] deprecating =>, take two By consensus, we have removed the new-to-9.0 operator text[] => text[] and renamed the hstore => text[] operator. (The current name is "%", but there is some discussion of "%>", some yet other name, or getting rid of it altogether; please comment on that thread if you wish to weigh in.) This means that the only r... 21 Jun 2010 15:48
[HACKERS] Cannot cancel the change of a tablespace Hi, Today, I tried to cancel the change of a tablespace for a table (ALTER TABLE ... SET TABLESPACE). I got the "Cancel request sent" but the query continued and finally succeed. It was a big issue for my customer, and I wanted to look more into that issue. So, I got a look at the source code and found we didn't... 21 Jun 2010 13:34
[HACKERS] Upgrade procedure for 9.0 with HS/SR ... ? What is the recommended procedure for this? For instance, normally I would do a dump, upgrade, reload, when dealing with a single server, just to make sure all my system tables and such are clean ... but, if I have HS/SR setup to a slave, what is the recommended method of doing an upgrade? This will be of... 21 Jun 2010 13:34
deprecating =>, take two Excerpts from Robert Haas's message of lun jun 21 12:20:59 -0400 2010: Barring vigorous objections, I will apply these tomorrow so that we can consider deprecating => as an operator name in 9.1, for better compliance with the SQL standard. Maybe this is just a matter of semantics, but I thought we were go... 21 Jun 2010 15:48
Patch: psql \whoami option On Sun, Jun 20, 2010 at 10:51 PM, Steve Singer <ssinger_pg(a)sympatico.ca> wrote: One comment I have on the output format is that values (ie the database name) are enclosed in double quotes but the values being quoted can contain double quotes that are not being escaped. � For example Connected to database... 18 Jul 2010 22:25 |