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

2003-07-24 Thread Adam Haberlach
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 | marketing problem

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 spits out: cannot open

Re: [HACKERS] Manual fixing of plpgsql_call_handler binary location

2003-06-28 Thread Adam Haberlach
of this than most folk, since I like to use HPUX which spells the shlib extension .sl ... Awesome -- I've questioned to myself the wisdom of having this sort of thing hardcoded, but it looks like it's already been solved. Thanks, all... -- Adam Haberlach | When your product

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

2003-06-27 Thread Adam Haberlach
? 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://mediariffic.com | millions of honest

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Adam Haberlach
(and yes, we need to start paying attention to the real world) advantages. And finally, don't go telling me that I'm wrong to put my data and config files where I am. You can offer advice, but I'm probably going to ignore it because I like where they are and don't need to explain why. -- Adam

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 ext3. There are a number of blessed

[HACKERS] My only post with regard to query caching

2002-03-18 Thread Adam Haberlach
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 that can help. I may even try to implement it, but I make no guarantees. -- Adam Haberlach | Who buys an eight-processor machine

Re: [HACKERS] Parser abort ignoring following commands

2001-05-26 Thread Adam Haberlach
that statements are in their own transaction block unless in an explicit BEGIN/COMMIT block. A statement is defined to 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

[HACKERS] pg_atoi() behavior change? Intentional?

2001-02-24 Thread Adam Haberlach
, 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. -- Adam Haberlach

[HACKERS] Something smells in this schema...

2001-02-16 Thread Adam Haberlach
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 between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http

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 things. We've had to restore from backup

[HACKERS] Sluggish inserts/updates ?

2001-02-07 Thread Adam Haberlach
? * 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, and '88 EX500'00 ^ |profound

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

2001-01-23 Thread Adam Haberlach
in the cvs logs. I'll bug someone again and see if I can find out what happened. I mean, they only have 240 people with write access to the cvs tree... -- Adam Haberlach|A cat spends her life conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire

Re: [HACKERS] Lock on arbitrary string feature

2001-01-11 Thread Adam Haberlach
ice 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 conflicted between a [EMAIL PROTECTED] |deep, passionate, and profound desire for http://www.

Re: [HACKERS] GNU readline and BSD license

2000-12-29 Thread Adam Haberlach
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. I wouldn't mind having someone tell RMS to fuck off, though. -- Adam Haberlach|A cat spen

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 to force the GPL'ing of the kernel. Did BeOS

Re: [HACKERS] PHP and PostgreSQL

2000-12-27 Thread Adam Haberlach
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 conflicted between a [EMAIL PROTECTED

Re: [HACKERS] Using Threads?

2000-12-04 Thread Adam Haberlach
eam) 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 http://www.newsnipple.com| the big tamale ... and the on

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
is not the only thing stopping it from happening. Most people just aren't up to making it happen. -- Adam Haberlach |"California's the big burrito, Texas is the big [EMAIL PROTECTED] | taco ... and following that theme, Florida is http://www.newsnipple.com| the big tamale ...

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
months? Can we create pgsql-benchmarks while we are at it, to take care of the other thread that keeps popping up? -- Adam Haberlach |"California's the big burrito, Texas is the big [EMAIL PROTECTED] | taco ... and following that theme, Florida is http://www.newsnipple.com| th

Re: [HACKERS] Initdb not running on beos

2000-11-28 Thread Adam Haberlach
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 |"California's the big burrito, Texas is