Re: [HACKERS] plpgsql versus domains

2015-02-28 Thread Andrew Gierth
> "Tom" == Tom Lane writes: Tom> This is the first attempt at weaponizing the memory context Tom> reset/delete feature, and I'm fairly happy with it, except for one Tom> thing: I had to #include utils/memnodes.h into typcache.h in order Tom> to preserve the intended property that the call

Re: [HACKERS] rm static libraries before rebuilding

2015-02-28 Thread Tom Lane
Noah Misch writes: > We build static libraries with "ar crs" or "ar cr". If the static library > already exists in the build directory, those commands will add new members and > replace existing members. They will not remove members present in the > existing library but not named on the "ar" com

[HACKERS] rm static libraries before rebuilding

2015-02-28 Thread Noah Misch
We build static libraries with "ar crs" or "ar cr". If the static library already exists in the build directory, those commands will add new members and replace existing members. They will not remove members present in the existing library but not named on the "ar" command line. This matters whe

Re: [HACKERS] plpgsql versus domains

2015-02-28 Thread Tom Lane
Andres Freund writes: > On 2015-02-26 13:53:18 -0500, Tom Lane wrote: >> Andres Freund writes: >>> You're probably going to kill me because of the increased complexity, >>> but how about making typecache.c smarter, more in the vein of >>> relcache.c, and store the relevant info in there? >> I th

Re: [HACKERS] Additional role attributes && superuser review

2015-02-28 Thread Stephen Frost
Adam, * Adam Brightwell (adam.brightw...@crunchydatasolutions.com) wrote: > I have attached and updated patch for review. Thanks! I've gone over this and made quite a few documentation and comment updates, but not too much else, so I'm pretty happy with how this is coming along. As mentioned el

Re: [HACKERS] CATUPDATE confusion?

2015-02-28 Thread Stephen Frost
Peter, * Peter Eisentraut (pete...@gmx.net) wrote: > On 2/25/15 10:05 PM, Stephen Frost wrote: > > Agreed, but I'd also like to get rid of any reason, beyond emergency > > cases, for people to modify the catalog directly. There's a few places > > which we aren't yet doing that, but I'd rather fix

Re: [HACKERS] Streaming replication and WAL archive interactions

2015-02-28 Thread Venkata Balaji N
> > > Here's a first cut at this. It includes the changes from your > standby_wal_archiving_v1.patch, so you get that behaviour if you set > archive_mode='always', and the new behaviour I wanted with > archive_mode='shared'. I wrote it on top of the other patch I posted > recently to not archive bo

Re: [HACKERS] CATUPDATE confusion?

2015-02-28 Thread Peter Eisentraut
On 2/25/15 10:05 PM, Stephen Frost wrote: > * Peter Eisentraut (pete...@gmx.net) wrote: >> On 2/25/15 3:39 PM, Stephen Frost wrote: I'd get rid of that whole check, not just replace rolcatupdate by rolsuper. >>> >>> Err, wouldn't this make it possible to grant normal users the ability to >>> m

[HACKERS] Looking for Intro to Hacking teacher for pgCon

2015-02-28 Thread Josh Berkus
Hackers: The pgCon committee would like to have someone give some kind of "Intro to Hacking" tutorial at pgCon this year, on the Advanced Tutorial Saturday. Since there will be lots of power users and other potential contributors at the conference, it seems like an opportunity not to be missed.

Re: [HACKERS] GSoC idea - Simulated annealing to search for query plans

2015-02-28 Thread Grzegorz Parka
Thank you a lot for your feedback. I searched a lot about GEQO, but I didn't find information about any earlier attempts. I'm happy to know that this is important for Postgres. I'm really interested in this project, so I just need to estimate if I can handle it. Now I will spend some time with SAI

Re: [HACKERS] Enforce creation of destination folders for source files in pg_regress (Was: pg_regress writes into source tree)

2015-02-28 Thread Stephen Frost
* Michael Paquier (michael.paqu...@gmail.com) wrote: > On Wed, Feb 25, 2015 at 4:27 AM, Peter Eisentraut wrote: > > On 2/23/15 1:27 AM, Michael Paquier wrote: > >>> I would like to have an extension in tree that also does this, so we > >>> > have a regression test of this functionality. > >> Sure.

Re: [HACKERS] add modulo (%) operator to pgbench

2015-02-28 Thread Stephen Frost
* Fabien COELHO (coe...@cri.ensmp.fr) wrote: > > >On Mon, Jan 5, 2015 at 10:37 AM, Fabien COELHO wrote: > >>Anyway, I suggest to keep that for another round and keep the Robert's > >>isofunctional patch as it is before extending. > > > >+1. Let's please get the basic thing committed, and then pe

Re: [HACKERS] star schema and the optimizer

2015-02-28 Thread Tom Lane
Marc Cousin writes: > I gave it another look this morning. It works very well with the initial test > schema. The situation is much improved for me. > I still have one issue: I've extended the test to more than 2 dimensions. I tried your original test script with 3 dimension tables, and it gave

Re: [HACKERS] Bug in pg_dump

2015-02-28 Thread Stephen Frost
Michael, * Michael Paquier (michael.paqu...@gmail.com) wrote: > + /* > + * Query all the foreign key dependencies for all the > extension > + * tables found previously. Only tables whose data need > to be > + * ha

Re: [HACKERS] Bug in pg_dump

2015-02-28 Thread Stephen Frost
Michael, all, * Michael Paquier (michael.paqu...@gmail.com) wrote: > On Wed, Feb 25, 2015 at 7:46 AM, Gilles Darold > wrote: > > This is a far better patch and the test to export/import of the > > postgis_topology extension works great for me. > > > > Thanks for the work. > > Attached is a patc

Re: [HACKERS] Strange assertion using VACOPT_FREEZE in vacuum.c

2015-02-28 Thread Stephen Frost
Michael, * Michael Paquier (michael.paqu...@gmail.com) wrote: > On Sat, Feb 28, 2015 at 2:45 PM, Stephen Frost wrote: > > So, basically, this feels like it's not really the right place > > for these checks and if there is an existing problem then it's probably > > with the grammar... Does that m

Re: [HACKERS] Merge compact/non compact commits, make aborts dynamically sized

2015-02-28 Thread Robert Haas
On Fri, Feb 27, 2015 at 7:10 AM, Michael Paquier wrote: > No, no. I meant that it is good the way your patch does it in > xactdesc.c, where both frontend and backend can reach it. Agreed, that seems much better than duplicating it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The En

Re: [HACKERS] Strange assertion using VACOPT_FREEZE in vacuum.c

2015-02-28 Thread Michael Paquier
On Sat, Feb 28, 2015 at 2:45 PM, Stephen Frost wrote: > I'm trying to wrap my head around the reasoning for this also and not > sure I'm following. In general, I don't think we protect all that hard > against functions being called with tokens that aren't allowed by the > parse. Check. > So, ba

Re: [HACKERS] star schema and the optimizer

2015-02-28 Thread Marc Cousin
On 27/02/2015 20:01, Marc Cousin wrote: > On 27/02/2015 19:45, Tom Lane wrote: >>> I wrote: I had actually thought that we'd fixed this type of problem in recent versions, and that you should be able to get a plan that would look like >> Nestloop -> scan dim1 ->