attached updated patch
* don't use a default option for navigation in editor - user have to
set this option explicitly
* name for this psql variable is EDITOR_LINENUMBER_SWITCH -
* updated comments, doc and some issues described by Robert
Regards
Pavel Stehule
2010/8/3 Robert Haas :
> On Sun, A
Hello
2010/8/3 Pavel Stehule :
> attached updated patch
>
> * don't use a default option for navigation in editor - user have to
> set this option explicitly
> * name for this psql variable is EDITOR_LINENUMBER_SWITCH -
> * updated comments, doc and some issues described by Robert
>
> Regards
>
>
Hello
I hope so I found and fixed last issue - the longer functions was
showed directly - without a pager.
Regards
Pavel
2010/8/3 Pavel Stehule :
> Hello
>
> 2010/8/3 Pavel Stehule :
>> attached updated patch
>>
>> * don't use a default option for navigation in editor - user have to
>> set this
2010/8/3 Pavel Stehule :
> Hello
>
> 2010/8/3 Joshua Tolley :
>> In case anyone's interested, I've taken the CTE-based grouping sets patch
>> from
>> [1] and made it apply to 9.1, attached. I haven't yet done things like
>> checked
>> it for whitespace consistency, style conformity, or anything e
2010/8/3 Hitoshi Harada :
> 2010/8/3 Pavel Stehule :
>> Hello
>>
>> 2010/8/3 Joshua Tolley :
>>> In case anyone's interested, I've taken the CTE-based grouping sets patch
>>> from
>>> [1] and made it apply to 9.1, attached. I haven't yet done things like
>>> checked
>>> it for whitespace consiste
Hello!
We are 2 Students from the Technical University of Vienna. At our internship
we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
to be qualified by schema/table name".
Is anyone working on it?
Our research at the SET CONTRAINTS function showed the following Error:
*E
On 3 August 2010 13:57, Viktor Valy wrote:
> Hello!
> We are 2 Students from the Technical University of Vienna. At our internship
> we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
> to be qualified by schema/table name".
> Is anyone working on it?
> Our research at the
Viktor Valy writes:
> We are 2 Students from the Technical University of Vienna. At our internship
> we would like to develop the item of the TODO list: "Allow SET CONSTRAINTS
> to be qualified by schema/table name".
> Is anyone working on it?
Uh, it was done years ago, AFAICS, unless the Todo en
On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown wrote:
> I can't answer the main question, but you can try Anjuta as a C
> editor: http://www.anjuta.org/
Or vi.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company
--
Sent via pgsql-hackers mailing list (pgsql-ha
On lör, 2010-07-31 at 13:40 -0400, Robert Haas wrote:
> > Well-formedness should probably only allow XML documents.
>
> I think the point of this function is to determine whether a cast to
> xml will throw an error. The behavior should probably match exactly
> whatever test would be applied there
Robert Haas wrote:
On Mon, Aug 2, 2010 at 2:56 PM, Yeb Havinga wrote:
Hence the ATOneLevelRecursion routing is usable in its
current form for all callers during the prep stage, and not only
ATPrepAddColumn.
Well, only if they happen to want the "visit each table only once"
behavior, which mig
1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to
another database instance (standby node) at real time, and keep startup alive
in standby node to recovery WAL online,so that standby node can be a hot
standby.But I got some trouble. When standby node switch to prima
On Tue, 2010-08-03 at 11:10 -0400, Robert Haas wrote:
> On Tue, Aug 3, 2010 at 9:01 AM, Thom Brown wrote:
> > I can't answer the main question, but you can try Anjuta as a C
> > editor: http://www.anjuta.org/
>
> Or vi.
cough.
The hint here would be:
>As we have few experience with open-source
2010/7/21 David Fetter :
> On Sat, Jul 17, 2010 at 01:15:22AM +0900, Hitoshi Harada wrote:
>> 2010/7/17 Marko Tiikkaja :
>> > On 7/16/10 6:15 PM +0300, Hitoshi Harada wrote:
>> >> 1. Use MaterialNode instead of adding DtScanNode. Since MaterialNode
>> >> is exsiting one that work with single tuples
On mån, 2010-08-02 at 01:43 -0500, Jaime Casanova wrote:
> nowadays, CREATE DATABASE has a lc_collate clause. is the new collate
> clause similar as the lc_collate?
> i mean, is lc_collate what we will use as a default?
Yes, if you do not specify anything per column, the database default is
used.
1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to
another database instance (standby node) at real time, and keep startup alive
in standby node to recovery WAL online,so that standby node can be a hot
standby.
But I got some trouble. When standby node switch to prim
On Wed, 2010-08-04 at 00:34 +0800, Richard wrote:
> 1.To add live HA to PG, I transfer WAL of a database instance(Primary node)
> to another database instance (standby node) at real time, and keep startup
> alive in standby node to recovery WAL online,so that standby node can be a
> hot standby
On Tue, Aug 3, 2010 at 12:34 PM, Richard wrote:
1.To add live HA to PG, I transfer WAL of a database instance(Primary
node) to another database instance (standby node) at real time, and
keep startup alive in standby node to recovery WAL online,so that
standby node can be a hot standby.
> But I go
On 31 July 2010 07:58, Robert Haas wrote:
> Here's a second version of the main patch, in which I have attempted
> to respond to Tom's concerns/suggestions.
>
> (There is still a small, side issue with numeric_maximum_size() which
> I plan to fix, but this patch is the good stuff.)
>
Applies fine
Hi,
attached is a patch that adds the missing feature to use
"WHERE CURRENT OF :curname" in UPDATE and
DELETE statements via ECPG. I used the current CVS MAIN
but also applies almost cleanly to 9.0beta4. I certainly feel that
this should be applied to 9.0 as a bugfix.
The execute.c changes were r
Boszormenyi Zoltan wrote:
> attached is a patch that adds the missing feature
> I certainly feel that this should be applied to 9.0 as a bugfix.
Those two statements seem to contradict one another. Is there some
bug manifestation beyond an unimplemented feature this fixes?
Without this, is
Kevin Grittner írta:
> Boszormenyi Zoltan wrote:
>
>
>> attached is a patch that adds the missing feature
>>
>
>
>> I certainly feel that this should be applied to 9.0 as a bugfix.
>>
>
> Those two statements seem to contradict one another.
PostgreSQL 8.3 or so added WHERE C
rh...@postgresql.org (Robert Haas) writes:
> Add \conninfo command to psql, to show current connection info.
> David Christensen. Reviewed by Steve Singer. Some further changes by me.
Looking at the output from this command:
regression=# \conninfo
You are connected to database "regression" via
Tom Lane wrote:
> You are connected to database "regression" as user "postgres"
> via local socket in "/tmp" at port "5432".
+1
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hacker
On 8/3/2010 7:30 PM, Hitoshi Harada wrote:
As hackers say, the first to try should be Marko's first design that
use the list of tuplestore and DTScanNode. So if he has solid image to
reach there, we can wait for him to complete his first compilable
version. Then let's take it back and forth. Is i
Hello
2010/8/3 Peter Eisentraut :
> On lör, 2010-07-31 at 13:40 -0400, Robert Haas wrote:
>> > Well-formedness should probably only allow XML documents.
>>
>> I think the point of this function is to determine whether a cast to
>> xml will throw an error. The behavior should probably match exactl
"Kevin Grittner" writes:
> Tom Lane wrote:
>> You are connected to database "regression" as user "postgres"
>> via local socket in "/tmp" at port "5432".
> +1
Looking at the code, I notice another problem, which is that it's a
rather egregious violation of the rule against assembling messages
On Tue, Aug 3, 2010 at 1:46 PM, Tom Lane wrote:
> 1. This way would match the argument ordering for \connect,
> which in case you've forgotten is dbname user host port.
I noticed that discrepancy when reviewing, but felt it was a problem
for another day. Today is fine, though. :-)
--
Robert H
Yeb Havinga wrote:
The underlying cause is the failure of the code to recognize that if
relation C inherits from both A and B, where A and B both have column
x, that A.x 'is the same as' B.x, where the 'is the same as' relation
is the same that holds for (A.x, C.x) and (B.x, C.x), which the cod
On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis wrote:
> On Mon, 2010-08-02 at 12:27 -0400, Robert Haas wrote:
>> I was also wondering if it would be worth adding some additional
>> regression testing to contrib/btree_gist exercising this new
>> functionality. Thoughts?
>
> Sure. I attached two tests
Florian Pflug wrote:
I created the patch to tune the wal_writer for the synchronous_commit=off case
- the idea being that the COMMIT should be virtually instantaneous if the
wal_writer writes old wal buffers out fast enough.
As I was saying, being able to see the COMMIT times for purposes
On Tue, Aug 3, 2010 at 3:05 PM, Yeb Havinga wrote:
> Yeb Havinga wrote:
>> The underlying cause is the failure of the code to recognize that if
>> relation C inherits from both A and B, where A and B both have column x,
>> that A.x 'is the same as' B.x, where the 'is the same as' relation is the
>
Robert Haas writes:
> On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis wrote:
>> Sure. I attached two tests.
> Committed.
I see no sign of a commit from here ...
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Tue, Aug 3, 2010 at 3:52 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Mon, Aug 2, 2010 at 11:16 PM, Jeff Davis wrote:
>>> Sure. I attached two tests.
>
>> Committed.
>
> I see no sign of a commit from here ...
Sigh. Forgot to exit my editor.
--
Robert Haas
EnterpriseDB: http://www.ente
On Mon, Aug 02, 2010 at 11:50:00PM -0600, Josh Tolley wrote:
> In case anyone's interested, I've taken the CTE-based grouping sets
> patch from [1] and made it apply to 9.1, attached. I haven't yet
> done things like checked it for whitespace consistency, style
> conformity, or anything else, but (
On Tue, Aug 03, 2010 at 12:58:03PM -0700, David Fetter wrote:
> On Mon, Aug 02, 2010 at 11:50:00PM -0600, Josh Tolley wrote:
> > In case anyone's interested, I've taken the CTE-based grouping sets
> > patch from [1] and made it apply to 9.1, attached. I haven't yet
> > done things like checked it f
On Mon, Aug 02, 2010 at 05:34:57PM +0100, Greg Stark wrote:
> Tom: Because that code is much more complex and prone to errors
> especially when you start getting into multiplication and other
> operations and it's also much slower than the code which allows
> overflow to happen and then checks that
"Kevin Grittner" writes:
> Tom Lane wrote:
>> I think the patch is good in principle
> Since everyone seems to agree this is a good patch which needed
> minor tweaks, and we haven't heard from the author, I just went
> ahead and made the changes.
Applied with a bit of further editing of the co
Robert Haas writes:
> Here's a second version of the main patch, in which I have attempted
> to respond to Tom's concerns/suggestions.
This version looks fine to me.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
> And, I have tested the running of MERGE command with different
> situations. I am sorry that I didn't create regression test files,
> because I am not sure how to add new files in the git package. But, I
> have written web pages in Postgres Wiki. I explain the details of my
> implementation and
> https://wiki.postgresql.org/wiki/Implementation_detalis
> https://wiki.postgresql.org/wiki/Test_examples
These pages were confusingly named, so I just moved them:
https://wiki.postgresql.org/wiki/MergeTestExamples
https://wiki.postgresql.org/wiki/MergeImplementationDetails
--
On Tue, Aug 03, 2010 at 03:14:02PM -0700, Josh Berkus wrote:
>
> > And, I have tested the running of MERGE command with different
> > situations. I am sorry that I didn't create regression test files,
> > because I am not sure how to add new files in the git package.
> > But, I have written web pa
On Tue, Aug 3, 2010 at 6:03 PM, Tom Lane wrote:
> Robert Haas writes:
>> Here's a second version of the main patch, in which I have attempted
>> to respond to Tom's concerns/suggestions.
>
> This version looks fine to me.
Excellent. Committed.
--
Robert Haas
EnterpriseDB: http://www.enterpris
Boxuan Zhai wrote:
I think there are no redundant lines in this time's patch file.
It is much better. There are still more blank likes around the new code
you've added than are needed in many places, but that doesn't interfere
with reading the patch.
The main code formatting issue left you
On Fri, Jul 9, 2010 at 10:26 AM, Robert Haas wrote:
> On Fri, Jul 9, 2010 at 12:54 AM, Tom Lane wrote:
>> Robert Haas writes:
> How long should I wait before I start breaking things?
Did you have any particular breakage in mind?
>>
>>> Well, you can see for yourself what I've submi
On Fri, Jul 30, 2010 at 9:55 PM, Robert Haas wrote:
> On Fri, Jul 30, 2010 at 2:08 PM, Tom Lane wrote:
>> Robert Haas writes:
>>> Maybe something like this,
>>> obviously with a suitable comment which I haven't written yet:
>>
>>> numeric_digits = (precision + 6) / 4;
>>> return (n
Hardik Belani wrote:
For this i can create a table with number and time (may be time offset
instead of timestamp) as columns. But still it will require me to
store huge number of rows in the order of few millions. Data is read
only and only inserts can happen. But I need to perform all kinds of
2010/8/3 Joshua Tolley :
> On Tue, Aug 03, 2010 at 12:58:03PM -0700, David Fetter wrote:
>> On Mon, Aug 02, 2010 at 11:50:00PM -0600, Josh Tolley wrote:
>> > In case anyone's interested, I've taken the CTE-based grouping sets
>> > patch from [1] and made it apply to 9.1, attached. I haven't yet
>>
2010/8/4 Greg Smith
> Boxuan Zhai wrote:
>
>> I think there are no redundant lines in this time's patch file.
>>
>
> It is much better. There are still more blank likes around the new code
> you've added than are needed in many places, but that doesn't interfere with
> reading the patch.
>
> Sor
Thanks for all your responses and my apologies for putting the question in
the wrong list.
I think OLAP is the answer for my requirements.
Regards,
Hardik
On Wed, Aug 4, 2010 at 5:40 AM, Greg Smith wrote:
> Hardik Belani wrote:
>
>> For this i can create a table with number and time (may be
50 matches
Mail list logo