On Sun, Oct 12, 2014 at 2:27 PM, Stephen Frost wrote:
>
> * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> > Sawada Masahiko wrote:
> > > Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing
> > > all table of specified schema.
> > > There are syntax dose reindexing specified
On 10/10/14 21:57, Simon Riggs wrote:
Postgres currently supports column level SELECT privileges.
1. If we want to confirm a credit card number, we can issue SELECT 1
FROM customer WHERE stored_card_number = '1234 5678 5344 7733'
2. If we want to look for card fraud, we need to be able to use t
* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote:
> Sawada Masahiko wrote:
> > Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing
> > all table of specified schema.
> > There are syntax dose reindexing specified index, per table and per
> > database,
> > but we can not do rein
Ronan Dunklau writes:
> That wouldn't solve the first problem mentioned, which is that for some
> regression tests one may want to test the costs themselves, which is now
> impossible with the new planning time feature.
That's a bogus argument, because it was impossible before too. We have
no
Sawada Masahiko wrote:
> Hi all,
>
> Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing
> all table of specified schema.
> There are syntax dose reindexing specified index, per table and per database,
> but we can not do reindexing per schema for now.
It seems doubtful that th
Le dimanche 12 octobre 2014 13:17:00 Andres Freund a écrit :
> On 2014-10-12 23:13:27 +1300, David Rowley wrote:
> > On Wed, Sep 24, 2014 at 8:02 AM, Christoph Berg wrote:
> > > Re: Tom Lane 2014-09-23 <15155.1411493...@sss.pgh.pa.us>
> > >
> > > > Robert Haas writes:
> > > > > On Sat, Sep 20, 2
Hi all,
Attached WIP patch adds new syntax REINEX SCHEMA which does reindexing
all table of specified schema.
There are syntax dose reindexing specified index, per table and per database,
but we can not do reindexing per schema for now.
So we must use reindexdb command if we want to do.
This new s
On 2014-10-12 13:40, Marko Tiikkaja wrote:
> On 10/12/14, 2:36 PM, Matthew Woodcraft wrote:
>> On 2014-10-10 19:44, Kevin Grittner wrote:
>>> To restate: to do so is conflating the logical definition of the
>>> database with a particular implementation detail. As just one
>>> reason that is a bad
On 10/12/14, 2:36 PM, Matthew Woodcraft wrote:
On 2014-10-10 19:44, Kevin Grittner wrote:
To restate: to do so is conflating the logical definition of the
database with a particular implementation detail. As just one
reason that is a bad idea: we can look up unique indexes on the
specified colu
On 2014-10-10 19:44, Kevin Grittner wrote:
> Peter Geoghegan wrote:
>> People keep remarking that they don't like that you can (optionally)
>> name a unique index explicitly,
[...]
> To restate: to do so is conflating the logical definition of the
> database with a particular implementation de
2014-10-11 22:28 GMT+07:00 Tom Lane :
> Seems dangerous as heck; certainly it would have side-effects far more
> wide-ranging than just making this particular function work.
>
> A safer answer is to split array_agg into two functions,
> array_agg(anynonarray) -> anyarray
> array_ag
On 2014-10-12 23:13:27 +1300, David Rowley wrote:
> On Wed, Sep 24, 2014 at 8:02 AM, Christoph Berg wrote:
>
> > Re: Tom Lane 2014-09-23 <15155.1411493...@sss.pgh.pa.us>
> > > Robert Haas writes:
> > > > On Sat, Sep 20, 2014 at 4:13 PM, Christoph Berg wrote:
> > > >> Can we have "EXPLAIN (timin
On Wed, Sep 24, 2014 at 8:02 AM, Christoph Berg wrote:
> Re: Tom Lane 2014-09-23 <15155.1411493...@sss.pgh.pa.us>
> > Robert Haas writes:
> > > On Sat, Sep 20, 2014 at 4:13 PM, Christoph Berg wrote:
> > >> Can we have "EXPLAIN (timing off)" in 9.4+ hide the "Planning time"
> > >> line? That wou
On 2014-10-11 20:33:57 -0400, Bruce Momjian wrote:
> On Tue, Aug 12, 2014 at 07:08:06PM -0400, Robert Haas wrote:
> > On Tue, Aug 12, 2014 at 12:59 PM, Andres Freund
> > wrote:
> > > On 2014-08-12 09:42:30 -0700, Sean Chittenden wrote:
> > >> One of the patches that I've been sitting on and am de
14 matches
Mail list logo
