Re: [HACKERS] Really odd corruption problem: cannot open pg_aggregate: No such file or directory

2003-07-24 Thread Adam Haberlach
On Thu, Jul 24, 2003 at 10:17:06AM -0700, Adam Haberlach wrote: > So, one of the many machines that I support seems to have developed > an incredibly odd and specific corruption that I've never seen before. > > Whenever a query requiring an aggregate is attempted, it sp

[HACKERS] Really odd corruption problem: cannot open pg_aggregate: No such file or directory

2003-07-24 Thread Adam Haberlach
ere could be an issue between the i686 and athlon optimizations? -- Adam Haberlach | "When your product is stolen by thieves, you [EMAIL PROTECTED] | have a police problem. When it is stolen by http://mediariffic.com | millions of honest customers, you have a

Re: [HACKERS] Manual fixing of plpgsql_call_handler binary location

2003-06-28 Thread Adam Haberlach
27; run) is just '$libdir/plpgsql'. Both the path and > the shlib extension are better left to the backend to supply than to > hardwire in. I'm possibly more aware of this than most folk, since I > like to use HPUX which spells the shlib extension ".sl" ...

[HACKERS] Manual fixing of plpgsql_call_handler binary location -- good idea?

2003-06-27 Thread Adam Haberlach
7;; On the machines? This seems to work, but I wanted to see if anyone out there wanted to tell me about this being a really stupid idea. -- Adam Haberlach | "When your product is stolen by thieves, you [EMAIL PROTECTED] | have a police problem. When it is stolen by http

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Adam Haberlach
I'm probably going to ignore it because I like where they are and don't need to explain why. -- Adam Haberlach | "Because manholes are round." [EMAIL PROTECTED] | http://mediariffic.com | ---(end of broadcast)--- TIP

Re: [HACKERS] Win32 port powerfail testing

2003-02-01 Thread Adam Haberlach
On Sat, Feb 01, 2003 at 11:30:17AM -0600, Greg Copeland wrote: > On Sat, 2003-02-01 at 00:34, Adam Haberlach wrote: > > On Sat, Feb 01, 2003 at 12:27:31AM -0600, Greg Copeland wrote: > > > On Fri, 2003-01-31 at 14:36, Dave Page wrote: > > > Please go with XFS or e

Re: [HACKERS] Win32 port powerfail testing

2003-01-31 Thread Adam Haberlach
iserfs on Linux as well. Even if we don't advocate it's use, it may not hurt to at least get an understanding of what one my reasonbly expect from it. I'm better there are people just waiting to run with reiserfs in the Linux world. ;) Regards, and tongue firmly in cheek, -- Ada

[HACKERS] My only post with regard to query caching

2002-03-18 Thread Adam Haberlach
MySQL in anything but "My database is transactionally secure" and "We have a GECO optimizer" pissing wars, we'll need to start becoming a little more competitive in the raw speed arena. I feel that this optimization, while it may not be trivial, is fairly low-hanging fruit th

Re: [HACKERS] Parser abort ignoring following commands

2001-05-26 Thread Adam Haberlach
end at the semicolon, not > at the end of the string you submit to PQexec(). You put semicolons at the end of your strings to PQexec()? -- Adam Haberlach| At either end of the social spectrum there lies [EMAIL PROTECTED] | a leisure class. -- Eric Beck 1965 http://www

[HACKERS] pg_atoi() behavior change? Intentional?

2001-02-24 Thread Adam Haberlach
nto 0, much as C's atoi function works. The new behavior is to throw a parse error, which causes all kinds of problem. Is this intentional? I dimly remember seeing a whole lot of atoi discussion, but I can't seem to find it in my last two files of this mailing list. --

Re: [HACKERS] Something smells in this schema...

2001-02-16 Thread Adam Haberlach
On Fri, Feb 16, 2001 at 01:02:24PM -0500, Tom Lane wrote: > Adam Haberlach <[EMAIL PROTECTED]> writes: > > I had postgres start blocking all it's UPDATEs on a production > > database today, when an engineer added the following two tables, > > among other th

[HACKERS] Something smells in this schema...

2001-02-16 Thread Adam Haberlach
r(2) not null, project int4, component text, time_start int4, time_stop int4, total_minutes int4, notes text ); create index time_cards_open_pkey on time_cards (open); create index time_cards_uid_pkey on time_cards (uid); -- Adam Haberlach|A cat spends her life conflicted b

[HACKERS] Sluggish inserts/updates ?

2001-02-07 Thread Adam Haberlach
blem, right? * Is there a good way to find out if this option is on/off? -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.newsnipple.com |fish and an equally deep, passionate, a

Re: [INTERFACES] Re: [HACKERS] PHP and PostgreSQL

2001-01-23 Thread Adam Haberlach
sent them patches against the at-the-time up-to-date CVS tree back when this first came up, they said that they failed, so I sent them another set, and have not heard back from them. It doesn't seem to show up in the cvs logs. I'll bug someone again and see if I can find out wh

Re: [HACKERS] Lock on arbitrary string feature

2001-01-11 Thread Adam Haberlach
, they send a notify back to the other side to un-block it. If anything, it would be nice if there were a way to make a LISTEN block the connection on a specific event tag, which is essentially what we are doing in our interface library. -- Adam Haberlach|A cat spends her life

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Adam Haberlach
On Fri, Dec 29, 2000 at 08:46:40PM -0500, Tom Lane wrote: > Adam Haberlach <[EMAIL PROTECTED]> writes: > > RMS already made a big stink about this, claiming that BeOS's use > > of an emulation layer to link to some GPL'ed network drivers was enough > &g

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Adam Haberlach
s enough to force the GPL'ing of the kernel. Be backed down (and re-licensed the code from the source, IIRC). Sun recently released a "driver porting kit" that allowed similar drivers to be used in Solaris. There was some outcry on Slashdot, but I'm not sure how it ended up.

Re: [HACKERS] PHP and PostgreSQL

2000-12-27 Thread Adam Haberlach
h for most things. However, just last week I implemented pg_lolseek($loid, $offset $whence) and pg_lotell($loid) For some stuff that we are working on. They are pretty straightforward, and I can package them up and submit them if someone wants. -- Adam Haberlach|A cat spends her life

Re: [HACKERS] Using Threads?

2000-12-04 Thread Adam Haberlach
, since everything in a group of threads (I'll call 'em a team) shares the same address space, there can be some memory overhead savings. -- Adam Haberlach |"California's the big burrito, Texas is the big [EMAIL PROTECTED] | taco ... and following that theme, Florida is

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
east it is > original. It wasn't an analogy. In any case, can we create pgsql-politics so we don't have to go over this issue every three months? Can we create pgsql-benchmarks while we are at it, to take care of the other thread that keeps popping up? -- Adam Habe

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
I've probably seen at least 100 requests for replication, with about 40 of them mentioning implementing it themself. I'm pretty sure that being told "PostgreSQL Inc. is working on that" is not the only thing stopping it from happening. Most people just aren't up to

Re: [HACKERS] Initdb not running on beos

2000-11-28 Thread Adam Haberlach
ht around here is where I am going to ask why we are > entertaining the idea of a BeOS port in the first place... it's > evidently not Unix or even trying hard to be close to Unix. You've asked this before. How does Windows manage to work? -- Adam Haberlach

Re: AW: [HACKERS] ALTER TABLE DROP COLUMN

2000-10-16 Thread Adam Haberlach
e warnings about using oids in any kind of persistant manner. -- Adam Haberlach|ASCII /~\ [EMAIL PROTECTED] | Ribbon \ / Against http://www.newsnipple.com | CampaignX HTML '88 EX500 |/ \ E-mail

Re: [HACKERS] C++ client libs

2000-10-03 Thread Adam Haberlach
ge to an arbitrary BLooper. Your messaging system may vary... -- Adam Haberlach| A billion hours ago, human life appeared on [EMAIL PROTECTED] | earth. A billion minutes ago, Christianity http://www.newsnipple.com | emerged. A billion Coca-Colas ago was '88 EX500 | yesterday morning. -1996 Coca-Cola Ann. Rpt.

Re: [HACKERS] C++ client libs

2000-10-03 Thread Adam Haberlach
we take this off-list, or keep it here? In either case, I'll spend some time formally thinking about my perfect API and we can get together and compare notes... -- Adam Haberlach| A billion hours ago, human life appeared on [EMAIL PROTECTED] | earth. A bill