Re: [HACKERS] Possible bug in update?

2003-08-28 Thread Jim Mercer
pom_c2996804 set p3=3268837857008 where p3=34804837857008 commit not overly clear from the debug statements, but are all the above lines also ended with a semi-colon? -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die trying

Re: [HACKERS] Bumping block size to 16K on FreeBSD...

2003-08-28 Thread Jim Mercer
to avoid any more in the 7.4 branch. if it does in fact give performance for FreeBSD (and possibly others), at least make it a build time option. -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die trying

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-28 Thread Jim Mercer
On Sat, Sep 28, 2002 at 01:08:36PM +0200, Peter Eisentraut wrote: Jim Mercer writes: ideally, i'd like to have users-per-database, as opposed to the global model we have now. That's in the works. Some form of this will be in 7.3. cool! if we are willing to modify libpq to support

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-28 Thread Jim Mercer
On Sat, Sep 28, 2002 at 03:57:27PM +0200, Michael Paesold wrote: Jim Mercer [EMAIL PROTECTED] wrote: as it currently stands, virtual hosts can trample all over other databases, and with the nature of a single uid for all apache/php/libpq proceses, they are generally doing it with the same

[HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
can control which tables they have access to (disregarding that almost all access will be by the web user). can anyone make some valid arguments for/against the patch in php? or any suggestions on how to do it in pgsql? - Forwarded message from Jim Mercer [EMAIL PROTECTED] - Date: Thu, 26

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Fri, Sep 27, 2002 at 11:15:35AM +1000, Gavin Sherry wrote: On Thu, 26 Sep 2002, Jim Mercer wrote: I would think so, and IMHO, that's where pgsql access control belongs, with pgsql. I totally disagree. It is a language level restriction, not a database level one, so why back

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Fri, Sep 27, 2002 at 12:06:43PM +1000, Gavin Sherry wrote: On Thu, 26 Sep 2002, Jim Mercer wrote: maybe not _totally_ secure, but much moreso than nothing. I was basically just suggesting that its effect needs to be documented. This needs to be used in conjunction with other forms

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of database access

2002-09-26 Thread Jim Mercer
On Thu, Sep 26, 2002 at 11:42:44PM -0400, Tom Lane wrote: Jim Mercer [EMAIL PROTECTED] writes: as best i can understand, there is no way to get apach/php/pgsql configured (using PostgreSQL's native access mappings) that would disallow php code in one virtual host from connecting to any

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
and pointless arguments. i'd go with: The PostgreSQL community is committed to creating and maintaining a very reliable, open-source, multi-purpose, standards-based database, and encouraging participation in open-source usage and development world wide. -- [ Jim Mercer[EMAIL PROTECTED

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 08:43:04AM -0400, mlw wrote: Jim Mercer wrote: why does it have to be THE BEST ? that is insulting to the other projects like MySQL which while competitors are also a valid and useful benchmark for features, performance and keeping the postgresql community on its

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 01:43:39PM +0100, Nigel J. Andrews wrote: I like: We'll store your data; if we think it'll be an interesting enough diversion for us. gets my vote. 8^) -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
strive to be as good as they can make them, and all of them borrow from each other in order to make their version better in the eyes of their audience. -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die trying

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: A mission statement is like a tie. straw vote! who on the list wears ties? -- [ Jim Mercer[EMAIL PROTECTED] +1 416 410-5633 ] [ I want to live forever, or die trying.] ---(end

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote: Jim Mercer wrote: On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: A mission statement is like a tie. straw vote! who on the list wears ties? How many people who make IT decisions wear ties? too many. -- [ Jim

Re: [HACKERS] PostgreSQL mission statement?

2002-05-02 Thread Jim Mercer
On Thu, May 02, 2002 at 09:45:45PM -0400, mlw wrote: Jim Mercer wrote: On Thu, May 02, 2002 at 09:14:03PM -0400, mlw wrote: Jim Mercer wrote: On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote: A mission statement is like a tie. who on the list wears ties? How many people

Re: [HACKERS] Re: Week number

2001-03-14 Thread Jim Mercer
apted to a 7 day week and a 365 day year, there shouldn't bee too much confusion. -- [ Jim Mercer [EMAIL PROTECTED] ] [ Reptilian Research -- Longer Life through Colder Blood ] [ aka[EMAIL PROTECTED] +1 416 410-5633 ] -

[HACKERS] off-topic: (sorta) freebsd - oracle, lightweight

2000-10-02 Thread Jim Mercer
i need to query some oracle tables from a freebsd system. is there a lightweight method to do this, or do i have no choice but to put in the Oracle Linux stuff and use their API's? -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Research

Re: [HACKERS] Installation layout is still hazardous for shared prefixes

2000-09-27 Thread Jim Mercer
al/libexec /usr/local/pgsql/data or /usr/local/pgsql the last one could also be /home/pgsql or whatever. -- [ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish