pgindent run and committed.
---
Bruce Momjian wrote:
>
> Here are the open items. The only big one left is the handling of a
> foreign key problem we have had for a while. We also have issues with
> MSVC builds crashing a
Andrew Dunstan wrote:
>
> From time to time the suggestion crops up of allowing a DROP IF EXISTS
> ... syntax. This seems not unreasonable, and I just spent a few minutes
> looking at what might be involved.
What about "CREATE IF NOT EXISTS" (CINE)? If we support DROP IF EXISTS
(DIE), is the o
On Fri, 2005-10-14 at 20:29 -0400, Andrew Dunstan wrote:
> From time to time the suggestion crops up of allowing a DROP IF EXISTS
> ... syntax. This seems not unreasonable, and I just spent a few minutes
> looking at what might be involved. Especially in the case of a table,
> view, sequence an
On Fri, Oct 14, 2005 at 08:29:43PM -0400, Andrew Dunstan wrote:
> From time to time the suggestion crops up of allowing a DROP IF
> EXISTS ... syntax. This seems not unreasonable, and I just spent a
> few minutes looking at what might be involved. Especially in the
> case of a table, view, sequenc
From time to time the suggestion crops up of allowing a DROP IF EXISTS
... syntax. This seems not unreasonable, and I just spent a few minutes
looking at what might be involved. Especially in the case of a table,
view, sequence and index the changes look like they would be very modest
indeed,
On Fri, Oct 14, 2005 at 07:09:17PM -0400, Tom Lane wrote:
> I wrote:
> > I'm thinking that IN should be converted to a ScalarArrayOpExpr,
> > ie
>
> > x = ANY (ARRAY[val1,val2,val3,val4,...])
>
> Actually, there is one little thing in the way of doing this: it'll
> fail if any of the IN-list
I wrote:
> I'm thinking that IN should be
> converted to a ScalarArrayOpExpr, ie
> x = ANY (ARRAY[val1,val2,val3,val4,...])
Actually, there is one little thing in the way of doing this: it'll
fail if any of the IN-list elements are NULL, because we have not got
support for arrays with null
Andrew - Supernews <[EMAIL PROTECTED]> writes:
> With everything in cache, selecting 1000 random rows from a 200k row table,
> I get:
>
> for IN (list): planning time 47ms, execution time 27ms
> array/nestloop: planning time 8ms, execution time 34ms
The reason for the slow planning time is that I
On Fri, 2005-14-10 at 13:08 +0100, Dave Page wrote:
> Note that when we moderate this we now hide away most of the comments
> that may suggest improvements for the docs and only leave the ones that
> are actually helpful in their own right visible.
> If someone wants access to these to review, ple
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> Dang. Obviously, that's inverted. Also, I'd need to
> factor in the setup time. Bother. Are you sure we can't
> just make sure the test scripts operate against tables
> with accurate statistics?
Well, the point of my comment was that you should re
Dang. Obviously, that's inverted. Also, I'd need to
factor in the setup time. Bother. Are you sure we can't
just make sure the test scripts operate against tables
with accurate statistics?
>>> "Kevin Grittner" <[EMAIL PROTECTED]> 10/14/05 3:34 PM >>>
The ratio I've been looking at should perha
I have to keep a very narrow focus on this, or there is likely that
nothing will come of it. The particular area which is my target
here is the accuracy of the cost values on the subplans
considered by the optimizer. As previously stated, we're getting
hurt by cases where the optimizer looks at t
"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> I propose capturing only three values from the output of explain
> analyze, and saving it with many columns of context information.
You really have to capture the rowcounts (est and actual) too.
Otherwise you can't tell if it's a costing problem or a
I think I get your point now. If I understand it, you could
accomplish what you want under my rough ("exists only in my
head so far") design by creating your own test cases and putting
together a script to run just those. I would be exremely leary of
comparing tests against a database under load
Kevin,
> It sounds as though you are more focused on picking up costing
> problems which happen during production -- which is clearly
> valuable, but addresses a somewhat different set of needs than
> I was looking at. That said, it seems like there is potential to share
> signifcant code between
> On 10/14/05, Dave Page wrote:
> > Won't help:
> >
> > Microsoft Windows XP [Version 5.1.2600]
> > (C) Copyright 1985-2001 Microsoft Corp.
> >
> > C:\Documents and Settings\dpage>mkdir c:\foo
> >
> > C:\Documents and Settings\dpage>cd c:/foo
> > The system cannot find the path specified.
> >
> >
What I couldn't work out was why the original requester didn't use the
Cygwin psql client, which should work just fine, instead of trying to use
the native client which we know has serious limitations.
cheers
andrew
Joshua D. Drake said:
>
>>>http://archives.postgresql.org/pgsql-hackers/2005-04
On Thu, Oct 13, 2005 at 05:39:32PM -0500, Kevin Grittner wrote:
> That said, there's certainly overlap between your effort and
> what I'm going to be developing. Do you have anything from
> your work which might save me some time?
Not really. I got stuck in the query design phase. I didn't even
g
> -Original Message-
> From: Christopher A. Watford [mailto:[EMAIL PROTECTED]
> Sent: 14 October 2005 15:58
> To: Dave Page
> Cc: Tom Lane; Martijn van Oosterhout; Thomas Hallgren;
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_config --pgxs on Win32
>
> On 10/14/05, Dave
http://archives.postgresql.org/pgsql-hackers/2005-04/threads.php
It seems pretty simple and non-invasive. I don't recall seeing the
reasons against doing it.
We need a large number of users who need something before we add it. If
we didn't we would have a mess of options.
The need
On 10/14/05, Dave Page wrote:
> Won't help:
>
> Microsoft Windows XP [Version 5.1.2600]
> (C) Copyright 1985-2001 Microsoft Corp.
>
> C:\Documents and Settings\dpage>mkdir c:\foo
>
> C:\Documents and Settings\dpage>cd c:/foo
> The system cannot find the path specified.
>
> C:\Documents and Setting
John DeSoi wrote:
>
> On Oct 13, 2005, at 4:42 PM, Bruce Momjian wrote:
>
> > I haven't seen any replies to this, so I guess you are left with
> > either
> > hacking psql yourself or getting Cygwin folks to fix it. Sorry.
>
> I have asked for this also. It would make it much easier to control
On Oct 13, 2005, at 4:42 PM, Bruce Momjian wrote:
I haven't seen any replies to this, so I guess you are left with
either
hacking psql yourself or getting Cygwin folks to fix it. Sorry.
I have asked for this also. It would make it much easier to control
psql from other applications.
ht
> On N, 2005-10-13 at 15:13 -0400, Merlin Moncure wrote:
> > I have a situation where I need to hack pg_dump not to dump columns
with
> > a particular name. If this is of interest to the community I can
spend
> > a little extra effort and work up a patch. I'd be curious to see if
> > anyone else
C Wegrzyn wrote:
> First, let me thank you for the effort you have been putting into the
> Postgresql development. It is a great system. It performs well and with
> the exception of a few little annoyances is a great competitor to Mysql
> or Oracle!
>
> This particular bug isn't a show stopper; I
On N, 2005-10-13 at 15:13 -0400, Merlin Moncure wrote:
> I have a situation where I need to hack pg_dump not to dump columns with
> a particular name. If this is of interest to the community I can spend
> a little extra effort and work up a patch. I'd be curious to see if
> anyone else thinks thi
First, let me thank you for the effort you have been putting into the
Postgresql development. It is a great system. It performs well and with
the exception of a few little annoyances is a great competitor to Mysql
or Oracle!
This particular bug isn't a show stopper; I could have easily found a
way
Christopher wrote:
> A general ability to be able to dump views as if they were tables
would
> be more broadly applicable methinks?
>
> Merlin Moncure wrote:
> > I have a situation where I need to hack pg_dump not to dump columns
with
> > a particular name. If this is of interest to the community
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: 14 October 2005 12:57
> To: PostgreSQL-development
> Subject: [HACKERS] Open items
>
>
> Has the interactive
> documentation been
> scanned and merged into the SGML?
Note
Oh, let me add that this release has gone very smoothly. We are right
on schedule in release timing. I sometimes think the beta period is not
as productive as the development period, but going through it, I am
always reminded how much more polished our final product is because of
the hard work w
Here are the open items. The only big one left is the handling of a
foreign key problem we have had for a while. We also have issues with
MSVC builds crashing and pg_config --pgxs on Win32 but they are being
actively discussed. I also have a dblink patch on hold.
I think it is time to start lo
Michael Paesold wrote:
> [moved to hackers]
>
> Is this a regression in the stable branches? If so, shouldn't we do a new
> release rather immediately? What do others think about this situation?
>
> Can you remember regressions in stable branches in the past? How were those
> it handled? I thin
Tatsuo Ishii wrote:
> > Also, JST doesn't work anymore, but JST9 does. JST has no daylight
> > savings time values, so it is a valid timezone setting, while EST is
> > not:
> >
> > test=> set timezone = 'JST';
> > ERROR: unrecognized time zone name: "JST"
> >
> > test=> set timezone
> Also, JST doesn't work anymore, but JST9 does. JST has no daylight
> savings time values, so it is a valid timezone setting, while EST is
> not:
>
> test=> set timezone = 'JST';
> ERROR: unrecognized time zone name: "JST"
>
> test=> set timezone = 'JST9';
> SET
Note t
Gaah, DLLIMPORT of course. Sorry...
- thomas
Thomas Hallgren wrote:
I made a "make distclean" and a "cvs update". Then I rebuilt and
installed. When I try to link PL/Java I now get the following:
Info: resolving _stack_base_ptr by linking to __imp__stack_base_ptr
(auto-import)
fu01.o(.i
Hi,
On 10/13/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Really, PQfnumber shouldn't do any case folding at all; that's not in
> its charter if you ask me. The problem is how to get there from here
> without too much compatibility pain. Maybe invent a new routine that
> does it right and then depr
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > Shall I add JST to our zic database?
>
> No. We have to update that from the upstream database every release;
> maintaining our own private mods is not acceptable. If you want JST
> to be recognized as a zic timezone, go lobby the upstream maintaine
On 2005-10-12, Andrew - Supernews <[EMAIL PROTECTED]> wrote:
> On 2005-10-12, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Andrew - Supernews <[EMAIL PROTECTED]> writes:
>>> As the number of items in the IN clause increases, the planning time grows
>>> rather radically.
>>
>> I was looking at this yester
I made a "make distclean" and a "cvs update". Then I rebuilt and
installed. When I try to link PL/Java I now get the following:
Info: resolving _stack_base_ptr by linking to __imp__stack_base_ptr
(auto-import)
fu01.o(.idata$3+0xc): undefined reference to `libpostgres_a_iname'
fu02.o(.i
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 13 October 2005 20:41
> To: Dave Page
> Cc: Martijn van Oosterhout; Thomas Hallgren;
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] pg_config --pgxs on Win32
>
> "Dave Page" writes:
> > When we first di
40 matches
Mail list logo