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, shelves, RAID

[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] 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

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 it that way ...

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 of

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 code

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've

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 unexpectedly

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

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 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

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; the

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:

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. Most

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] 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 the fire

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 data

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 you.

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/reload, changes

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 controllers,

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 (RangeTblRef's or

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 or a function

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 fragility.

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? I think

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 way

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, I meant

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 that