Re: PG + PHP, was Re: [GENERAL] Zend survey result about dbms...

2003-09-20 Thread Mike Mascari
Mike Mascari wrote: > Tom Lane wrote: >>Uh, what exactly does it buy you to involve an environment variable >>in this process? I think it just adds fragility. (For example, >>exposing setenv to the user creates the risk that he'll overwrite >>something of importance, like PATH.) > > Actually,

Re: PG + PHP, was Re: [GENERAL] Zend survey result about dbms...

2003-09-20 Thread Tom Lane
Mike Mascari <[EMAIL PROTECTED]> writes: > Actually, I meant that setenv() and getenv() would only be used to > store the memory address of a privately manipulated variable map. I > did not mean that it should actually be used to store and retrieve the > variables themselves. If there is already a

Re: [GENERAL] About GPL and proprietary software

2003-09-20 Thread Jan Wieck
FYI In answer to Kaarel's question Kaarel wrote: Would a perl application using DBI have a similar problem? Or how would one then legally use PHP with MySQL without GPL-ing your product and without buying MySQL commercial license? Marten Mickos, CEO of MySQL AB Sweden answered and kindly gave

Re: PG + PHP, was Re: [GENERAL] Zend survey result about dbms...

2003-09-20 Thread Mike Mascari
Tom Lane wrote: > Mike Mascari <[EMAIL PROTECTED]> writes: > >>In the past, one hack would be to use setenv() and getenv() of the >>backend to implement these functions. What about a contrib module that: > > > Uh, what exactly does it buy you to involve an environment variable > in this process

Re: PG + PHP, was Re: [GENERAL] Zend survey result about dbms...

2003-09-20 Thread Tom Lane
Mike Mascari <[EMAIL PROTECTED]> writes: > In the past, one hack would be to use setenv() and getenv() of the > backend to implement these functions. What about a contrib module that: Uh, what exactly does it buy you to involve an environment variable in this process? I think it just adds fragili

Re: PG + PHP, was Re: [GENERAL] Zend survey result about dbms...

2003-09-20 Thread Mike Mascari
Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > >>One thing I think would be useful is another pseudo-var in PG, >>something like APP_SESSION_VAR which can be set and then used in PG >>queries. > > >>Tom - if I offered to produce a patch for something like this - either a var >>

Re: [GENERAL] about the pstate node

2003-09-20 Thread Tom Lane
=?gb2312?q?=B2=A9=D7X=20=B5=D4?= <[EMAIL PROTECTED]> writes: > I am trying to analyse the source code in " /backend/paser". And I am > really puzzled about the node "PaserState",especially the meaning of p_namespace and > p_joinlist! p_namespace is a list of the FROM items (RangeTblRe

Re: [GENERAL] need for in-place upgrades

2003-09-20 Thread Ron Johnson
On Fri, 2003-09-19 at 06:37, Christopher Browne wrote: > [EMAIL PROTECTED] (Ron Johnson) wrote: > > On Thu, 2003-09-18 at 16:29, Andrew Sullivan wrote: > >> On Sat, Sep 13, 2003 at 10:52:45AM -0500, Ron Johnson wrote: > >> > >> > So instead of 1TB of 15K fiber channel disks (and the requisite > >

Re: Catalog vs. user table format (was Re: [GENERAL] State of Beta

2003-09-20 Thread Marc G. Fournier
On Sat, 20 Sep 2003, Ron Johnson wrote: > On Sat, 2003-09-20 at 11:17, Tom Lane wrote: > > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > > No, I'm not suggesting no catalog changes ... wait, I might be wording > > > this wrong ... there are two changes that right now requires a > > > dump/r

Catalog vs. user table format (was Re: [GENERAL] State of Beta 2)

2003-09-20 Thread Ron Johnson
On Sat, 2003-09-20 at 11:17, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > No, I'm not suggesting no catalog changes ... wait, I might be wording > > this wrong ... there are two changes that right now requires a > > dump/reload, changes to the catalogs and changes to the dat

Re: [GENERAL] This mail list and its policies

2003-09-20 Thread Ron Johnson
On Sat, 2003-09-20 at 11:04, Joshua D. Drake wrote: > Hello, > > Just run IMAP. That way all the mail stay one the server. Your > system will just grab the headers and you can delete as required. > Also you could installed something like spamassassin on the server (if > you ISP) will let yo

Re: [GENERAL] PostgreSQL versus MySQL

2003-09-20 Thread Ron Johnson
On Thu, 2003-09-18 at 17:15, Christopher Browne wrote: > [EMAIL PROTECTED] (Sean Chittenden) writes: [snip] > A coworker made the snide remark that anyone that doesn't totally "get > it" is likely to really wonder about the notion of roasting a dolphin > over a spit. > > Roasting dolphins over t

Re: [GENERAL] OT: HEADS-UP: viral storm out there

2003-09-20 Thread Ron Johnson
On Fri, 2003-09-19 at 17:16, Christopher Browne wrote: > [EMAIL PROTECTED] ("Nikola Milutinovic") writes: > > This is off topic and is a cross-post, so I'll be brief. There is a > > very nasty virus out there and I urge everybody to get their AV in > > order. The virus is known as: "W32.Gibe-F" or

Re: [GENERAL] This mail list and its policies

2003-09-20 Thread Bruno Wolff III
On Sat, Sep 20, 2003 at 12:53:12 -0700, "Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> wrote: > > On Thursday, Sept 18 Bruno Wolff said: > >One option for you is to use the list address in the from header when > >posting to the list. That will hide your address and not break > >replies.

Re: [GENERAL] Can't Build 7.3.4 on OS X

2003-09-20 Thread Tom Lane
Hunter Hillegas <[EMAIL PROTECTED]> writes: > I cannot build the latest release on OS X Jaguar. > Running GCC 3.3 from Apple: It seems "-traditional-cpp" has become nontraditional in 3.3. Or possibly Apple changed their system header files in a way that broke that preprocessor. What's certain is

Re: [GENERAL] Question about connection java and Postgresql in Linux

2003-09-20 Thread Paul Thomas
On 20/09/2003 15:23 DN wrote: I am trying to use Redhat Linux 9, J2sdk 1.4.2 and Postgresql 7.3.2 to do my setting. But, I cannot access the database to set/get data through the java program. Please help give me some suggestions. Here is what my setting and problems: http://hk.geocities.com/daisy_n

Re: [GENERAL] 7.3.2 client connecting to 7.2.1 server problem

2003-09-20 Thread Oliver Elphick
On Wed, 2003-09-17 at 21:55, Jeff wrote: > I have the following packages installed on my system: > > libpq3: 7.3.2r1-5 > python-pygresql: 7.3.2r1-5 > postgresql: 7.2.1-2woody2 > postgresql-client: 7.2.1-2woody2 [This is clearly a Debian system.] You seem to have done a partial upgrade to testing;

Re: [GENERAL] This mail list and its policies

2003-09-20 Thread Dean Gibson (DB Administrator)
On Thursday, Sept 18 Bruno Wolff said: One option for you is to use the list address in the from header when posting to the list. That will hide your address and not break replies. Most likely the list checks the envelope sender address to see whether or not the message needs moderator approva

Re: [GENERAL] Triggers/perform oddity between 7.2 and 7.3

2003-09-20 Thread Tom Lane
Andreas Forsgren <[EMAIL PROTECTED]> writes: > Anyone knows how to solve this? I was playing around with triggers on > my own machine which runs 7.3 and there it works okey, but when trying > it on 7.2 I get an error about duplicate keys. [checks code] In 7.2, PERFORM didn't set FOUND; in 7.3 it

Re: [GENERAL] This mail list and its policies

2003-09-20 Thread Bruno Wolff III
On Sat, Sep 20, 2003 at 11:46:11 -0500, [EMAIL PROTECTED] wrote: > > I hope there is a special corner of hell reserved for spammers and an > even worse corner reserved for virus/worm writers. Don't you mean for people who use Lookout to read eamil? ---(end of broadcast)

Re: [GENERAL] 7.3.2 client connecting to 7.2.1 server problem

2003-09-20 Thread Tom Lane
Jeff <[EMAIL PROTECTED]> writes: > I have the following packages installed on my system: > libpq3: 7.3.2r1-5 > python-pygresql: 7.3.2r1-5 > postgresql: 7.2.1-2woody2 > postgresql-client: 7.2.1-2woody2 > In my application, which is written in python, I get a "server closed the > connection unexpect

Re: [GENERAL] This mail list and its policies

2003-09-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > Also, I DO run spamassassin here, and it is finding only perhaps 10-20% > of the copies of the most recent worm. I think it sends out copies that > are sufficiently different from each other that it bypasses all the > checks, including a Bayesian filter. Hmm. I'v

Re: [GENERAL] State of Beta 2

2003-09-20 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > The reality of pg_dump is not a good one. It is buggy and not very > reliable. I think everyone acknowledges that we have more work to do on pg_dump. But we have to do that work anyway. Spreading ourselves thinner by creating a whole new batch of c

Re: [GENERAL] add constraints to views

2003-09-20 Thread Tom Lane
Andreas Fromm <[EMAIL PROTECTED]> writes: > No, I mean that the view behaves like a table with the same columns as > table, but that restricts to records on wich tag is set. To insert a > record to this "special" table it requires to have field1 set. In other > words: A record of table is a record

Re: [GENERAL] need for in-place upgrades

2003-09-20 Thread Christopher Browne
[EMAIL PROTECTED] ("Marc G. Fournier") writes: > On Thu, 18 Sep 2003, Andrew Sullivan wrote: > >> On Sat, Sep 13, 2003 at 10:27:59PM -0300, Marc G. Fournier wrote: >> > >> > I thought we were talking about upgrades here? >> >> You do upgrades without being able to roll back? > > Hadn't thought of i

Re: [GENERAL] Serialization, Locking...implement processing Queue with a

2003-09-20 Thread attilio drei
I searched for a long time for a response on how correctly use the database lock feature to create a job distribution system. Also I hate programs that pools databases every few seconds. Than I noticed that postgresql have a notify feature that inform clients when a table change. Beautiful!! why

[GENERAL] Triggers/perform oddity between 7.2 and 7.3

2003-09-20 Thread Andreas Forsgren
Hi gurus, Anyone knows how to solve this? I was playing around with triggers on my own machine which runs 7.3 and there it works okey, but when trying it on 7.2 I get an error about duplicate keys. Upgrading to 7.3 on the other machines is not possible yet. Any help on getting it to work with 7.2

Re: [GENERAL] need for in-place upgrades

2003-09-20 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Ron Johnson) would write: > On Thu, 2003-09-18 at 16:29, Andrew Sullivan wrote: >> On Sat, Sep 13, 2003 at 10:52:45AM -0500, Ron Johnson wrote: >> >> > So instead of 1TB of 15K fiber channel disks (and the requisite >> > controllers, shel

[GENERAL] add constraints to views

2003-09-20 Thread Andreas Fromm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Please consider the following situation. CREATE TABLE test_table ( ~id SERIAL PRIMARY_KEY, ~tag BOOLEAN, ~field1 INTEGER ); CREATE VIEW test_view ( ~SELECT * FROM test_table WHERE tag ); Now I want ad a NOT NULL constraint to the view o