Re: [HACKERS] Web site

2002-09-24 Thread Ross J. Reedstrom
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 before but

Re: [HACKERS] Web site

2002-09-24 Thread Ross J. Reedstrom
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 mirror' that resets or ignores the cookie. Or choose

Re: [HACKERS] Turning the PLANNER off

2002-10-30 Thread Ross J. Reedstrom
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

Re: [HACKERS] protocol change in 7.4

2002-11-04 Thread Ross J. Reedstrom
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

Re: [HACKERS] Turning the PLANNER off

2002-11-04 Thread Ross J. Reedstrom
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 choice of

Re: [HACKERS] protocol change in 7.4

2002-11-05 Thread Ross J. Reedstrom
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 without any

Re: [HACKERS] protocol change in 7.4

2002-11-07 Thread Ross J. Reedstrom
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 from user

[HACKERS] performance regression, 7.2.3 - 7.3b5 w/ VIEW

2002-11-12 Thread Ross J. Reedstrom
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

Re: [HACKERS] performance regression, 7.2.3 - 7.3b5 w/ VIEW

2002-11-13 Thread Ross J. Reedstrom
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://groups.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8threadm

Re: [HACKERS] performance regression, 7.2.3 - 7.3b5 w/ VIEW

2002-11-13 Thread Ross J. Reedstrom
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 modules m WHERE module_ident = (SELECT

Re: [HACKERS] performance regression, 7.2.3 - 7.3b5 w/ VIEW

2002-11-13 Thread Ross J. Reedstrom
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 was the smarter/faster order of application? As I

Re: [HACKERS] Propose RC1 for Friday ...

2002-11-15 Thread Ross J. Reedstrom
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

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Ross J. Reedstrom
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-03.pdf

Re: [HACKERS] SQL/MED spec for cross-database linkages

2002-12-06 Thread Ross J. Reedstrom
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-03.pdf

Re: [HACKERS] Upgrading rant.

2003-01-02 Thread Ross J. Reedstrom
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

Re: [HACKERS] psql and readline

2003-01-09 Thread Ross J. Reedstrom
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 it.

Re: [HACKERS] psql and readline

2003-01-09 Thread Ross J. Reedstrom
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 then you're

Re: [HACKERS] psql and readline

2003-01-10 Thread Ross J. Reedstrom
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: We need this to work without readline

Re: [HACKERS] pg_get_constraintdef

2003-01-13 Thread Ross J. Reedstrom
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, not

Re: [HACKERS] PostgreSQL site, put up or shut up?

2003-01-13 Thread Ross J. Reedstrom
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 over 90MB, can't tell

Re: [HACKERS] copying perms to another user

2003-01-14 Thread Ross J. Reedstrom
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. You could only

Re: [HACKERS] Oracle rant

2003-01-16 Thread Ross J. Reedstrom
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 was

Re: [HACKERS] Generate user/group sysids from a sequence?

2003-01-17 Thread Ross J. Reedstrom
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 as an

Re: [HACKERS] Call for objections: put back OIDs in CREATE TABLE AS/SELECT INTO

2003-01-23 Thread Ross J. Reedstrom
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

Re: [HACKERS] Todo claim: psql tab completion on schema names

2003-02-15 Thread Ross J. Reedstrom
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, that

Re: [HACKERS] psql and readline

2003-02-18 Thread Ross J. Reedstrom
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 bug in your wrapper? Or must we add a configure

Re: [HACKERS] psql and readline

2003-02-18 Thread Ross J. Reedstrom
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 suggest this part is taken out. Well, I

Re: [HACKERS] Simplifying timezone support

2003-02-20 Thread Ross J. Reedstrom
On Wed, Feb 19, 2003 at 10:35:58PM -0500, Tom Lane wrote: snip Tom discussion backend internal tracking of timezone 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

Re: [HACKERS] Simplifying timezone support

2003-02-21 Thread Ross J. Reedstrom
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', while general timestamp parsing doesn't: The TIME ZONE

Re: [HACKERS] Simplifying timezone support

2003-02-28 Thread Ross J. Reedstrom
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 I'll be glad to fix this. Dang that lovely word

Re: [HACKERS] Simplifying timezone support

2003-02-28 Thread Ross J. Reedstrom
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: snip I'm worried about cases like Africa/Benin for places that just happen to be on the prime meridian, but don't call

Re: [HACKERS] Simplifying timezone support

2003-02-28 Thread Ross J. Reedstrom
On Fri, Feb 21, 2003 at 06:15:31PM -0500, Tom Lane wrote: Ross J. Reedstrom [EMAIL PROTECTED] writes: snip 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 GMT or UTC. Looking at a globe, it also seems possible

Re: [HACKERS] Simplifying timezone support

2003-03-02 Thread Ross J. Reedstrom
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 caught be the datetktbl check

Re: [HACKERS] Simplifying timezone support

2003-03-02 Thread Ross J. Reedstrom
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 over, And I've created two

Re: [HACKERS] Error codes revisited

2003-03-05 Thread Ross J. Reedstrom
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 maybe

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Ross J. Reedstrom
On Sun, Apr 21, 2002 at 07:28:32PM +1000, Martijn van Oosterhout wrote: http://svana.org/kleptog/pgsql/page.sgml.txt I don't know whatever SGML format this is using, so the layout is not great, but the information should be accurate. I used it to create a program to dump the datafiles

Re: [HACKERS] [INTERFACES] Schemas: status report, call for developers

2002-04-30 Thread Ross J. Reedstrom
On Wed, May 01, 2002 at 10:05:23AM +0800, Christopher Kings-Lynne wrote: phpPgAdmin (WebDB) will be broken as well. I think myself and at least a few other committers lurk here tho. Other things that will break: TOra Various KDE interfaces GNUe will break, as well. Ross

Re: [HACKERS] [INTERFACES] Schemas: status report, call for developers

2002-04-30 Thread Ross J. Reedstrom
On Wed, May 01, 2002 at 12:03:00AM -0400, Tom Lane wrote: Ross J. Reedstrom [EMAIL PROTECTED] writes: GNUe will break, as well. Do I hear a volunteer to fix it? I'm willing to implement whatever clever solution we all come up with. I'll have to coordinate w/ the GNUe IRC folks to get

Re: [HACKERS] [INTERFACES] Schemas: status report, call for developers

2002-04-30 Thread Ross J. Reedstrom
On Wed, May 01, 2002 at 12:56:00AM -0400, Tom Lane wrote: Ross J. Reedstrom [EMAIL PROTECTED] writes: GNUe will break, as well. I'm willing to implement whatever clever solution we all come up with. If you need help in inventing a solution, it'd be a good idea to explain the problem

Re: [HACKERS] pgaccess

2002-05-10 Thread Ross J. Reedstrom
On Thu, May 09, 2002 at 06:33:58PM +0100, Nigel J. Andrews wrote: On Thu, 9 May 2002, Thomas Lockhart wrote: gborg is another way to organize, and of course www.pgaccess.org is a way too. It partly depends on how you see the future of pgaccess. If it stays tightly coupled to pgsql, then

Re: [HACKERS] www.pgaccess.org - the official story (the way I saw it)

2002-05-10 Thread Ross J. Reedstrom
On Thu, May 09, 2002 at 10:24:00PM +0200, Iavor Raytchev wrote: nice summary of how we got here PROPOSAL What pgaccess needs is some fresh air - it needs a small and fresh team. It needs own web site, own cvs, own mailing list. So that the people who love it, write for it and really need

Re: [HACKERS] pgaccess

2002-05-10 Thread Ross J. Reedstrom
On Fri, May 10, 2002 at 09:13:20PM +0200, Peter Eisentraut wrote: Nigel J. Andrews writes: BTW, I had been wondering what to call the Schema tab now that that label is required for schemas rather than design. Design? Thought about it, but it seems to 'active' for what's behind the tab:

Re: [HACKERS] internal voting

2002-05-13 Thread Ross J. Reedstrom
On Fri, May 10, 2002 at 11:24:40PM +0200, Peter Eisentraut wrote: Iavor Raytchev writes: 3] Still - the only thing that is not clear to me is - who is going to collect all patches and make one whole form them. As long as each of us works on a different thing - this should not be a big

Re: [HACKERS] New string functions; initdb required

2002-06-11 Thread Ross J. Reedstrom
On Tue, Jun 11, 2002 at 11:08:11AM -0700, Josh Berkus wrote: Thomas, I've just committed changes which implement three SQL99 functions and operators. OVERLAY() allows substituting a string into another string, SIMILAR TO is an operator for pattern matching, and a new variant of

Re: [HACKERS] PostGres Doubt

2002-06-18 Thread Ross J. Reedstrom
On Tue, Jun 18, 2002 at 03:24:57PM +0200, Michael Meskes wrote: On Mon, Jun 17, 2002 at 11:27:45AM -0700, Dann Corbit wrote: Here is the complete NIST regression test: ftp://cap.connx.com/pub/chess-engines/new-approach/nist.ZIP You have to use passive ftp to get files from my site

Re: [HACKERS] need assignment

2002-07-17 Thread Ross J. Reedstrom
On Wed, Jul 17, 2002 at 11:19:40PM +0800, Christopher Kings-Lynne wrote: i spoke w/jan some time ago (in a hurry now -- have to call salvation army to have them pick up my couch!). i need to jump in an discuss/get an assignment off the todo list. i am a cs doctoral student at gmu in va.

Re: [HACKERS] Inheritance

2002-08-14 Thread Ross J. Reedstrom
On Wed, Aug 14, 2002 at 09:39:06AM -0500, Greg Copeland wrote: On Tue, 2002-08-13 at 23:43, Curt Sampson wrote: Just my opinion of course, but I think it would be best to have a detailed description of how everything in inheritance is supposed to work, write a set of tests from that, and

Re: [HACKERS] tsearch bug in 7.2.1?

2002-08-15 Thread Ross J. Reedstrom
On Thu, Aug 15, 2002 at 11:59:20AM +0300, Oleg Bartunov wrote: tsearch has compiled-in stop-list, it's currently just not flexible as OpenFTS does. We plan to move most functionality to tsearch but currently have no time. Feel free to join us to speedup tsearch development. Oleg - I think

Re: [HACKERS] Companies involved in development

2002-08-15 Thread Ross J. Reedstrom
On Thu, Aug 15, 2002 at 11:05:07AM -0400, Bruce Momjian wrote: I think we are going to see more company-funded developers working on PostgreSQL. There are a handful now, but I can see lots more coming. I am going to work on getting those funding companies more visibility. We originally were

Re: [HACKERS] Open 7.3 items

2002-08-16 Thread Ross J. Reedstrom
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 as

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-20 Thread Ross J. Reedstrom
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 type in

Re: [HACKERS] Proposed GUC Variable

2002-08-27 Thread Ross J. Reedstrom
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 weighed in

Re: [HACKERS] pgaccess - where to store the own data

2002-09-04 Thread Ross J. Reedstrom
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* changes to

Re: [HACKERS] Inheritance

2002-09-05 Thread Ross J. Reedstrom
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

Re: [HACKERS] Rule updates and PQcmdstatus() issue

2002-09-09 Thread Ross J. Reedstrom
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 (anyway) if

Re: [HACKERS] MySQL wins award - makes amusing statement

2002-09-11 Thread Ross J. Reedstrom
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)--- TIP

Re: [HACKERS] Win32 rename()/unlink() questions

2002-09-18 Thread Ross J. Reedstrom
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

Re: [HACKERS] Proposal for resolving casting issues

2002-09-19 Thread Ross J. Reedstrom
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 say that you

Re: [HACKERS] Proposal for resolving casting issues

2002-09-19 Thread Ross J. Reedstrom
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 noticed all the big

Re: [HACKERS] Proposal for resolving casting issues

2002-09-19 Thread Ross J. Reedstrom
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

Re: [HACKERS] More on elog and error codes

2001-03-20 Thread Ross J. Reedstrom
On Wed, Mar 21, 2001 at 09:41:44AM +1200, Christopher Sawtell wrote: On Tue, 20 Mar 2001 10:56, you wrote: Just that it might be a good idea to incorporate the version / release details in some way so that when somebody on the list is squeaking about an error message it is obvious to the

Re: [HACKERS] pg_inherits: not found, but visible [IT GETS WORSE]

2001-03-20 Thread Ross J. Reedstrom
On Tue, Mar 20, 2001 at 08:03:16PM -0500, Joel Burton wrote: Yikes. It gets weirder. I have Zope 2.3.1b2 (most recent version of Zope) running on a Linux-Mandrake 7.2 box (server #1) What kind of filesystem is the pgsql data tree living on? If you do a fsck, does anything turn up

Re: [HACKERS] New TODO item

2001-03-21 Thread Ross J. Reedstrom
On Wed, Mar 21, 2001 at 10:51:03AM -0500, Bruce Momjian wrote: Added to TODO: * Add BETWEEN [ASYMMETRIC|SYMMETRIC] Ross did a patch for this but some wanted it implemented differently so I just added it to the TODO list. Hmm, have I been coding in my sleep? I think I perhaps

Re: [HACKERS] pg_dump performance lossage for primary keys

2001-04-03 Thread Ross J. Reedstrom
On Tue, Apr 03, 2001 at 03:34:51PM -0400, Tom Lane wrote: Philip Warner [EMAIL PROTECTED] writes: We really need ALTER TABLE ADD CONSTRAINT for PK. That would be a cleaner way to do it, all right ... but for now, you can just reach in and set the indisprimary flag in pg_index after

Re: [HACKERS] Re: I don't understand...

2001-05-22 Thread Ross J. Reedstrom
Gabor - Tri-valued logic strikes again. Remember, NULL represents don't know, which means could be anything. So, when you ask the system to return values that are guaranteed not to be in a list, and that list contains a NULL, the system returns nothing, since the NULL _could_ be equal to the

Re: [HACKERS] Re: Various silliness in heap_getnext and related routines

2001-06-18 Thread Ross J. Reedstrom
On Mon, Jun 11, 2001 at 12:21:56PM -0400, Robert E. Bruccoleri wrote: Dear Tom, [EMAIL PROTECTED] (Robert E. Bruccoleri) writes: BTW, given the high level of support that you provide to the PostgreSQL community, it's very accurate to state that support for PostgreSQL is far

Re: [HACKERS] vacuum

2001-06-19 Thread Ross J. Reedstrom
On Wed, Jun 13, 2001 at 06:24:10PM -0300, The Hermit Hacker wrote: Now that you've narrowed it down to a specific table, at least you can specifically vacuum just that table and ignore the rest of the database ...might help a bit? Even better: since he's loading a script anyway, the script

Re: [HACKERS] RE: Universal admin frontend

2001-06-20 Thread Ross J. Reedstrom
On Wed, Jun 20, 2001 at 09:13:13AM +0200, Pedro Abelleira Seco wrote: To say it briefly if an average IT manager asks you to show him PostgreSQL and you open pgsql or pgaccess you are done. Sad but true. Well, then open Access. What do you do when the same manager wants to see your web

Re: [HACKERS] Re: Primary Key

2001-06-20 Thread Ross J. Reedstrom
Hmm, your using ColdFusion, so that goes through the ODBC driver, which picks up the 'primary key' by looking for an index named 'foo_pkey', I think. Ah, here it is: in interfaces/odbc/info.c: sprintf(tables_query, select ta.attname, ia.attnum from pg_attribute ta, pg_attribute ia,

Re: [HACKERS] Setuid functions

2001-06-20 Thread Ross J. Reedstrom
On Thu, Jun 21, 2001 at 09:44:43AM +0800, Christopher Kings-Lynne wrote: Okay, what I'm thinking is to have a pair of commands added to PL/pgSQL. For the sake of example we'll call them: ENABLE PRIVLEDGE -- Sets user ID to that of the function's owner DISABLE PRIVLEDGE -- Restores

Re: [HACKERS] Re: Universal admin frontend

2001-06-22 Thread Ross J. Reedstrom
On Thu, Jun 21, 2001 at 02:32:59PM +1000, Joe Shevland wrote: I'd certainly be keen on helping out with a Java/Swing approach. It would be an excellent test of the meta-data stuff in the JDBC driver and to catch any ommissions. I'm willing to provide a homepage etc if wanted (and for some

Re: [HACKERS] Any tips for this particular performance problem?

2001-07-10 Thread Ross J. Reedstrom
On Tue, Jul 10, 2001 at 09:46:07AM -0700, Stephan Szabo wrote: On Tue, 10 Jul 2001, Sergio Bruder wrote: If you have time, take a quick look at http://acidlab.sourceforge.net/perf/acid_perf.html PostgreSQL has serious scalability problems with snort + acid. Any advices? (Now

Re: [HACKERS] pg_depend

2001-07-18 Thread Ross J. Reedstrom
On Wed, Jul 18, 2001 at 01:08:15PM +1000, Philip Warner wrote: At 11:25 18/07/01 +0900, Hiroshi Inoue wrote: Oops I made a mistake. Reference name is needed not an object name, i.e object relid object oid relerence relid reference oid reference name I

Re: [HACKERS] pg_depend

2001-07-19 Thread Ross J. Reedstrom
On Fri, Jul 20, 2001 at 08:45:05AM +0900, Hiroshi Inoue wrote: It doesn't seem preferable that the default(unadorned) DROP allows reattachement after the DROP. The default(unadorned) DROP should be the same as DROP RESTRICT(or CASCADE because the current behabior is halfway CASCADE?). How

Re: OID wraparound (was Re: [HACKERS] pg_depend)

2001-07-18 Thread Ross J. Reedstrom
On Wed, Jul 18, 2001 at 04:06:28PM -0400, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Is the idea to make oid's optional, with them disabled by default on user tables? My thought is to make OID generation optional on a per-table basis, and disable it on system tables that

Re: [HACKERS] varchar vs. text

2001-07-11 Thread Ross J. Reedstrom
On Wed, Jul 11, 2001 at 09:56:27AM -0400, Jan Wieck wrote: Rachit Siamwalla wrote: Is there any good reason to use VARCHAR over TEXT for a string field? ie. performance hits, etc. Other than running into the row size limit problem, are there any large storage / performance penalties

Re: [HACKERS] Re: From TODO, XML?

2001-07-29 Thread Ross J. Reedstrom
On Sun, Jul 29, 2001 at 12:19:48PM -0400, mlw wrote: employee nameBill/name positionProgrammer/position address number1290/number street nameCanton Ave/name /street town nameMilton/name /town /address /emplyee The

Re: [HACKERS] Re: [PATCHES] Select parser at runtime

2001-08-12 Thread Ross J. Reedstrom
On Sun, Aug 12, 2001 at 10:21:55PM -0400, Vince Vielhaber wrote: If you think that people are going to flock to PostgreSQL from Oracle simply because it's a drop in replacement, I want some of whatever it is you're drinking! An Oracle compatibility mode wouldn't be a bad idea, but at what

Re: [HACKERS] Re: Rough idea for supporting sequencename.nextval syntax

2001-08-17 Thread Ross J. Reedstrom
On Thu, Aug 16, 2001 at 10:36:49PM -0400, Tom Lane wrote: I said: Suppose that we invent a new datatype regclass, similar to regproc: it's actually an OID, but it has the additional implication that it is the OID of a pg_class row, and the I/O operations for the type try to accept or

Re: [HACKERS] Link to bug webpage

2001-08-21 Thread Ross J. Reedstrom
On Tue, Aug 21, 2001 at 09:51:29AM -0400, Bruce Momjian wrote: It's up to the group to decide. If we have a database of bugs, I think it has to be complete. I think a partial list is worse than no list at all. I disagree. Unless you are omniscient, we will only ever have a

Re: [HACKERS] User locks code

2001-08-24 Thread Ross J. Reedstrom
Uh, guys? The last thing I can find that Massimo says about the license is this, from Sunday: On Sun, Aug 19, 2001 at 11:15:54PM +0200, Massimo Dal Zotto wrote: Regarding the licencing of the code, I always release my code under GPL, which is the licence I prefer, but my code in the backend

Re: [HACKERS] Is there no DESCRIBE TABLE; on PGSQL? help!!!

2001-10-23 Thread Ross J. Reedstrom
On Sat, Oct 20, 2001 at 05:24:39PM +0200, Ron de Jong wrote: Not even close! Oh? What's it missing? the \dt display in psql has all the information in your mythical table versionbelow, just organized a little differently, doesn't it? Particularly on the hackers list, if there's a feature you

Re: [HACKERS] schema support, was Package support for Postgres

2001-10-24 Thread Ross J. Reedstrom
On Tue, Oct 23, 2001 at 08:43:32AM -0700, Bill Studenmund wrote: And there's the fact that schemas were wanted for 7.2, and didn't happen. Withouth external adgitation, will they happen for 7.3? Given the size of the job, I understand why they didn't happen (the package changes so far

Re: [PHP] [HACKERS] [BUGS] PostgreSQL / PHP Overrun Error

2001-10-01 Thread Ross J. Reedstrom
On Fri, Sep 28, 2001 at 03:50:12PM -0400, Bruce Momjian wrote: I'm using the current CVS (4.0.8-dev)- It's spectacular. Lower memory usage, more descriptive debug, better control over it. Tons more options, smaller code, much much faster. snip Note: if you are not having the problem

Re: [HACKERS] Again, sorry, caching.

2002-03-19 Thread Ross J. Reedstrom
On Mon, Mar 18, 2002 at 09:35:51PM -0500, Neil Conway wrote: It is an application issue This is completely wrong. Caching can not be done against a database without knowledge of the database, i.e. when the data changes. But can't this be achieved by using a LISTEN/NOTIFY model, with

Re: [HACKERS] Again, sorry, caching.

2002-03-20 Thread Ross J. Reedstrom
On Tue, Mar 19, 2002 at 08:28:19PM -0500, Neil Conway wrote: On Tue, 2002-03-19 at 19:20, F Harvell wrote: I feel that the caching should be SQL transparent. If it is implemented reasonably well, the performance gain should be pretty much universal. Well, the simple query cache scheme

Re: [HACKERS] SET NULL / SET NOT NULL

2002-03-21 Thread Ross J. Reedstrom
On Fri, Mar 22, 2002 at 02:34:57PM +0800, Christopher Kings-Lynne wrote: Do we want the above syntax, or this syntax: ALTER TABLE blah ALTER COLUMN col SET NOT NULL; ALTER TABLE blah ALTER COLUMN col SET NULL; My only objection to the second command is that it's plain wrong. You

Re: [HACKERS] SET NULL / SET NOT NULL

2002-03-22 Thread Ross J. Reedstrom
On Fri, Mar 22, 2002 at 01:12:09PM -0500, Tom Lane wrote: Also I agree with Fernando that trying to make the word COLUMN optional is likely to lead to conflicts. According to the docs, COLUMN is _already_ optional at that point. Are the changes past that point going to cause different

Re: [HACKERS] timeout implementation issues

2002-04-05 Thread Ross J. Reedstrom
On Fri, Apr 05, 2002 at 11:19:04AM -0500, Tom Lane wrote: Jan Wieck [EMAIL PROTECTED] writes: Could we get out of this by defining that timeout is automatically reset at next statement end? I was hoping to avoid that, because it seems like a wart. OTOH, it'd be less of a

Re: Postgres development model (was Re: [HACKERS] CVS comment)

2004-08-08 Thread Ross J. Reedstrom
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

Re: [HACKERS] Open items

2004-08-19 Thread Ross J. Reedstrom
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 could do

Re: [HACKERS] 'TID index'

2004-09-25 Thread Ross J. Reedstrom
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 whole

Re: [HACKERS] My new job

2000-10-13 Thread Ross J. Reedstrom
to reveal the content. Well, there's my nickel. Do with it what you will. Ross Ross J. Reedstrom, [EMAIL PROTECTED] NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005 -- Open source code is like a natural resource

Re: [HACKERS] TIOGA

2000-10-13 Thread Ross J. Reedstrom
On Wed, Oct 11, 2000 at 02:40:47PM -0400, Bruce Momjian wrote: On Wed, 11 Oct 2000, Bruce Momjian wrote: Considering no one has used it in 4 years that I remember, my guess is that it is an abandonded Berkeley project. If it does not break anything in our build process, please let

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-13 Thread Ross J. Reedstrom
On Fri, Oct 13, 2000 at 04:10:48PM -0400, Bruce Momjian wrote: We were talking about this today down here at Great Bridge, and I mentioned that there is very little that happens in the core group. Up until Great Bridge arrived, and we had to secretly communicate with them, there really

Re: [HACKERS] when does CREATE VIEW not create a view?

2000-10-16 Thread Ross J. Reedstrom
On Mon, Oct 16, 2000 at 12:22:23PM -0400, Bruce Momjian wrote: OK, the bad news is that this does not apply to the current development tree. Ross, can you make a more corrent one? Sorry. I think it won't apply because it's already in there. There were also subsequent fixes to how pg_dump

Re: [PATCHES] Re: [HACKERS] when does CREATE VIEW not create a view?

2000-10-16 Thread Ross J. Reedstrom
On Mon, Oct 16, 2000 at 03:31:08PM -0500, Ross J. Reedstrom wrote: On Mon, Oct 16, 2000 at 12:22:23PM -0400, Bruce Momjian wrote: OK, the bad news is that this does not apply to the current development tree. Ross, can you make a more corrent one? Sorry. I think it won't apply because

Re: [HACKERS] Now 376175 lines of code

2000-10-20 Thread Ross J. Reedstrom
On Fri, Oct 20, 2000 at 01:30:25PM -0400, Bruce Momjian wrote: I compute the code count with: find . -name \*.[chyl] | xargs cat| wc -l Right, that solves the problem others might be seeing, with the command line getting expanded and silently chopped off. For example, no one seems to

Re: [HACKERS] New build fails: cannot find postmaster.opts.default

2000-10-20 Thread Ross J. Reedstrom
On Fri, Oct 20, 2000 at 04:15:11PM -0700, Kevin O'Gorman wrote: I've just built 7.1 from a slightly old point in the tree: October 9. Regression tests pass, but postmaster won't start. I'm getting a complaint from pg_ctl that it cannot find postmaster.opts.default. What am I missing?

Re: [HACKERS] failed runcheck

2000-10-25 Thread Ross J. Reedstrom
On Sun, Oct 22, 2000 at 01:26:07AM -0400, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Next question: why is RelationInitLockInfo using RelationGetPhysicalRelationName to get the input data for IsSharedSystemRelationName --- shouldn't that be a test on logical relation name?

  1   2   >