Re: [HACKERS] Auto Partitioning

2007-04-06 Thread Richard Troy
-cases - or observed behavior - to taylor the CYA solution to fit the need without undue overhead. Rgds, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Richard Troy
with Oracle just fine. In sum, I agree with Tom Lane and the others who chimed in with keep the docs clean, use the web site for mentioning other projects/products. And again I applaud this new effort. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747

Re: [HACKERS] Replication documentation addition

2006-10-25 Thread Richard Troy
to (re)write some of the bits discussed above. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 3: Have you checked our

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-26 Thread Richard Troy
, and maybe the odd small .gif logo, if permitted, so it won't be a huge thing. Come on now, are there thousands of such products? Tens sounds more plausible. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Richard Troy
. All that's needed are pointers, but the pointers need to be to solid documents/resources, not just the top of a heap - if you'll forgive the pun. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [HACKERS] Replication documentation addition

2006-10-27 Thread Richard Troy
, but it's hardly worth the sentence. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [HACKERS] bug in on_error_rollback !?

2006-10-28 Thread Richard Troy
it lowercase and wonder why it isn't working. :) /Greg I agree, we can't make every '\' command case-insensitive, but a few, where it makes absolute sense, should be subject to reconsideration. We have the choice of making it more user-friendly, and less confusing. -- Richard Troy, Chief

Re: [HACKERS] Design Considerations for New Authentication Methods

2006-11-02 Thread Richard Troy
-- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http

Re: [HACKERS] Design Considerations for New Authentication Methods

2006-11-02 Thread Richard Troy
, Stephen ...I thought you said this _needs_ to be done - by using words like unacceptible and required - and I disagree. There's a difference between what needs to be done and what is desired to be done. Further, I never said shouldn't. Richard -- Richard Troy, Chief Scientist Science Tools

Re: [HACKERS] recovering prepared transaction after serverrestart

2006-11-03 Thread Richard Troy
. And to the underlying question: is this the case with PostgreSql? I can't say... Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 1

Re: [HACKERS] ideas for auto-processing patches

2007-01-10 Thread Richard Troy
! -smile- Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating

Re: [HACKERS] [GENERAL] Checkpoint request failed on version 8.2.1.

2007-01-11 Thread Richard Troy
/on a web page.) On occasion, I could *really* use such a list! (If such already exists, please point me at it!) Thing is, Tom, not everybody has the same level of information you have on the subject... Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747

Re: [HACKERS] Function execution costs 'n all that

2007-01-15 Thread Richard Troy
, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Function execution costs 'n all that

2007-01-15 Thread Richard Troy
On Mon, 15 Jan 2007, Neil Conway wrote: On Mon, 2007-01-15 at 10:51 -0800, Richard Troy wrote: I therefore propose that the engine evaluate - benchmark, if you will - all functions as they are ingested, or vacuum-like at some later date (when valid data for testing may exist), and assign

Re: [HACKERS] Updateable cursors

2007-01-23 Thread Richard Troy
be updated to not only indicate usage of this new feature, but provide cautionary warnings about the potential locking issues and, for the authors of libraries, Java in particular, the possible security issues. Regards, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924

Re: [HACKERS] Proposal: allow installation of any contrib module

2007-01-25 Thread Richard Troy
now, but many are not, and in almost all cases it's only plain text not SGML. +1 * Better advertising, for instance make the contrib documentation available on the website (which probably requires SGML conversion to happen first...) +1 RT -- Richard Troy, Chief Scientist Science Tools

Re: [HACKERS] Proposal: Commit timestamp

2007-01-25 Thread Richard Troy
prototyped this system yet? ISTM you can prototype your proposal using external components so you can work out the kinks first. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL PROTECTED], http://ScienceTools.com

Re: [HACKERS] DROP FUNCTION failure: cache lookup failed for relation

2007-01-28 Thread Richard Troy
through and are usually either completely automated by well crafted programs or are performed by one person at a time - the DBA. I therefore conclude that any deadlock risk is triflingly small and would be a self-inflicted circumstance. Richard -- Richard Troy, Chief Scientist Science Tools

Re: [HACKERS] Updateable cursors

2007-01-29 Thread Richard Troy
don't want you to have to spend any of your machine's performace giving you the information you need? Help your user by giving them information when they want it. ... Do you argue that this is useless information? Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202

Re: [HACKERS] The may/can/might business

2007-02-01 Thread Richard Troy
. No, Bruce, he got it exactly right: cannot indicates, as Tom put it, logical impossibility, whereas may not suggests that something could happen but it's being prevented. His parsing of the english was spot-on. RT -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202

Re: [HACKERS] Proposal: Commit timestamp

2007-02-07 Thread Richard Troy
the various replication efforts merged as best they can be because even if the majority of users don't use a little bit of everything, surely the more interesting cases would like to and the entire community is better served if the various solutions are in harmony. Richard -- Richard Troy, Chief

Re: [HACKERS] Proposal: Commit timestamp

2007-02-08 Thread Richard Troy
. A solution that lets you blend replication strategies in a single db is, from my point of view, very important. I have no clue what got you into what you are doing here. Jan, some sleep now and then might be helpful to your public disposition. -smile- peace, Richard -- Richard Troy, Chief

Re: [HACKERS] Proposal: Commit timestamp

2007-02-09 Thread Richard Troy
, nay, installation- wide constructs as in your Commit Timestamp proposal, I don't see that there's any conflict - at least, from what I understand of existing systems and proposals to date. HTH, Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263 [EMAIL

Re: [HACKERS] Proposal: Commit timestamp

2007-02-09 Thread Richard Troy
On Fri, 9 Feb 2007, Andrew Dunstan wrote: Richard Troy wrote: In more specific terms, and I'm just brainstorming in public here, perhaps we can use the power of Schemas within a database to manage such divisions; commands which pertain to replication can/would include a schema specifier

Re: [HACKERS] Proposal: Commit timestamp

2007-02-09 Thread Richard Troy
that in a 100% backward compatible way. Jan Fantastic! ...At some point you'll be thinking of the management end - turning it on or off, etc. That might be where these other points come more into play. Richard -- Richard Troy, Chief Scientist Science Tools Corporation 510-924-1363 or 202-747-1263