PgSql

pgsql: Ensure that top level aborts call XLogSetAsyncCommit().
On Thu, May 13, 2010 at 8:39 PM, Simon Riggs <sriggs(a)postgresql.org> wrote: Log Message: ----------- Ensure that top level aborts call XLogSetAsyncCommit(). Not doing so simply leads to data waiting in wal_buffers which then causes later commits to potentially do emergency writes and for all forms of ... 31 May 2010 08:40

pgsql: In walsender, don't sleep if there's outstandingWAL waiting to
On 31/05/10 13:20, Fujii Masao wrote: On Mon, May 31, 2010 at 7:03 PM, Fujii Masao<masao.fujii(a)gmail.com> wrote: This commit seems to have introduced the bug that walsender exits before sending all the WAL up to shutdown checkpoint record when smart shutdown is requested. The attached patch fixe... 31 May 2010 07:35

pgsql: In walsender, don't sleep if there's outstanding WAL waiting to
Hi, On Thu, May 27, 2010 at 7:21 AM, Heikki Linnakangas <heikki(a)postgresql.org> wrote: Log Message: ----------- In walsender, don't sleep if there's outstanding WAL waiting to be sent, otherwise we effectively rate-limit the streaming as pointed out by Simon Riggs. Also, send the WAL in smaller chunk... 31 May 2010 06:31

[HACKERS] server authentication over Unix-domain sockets
It has been discussed several times in the past that there is no way for a client to authenticate a server over Unix-domain sockets. So depending on circumstances, a local user could easily insert his own server and collect passwords and data. Suggestions for possible remedies included: You can put the socket ... 30 May 2010 12:11

Is there anyway to get list of table name, before raw parser is analyze?
Mohammad Heykal Abdillah <heykal.abdillah(a)gmail.com> writes: Yes that i know, expanding '*' is done in analyzer part. I am try to do is, move the expanding process to "before" raw_parser that produce by gram.y is processed by analyzer. Like this : sql query -> gram.y -> raw_parse_tree -> (expand the '*') ... 30 May 2010 12:11

dividing money by money
Andy Balholm wrote: On May 26, 2010, at 11:18 AM, Kevin Grittner wrote: Do you want to package this up as a patch for 9.1? If not, is it OK if I do? I'm not quite sure how to go about changing it from an add-on function to a built-in one. So if you want to do that, go ahead. If you'd rather I di... 18 Jul 2010 11:36

Winflex
Magnus Hagander wrote: Using http://www.postgresql.org/ftp/misc/winflex/ on a 64-bit windows, but in 32-bit mode (this certainly used to work), trying to build HEAD. first of all, it returns error code 128 when running "flex -V", which means our script claims it doesn't work. Commenting out ... 30 May 2010 10:01

Is there anyway to get list of table name, before rawparser is analyze?
Mohammad Heykal Abdillah wrote: Hi all, Right now i am trying to understand how SQL parser is work. My question is there anyway to get list of table name and its atribut before raw parser is analyze? Because i like to understand how PostgreSQL "break-down" the asterik at target list, spe... 30 May 2010 08:57

[HACKERS] Is there anyway to get list of table name, before raw parser isanalyze?
Hi all, Right now i am trying to understand how SQL parser is work. My question is there anyway to get list of table name and its atribut before raw parser is analyze? Because i like to understand how PostgreSQL "break-down" the asterik at target list, specialy in "natural join" case where PostgreSQL can gi... 30 May 2010 02:35

Is there anyway to get list of table name, beforeraw parser is analyze?
On Min, 2010-05-30 at 00:44 -0400, Andrew Dunstan wrote: Mohammad Heykal Abdillah wrote: Hi all, Right now i am trying to understand how SQL parser is work. My question is there anyway to get list of table name and its atribut before raw parser is analyze? Because i like... 30 May 2010 10:01