Re: [HACKERS] invalid search_path complaints

2012-04-04 Thread Scott Mead
On Wed, Apr 4, 2012 at 12:02 PM, Tom Lane wrote: > Scott Mead writes: > > Personally, I feel that if unix will let you be stupid: > > $ export PATH=/usr/bin:/this/invalid/crazy/path > > $ echo $PATH > > /usr/bin:/this/invalid/crazy/path > > PG sho

Re: [HACKERS] invalid search_path complaints

2012-04-03 Thread Scott Mead
On Tue, Apr 3, 2012 at 2:37 PM, Tom Lane wrote: > Robert Haas writes: > > So we have an established precedent that it is right to warn about > > things that are sketchy at the time that they are defined, but not > > every time they are used. > > Sure, but we don't have that option available to u

Re: [HACKERS] IDLE in transaction introspection

2012-01-18 Thread Scott Mead
On Wed, Jan 18, 2012 at 8:27 AM, Magnus Hagander wrote: > On Tue, Jan 17, 2012 at 01:43, Scott Mead wrote: > > > > > > On Mon, Jan 16, 2012 at 6:10 PM, Scott Mead wrote: > >> > >> > >> On Sun, Jan 15, 2012 at 4:28 AM, Greg Smith > wrote: &

Re: [HACKERS] IDLE in transaction introspection

2012-01-16 Thread Scott Mead
On Sun, Jan 15, 2012 at 4:28 AM, Greg Smith wrote: > On 01/12/2012 11:57 AM, Scott Mead wrote: > >> Pretty delayed, but please find the attached patch that addresses all the >> issues discussed. >> > > The docs on this v4 look like they suffered a patch order p

Re: [HACKERS] IDLE in transaction introspection

2011-12-15 Thread Scott Mead
On Thu, Dec 15, 2011 at 12:10 PM, Magnus Hagander wrote: > On Thu, Dec 15, 2011 at 13:18, Greg Smith wrote: > > This patch seems closing in on being done, but it's surely going to take > at > > least one more round of review to make sure all the naming and > documentation > > is up right. I can

Re: [HACKERS] IDLE in transaction introspection

2011-12-07 Thread Scott Mead
On Tue, Dec 6, 2011 at 6:38 AM, Magnus Hagander wrote: > On Sat, Nov 19, 2011 at 02:55, Scott Mead wrote: > > > > On Thu, Nov 17, 2011 at 11:58 AM, Scott Mead wrote: > >> > >> On Wed, Nov 16, 2011 at 4:09 PM, Scott Mead wrote: > >>> > >>

Re: [HACKERS] IDLE in transaction introspection

2011-11-17 Thread Scott Mead
On Wed, Nov 16, 2011 at 4:09 PM, Scott Mead wrote: > > > On Tue, Nov 15, 2011 at 1:18 PM, Robert Treat wrote: > >> On Tue, Nov 15, 2011 at 12:00 PM, Greg Smith >> wrote: >> > On 11/15/2011 09:44 AM, Scott Mead wrote: >> >> >> >> Fel

Re: [HACKERS] IDLE in transaction introspection

2011-11-16 Thread Scott Mead
On Tue, Nov 15, 2011 at 1:18 PM, Robert Treat wrote: > On Tue, Nov 15, 2011 at 12:00 PM, Greg Smith wrote: > > On 11/15/2011 09:44 AM, Scott Mead wrote: > >> > >> Fell off the map last week, here's v2 that: > >> * RUNNING => active > >> *

Re: [HACKERS] IDLE in transaction introspection

2011-11-15 Thread Scott Mead
. > Fell off the map last week, here's v2 that: * RUNNING => active * all states from CAPS to lower case -- Scott Mead OpenSCG http://www.openscg.com > >regards, tom lane > pg_stat_activity_state_query.v2.patch Description: Binary data

Re: [HACKERS] IDLE in transaction introspection

2011-11-10 Thread Scott Mead
On Nov 5, 2011 9:02 AM, "Greg Smith" wrote: > > On 11/04/2011 05:01 PM, Tom Lane wrote: >> >> Scott Mead writes: >> >>> >>>I leave the waiting flag in place for posterity. With this in mind, is >>> the consensus: >>>R

Re: [HACKERS] IDLE in transaction introspection

2011-11-04 Thread Scott Mead
> "active"? > > +1. > >Letting this one 'poll' a bit more before I post the patch, but here's what I have: If waiting == true, then state = WAITING else state = appropriate state I leave the waiting flag in place for posterity.

Re: [HACKERS] IDLE in transaction introspection

2011-11-04 Thread Scott Mead
; Perhaps, but we don't really use enum types in any other system views, > > so inventing one here would be out of character. > > Yeha, that seems inconsistent. Using a single character might work - > but it's not particularly user-friendly to do that in the view itself. >

Re: [HACKERS] IDLE in transaction introspection

2011-11-02 Thread Scott Mead
ay , , in transaction, etc... query will display the last query that was executed. I've written this up in the attached patch, looking for feedback. (NB: Originally I was using 9.1.1 release, I just did a git clone today to generate this). -- Scott Mead OpenSCG http://www.openscg.com >

Re: [HACKERS] IDLE in transaction introspection

2011-11-01 Thread Scott Mead
rack_activity_size most tools would behave nicely. Now... all that being said, I've implemented the 'previous_query' column and (maybe just for my own benefit), is the PostgreSQL community interested in the patch? -- Scott Mead OpenSCG http://www.openscg.com > >regards, tom lane >

Re: [HACKERS] IDLE in transaction introspection

2011-11-01 Thread Scott Mead
On Tue, Nov 1, 2011 at 1:20 PM, Magnus Hagander wrote: > On Tue, Nov 1, 2011 at 18:11, Scott Mead wrote: > > > > On Tue, Nov 1, 2011 at 10:40 AM, Tom Lane wrote: > >> > >> Robert Haas writes: > >> > On Tue, Nov 1, 2011 at 9:52 AM, Tom Lane wrote:

Re: [HACKERS] IDLE in transaction introspection

2011-10-31 Thread Scott Mead
On Mon, Oct 31, 2011 at 7:18 PM, Scott Mead wrote: > > > On Mon, Oct 31, 2011 at 6:13 PM, Robert Haas wrote: > >> On Mon, Oct 31, 2011 at 5:45 PM, Magnus Hagander >> wrote: >> > Actually, for the future, it might be useful to have a "state" colu

Re: [HACKERS] IDLE in transaction introspection

2011-10-31 Thread Scott Mead
last / currently running) That may be a bit tougher to get across to people though (especially in the case where state=''). I'll rework this when I don't have trick-or-treaters coming to the front door :) -- Scott Mead OpenSCG http://www.openscg.com > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >

[HACKERS] IDLE in transaction introspection

2011-10-31 Thread Scott Mead
ted here) someone else would find this useful. Just wondering what ya'll thought. Any feedback (including a more efficient approach) is welcome. (Patch against release 9.1.1 tarball). Thanks! -- Scott Mead OpenSCG idleInTrans.911.patch Description: Binary data -- Sent via pgsql-hack