On Tue, Nov 01, 2011 at 10:13:52AM -0400, Andrew Dunstan wrote:
>
>
> On 11/01/2011 09:52 AM, Tom Lane wrote:
> >Simon Riggs writes:
> >>Why not leave it exactly as it is, and add a previous_query column?
> >>That gives you exactly what you need without breaking anything.
> >That would cost twic
On Mon, Oct 31, 2011 at 09:14:48AM -0400, Andrew Dunstan wrote:
> The fact is that if you have 100 columns and want 95 of them, it's
> very tedious to have to specify them all, especially for ad hoc
> queries where the house SQL standards really don't matter that much.
> It's made more tedious by t
On Fri, Sep 02, 2011 at 02:05:45PM -0500, k...@rice.edu wrote:
> On Fri, Sep 02, 2011 at 09:54:07PM +0300, Peter Eisentraut wrote:
> > On ons, 2011-08-31 at 13:12 -0500, Ross J. Reedstrom wrote:
> > > Hmm, this thread seems to have petered out without a conclusion. Just
>
On Fri, Aug 12, 2011 at 10:14:58PM +0300, Marko Kreen wrote:
> On Thu, Aug 11, 2011 at 5:46 PM, Tom Lane wrote:
> > Marko Kreen writes:
> >> On Wed, Aug 10, 2011 at 9:19 PM, Tom Lane wrote:
> >>> ... which this approach would create, because digest() isn't restricted
> >>> to just those algorith
On Tue, Jun 21, 2011 at 10:15:50AM -0400, Alvaro Herrera wrote:
> Excerpts from Pavel Stehule's message of mar jun 21 10:04:26 -0400 2011:
> > 2011/6/21 Alvaro Herrera :
> > > Excerpts from Pavel Stehule's message of mar jun 21 00:59:44 -0400 2011:
> > >
> > >> yes - it has a sense. Quoting changes
On Fri, Jun 17, 2011 at 05:21:10PM +0200, Florian Pflug wrote:
> On Jun17, 2011, at 17:15 , Ross J. Reedstrom wrote:
> > On Fri, Jun 17, 2011 at 10:20:04AM -0400, Alvaro Herrera wrote:
> >> Excerpts from Florian Pflug's message of vie jun 17 10:03:56 -0400 2011:
> >&g
On Fri, Jun 17, 2011 at 10:20:04AM -0400, Alvaro Herrera wrote:
> Excerpts from Florian Pflug's message of vie jun 17 10:03:56 -0400 2011:
>
> > How is that worse than the situation with "=~" and "~="?
>
> With =~ it is to the right, with ~= it is to the left.
To throw my user opinion into this
Right, but I think he needs the "it's not easy, here's the whole
workflow" overview first.
Ross
--
Ross Reedstrom, Ph.D. reeds...@rice.edu
Systems Engineer & Admin, Research Scientistphone: 713-348-6166
Connexions http://cnx.org
On Thu, Jun 16, 2011 at 09:48:12AM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > "Ross J. Reedstrom" writes:
> > > As an operations guy, the idea of an upgrade using a random,
> > > non-repeatable port selection gives me the hebejeebees.
> >
&g
On Wed, Jun 15, 2011 at 09:14:16PM -0400, Stephen Frost wrote:
> Bruce,
>
> * Bruce Momjian (br...@momjian.us) wrote:
> > I have researched this and need feedback.
>
> In general, I like the whole idea of using random/special ports for the
> duration of the upgrade. I agree that we need to kee
On Mon, Jun 06, 2011 at 12:53:49PM -0400, Robert Haas wrote:
>
> I don't have clear feeling on this question in general, but if we're
> going to break this up into pieces, it's important that they be
> logical pieces. Putting half the feature in core and half into an
> extension just because we c
On Fri, Jun 03, 2011 at 11:22:34AM -0400, Robert Haas wrote:
> On Fri, Jun 3, 2011 at 1:14 AM, Noah Misch wrote:
> > No, there's no need to do that. The domain "is" an array, not merely
> > something
> > that can be coerced to an array. Therefore, it can be chosen as the
> > polymorphic
> > ty
On Thu, Jun 02, 2011 at 01:43:16PM -0400, Tom Lane wrote:
> =?utf-8?q?Rados=C5=82aw_Smogura?= writes:
> > Tom Lane Thursday 02 of June 2011 16:42:42
> >> Yes. I think the appropriate problem statement is "provide streaming
> >> access to large field values, as an alternative to just fetching/sto
On Wed, Jun 01, 2011 at 04:58:36PM -0400, Robert Haas wrote:
> On Wed, Jun 1, 2011 at 4:47 PM, Tom Lane wrote:
> > Robert Haas writes:
> >> I guess the real issue here is that m1.id < m2.id has to be evaluated
> >> as a filter condition rather than a join qual.
> >
> > Well, if you can invent an
On Tue, May 31, 2011 at 11:35:01AM -0500, Kevin Grittner wrote:
> Alvaro Herrera wrote:
>
> > This patch allows you to initially declare a CHECK constraint as
> > NOT VALID, similar to what we already allow for foreign keys.
> > That is, you create the constraint without scanning the table and
On Tue, May 31, 2011 at 04:19:29PM +0200, Florian Pflug wrote:
> Sorry for the self-reply but I figured it'd be helpful to add information
> that I discovered only after my initial post.
>
> On May30, 2011, at 15:17 , Florian Pflug wrote:
> > The XPath expression 'name(/*)', for example, is suppos
On Wed, May 25, 2011 at 01:29:05PM -0400, Robert Haas wrote:
> On Wed, May 25, 2011 at 1:06 PM, Greg Smith wrote:
> > On 05/24/2011 04:34 PM, Robert Haas wrote:
>
> > I've been looking into a similar refactoring of the names here, where we
> > bundle all of these speed over safety things (fsync,
On Thu, May 19, 2011 at 04:13:12PM -0400, Alvaro Herrera wrote:
> Excerpts from Robert Haas's message of jue may 19 15:32:57 -0400 2011:
> >
> > That's a bit of a self-defeating argument though, since it implies
> > that the effect of taking an exclusive lock via LockSharedObject()
> > will not si
On Mon, May 23, 2011 at 11:08:40PM -0400, Robert Haas wrote:
>
> I don't really like the idea of adding a GUC for this, unless we
> convince ourselves that nothing else is sensible. I mean, that leads
> to conversations like this:
>
> Newbie: My query is slow.
> Hacker: Turn on enable_magic_pixi
On Tue, May 10, 2011 at 07:21:16PM +0200, Andres Freund wrote:
> On Tuesday, May 10, 2011 07:08:23 PM Ross J. Reedstrom wrote:
> > On Mon, May 09, 2011 at 03:57:12PM -0400, Robert Haas wrote:
> > > On Mon, May 9, 2011 at 2:58 PM, Bruce Momjian wrote:
> > > > Tom this
On Mon, May 09, 2011 at 03:57:12PM -0400, Robert Haas wrote:
> On Mon, May 9, 2011 at 2:58 PM, Bruce Momjian wrote:
> > Tom this collation stuff has seen more post-feature-commit cleanups than
> > I think any patch I remember. Is there anything we can learn from this?
>
> How about "don't commit
On Thu, Apr 21, 2011 at 11:16:45AM -0400, Tom Lane wrote:
> Robert Haas writes:
> > On Thu, Apr 21, 2011 at 2:43 AM, Peter Eisentraut wrote:
> >> I think to really address that problem, you need to think about shorter
> >> release cycles overall, like every 6 months. �Otherwise, the current 12
>
On Fri, Mar 18, 2011 at 11:00:19PM -0400, Tom Lane wrote:
> Robert Haas writes:
> > On Fri, Mar 18, 2011 at 10:19 PM, Andrew Dunstan
> > wrote:
> >> On 03/18/2011 09:18 PM, Robert Haas wrote:
> >>> "all balls" seems like a colloquialism best avoided in our documentation.
>
> >> It's already the
On Fri, Mar 11, 2011 at 09:03:33AM -0500, Robert Haas wrote:
> On Fri, Mar 11, 2011 at 8:21 AM, Fujii Masao wrote:
> >
> > In that case, the last write WAL timestamp would become equal to the
> > last replay WAL timestamp. So we can see that there is no lag.
>
> Oh, I see (I think). You're talki
On Mon, Mar 07, 2011 at 03:45:17PM -0300, Alvaro Herrera wrote:
> Excerpts from Tom Lane's message of lun mar 07 15:16:31 -0300 2011:
>
> > If we do that then it becomes worth wondering what the -docs list is for
> > at all. Maybe we *should* get rid of it; I dunno. I see your point
> > about ho
On Thu, Feb 03, 2011 at 04:31:08PM +0100, Dimitri Fontaine wrote:
> "Ross J. Reedstrom" writes:
> > Hmm, how about allowing a list of files to execute? That allows the
>
> Sure. I still don't see why doing it in the control file is better than
> in the Makefile,
On Thu, Feb 03, 2011 at 10:21:28AM +0200, Anssi Kääriäinen wrote:
> On 02/02/2011 08:22 PM, Dimitri Fontaine wrote:
>> Either one line in the Makefile or a new file with the \i equivalent
>> lines, that would maybe look like:
>>
>>SELECT pg_execute_sql_file('upgrade.v14.sql');
>>SELECT pg_e
On Tue, Jan 11, 2011 at 11:06:18AM -0800, Josh Berkus wrote:
>
> > It makes it very convenient to set up standbys, without having to worry
> > that you'll conflict e.g with a nightly backup. I don't imagine people
> > will use streaming base backups for very large databases anyway.
>
> Also, imag
On Fri, Dec 03, 2010 at 05:16:04PM -0500, Robert Treat wrote:
> On Fri, Dec 3, 2010 at 4:41 PM, Josh Berkus wrote:
>
> > However, I don't see why we need (column_list). Surely the index has a
> > column list already?
> >
> > ALTER TABLE table_name ADD CONSTRAINT pk_name PRIMARY KEY USING index_na
On Fri, Nov 19, 2010 at 04:57:03PM +0900, KaiGai Kohei wrote:
> (2010/11/18 2:17), Robert Haas wrote:
> >
> >If KaiGai updates the code per previous discussion, would you be
> >willing to take a crack at adding documentation?
> >
> >P.S. Your email client seems to be setting the Reply-To address to
On Tue, Nov 16, 2010 at 09:41:37PM -0500, Robert Haas wrote:
> On Tue, Nov 16, 2010 at 8:15 PM, KaiGai Kohei wrote:
> > If we don't need a PoC module for each new hooks, I'm not strongly
> > motivated to push it into contrib tree.
> > How about your opinion?
>
> I'd say let it go, unless someone
On Thu, Jul 15, 2010 at 04:20:12PM +0100, Simon Riggs wrote:
>
> Just for the record, I've never ever met anyone that said "Oh, this \d
> syntax makes so much sense. I'm a real convert to Postgres now you've
> shown me this". The reaction is always the opposite one; always
> negative. Which detrac
On Sat, Jun 26, 2010 at 01:19:57PM -0400, Robert Haas wrote:
>
> I'm not sure. What does seem clear is that it's fundamentally at odds
> with the "admission control" approach Kevin is advocating. When you
> start to run short on a resource (perhaps memory), you have to decide
> between (a) waiti
On Tue, Jun 15, 2010 at 03:42:59PM -0700, David E. Wheeler wrote:
> On Jun 15, 2010, at 3:22 PM, Bruce Momjian wrote:
>
> > I totaly agreed you need funding, and you are very well qualified to do
> > this, and it is a badly needed facility.
>
> Thanks.
>
> > The problem I had is that the effort
On Tue, Jun 15, 2010 at 01:25:33PM -0700, David E. Wheeler wrote:
> On Jun 15, 2010, at 1:12 PM, Bruce Momjian wrote:
>
> > This was just posted to announce. Seems the community now has to
> > compete with another extension-based infrastructure if we ever get
> > around to developing one of our o
On Mon, May 10, 2010 at 01:35:32PM -0700, Josh Berkus wrote:
> deleted,
> or on a reporting read-only clone of your database which gets
> recreated very
> night and is not used for failover. High quality hardware alone
s/very/every/
or
s/very night/periodically/
Ross
--
Ross Re
On Tue, Apr 27, 2010 at 08:18:13PM -0400, Robert Haas wrote:
> On Tue, Apr 27, 2010 at 6:45 PM, Kjell Rune Skaaraas
> wrote:
[snip]
> > I saw some indications that this might be a minority opinion, well I would
> > like to cast a vote FOR this functionality. The workarounds are ugly, the
> > so
On Fri, Apr 23, 2010 at 10:58:40AM -0500, Terry Brown wrote:
> I asked on IRC if there was any way to make \d behave like \d+ by default,
> and davidfetter said no but suggest it here.
>
> endpoint_david pointed out you could use \d- to get the old behavior if you
> wanted to temporarily negate
On Wed, Mar 31, 2010 at 10:34:41PM -0400, Bruce Momjian wrote:
> Matthew Altus wrote:
> > Hey,
> >
> > After dealing with a production fault and having to rollback all the time,
> > I
> > kept typing a different word instead of rollback. So I created a patch to
> > accept this word as an alias
On Sun, Feb 14, 2010 at 05:08:05PM +0100, Yeb Havinga wrote:
> Little, Douglas wrote:
> >
> >Hi,
> >
> >
> >
> >Is there a PG command or fuction that will return table ddl?
> >
> If you just want the definition,in psql type \d tablename.
> To dump ddl the pg_dump with proper arguments can dump jus
On Wed, Feb 10, 2010 at 07:01:19PM +0200, Priit Laes wrote:
>
> It might avoid the 'UU, I forgot to enable python support.',
> after you have waited a while for the build to finish...
>
+1 from me, for that very reason!
Ross
--
Ross Reedstrom, Ph.D. reed
On Mon, Jan 25, 2010 at 10:49:55AM -0600, Ross J. Reedstrom wrote:
> On Mon, Jan 25, 2010 at 06:06:53PM +0200, Alastair Bell Turner wrote:
> <..>
> > without having to add a switch to their command lines. It's not going
> > to have anything to say to experienced
On Mon, Jan 25, 2010 at 06:06:53PM +0200, Alastair Bell Turner wrote:
<..>
> without having to add a switch to their command lines. It's not going
> to have anything to say to experienced psql users anyway so it would
> probably not bug anyone enough to turn it off.
I would so use this feature goi
On Wed, Jan 13, 2010 at 05:03:33PM -0500, Robert Haas wrote:
> On Wed, Jan 13, 2010 at 4:47 PM, Tom Lane wrote:
> >
> > Spelling out "primary key" would seem to be more in keeping with existing
> > entries in that column, eg we have "not null" not "NN".
> >
> > I think this is a sensible proposal
On Mon, Dec 07, 2009 at 10:49:13AM +, Dave Page wrote:
> On behalf of the core team, I'm pleased to announce that the
>
> Congratulations!
>
+1 Congrats to you all, and thanks for the contributions, both past and
future.
As an aside, this sort of thing is one of the best signs to an external
On Tue, Nov 24, 2009 at 03:12:43PM +0900, KaiGai Kohei wrote:
> Itagaki Takahiro wrote:
> > * CREATE TABLE tbl (col integer AS SECURITY_CONTEXT = '...')
> > Is the syntax " SECURITY_CONTEXT" natural in English?
>
> We need to put a reserved token, such as "AS", prior to the SECURITY_CONTEXT
> to
On Thu, Nov 19, 2009 at 05:15:05PM -0700, u235sentinel wrote:
> Does anyone have a link for pl/ruby? I found a link under the postgres
> documentation and found a web site from there talking about the code.
> However when I clicked on the link to download it I noticed ftp wouldn't
> respond on
On Sat, Sep 25, 2004 at 11:14:53AM +0100, Simon Riggs wrote:
> >Jim C. Nasby
>
> Fair questions. MVCC has been tightly locked into Postgres/SQL for the whole
> of its history. There is much written on this and you should search some
> more - references are in the manual.
Well, not quite it's whol
On Wed, Aug 18, 2004 at 10:12:53PM -0400, Bruce Momjian wrote:
> Magnus Hagander wrote:
> >
> > Another discussion was about binary files in the tree (not being source
> > files - the source is a binary .AI file (AFAIK that's Adobe
> > Illustrator)). The question was raised wether ImageMagick coul
On Sun, Aug 08, 2004 at 01:18:02AM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>
> > Maybe a better SCM could help with this, but I doubt it.
>
> I haven't seen any particular reason why we should adopt another SCM.
> Perhaps BitKeeper or SubVersion would be better for our
On Tue, Mar 04, 2003 at 11:04:03PM -0500, Tom Lane wrote:
>
> There is still barely enough time to do the long-threatened protocol
> revision for 7.4, if we suck it up and get started on that now. I've
> been avoiding the issue myself, because it seems generally boring and
> thankless work, but m
On Fri, Feb 21, 2003 at 08:39:12PM -0600, Ross J. Reedstrom wrote:
>
> Every other validly formatted TZ variable that returns GMT should be
> caught be the datetktbl check.
>
> I'll play with it this weekend, see how hard it is to make it work.
O.K., the weekend's o
proposed order of application of tzset()
vs. table lookup?
Ross
On Mon, Feb 24, 2003 at 03:34:56PM -0600, Ross J. Reedstrom wrote:
> On Fri, Feb 21, 2003 at 08:39:12PM -0600, Ross J. Reedstrom wrote:
> >
> > Every other validly formatted TZ variable that returns GMT should be
>
On Fri, Feb 21, 2003 at 06:15:31PM -0500, Tom Lane wrote:
> "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
>
> I'm worried about cases like "Africa/Benin" for places that just happen
> to be on the prime meridian, but don't call their time
On Fri, Feb 21, 2003 at 05:45:53PM -0600, Ross J. Reedstrom wrote:
> On Fri, Feb 21, 2003 at 06:15:31PM -0500, Tom Lane wrote:
> > "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
>
> >
> > I'm worried about cases like "Africa/Benin" for
On Thu, Feb 20, 2003 at 04:19:21PM -0500, Tom Lane wrote:
> "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> > On Thu, Feb 20, 2003 at 03:21:09PM -0500, Tom Lane wrote:
> >> Provide a portable way of getting libc to tell us whether it likes TZ,
> >> and
On Thu, Feb 20, 2003 at 03:21:09PM -0500, Tom Lane wrote:
> "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> > question about pgsql's time zone parsers. It appears there's at least
> > two, since SET TIME ZONE accepts strings like 'US/Eastern
On Wed, Feb 19, 2003 at 10:35:58PM -0500, Tom Lane wrote:
> Any objections?
Not to your suggestion per se, but looking at the bug report raises a
question about pgsql's time zone parsers. It appears there's at least
two, since SET TIME ZONE accepts strings like 'US/Eastern', while general
timest
On Wed, Feb 19, 2003 at 12:03:44AM +0100, Peter Eisentraut wrote:
> Ross J. Reedstrom writes:
>
> > Yes, BSD systems that install libedit directly in /usr/include (or into
> > readline), like Patrick's, don't need it, but mine do. Is there some
> >
On Mon, Feb 17, 2003 at 12:05:20AM +0100, Peter Eisentraut wrote:
> Ross J. Reedstrom writes:
>
> I don't think this is what we were out for. We've certainly been running
> with libedit for a long time without anyone ever mentioning
> /usr/include/editline. I sugge
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote:
> On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote:
> > Patrick Welche <[EMAIL PROTECTED]> writes:
> > > On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
> > >> Well, is that a
On Sun, Feb 16, 2003 at 01:34:34AM +0100, Ian Barwick wrote:
> On Sunday 16 February 2003 01:10, Rod Taylor wrote:
> > I've been debating a mechanism which could build tab completion tables
> > based on the documentation for a while now -- and was going to give it a
> > try next week. If it works,
On Sat, Jan 25, 2003 at 09:55:25PM -0500, Bruce Momjian wrote:
> Lamar Owen wrote:
> > We'll see how it pans out, I guess.
> >
> > Red Hat certainly thought it was worth spending some time on; reference their
> > back porting of the fixes to versions as old as 6.5.3.
>
> If we can get them all,
On Thu, Jan 23, 2003 at 10:03:28AM -0500, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > I object. I personally think we should be moving towards not using OIDs
> > as the default behaviour, inasmuch as we can, for several reasons:
>
> All these objections are global in nature, not
On Fri, Jan 17, 2003 at 11:38:24AM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> >
> > A small difficulty is that explicitly-specified sysids could conflict
> > with sysids generated later by the sequence. We could perhaps fix this
> > by forcing up the sequence setting to be at least as large
On Thu, Jan 16, 2003 at 11:17:42AM -0500, Jeff wrote:
> On Wed, 15 Jan 2003, mlw wrote:
>
> So with all that, you gotta appreciate both sides - hte fact pg "just
> works" and the tunability of bigger db's (Oh yeah - and we've actually had
> informix on the horn about the problem - their solution w
On Tue, Jan 14, 2003 at 12:23:59PM +0800, Christopher Kings-Lynne wrote:
> > "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > > No, I mean that we don't drop the user. You go:
> > > ALTER USER chriskl COPY PERMISSIONS FROM blah;
> >
> > That seems cleaner to me than the DROP thingy.
> >
>
On Mon, Jan 13, 2003 at 10:01:38AM -0500, Vince Vielhaber wrote:
> On Mon, 13 Jan 2003, Dan Langille wrote:
>
> > On 13 Jan 2003 at 9:45, Vince Vielhaber wrote:
> >
> > > On Mon, 13 Jan 2003 [EMAIL PROTECTED] wrote:
> > >
> > > > > FTP is just over 800MB, plan for growth.
> > > > > WEB is just ove
On Mon, Jan 13, 2003 at 11:59:33AM +0800, Christopher Kings-Lynne wrote:
>Tom Lane writes:
> >
> > Feel free to contribute some code.
>
> I will, but unfortunately the damage has already been done...since I have to
> support 7.3 anyway, fixing the above problem will actually make my life
> harder,
On Fri, Jan 10, 2003 at 11:02:55PM +0100, Peter Eisentraut wrote:
> Ross J. Reedstrom writes:
>
> > I already posted a one-line patch to implement this, but it doesn't
> > seem to hve come through to the list. Here it is inline, instead of as
> > an attachment:
>
On Fri, Jan 10, 2003 at 07:15:34AM +, Peter Mount wrote:
> On Thu, 9 Jan 2003, Peter Eisentraut wrote:
>
> > Tom Lane writes:
> >
> > > The case I find interesting is where you're using plain "\e" to
> > > re-edit a query interactively. If this query never gets into the
> > > history buffer
On Thu, Jan 09, 2003 at 10:49:33PM +0100, Peter Eisentraut wrote:
> Christopher Kings-Lynne writes:
>
> > Is there any way of making the 'up' arrow retrieve all of the last multiline
> > query, instead of just the last line?
>
> There is nothing technical that should prevent you from implementing
On Thu, Jan 02, 2003 at 07:26:06PM -0500, Tom Lane wrote:
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > replies I will rather quickly redirect to /dev/null, as it isn't Red Hat's
> > fault we can't do a sane upgrade.
>
> I think you're wasting your time trying to hold us to a higher standard
> of
On Tue, Dec 10, 2002 at 09:04:07PM +0100, Peter Eisentraut wrote:
> Alvaro Herrera writes:
>
> > Would it work to make \d tab-completable in a way that showed both the
> > commands that are available and the objects they describe? e.g.
> >
> > \d would show something like
> > \dt [tables]\
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Found SQL/MED, Section 21 of ISO 9075-9.
>
> That's the old version, though. The new draft is at (digs out article)
> http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002
On Fri, Dec 06, 2002 at 01:52:01PM -0500, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Found SQL/MED, Section 21 of ISO 9075-9.
>
> That's the old version, though. The new draft is at (digs out article)
> http://sqlstandards.org/SC32/WG3/Progression_Documents/FCD/4FCD1-14-XML-2002
I've tested this under 7.3, and it works beautifully for the cases I've
built over the last 2 days. I can no longer bugger a plan up mearly
by reordering the WHERE clauses. Note that 2 of the five parts won't
patch in (involving constantqual). Looks to be code refactoring between
here and planmain.
On Wed, Nov 13, 2002 at 11:43:14PM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > > It seems to me that about the only major issue right now is testing the
> > > various platforms ... would anyone disagree with putting out an RC1 on
> > > Friday
, I'll fix it.
Ross
On Wed, Nov 13, 2002 at 09:28:38AM +0100, Tommi Maekitalo wrote:
> Am Mittwoch, 13. November 2002 07:22 schrieb Ross J. Reedstrom:
> > Hey Hackers -
> ...
> >
> > CREATE VIEW current_modules AS
> >SELECT * FROM m
On Wed, Nov 13, 2002 at 08:58:04AM -0500, Tom Lane wrote:
> "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes:
> > Bingo, that solved it. I'm back to 160 ms. What does Tom feel about
> > removing this? Is there some way the planner could have known which
On Wed, Nov 13, 2002 at 02:40:40AM -0500, Mike Mascari wrote:
> Ross J. Reedstrom wrote:
> >
> >For this query, the difference is 160 ms vs. 2 sec. Any reason for this
> >change?
>
> I could be way off base, but here's a shot in the dark:
>
>
>http://gr
Hey Hackers -
I was testing beta5 and found a performance regression involving
application of constraints into a VIEW - I've got a view that is fairly
expensive, involving a subselet and an aggregate. When the query is
rewritten in 7.2.3, the toplevel constraint is used to filter before
the subse
On Wed, Nov 06, 2002 at 05:02:14PM +0900, Satoshi Nagayasu wrote:
> Hannu Krosing <[EMAIL PROTECTED]> wrote:
> > > Exactly. When user send the COMMIT command to the master server, the
> > > master.talks to the slaves to process precommit-vote-commit using the
> > > 2PC. The 2PC cycle is hidden fro
On Tue, Nov 05, 2002 at 08:54:46PM +0900, Satoshi Nagayasu wrote:
>
>
> Hannu Krosing <[EMAIL PROTECTED]> wrote:
> > >
> > > In protocol-layer 2PC, no new SQL command is required.
> > > A precommit-vote-commit phase will be called implicitly. It means an
> > > user application can be used witho
On Mon, Nov 04, 2002 at 08:10:29PM -0500, Mike Mascari wrote:
> Actually, I was thinking along the lines of a true CREATE
> DATABASE LINK implementation, where multiple databases could
> participate in a distributed transaction. That would require the
> backend in which the main query is execu
On Wed, Oct 30, 2002 at 10:59:39PM -0500, Tom Lane wrote:
>
> What's the basis for your assertion that it's "planning things that
> don't need it"? Given a JOIN-constrained query I do not believe the
> planner will look at any cases other than the intended join order.
Well, that was a loose choi
Ah, so Ben finally got around to posting here. Ben's a CS Grad student
here at Rice. His (current) project involves taking some interesting
results from constraint satisfaction and implementing them on a database:
one of the CS faculty has demonstrated that one class of highly joined
DB queries map
On Tue, Sep 24, 2002 at 11:26:55AM -0400, Vince Vielhaber wrote:
> On Tue, 24 Sep 2002, Ross J. Reedstrom wrote:
> >
> > I'd suggest setting a cookie, so I only see the 'pick a mirror' the
> > first time. And provide a link to 'pick a different mirr
On Tue, Sep 24, 2002 at 03:59:33AM -0400, Vince Vielhaber wrote:
> On Tue, 24 Sep 2002, Gavin Sherry wrote:
>
> > Hi all,
> >
> > It occurs to me that opening web page on www.postgresql.org, asking the
> > user to select the mirror, is rather unprofessional. I am sure this has
> > been discussed
On Thu, Sep 19, 2002 at 06:00:37PM +0200, Zeugswetter Andreas SB SD wrote:
>
> What if he must display 9 digits and says the result is approximately 2.45678932
> would that be worse than 2.4600 ?
Yup. Trailing zeros are not significant. That's why scientific notation is nice:
you don't fill
On Thu, Sep 19, 2002 at 10:30:51AM -0500, Ross J. Reedstrom wrote:
>
> Ah, sorry to drag this on, then. But this is one of those clear cases
> were we must fo the right thing, not follow the crowd. PostgreSQL gets
do
> used by a lot of scientific projects (Have you not
On Thu, Sep 19, 2002 at 04:57:30PM +0200, Zeugswetter Andreas SB SD wrote:
>
> >
> > > Have you seen my example ? If calculated in float4 the result of
> > > 1.01*1000.0-1000.0 would be 0.0, no ?
> >
> > So? If you are storing one input as float4, then you cannot rationally
> > sa
On Wed, Sep 18, 2002 at 08:01:42PM -0400, Bruce Momjian wrote:
> Second, when you unlink() a file on Win32, do applications continue
> accessing the old file contents if they had the file open before the
> unlink?
I'm pretty sure it errors with 'file in use'. Pretty ugly, huh?
Ross
-
On Thu, Sep 12, 2002 at 01:56:19PM +0800, Christopher Kings-Lynne wrote:
>
> *sigh*
>
> Well, at least they have an easy and fast upgrade process ;)
Right, fewer pesky features to get in the way of the upgrade ;->
Ross
---(end of broadcast)---
T
On Mon, Sep 09, 2002 at 11:30:52AM -0700, Dann Corbit wrote:
> >
> > I suspect it'll be several more major releases before we
> > begin to consider it approaching completely functional.
>
> I believe that the surprise is at the focus, when it comes to a release.
> With commercial products (anyw
On Thu, Sep 05, 2002 at 10:23:02AM -0400, Tom Lane wrote:
> I really like Hannu's idea of storing an entire (single-inheritance)
> hierarchy in a single file.
Wouldn't this require solving the ALTER TABLE ADD COLUMN (to parent)
column ordering problem?
> I guess the question we need to ask ours
On Fri, Aug 30, 2002 at 02:43:38PM -0400, Matthew T. OConnor wrote:
> > As someone else mentioned (I think), even using a separate schema is not
> > always an acceptable option. If you are using a "packaged" application
> > (whether commercial or open source), you usually don't want *any*
> > chan
On Tue, Aug 27, 2002 at 06:08:40PM -0400, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > But we should have some default to print some of the query,
>
> Why? So far you've been told by two different people (make that three
> now) that such a behavior is useless, and no one's wei
On Tue, Aug 20, 2002 at 11:28:32AM -0400, Tom Lane wrote:
> "Nigel J. Andrews" <[EMAIL PROTECTED]> writes:
> > But going back to the idea that it seems that the only problem being
> > publicised in the 'outside world' is the cash_out(2) version can we
> > not do the restriction on acceptable input
On Fri, Aug 16, 2002 at 10:21:12AM -0400, Vince Vielhaber wrote:
> RPMs aren't a good enough reason to put it in. All features aren't
> installed in an RPM, why would this need to? Besides, anything that
> is runtime configurable can end up getting its default changed on a
> whim. Then again
1 - 100 of 203 matches
Mail list logo
