On 01/28/2014 10:29 AM, Merlin Moncure wrote:
In addition to this, the JSON vs JSONB datatype page really needs
expansion and clarification.
right: exactly. I'd be happy to help (such as I can) ...I wanted to
see if jsonb to make it in on this 'fest (doc issues notwithstanding);
it hasn't
Rohit Goyal rhtgyl...@gmail.com writes:
Hi All,
I was trying to modify indextupledata structure by adding an integer
variable. ButI faced an error message psql: FATAL: could not find
tuple
for opclass 10032.
Could anyone please help me in resolving this issue.
You broke a system
Josh Berkus escribió:
Or is this just about whitespace and line breaks?
If the docs are going to be rehauled, please ignore my whitespace
comments.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via
On 01/28/2014 10:56 AM, Alvaro Herrera wrote:
Josh Berkus escribió:
Or is this just about whitespace and line breaks?
If the docs are going to be rehauled, please ignore my whitespace
comments.
I'm sure you'll find plenty to criticize in my version. ;-)
--
Josh Berkus
PostgreSQL
I've written a variant of regexp_matches called regexp_matches_positions
which instead of returning matching substrings will return matching
positions. I found use of this when processing OCR scanned text and wanted
to prioritize matches based on their position.
The patch is for discussion. I'd
On Tue, Jan 28, 2014 at 7:49 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Oh really. So, to clean up after their own ill-considered decision,
they'd like to take useful information away from everybody.
Well maybe. Or we want this useful information at a finer granularity
than everyone or nobody and
Thom,
* Thom Brown (t...@linux.com) wrote:
Application to Google Summer of Code 2014 can be made as of next
Monday (3rd Feb), and then there will be a 12 day window in which to
submit an application.
This is just for PG to be a participating organization, right? There's
a while before
Hi all,
I'd very interesting in taking part in the GSoC with PostgreSQL, as a
student.
Being quite busy at the moment (exam time), I haven't had time to think of
a subject yet, even though I could see some topics I found interesting.
2014-01-28 Josh Berkus j...@agliodbs.com
On 01/28/2014 09:46
On 28 January 2014 19:43, Stephen Frost sfr...@snowman.net wrote:
Thom,
* Thom Brown (t...@linux.com) wrote:
Application to Google Summer of Code 2014 can be made as of next
Monday (3rd Feb), and then there will be a 12 day window in which to
submit an application.
This is just for PG to
On Tue, Jan 28, 2014 at 11:28 AM, Greg Stark st...@mit.edu wrote:
Well maybe. Or we want this useful information at a finer granularity
than everyone or nobody and given the choice we prefer to have it
than not.
Anyways, I don't feel incredibly strongly about this. I think we
should default
On 01/28/2014 07:27 AM, Greg Stark wrote:
Why is application_name useful for users who aren't the DBA and aren't
the user in question. The sql_query would probably be more useful than
application_name but we hide that...
I have non-privileged monitoring scripts do counts of connections by
On Tue, Jan 28, 2014 at 06:53:32PM +0900, Kyotaro HORIGUCHI wrote:
Hello, Thank you, and I' sorry to have kept you waiting.
No hurry.
The attached two patches are rebased to current 9.4dev HEAD and
make check at the topmost directory and src/test/isolation are
passed without error. One
On Tue, Jan 28, 2014 at 10:57 AM, Rohit Goyal rhtgyl...@gmail.com wrote:
Hello,
I started all the process again and configured my eclipse with raw
postgresql code. First change i made in the code is
I added *int i; *in indextupleData structure in itup.h.
You should show us *exactly* where
On Tue, Jan 28, 2014 at 11:56 AM, Josh Berkus j...@agliodbs.com wrote:
Really the only way we're going to solve this is to make column
permissions on special system views fully configurable.
For example, I would really like to GRANT an unpriv user access to the
WAL columns in
Josh Berkus j...@agliodbs.com writes:
For example, I would really like to GRANT an unpriv user access to the
WAL columns in pg_stat_replication so that I can monitor replication
delay without granting superuser permissions.
Just out of curiosity, why is that superuser-only at all? AFAICS the
Josh,
* Josh Berkus (j...@agliodbs.com) wrote:
Really the only way we're going to solve this is to make column
permissions on special system views fully configurable.
We really need to fully support column and row-level security to provide
the kind of granularty which we do today (but force on
On 01/28/2014 12:10 PM, Tom Lane wrote:
Josh Berkus j...@agliodbs.com writes:
For example, I would really like to GRANT an unpriv user access to the
WAL columns in pg_stat_replication so that I can monitor replication
delay without granting superuser permissions.
Just out of curiosity, why
On Jan27, 2014, at 23:28 , Dean Rasheed dean.a.rash...@gmail.com wrote:
strict transfn vs non-strict inv_transfn
This case is explicitly forbidden, both in CREATE AGGREGATE and in the
executor. To me, that seems overly restrictive --- if transfn is
Greg,
* Greg Stark (st...@mit.edu) wrote:
On Tue, Jan 28, 2014 at 11:56 AM, Josh Berkus j...@agliodbs.com wrote:
For example, I would really like to GRANT an unpriv user access to the
WAL columns in pg_stat_replication so that I can monitor replication
delay without granting superuser
Robert Haas robertmh...@gmail.com writes:
On Thu, Jan 9, 2014 at 11:45 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Uh, no, wasn't my suggestion. Doesn't that design imply measuring *every*
planning cycle, explain or no? I was thinking more of just putting the
timing calls into explain.c.
The
On 01/28/2014 01:22 PM, Alvaro Herrera wrote:
Josh Berkus wrote:
On 01/27/2014 01:06 PM, Alvaro Herrera wrote:
Andrew Dunstan escribió:
I'm not sure I understand the need. This is the difference between
the _text variants and their parents. Why would you call
json_object_field when you want
On Mon, Jul 1, 2013 at 08:10:14PM -0400, Josh Kupershmidt wrote:
On Thu, Jun 27, 2013 at 11:47 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Thu, Jun 27, 2013 at 10:36 AM, Josh Kupershmidt schmi...@gmail.com
wrote:
On Wed, Jun 26, 2013 at 12:22 PM, Fujii Masao masao.fu...@gmail.com
Hi,
On 28/01/14 16:43, Christian Kruse wrote:
ereport(FATAL,
(errmsg(could not map anonymous shared memory:
%m),
(errno == ENOMEM) ?
errhint(This error usually means that
PostgreSQL's
Christian Kruse christ...@2ndquadrant.com writes:
According to http://llvm.org/bugs/show_bug.cgi?id=18644#c5 this is not
a compiler bug but a difference between gcc and clang. Clang seems to
use a left-to-right order of evaluation while gcc uses a right-to-left
order of evaluation. So if
Björn Harrtell wrote:
I've written a variant of regexp_matches called regexp_matches_positions
which instead of returning matching substrings will return matching
positions. I found use of this when processing OCR scanned text and wanted
to prioritize matches based on their position.
I realize Postgres’ codebase is probably intractably large to begin using a
tool like splint (http://www.splint.org ), but this is exactly the sort of
thing it’ll catch. I’m pretty sure it would have warned in this case that the
code relies on an ordering of side effects that is left undefined
On 2014-01-28 16:19:11 -0500, Tom Lane wrote:
Christian Kruse christ...@2ndquadrant.com writes:
According to http://llvm.org/bugs/show_bug.cgi?id=18644#c5 this is not
a compiler bug but a difference between gcc and clang. Clang seems to
use a left-to-right order of evaluation while gcc uses
On Tue, Jan 28, 2014 at 5:02 AM, Simon Riggs si...@2ndquadrant.com wrote:
I agree that this is being seen the wrong way around. The planner
contains things it should not do, and as a result we are now
discussing enhancing the code that is in the wrong place, which of
course brings objections.
On Thu, Jun 27, 2013 at 05:31:54PM -0400, Tom Lane wrote:
Alvaro Herrera alvhe...@2ndquadrant.com writes:
Noah Misch wrote:
Note that emacs and pgindent remain at odds over interior tabs in comments.
When pgindent finds a double-space (typically after a sentence) ending at a
tab stop, it
Jason Petersen wrote:
I realize Postgres’ codebase is probably intractably large to begin
using a tool like splint (http://www.splint.org ), but this is exactly
the sort of thing it’ll catch. I’m pretty sure it would have warned in
this case that the code relies on an ordering of side effects
On Thu, Jun 27, 2013 at 09:54:45PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Should we be using entab -s 3?
IIUC, that wouldn't affect leading whitespace at all. What it would
affect I think (outside of comment blocks) is whitespace between code
and a same-line /* ...
On 2014-01-28 18:31:59 -0300, Alvaro Herrera wrote:
Jason Petersen wrote:
I realize Postgres’ codebase is probably intractably large to begin
using a tool like splint (http://www.splint.org ), but this is exactly
the sort of thing it’ll catch. I’m pretty sure it would have warned in
this
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com wrote:
I've rebased it here and am hacking on it still.
Andres and I are going back and forth between our respective git repos
hacking on this, and I think we're getting there, but I have a
terminological question which I'd like
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com wrote:
I've rebased it here and am hacking on it still.
Andres and I are going back and forth between our respective git repos
hacking on this, and I think
On 2014-01-28 21:48:09 +, Thom Brown wrote:
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com wrote:
I've rebased it here and am hacking on it still.
Andres and I are going back and forth between our
Hello,
I started all the process again and configured my eclipse with raw
postgresql code. First change i made in the code is
I added *int i; *in indextupleData structure in itup.h.
You should show us *exactly* where you added it. (Doing so is what diff
was developed for, so please use
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
Well, we already have Coverity reports and the VIVA64 stuff posted last
month. Did they not see these problems? Maybe they did, maybe not, but
since there's a large number of false positives it's hard to tell. I
don't know how many false
Hi Andrew,
On 1/24/14, 7:26 PM, Andrew Dunstan wrote:
OK, here's the patch, this time with docs, thanks to Merlin Moncure and
Josh Berkus for help with that.
Thanks, this one is looking pretty good. A couple of small issues:
- The oid 3195 of json_object_agg_transfn has been taken by a
On 28 January 2014 21:56, Andres Freund and...@2ndquadrant.com wrote:
On 2014-01-28 21:48:09 +, Thom Brown wrote:
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com
wrote:
I've rebased it here and am
On Tue, Jan 28, 2014 at 4:56 PM, Andres Freund and...@2ndquadrant.comwrote:
On 2014-01-28 21:48:09 +, Thom Brown wrote:
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com
wrote:
I've rebased it here
On 01/28/2014 05:07 PM, Marko Tiikkaja wrote:
Hi Andrew,
On 1/24/14, 7:26 PM, Andrew Dunstan wrote:
OK, here's the patch, this time with docs, thanks to Merlin Moncure and
Josh Berkus for help with that.
Thanks, this one is looking pretty good. A couple of small issues:
- The oid 3195
On Tue, Jan 28, 2014 at 05:31:25PM -0500, Rod Taylor wrote:
On Tue, Jan 28, 2014 at 4:56 PM, Andres Freund and...@2ndquadrant.comwrote:
On 2014-01-28 21:48:09 +, Thom Brown wrote:
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM,
On Wed, Jan 15, 2014 at 10:34 AM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Jan 15, 2014 at 1:53 AM, KONDO Mitsumasa
kondo.mitsum...@lab.ntt.co.jp wrote:
I create patch that can drop duplicate buffers in OS using usage_count
alogorithm. I have developed this patch since last summer.
Stephen Frost wrote:
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
Well, we already have Coverity reports and the VIVA64 stuff posted last
month. Did they not see these problems? Maybe they did, maybe not, but
since there's a large number of false positives it's hard to tell. I
Bruce Momjian wrote:
I see I already asked about entab -s 3. Let me see how hard it would be
to modify entab.
I cannot tell you what to waste your time on, of course, but I wonder if
it'd be better spent trying to make something like astyle work for us.
The entab/pg_bsd_indent combo is a bit
On 01/28/2014 10:56 PM, Andres Freund wrote:
On 2014-01-28 21:48:09 +, Thom Brown wrote:
On 28 January 2014 21:37, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas robertmh...@gmail.com wrote:
The point of Andres's patch set is to introduce a new
On Wed, Jan 29, 2014 at 3:03 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Tue, Jan 28, 2014 at 3:42 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Sat, Jan 25, 2014 at 3:19 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Sat, Jan 25, 2014 at 5:41 AM, Fujii Masao
On Jan28, 2014, at 19:19 , Jeff Janes jeff.ja...@gmail.com wrote:
On windows, if the client gets terminated while sending data to the server,
in a
COPY for example, it results in some rather head-scratcher messages in the
server
log, for example:
LOG: could not receive data from client:
On Wed, Jan 29, 2014 at 3:07 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Anybody knows about this patch?
http://www.postgresql.org/message-id/508dfec9.4020...@uptime.jp
Though I'm not sure whether Nagayasu is still working on that patch,
it's worth thinking to introduce that together
On Wed, Jan 29, 2014 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Jan 29, 2014 at 3:07 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Anybody knows about this patch?
http://www.postgresql.org/message-id/508dfec9.4020...@uptime.jp
Though I'm not sure whether Nagayasu is
Andres Freund and...@2ndquadrant.com writes:
Absolutely. Probably best to save errno into a local just before the
ereport.
I think just resetting to edata-saved_errno is better and sufficient?
-1 --- that field is nobody's business except elog.c's.
regards, tom lane
On Tue, Jan 28, 2014 at 6:12 AM, Kyotaro HORIGUCHI
horiguchi.kyot...@lab.ntt.co.jp wrote:
I had a short look on this patch.
- DSM implimentation seems divided into generic part (dsm.c) and
platform dependent part(dsm_impl.c). This dsm_keep_segment
puts WIN32 specific part directly into
On Tue, Jan 28, 2014 at 06:39:43PM -0300, Alvaro Herrera wrote:
Bruce Momjian wrote:
I see I already asked about entab -s 3. Let me see how hard it would be
to modify entab.
I cannot tell you what to waste your time on, of course, but I wonder if
it'd be better spent trying to make
Bruce Momjian br...@momjian.us writes:
I see I already asked about entab -s 3. Let me see how hard it would be
to modify entab.
TBH I'm not sure we should be changing pgindent at this late date, even if
there is a good fix for its minor annoyances. When you changed its wrap
behavior in 8.1, I
On Tue, Jan 28, 2014 at 10:40:10PM -0500, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
I see I already asked about entab -s 3. Let me see how hard it would be
to modify entab.
TBH I'm not sure we should be changing pgindent at this late date, even if
there is a good fix for its
Bruce Momjian br...@momjian.us writes:
On Tue, Jan 28, 2014 at 10:40:10PM -0500, Tom Lane wrote:
TBH I'm not sure we should be changing pgindent at this late date, even if
there is a good fix for its minor annoyances. When you changed its wrap
behavior in 8.1, I spent the next several years
On Tue, Jan 28, 2014 at 7:43 PM, Andreas Karlsson andr...@proxel.se wrote:
I think physical and logical are fine and they seem to be well known
terminology. Oracle uses those words and I have also seen many places use
physical backup and logical backup, for example on Barman's homepage.
On Tue, Jan 28, 2014 at 11:03 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Bruce Momjian br...@momjian.us writes:
On Tue, Jan 28, 2014 at 10:40:10PM -0500, Tom Lane wrote:
TBH I'm not sure we should be changing pgindent at this late date, even if
there is a good fix for its minor annoyances. When
Alvaro Herrera-9 wrote
Björn Harrtell wrote:
I've written a variant of regexp_matches called regexp_matches_positions
which instead of returning matching substrings will return matching
positions. I found use of this when processing OCR scanned text and
wanted
to prioritize matches based on
On Tue, Jan 28, 2014 at 6:28 AM, Andres Freund and...@2ndquadrant.com wrote:
On 2014-01-28 09:13:15 +, Rajeev rastogi wrote:
I observed below WIN32 compilation warnings in postmaster.c (seems
introduced by commit ea9df812d8502fff74e7bc37d61bdc7d66d77a7f Relax the
requirement that all
On Tue, Jan 28, 2014 at 9:01 AM, salah jubeh s_ju...@yahoo.com wrote:
Hello Sawada,
- This patch is not patched to master branch
Sorry, My mistake
//new connections are not allowed
Corrected.
I hope now the patch in better state, if somthing left, I will be glad to
fix it
Regards
I'm not
On 2014-01-28 18:39:43 -0300, Alvaro Herrera wrote:
Bruce Momjian wrote:
I see I already asked about entab -s 3. Let me see how hard it would be
to modify entab.
I cannot tell you what to waste your time on, of course, but I wonder if
it'd be better spent trying to make something like
On Fri, Jan 24, 2014 at 4:38 PM, MauMau maumau...@gmail.com wrote:
How about below message:
event source event_source_name is already registered.
OK, I added several lines for this. Please check the attached patch.
It gives the proper message, but even after error, the second message
box
On Tue, Jan 28, 2014 at 12:36 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Bruce Momjian escribió:
I have no problem removing the parameter if required to. In that case,
I would like to leave the parameter in until mid beta, to allow
greater certainty.
Uhm. If we remove a GUC
On Tue, Jan 28, 2014 at 4:42 PM, Kyotaro HORIGUCHI
horiguchi.kyot...@lab.ntt.co.jp wrote:
Hello,
Currently there is no way user can keep the dsm
segments if he wants for postmaster lifetime, so I
have exposed a new API dsm_keep_segment()
to implement the same.
I had a short look on this
On Fri, Nov 15, 2013 at 11:47 AM, Andres Freund and...@2ndquadrant.com wrote:
1) I've added an abstracted atomic ops implementation. Needs a fair
amount of work, also submitted as a separate CF entry. (Patch 1 2)
Commit 220b34331f77effdb46798ddd7cca0cffc1b2858 caused bitrot when
applying
Robert Haas robertmh...@gmail.com writes:
On Tue, Jan 28, 2014 at 12:36 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Honestly, I would prefer that we push a patch that has been thoroughly
reviewed and in which we have more confidence, so that we can push
without a GUC. This means mark
Robert Haas robertmh...@gmail.com writes:
If this only affects a handful of places, then sure, let's go ahead
and fix it. But if it's going to create a massive enough diff that
we've gotta think about back-patching it, then IMHO it's totally not
worth it.
A quick grep search says there are
Kouhei Kaigai kai...@ak.jp.nec.com writes:
Let me ask an elemental question. What is the reason why inheritance
expansion logic should be located on the planner stage, not on the tail
of rewriter?
I think it's mostly historical. You would however have to think of a
way to preserve the
KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp writes:
By the way, latest pg_stat_statement might affect performance in Windows
system.
Because it uses fflush() system call every creating new entry in
pg_stat_statements, and it calls many fread() to warm file cache.
This statement doesn't
On Wed, January 29, 2014 05:16, David Johnston wrote:
How does this resolve in the patch?
SELECT regexp_matches('abcabc','((a)(b)(c))','g');
With the patch:
testdb=# SELECT regexp_matches('abcabc','((a)(b)(c))','g'),
regexp_matches_positions('abcabc','((a)(b)(c))');
regexp_matches |
Erik Rijkers wrote
On Wed, January 29, 2014 05:16, David Johnston wrote:
How does this resolve in the patch?
SELECT regexp_matches('abcabc','((a)(b)(c))','g');
With the patch:
testdb=# SELECT regexp_matches('abcabc','((a)(b)(c))','g'),
regexp_matches_positions('abcabc','((a)(b)(c))');
Kouhei Kaigai kai...@ak.jp.nec.com writes:
Let me ask an elemental question. What is the reason why inheritance
expansion logic should be located on the planner stage, not on the
tail of rewriter?
I think it's mostly historical. You would however have to think of a way
to preserve the
Hi,
Attached is latest patch.
I change little bit at PinBuffer() in bufmgr.c. It will evict target clean file
cache in OS more exactly.
- if (!(buf-flags BM_FADVED) !(buf-flags BM_JUST_DIRTIED))
+ if (!(buf-flags BM_DIRTY) !(buf-flags BM_FADVED) !(buf-flags
BM_JUST_DIRTIED))
On Tue, Jan 28, 2014 at 10:51 PM, Tom Lane t...@sss.pgh.pa.us wrote:
KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp writes:
By the way, latest pg_stat_statement might affect performance in Windows
system.
Because it uses fflush() system call every creating new entry in
pg_stat_statements, and
(2014/01/29 15:51), Tom Lane wrote:
KONDO Mitsumasa kondo.mitsum...@lab.ntt.co.jp writes:
By the way, latest pg_stat_statement might affect performance in Windows
system.
Because it uses fflush() system call every creating new entry in
pg_stat_statements, and it calls many fread() to warm
101 - 176 of 176 matches
Mail list logo