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
>
> Rohit Goyal 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 s
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 pgsql-hacke
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 al
On Tue, Jan 28, 2014 at 7:49 AM, Tom Lane 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 given the choic
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 ment
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
> On 01/28/2014 09:46 AM, Atri Sharma
On 28 January 2014 19:43, Stephen Frost 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 be a part
On Tue, Jan 28, 2014 at 11:28 AM, Greg Stark 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 any user-da
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
ap
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 e
On Tue, Jan 28, 2014 at 10:57 AM, Rohit Goyal 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 you added it.
On Tue, Jan 28, 2014 at 11:56 AM, Josh Berkus 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 pg_stat_replication so that I
Josh Berkus 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
hidden columns
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 o
On 01/28/2014 12:10 PM, Tom Lane wrote:
> Josh Berkus 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 s
On Jan27, 2014, at 23:28 , Dean Rasheed 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
> strict, then you kno
Greg,
* Greg Stark (st...@mit.edu) wrote:
> On Tue, Jan 28, 2014 at 11:56 AM, Josh Berkus 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 permissions.
>
Robert Haas writes:
> On Thu, Jan 9, 2014 at 11:45 PM, Tom Lane 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 problem is that you really can't d
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 wrote:
> > On Thu, Jun 27, 2013 at 10:36 AM, Josh Kupershmidt
> > wrote:
> >> On Wed, Jun 26, 2013 at 12:22 PM, Fujii Masao
> >> wrote:
> >>> Though this is a corner case, the patc
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
> Post
Christian Kruse 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 errmsg changes errno this w
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.
Inter
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 b
On 2014-01-28 16:19:11 -0500, Tom Lane wrote:
> Christian Kruse 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
>
On Tue, Jan 28, 2014 at 5:02 AM, Simon Riggs 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.
>
> I think we wou
On Thu, Jun 27, 2013 at 05:31:54PM -0400, Tom Lane wrote:
> Alvaro Herrera 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 replaces the
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 effec
On Thu, Jun 27, 2013 at 09:54:45PM -0400, Tom Lane wrote:
> Bruce Momjian 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 /* ... */ comment
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
>
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas 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 to submit to a wider
On 28 January 2014 21:37, Robert Haas wrote:
> On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas 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
> ter
On 2014-01-28 21:48:09 +, Thom Brown wrote:
> On 28 January 2014 21:37, Robert Haas wrote:
> > On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas 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
>
> 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
* 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 rec
On 28 January 2014 21:56, Andres Freund wrote:
> On 2014-01-28 21:48:09 +, Thom Brown wrote:
>> On 28 January 2014 21:37, Robert Haas wrote:
>> > On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas
>> > wrote:
>> >> I've rebased it here and am hacking on it still.
>> >
>> > Andres and I are going
On Tue, Jan 28, 2014 at 4:56 PM, Andres Freund wrote:
> On 2014-01-28 21:48:09 +, Thom Brown wrote:
> > On 28 January 2014 21:37, Robert Haas wrote:
> > > On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas
> wrote:
> > >> I've rebased it here and am hacking on it still.
> > >
> > > Andres and I a
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 of
On Tue, Jan 28, 2014 at 05:31:25PM -0500, Rod Taylor wrote:
> On Tue, Jan 28, 2014 at 4:56 PM, Andres Freund wrote:
>
> > On 2014-01-28 21:48:09 +, Thom Brown wrote:
> > > On 28 January 2014 21:37, Robert Haas wrote:
> > > > On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas
> > wrote:
> > > >> I
On Wed, Jan 15, 2014 at 10:34 AM, Robert Haas wrote:
> On Wed, Jan 15, 2014 at 1:53 AM, KONDO Mitsumasa
> wrote:
> > I create patch that can drop duplicate buffers in OS using usage_count
> > alogorithm. I have developed this patch since last summer. This feature
> seems to
> > be discussed in h
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.
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 b
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 wrote:
On Tue, Jan 28, 2014 at 11:53 AM, Robert Haas wrote:
The point of Andres's patch set is to introduce a new technology
called logical decoding; that is, the
On Wed, Jan 29, 2014 at 3:03 AM, Fujii Masao wrote:
> On Tue, Jan 28, 2014 at 3:42 AM, Fujii Masao wrote:
>> On Sat, Jan 25, 2014 at 3:19 PM, Michael Paquier
>> wrote:
>>> On Sat, Jan 25, 2014 at 5:41 AM, Fujii Masao wrote:
On Thu, Jan 23, 2014 at 4:10 PM, Michael Paquier
wrote:
On Jan28, 2014, at 19:19 , Jeff Janes 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: No connection
On Wed, Jan 29, 2014 at 3:07 AM, Alvaro Herrera
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 with pg_stat_archiver.
On Wed, Jan 29, 2014 at 10:55 AM, Fujii Masao wrote:
> On Wed, Jan 29, 2014 at 3:07 AM, Alvaro Herrera
> 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
Andres Freund 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
--
Sent via pg
On Tue, Jan 28, 2014 at 6:12 AM, Kyotaro HORIGUCHI
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 dms.c. I suppose it'd
>
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 t
Bruce Momjian 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 spent the next
On Tue, Jan 28, 2014 at 10:40:10PM -0500, Tom Lane wrote:
> Bruce Momjian 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 an
Bruce Momjian 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 cursing tha
On Tue, Jan 28, 2014 at 7:43 PM, Andreas Karlsson 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.
There's certa
On Tue, Jan 28, 2014 at 11:03 PM, Tom Lane wrote:
> Bruce Momjian 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
>>> be
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
On Tue, Jan 28, 2014 at 6:28 AM, Andres Freund 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 lwlocks be stored
On Tue, Jan 28, 2014 at 9:01 AM, salah jubeh 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 partic
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 somet
On Fri, Jan 24, 2014 at 4:38 PM, MauMau wrote:
>
>> How about below message:
>>
>> event source "" 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 it shows "DLLInstall ... s
On Tue, Jan 28, 2014 at 12:36 PM, Alvaro Herrera
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 during beta we don
On Tue, Jan 28, 2014 at 4:42 PM, Kyotaro HORIGUCHI
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 patch.
Thanks.
>
On Fri, Nov 15, 2013 at 11:47 AM, Andres Freund 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 0002-Very-basic-atomic
Robert Haas writes:
> On Tue, Jan 28, 2014 at 12:36 PM, Alvaro Herrera
> 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 in CF as needs-review, then some other
Robert Haas 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 well over 3000 comm
Kouhei Kaigai 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 inheritance relationships
KONDO Mitsumasa 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 seem to have much to do wit
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 | r
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',
> Kouhei Kaigai 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 inheritance
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_DIR
On Tue, Jan 28, 2014 at 10:51 PM, Tom Lane wrote:
> KONDO Mitsumasa 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 cac
(2014/01/29 15:51), Tom Lane wrote:
> KONDO Mitsumasa 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 stat
101 - 176 of 176 matches
Mail list logo