Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-14 Thread Andrew Sullivan
On Fri, Dec 14, 2007 at 09:02:04AM +, Gregory Stark wrote: Oh, and incidentally the problem with WARNING is that this is DML which could potentially be executing hundreds or thousands of times per minute. A WARNING is effectively an ERROR. Good point. Also, the sort of case where you're

Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-14 Thread Andrew Sullivan
On Thu, Dec 13, 2007 at 11:31:17PM -0500, Merlin Moncure wrote: for historical record, this comment (subject not directly related to the OP) was probably this: http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg62562.html Bingo. Thanks! A ---(end of

Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-13 Thread Andrew Sullivan
On Fri, Dec 14, 2007 at 01:47:23AM +, Gregory Stark wrote: Huh, I was all set to post an example of a useful application of it but then apparently I'm wrong and it doesn't work: I dimly remember some discussion of this issue once before, maybe a year ago. My memory isn't what it was, and I

Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-13 Thread Andrew Sullivan
On Thu, Dec 13, 2007 at 10:06:35PM -0500, Tom Lane wrote: of a negative limit, it's meeting its spec. If you want to throw an error for negative limit, shouldn't you logically also throw an error Should it be a WARNING? A ---(end of

Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-13 Thread Andrew Sullivan
On Thu, Dec 13, 2007 at 10:01:43PM -0500, Jonah H. Harris wrote: Man, maybe my mad Google skillz are not as mad as I thought :( Hey, I worked in a library some years ago, when Google was just a googlet, and I couldn't find it either. It's a dim memory, note. Which could mean artifact. I'm

Re: [HACKERS] WORM and Read Only Tables (v0.1)

2007-12-12 Thread Andrew Sullivan
On Wed, Dec 12, 2007 at 12:14:43PM +0100, Zeugswetter Andreas ADI SD wrote: Uniqueness is currently perfectly practical, when the unique index contains the column[s] that is/are used in a non overlapping partitioning scheme. Well, yes, assuming you have no bugs. Part of the reason I want the

Re: [HACKERS] WORM and Read Only Tables (v0.1)

2007-12-12 Thread Andrew Sullivan
On Wed, Dec 12, 2007 at 12:58:11PM +0100, Zeugswetter Andreas ADI SD wrote: Wouldn't one very substantial requirement of such storage be to have it independent of db version, or even db product? Keeping old hardware and software around can be quite expensive. This was one of the explicit

Re: [HACKERS] WORM and Read Only Tables (v0.1)

2007-12-12 Thread Andrew Sullivan
On Wed, Dec 12, 2007 at 07:07:57PM +, Simon Riggs wrote: Enforcing uniqueness with a global index has a number of disadvantages. This is why I was trying to talk about constraints rather than global indexes. Just because we happen to implement them that way today does not mean that such

Re: [HACKERS] WORM and Read Only Tables (v0.1)

2007-12-11 Thread Andrew Sullivan
On Tue, Dec 11, 2007 at 11:12:46AM +, Simon Riggs wrote: Read-Only Tables In the past when this topic came up, there was some discussion of doing this at a level somewhere below the table horizon. There are a number of nasty limitations for partitions currently (not the

Re: [HACKERS] Quality and Performance

2007-11-27 Thread Andrew Sullivan
is the time to list some specific performance areas you want to fix up? A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] How to keep a table in memory?

2007-11-13 Thread Andrew Sullivan
. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [HACKERS] How to keep a table in memory?

2007-11-13 Thread Andrew Sullivan
they're smarter than the system. Much of the time, this sort of thumb on the scale optimisation just moves the cost to some other place, and the admin's analysis isn't comprehensive enough to turn that up until it's all turned on in production. A -- Andrew Sullivan Old sigs will return after re

Re: [HACKERS] Simplifying Text Search

2007-11-12 Thread Andrew Sullivan
a standard set of such sugar if they wanted. A -- Andrew Sullivan Old sigs will return after re-constitution of blue smoke ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] PANIC caused by open_sync on Linux

2007-10-29 Thread Andrew Sullivan
, IMO. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] PANIC caused by open_sync on Linux

2007-10-26 Thread Andrew Sullivan
that, no? A -- Andrew Sullivan | [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

2007-09-06 Thread Andrew Sullivan
want is near-real-time online backups with _no cost_, which is not a feature that I think anyone will ever work on. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath

Re: [HACKERS] Password requirement in windows installer

2007-08-31 Thread Andrew Sullivan
originate spoofed TCP packets from 127.0.0.1, you gots bigger problems than them being able to lie about the identity of a user. A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues

Re: [HACKERS] Password requirement in windows installer

2007-08-31 Thread Andrew Sullivan
if you did run it, it would not represent a real risk.) -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie ---(end of broadcast

Re: [HACKERS] Password requirement in windows installer

2007-08-31 Thread Andrew Sullivan
authentication for this reason (but it's not perfect either -- if someone has root, they have root. You're hosed). None of my employers ever seem willing to pay the additional overhead, however. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data

Re: [HACKERS] Password requirement in windows installer

2007-08-31 Thread Andrew Sullivan
in for bridged packets? Are you 100.0% sure? I dunno, but I do know that I'd test it before I started doing it :) A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism

Re: [HACKERS] SQL feature requests

2007-08-24 Thread Andrew Sullivan
doesn't fail either of these. From what I can see upthread, it fails 1 and possibly 2. Given that we don't seem to know _why_ it is forbidden, there could well be a case under 2 is a problem, and we haven't thought of it. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens

Re: [HACKERS] Obfuscated definitions of database objects

2007-08-24 Thread Andrew Sullivan
committed to doing it. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---(end of broadcast

Re: [HACKERS] crypting prosrc in pg_proc

2007-08-09 Thread Andrew Sullivan
don't care to pursue. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] crypting prosrc in pg_proc

2007-08-09 Thread Andrew Sullivan
weight that may foil casual users, but that are trivially broken by anyone actually interested in doing the breaking. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism

Re: [HACKERS] Straightforward changes for increased SMP scalability

2007-07-16 Thread Andrew Sullivan
, and adding incremental changes near the end of the cycle strikes me as a possible source of significant additional surprises (and therefore delays). I am no code expert, though; I just wanted to be sure there's consensus on the simplicity of the changes. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [HACKERS] bit string functions

2007-07-16 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] The very definition of news is something that hardly ever happens. --Bruce Schneier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] 2PC-induced lockup

2007-07-12 Thread Andrew Sullivan
, If you are completely hosed, you will lose some data. But 2PC is making some pretty strong promises, and I sort of hate it that it's not real hard to break things in such a way that those promises have to be broken. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter

Re: [HACKERS] 2PC-induced lockup

2007-07-12 Thread Andrew Sullivan
of all of them? (I'm not suggesting that no data must ever be lost in this case; just that we should lose the minimum necessary to make the system work.) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money

Re: [HACKERS] 2PC-induced lockup

2007-07-11 Thread Andrew Sullivan
On Wed, Jul 11, 2007 at 10:43:23AM -0400, Chris Browne wrote: The right resolution to this is not, a priori, evident yet. _A posteriori_, though, it seems to me the right resolution is don't do that ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may

Re: [HACKERS] 2PC-induced lockup

2007-07-11 Thread Andrew Sullivan
, but on a production system, you'd violate the semantics of 2PC by doing this? A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath. --Damien Katz

Re: [HACKERS] 2PC-induced lockup

2007-07-11 Thread Andrew Sullivan
. But how do you know which file to delete? Is it keyed to the transaction identifier or something? A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues in a great many others

Re: [HACKERS] 2PC-induced lockup

2007-07-11 Thread Andrew Sullivan
the commitment you made before crash when you accepted a PREPARE TRANSACTION is going to be gone, which violates the 2PC rules. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-26 Thread Andrew Sullivan
. I think it should be regarded as Dead, Jim. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-25 Thread Andrew Sullivan
-authentication=trust or something like that. Using this approach, packagers can also continue to do what they want. A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-25 Thread Andrew Sullivan
think it's a bad thing that you run superuser-type commands without reading the manual, and then get a badly-secured system. (The idea here, incidentally, is not to replace the initdb-time option, but to set the default of the initdb command.) A -- Andrew Sullivan | [EMAIL PROTECTED] When my

Re: [HACKERS] GUC time unit spelling a bit inconsistent

2007-06-21 Thread Andrew Sullivan
that Tom's original suggestion was at least a HINT, which seems perfectly reasonable to me. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ritchie

Re: [HACKERS] GUC time unit spelling a bit inconsistent

2007-06-21 Thread Andrew Sullivan
On Thu, Jun 21, 2007 at 11:55:56AM -0400, Tom Lane wrote: where the HINT gets appended if there's something after the integer but it doesn't look like any of the allowed units. Objections? Sounds like a good idea to me. A -- Andrew Sullivan | [EMAIL PROTECTED] The very definition of news

Re: What does Page Layout version mean? (Was: Re: [HACKERS] Reducing NUMERIC size for 8.3)

2007-06-20 Thread Andrew Sullivan
is needed, though. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Andrew Sullivan
on such disclaimers, pointing out the folly of their ways and asking that the policy be changed to distinguish between list-posting and non-list-posting accounts. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end

Re: [HACKERS] Avoiding legal email signatures

2007-06-10 Thread Andrew Sullivan
is what the proposal so far sounds like to me. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end

Re: [HACKERS] Controlling Load Distributed Checkpoints

2007-06-08 Thread Andrew Sullivan
. Do you mean change the OS settings or something else? (I'm not sure it's true in any case, because shared memory kernel settings have to be fiddled with in many instances, but I thought I'd ask for clarification.) A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software

Re: [HACKERS] COPYable logs status

2007-06-08 Thread Andrew Sullivan
, but maybe others have thought about some of these things. I haven't read the draft, note.) http://tools.ietf.org/html/draft-ietf-syslog-protocol-20 There's also the discussion of reliability in RFC 3195: ftp://ftp.rfc-editor.org/in-notes/rfc3195.txt A -- Andrew Sullivan | [EMAIL PROTECTED] The whole

Re: [HACKERS] Controlling Load Distributed Checkpoints

2007-06-08 Thread Andrew Sullivan
you're in (if I'm paying for dedicated hosting, you better believe I'm going to insist they tune the kernel the way I want), but you're right that in shared hosting for $25/mo, it's not going to happen. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good

Re: [HACKERS] Signing off of patches (was Re: Not ready for 8.3)

2007-05-18 Thread Andrew Sullivan
learn more of the code in each cycle. I think this is similar to a previous suggestion someone made about mentored review, but it doesn't require formal mentoring for it to get started. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use

Re: [HACKERS] Not ready for 8.3

2007-05-17 Thread Andrew Sullivan
. PostgreSQL has a history with remarkably few of those blunders, and I'd hate to give that up. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast

Re: [HACKERS] Managing the community information stream

2007-05-08 Thread Andrew Sullivan
think it's democratic. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ

Re: [HACKERS] Multiple Storage per Tablespace, or Volumes

2007-02-20 Thread Andrew Sullivan
set to the user, and tell it call back in 24 hours for your full report. Yes, I know, hands waving in the air. But I already said I was having a you know what would be sweet moment. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show

Re: [HACKERS] Multiple Storage per Tablespace, or Volumes

2007-02-19 Thread Andrew Sullivan
that would tell one which spans of data are candidates for the search, you could bring back online (onto reasonably fast storage, for instance) just the volumes you need to read. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use

Re: [HACKERS] Modifying and solidifying contrib

2007-02-06 Thread Andrew Sullivan
) I used to do this as a matter of completeness, and never had a collision. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast

Re: [HACKERS] Modifying and solidifying contrib

2007-02-06 Thread Andrew Sullivan
On Tue, Feb 06, 2007 at 11:43:24AM -0500, Andrew Dunstan wrote: Andrew Sullivan wrote: As a data point, some time ago (7.2 days) I used to do this as a matter of completeness, and never had a collision. The point I at least have been trying to make is that extensions generally (e.g

Re: [HACKERS] Proposal: Commit timestamp

2007-02-05 Thread Andrew Sullivan
with this too, I guess, to solve for conflict cases, but that seems like the sort of decision that needs to be pushed down to policy level. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell

Re: [HACKERS] May, can, might

2007-02-02 Thread Andrew Sullivan
) agreeing that MAY and may are not the same word. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Introducing an advanced Frequent Update Optimization

2006-11-09 Thread Andrew Sullivan
this problem to sink forever, because it's a big problem. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland

Re: [HACKERS] Design Considerations for New Authentication Methods

2006-11-02 Thread Andrew Sullivan
of several applications for SASL/GSSAPI where something weaker will simply not do; in the absence of the proposed functionality, I simply wouldn't be able to use Postgres for those applications. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking

Re: [HACKERS] Force 8.2 initdb to rename pg_database/pg_class minxid columns?

2006-11-02 Thread Andrew Sullivan
entails backwards incompatibility for many users, and the change no longer signifies an actual change to underlying functionality, though, it seems worth the pain to me. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Andrew Sullivan
don't see it ATM, I guess because the URL isn't chosen yet?) We get so many questions about what replication system that I'm sure people are looking for outlines. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably

Re: [HACKERS] Replication documentation addition

2006-10-26 Thread Andrew Sullivan
in the FAQ fwiw). Once it is in place, it will be stable though. Surely this is what redirects were invented for, no? http://www.postgresql.org/replication redirects to [stable magic URL] Put the former in the docs. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow

Conference materials (Was: [HACKERS] pdfs of the conference)

2006-10-24 Thread Andrew Sullivan
On Tue, Sep 19, 2006 at 12:29:18PM -0400, Andrew Sullivan wrote: The slides, all the photos, and even the audio are, I've been assured, going to get cleared up in the next few days. Well, those were some very long days, but it seems a good time to note that the slides and audio (all that we

Re: [pgsql-advocacy] Conference materials (Was: [HACKERS] pdfs of

2006-10-24 Thread Andrew Sullivan
on the way, but we don't have them yet. Someone is reportedly doing some sort of audio magic to improve the sound. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 4

Re: [HACKERS] On status data and summaries

2006-10-13 Thread Andrew Sullivan
maintain is that it is a flat text file, so I can update it in seconds. If a wiki doesn't work, then surely a CVS repository with the flat file in it would? That'd be easy enough to post weekly or something, no? A -- Andrew Sullivan | [EMAIL PROTECTED] Windows is a platform without soap, where

Re: [HACKERS] [PERFORM] Hints proposal

2006-10-13 Thread Andrew Sullivan
an immediate result, and be annoyed when that short cut later turns out to have been expensive. Postgres will get a black eye from that (Too hard to manage! Upgrades cause all sorts of breakage!). A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger

Re: [HACKERS] On status data and summaries

2006-10-12 Thread Andrew Sullivan
/features/whatever to me to watch? Would that help? (I don't care how we do it, so long as it would be helpful and so long as it's wanted.) A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out

Hints (was: [HACKERS] Index Tuning Features)

2006-10-12 Thread Andrew Sullivan
plenty of statistics math kicking around that allows one to discover such relationships, and they have the benefit of not being by definition a way to work around the optimiser. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use

Hints (Was: [HACKERS] Index Tuning Features)

2006-10-12 Thread Andrew Sullivan
relationships in the system in such a way that the optimizer can learn to use that information. _That_ seems to me to be a big improvement, because it can be taken into consideration along with relationships that emerge from the statistics, that the DBA may not know about. A -- Andrew Sullivan

Re: [HACKERS] [PERFORM] Hints proposal

2006-10-12 Thread Andrew Sullivan
for right now gives me the willies. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [HACKERS] On status data and summaries

2006-10-12 Thread Andrew Sullivan
this as a suggestion to pick some threads, keep track of them, but otherwise shut up until feature freeze? That's ok with me, if that's what helps; but I was under the impression from the meta-discussion last time that people didn't think that was working. Anyone? A -- Andrew Sullivan | [EMAIL

Re: [HACKERS] On status data and summaries

2006-10-12 Thread Andrew Sullivan
many cycles keeping on top of this. Or maybe I just misunderstood what the problem was people were having. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath. --Damien

Re: [HACKERS] [PERFORM] Hints proposal

2006-10-12 Thread Andrew Sullivan
into this latter category. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end of broadcast

Re: [HACKERS] Index Tuning Features

2006-10-11 Thread Andrew Sullivan
.) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [HACKERS] Index Tuning Features

2006-10-11 Thread Andrew Sullivan
was better knowledge, based on some analysis of the data. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 6: explain analyze is your

[HACKERS] On status data and summaries

2006-10-11 Thread Andrew Sullivan
? A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

Re: [HACKERS] PostgreSQL HA questions

2006-09-27 Thread Andrew Sullivan
detailed outlines of how to do this sort of thing by searching for rotor tables. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin

Re: [HACKERS] Sane error messages for SSL retry cases

2006-09-26 Thread Andrew Sullivan
when talking to an 8.2 or later server. Thoughts? Is this something to tackle during beta, or must we put it off till 8.3? It sounds to me like a very nice idea that has to wait for the next cycle. Just getting agreement on the categories will take time and cycles, no? A -- Andrew Sullivan

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-25 Thread Andrew Sullivan
On Fri, Sep 22, 2006 at 12:59:36PM -0700, Joe Conway wrote: In that case, what about things on gborg too? Yes, same idea. I don't care where the project _lives_; the important thing is its integration with PostgreSQL (and its quality). A -- Andrew Sullivan | [EMAIL PROTECTED] When my

Re: [HACKERS] Release Notes: Major Changes in 8.2

2006-09-22 Thread Andrew Sullivan
products or something? A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast

Re: [HACKERS] pg_upgrade: downgradebility

2006-09-20 Thread Andrew Sullivan
, if you've upgraded to 8.1.x, you replicate to an old 8.0.x back end as well. If 8.1 doesn't work for you, you just MOVE everything back to the 8.0.x back end, and you're golden. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics

Re: [HACKERS] pg_upgrade: downgradebility

2006-09-20 Thread Andrew Sullivan
in the new system. But in the new system, you can have just one of those flags by itself, and there's no obvious way to preserve that data when moving back to the old protocol. If we never have that sort of case with the binary formats, then what you propose ought to work. A -- Andrew Sullivan

Re: [HACKERS] pdfs of the conference

2006-09-19 Thread Andrew Sullivan
to make an announcement when everything is done. Best, A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)--- TIP 4: Have you searched

Re: [HACKERS] Getting a move on for 8.2 beta

2006-09-06 Thread Andrew Sullivan
, and that sort of thing? (Yes, I'll put my money where my mouth is.) A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath. --Damien Katz ---(end of broadcast

Re: [HACKERS] integration of pgcluster into postgresql

2006-09-05 Thread Andrew Sullivan
let me know. If people want to contact me off-list, that's also fine; I'll summarise. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 3

Re: [HACKERS] anoncvs still slow

2006-05-29 Thread Andrew Sullivan
of resources. Unfortunately, there's no standards-compliant way to drop such connections on the floor instead of erroring, once you've accepted the mail. Better to reject at the time of connection, which is what the local_recipient_maps setting is for. A -- Andrew Sullivan | [EMAIL PROTECTED

Re: [HACKERS] LIKE, leading percent, bind parameters and indexes

2006-05-25 Thread Andrew Sullivan
lucky, and hit it. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast

Re: [HACKERS] PostgreSQL Anniversary Summit, Call for Contributions

2006-03-09 Thread Andrew Sullivan
your help. Please contact me off list in that case. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [HACKERS] new feature: LDAP database name resolution

2006-02-20 Thread Andrew Sullivan
UNIX does things: small tools that each do one job, piped together. A connection dispatcher should be pretty cheap, and those who have reported success with pgpool have remarked on how lightweight it is. A -- Andrew Sullivan | [EMAIL PROTECTED] The year's penultimate month is not in truth

Re: [HACKERS] Cleaning up the INET/CIDR mess

2006-01-24 Thread Andrew Sullivan
(I don't think it is, is it?) then I'd argue for erroring, on the same grounds of what I say above. But otherwise, I think you could ignore it. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually

Re: [HACKERS] Replication on the backend

2005-12-07 Thread Andrew Sullivan
(by definition) it's a modular extension. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---(end

Re: [HACKERS] Race condition in backend process exit

2005-08-11 Thread Andrew Sullivan
). A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---(end of broadcast)--- TIP 3: Have

Re: [HACKERS] Simplifying wal_sync_method

2005-08-11 Thread Andrew Sullivan
wouldn't be surprised if they'd wired fsync directly to something else; but I can hardly believe it'd be faster than any other option. (Mind, we were using Veritas filesyste with this, as well, which was at least half the headache.) A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology

Re: [HACKERS] Solving the OID-collision problem

2005-08-09 Thread Andrew Sullivan
a bit of time preparing for it. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast

Re: [HACKERS] Server instrumentation for 8.1

2005-05-11 Thread Andrew Sullivan
be included in desktop systems -- but enabled-by-default for many of these things seems to me to be too dangerous. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now

Re: [HACKERS] pl/pgsql enabled by default

2005-05-07 Thread Andrew Sullivan
system. Indeed. But that doesn't mean that the principle isn't sound for both cases. I haven't seen an argument against that yet. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast

Re: [HACKERS] pgFoundry

2005-05-06 Thread Andrew Sullivan
. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] pgFoundry

2005-05-06 Thread Andrew Sullivan
.) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton ---(end of broadcast)--- TIP 3: if posting/reading

[HACKERS] Praise (was: [ADMIN] is postgresql 8 is realy mature)

2005-04-15 Thread Andrew Sullivan
, that there have been so few problems with 8.0. If every dot-zero release of every product were this good, people wouldn't be so gun-shy about upgrades. You folks should be extremely proud of yourselves. Good work. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men

Re: [HACKERS] Data loss, vacuum, transaction wrap-around

2005-03-11 Thread Andrew Sullivan
for the users that cryptic support by someone whos is reading a script and who's afraid of the legal department. Silly me. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes

Re: [HACKERS] US Patents vs Non-US software ...

2005-01-18 Thread Andrew Sullivan
. The relief is limited, however, and requires certain hoop-jumping which is sort of tiresome. Unless, of course, you have a large, full time legal staff and you're already a multinational. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner

Re: [HACKERS] ARC patent

2005-01-17 Thread Andrew Sullivan
from IBM demanding the removal of all offending code from the Net? The code would have to be yanked from CVS c., in that case, no? (IANAL, but I think I may consult with one.) A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace

Re: [HACKERS] ARC patent

2005-01-17 Thread Andrew Sullivan
be pleased with the implementation. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin ---(end of broadcast

Re: [HACKERS] ARC patent

2005-01-17 Thread Andrew Sullivan
On Mon, Jan 17, 2005 at 02:58:33PM -0500, Tom Lane wrote: Andrew Sullivan [EMAIL PROTECTED] writes: ahead and release with it anyway. IBM would justifiably jump on us for that as a result. With what? They have no patent, yet, and may never have one. If the patent were already issued

Re: [HACKERS] ARC patent

2005-01-17 Thread Andrew Sullivan
On Mon, Jan 17, 2005 at 02:48:46PM -0500, Tom Lane wrote: I think there is zero probability of being sued by IBM in the near future. They won't sue the project. They'll send corporate users a bill, instead, for a license. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description

<    1   2   3   4   >