Robert Treat <[EMAIL PROTECTED]> writes:
> On Friday 20 June 2008 10:49:49 Tom Lane wrote:
>> Be specific:
>> "Sets the maximum length of pg_stat_activity.current_query."
> I think there are other places this might manifest itself besides
> pg_stat_activity...
No, there aren't.
I'm struggling
Linux jd-laptop 2.6.24-19-generic #1 SMP Wed Jun 4 16:35:01 UTC 2008
i686 GNU/Linux
Using built-in specs.
Target: i486-linux-gnu
Configured with: ../src/configure -v --enable-languages=c,c
++,fortran,objc,obj-c++,treelang --prefix=/usr --enable-shared
--with-system-zlib --libexecdir=/usr/lib --wit
On Friday 20 June 2008 10:49:49 Tom Lane wrote:
> Thomas Lee <[EMAIL PROTECTED]> writes:
> > How does this sound:
> >
> > * A new GUC variable -- "activity_message_size" -- will be introduced
>
> Well, "message" doesn't seem quite le mot juste to me for a column that
> is displaying a SQL command.
On Jun 20, 2008, at 11:48 AM, Tom Lane wrote:
Decibel! <[EMAIL PROTECTED]> writes:
I realize we just got rid of stats_command_string, but if we're
adding a GUC back in we might as well allow it to be set to 0 which
disables logging.
How would that not duplicate track_activities?
Sorry, I th
Hackers,
At the developer meeting, we determined that one thing needed to speed
up the commitfests is a list of people who were available to review
assigned patches, and someone to do the assigning. Well, for July I'm
the assignor, and I'm looking for some assignees. Here's how it will work:
Decibel! <[EMAIL PROTECTED]> writes:
> I realize we just got rid of stats_command_string, but if we're
> adding a GUC back in we might as well allow it to be set to 0 which
> disables logging.
How would that not duplicate track_activities?
regards, tom lane
--
Sent v
On Jun 20, 2008, at 9:49 AM, Tom Lane wrote:
* Minimum value of PGBE_DEFAULT_ACTIVITY_SIZE, maximum value of
INT_MAX?
I was thinking about a range of 100 to 100K or thereabouts. INT_MAX
is just silly...
I realize we just got rid of stats_command_string, but if we're
adding a GUC back in
On Jun 20, 2008, at 1:11 AM, Suresh wrote:
I have a query plan for a certain query
Nested Loop (cost=1.00..38761761090.50 rows=3000608 width=8)
-> Seq Scan on lineitem (cost=1.00..100213649.15
rows=6001215 width=8)
-> Index Scan using oindex2 on myorders (cost=0.00.
On Fri, 2008-06-20 at 13:10 +0530, Deepak wrote:
>
>
> Hi
>
> I am trying to create a TRIGGER function,that populates values to
> another table upon inserting a value into a table. The issue is,if
> there is a exception(in Table 2) everything gets rolled back including
> Table1.I dont want thi
Thomas Lee <[EMAIL PROTECTED]> writes:
> How does this sound:
> * A new GUC variable -- "activity_message_size" -- will be introduced
Well, "message" doesn't seem quite le mot juste to me for a column that
is displaying a SQL command. Usually we'd use "statement", "command",
or "query" to refer
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> we have faced lately dumps not valid, the bug can be replicated using a 8.2.9
> or
> a 8.3.1 server.
> These are the steps to create the database that will generate a not valid
> dump:
This is a bug in your function: it will not work if the search p
On Wed, Jun 18, 2008 at 09:26:24PM -0400, Tom Lane wrote:
> > ? src/interfaces/ecpg/compatlib/libecpg_compatddll.def
> > ? src/interfaces/ecpg/ecpglib/libecpgddll.def
> > ? src/interfaces/ecpg/pgtypeslib/libpgtypesddll.def
IIRC these are for MS VC++.
> > I am not sure if these should stay on the
Hi all,
we have faced lately dumps not valid, the bug can be replicated using a 8.2.9 or
a 8.3.1 server.
These are the steps to create the database that will generate a not valid dump:
---
CREATE TABLE t_public (
a integer
);
CREATE OR REPL
Hi,
I'm new to the postgresql source, thought I'd try my hand at
implementing the change suggested (i.e. the GUC-ification of the
PGBE_ACTIVITY_SIZE constant) to get my hands dirty with the code.
How does this sound:
* A new GUC variable -- "activity_message_size" -- will be introduced
* The
Hi
I am trying to create a TRIGGER function,that populates values to another
table upon inserting a value into a table. The issue is,if there is a
exception(in Table 2) everything gets rolled back including Table1.I dont
want this to happen.i want the value of table1 to stay.
I tried "tryexcep
15 matches
Mail list logo