Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-18 Thread Simon_Kelly
> > I've > > never used a hammer to put in a screw. > > So I guess you're one of those ivory-tower theory-purist academic types, at > least when it comes to home repairs. No no. When it comes to everything. I have read all the books and watched Norm Abraham till my eyes bled. There's not m

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-18 Thread Simon_Kelly
All of my cool witty retorts to all of these posts are being ruined by the fact that all of my mails are being scrutinized by the moderators first. Everyone is getting in before me. Mine are going to seem like the slow witted back-water cousins to these sharp NY barristers. [EMAIL PROTECTED]

Re: [GENERAL] Table Inheritance / VARCHAR search question

2006-09-24 Thread Simon_Kelly
I would say that splitting the data will work ok if ( and only if ) you can remove some duplication of data and therefore reduce disk usage. If it won't, it'll not really save you anything, and it may increase disk space with the additional db overheads of another set of table meta informatio

[GENERAL] Issue with order by for type varchar

2006-09-12 Thread Simon_Kelly
Hi All, I am trying to order a select by the primary key which is a varchar field. I have two known conditions, 1. the varchar always contains 28 characters. ( and, yes, I know the irony of using a variable array on a known fixed length field ) 2. the content of this field contains only the c

Re: [GENERAL] Superuser lost access to particular database

2006-09-12 Thread Simon_Kelly
This may sound a bit weird, but have you tried logging in as user1 and then granting the permission's to the superuser? Simon Kelly Java Developer Information Systems Development Information Technology Shared Services Ministry of Health DDI: Mobile: http://www.moh.govt.nz mailto:[EMAIL PROTEC

Re: [GENERAL] Issue with order by for type varchar

2006-09-13 Thread Simon_Kelly
Thanks Martijn. Simon Kelly Java Developer Information Systems Development Information Technology Shared Services Ministry of Health DDI: Mobile: http://www.moh.govt.nz mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 13/09/2006 01:33:15 a.m.: > On Tue, Sep 12, 2006 at 09:51:20AM +1200,

Re: [GENERAL] PostgreSQL slammed by PHP creator

2006-09-16 Thread Simon_Kelly
[EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.: > > > I wasn't able to find anything the "article" worth discussing. If you > > give up A, C, I, and D, of course you get better performance- just like > > you can get better performance from a wheel-less Yugo if you slide it > > down a lug

Re: [GENERAL][Off Topic] PostgreSQL slammed by PHP creator

2006-09-16 Thread Simon_Kelly
> > I found in my youth that a mini slides better on it roof than on it's > > wheels. > > I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :) > If it hadn't been for the gravel around that corner, I would have beat > the other car too. I used to dream of hitting 70mph in the min