Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

On Wed, May 28, 2008 at 10:17 PM, hobbes <[EMAIL PROTECTED]> wrote: > Hi Guys, > > I have been trying to get my local (windows) machine's PgAdmin II to > connect directly to a remote Linux (Debian) Server where Postgresql > 8.3 is installed. Is that a typo? pgAdmin II hasn't been supported in year

Re: [GENERAL] PL/R download

Still does not work for me, HTTP timeout On Tue, May 27, 2008 at 7:35 PM, Joe Conway <[EMAIL PROTECTED]> wrote: > Cindy Makarowsky wrote: >> >> Is the PL/R download still available? The link is dead from the Postgres >> site and also at www.joeconway.com . Is there >> a

Re: [GENERAL] Help with remote connection to remote Postgresql 8.3 Server...

On May 29, 4:45 pm, [EMAIL PROTECTED] ("Dave Page") wrote: > On Wed, May 28, 2008 at 10:17 PM, hobbes <[EMAIL PROTECTED]> wrote: > > Hi Guys, > > > I have been trying to get my local (windows) machine's PgAdmin II to > > connect directly to a remote Linux (Debian) Server where Postgresql > > 8.3 is

Re: [GENERAL] New MS patent: sounds like PG db rules

Still, this sounds dangerous. It should be, even legally, WRONG to patent something that already exist and was not invented by the patentee. I know we can laugh off MS in court, but what about new DBs or project even built on PG that have this functionality? Software patents are a menace, I'm af

Re: [GENERAL] Howto implement sxntax and semantic complie time chock for

marco-oweber wrote: > I'd like to implement some query checking at compile time for haskell > using template haskell. > > Is there any query method such as > explain input and output types of query "SELECT (1,'string')" > or "INSERT INTO foo (a,b,c) VALUES (?,?,?)" ? > returning Int, String or suc

Re: [GENERAL] Copying data from a table to another database

Dears Craig, Roberts, Reece and Shane Thank you very much for your thoughts. They're helpful! ;-) I've chosen the dump approach to another table in the migration server and then INSERTing the different recs with a WHERE clause for every non-existing timestamp for a deviceID. As far as the pkey wa

Re: [GENERAL] New MS patent: sounds like PG db rules

Nikola Milutinovic wrote: Still, this sounds dangerous. It should be, even legally, WRONG to patent something that already exist and was not invented by the patentee. I know we can laugh off MS in court, but what about new DBs or project even built on PG that have this functionality? Software

Re: [GENERAL] New MS patent: sounds like PG db rules

which is the reason why i think Design Patterns and Patterns are unpatentable..too many cooks created these meals to attribute to any one or group of individuals The real challenge is the submittal process where one must submit at least 50% of the patentable code..what do you submit? I always t

Re: [GENERAL] New MS patent: sounds like PG db rules

Martin wrote: which is the reason why i think Design Patterns and Patterns are unpatentable..too many cooks created these meals to attribute to any one or group of individuals That will never happen and it if it does it years away. we must deal with the current problems in front of us not worr

Re: [GENERAL] New MS patent: sounds like PG db rules

Justin wrote: Only objective is to protect everyone from stupid and ridiculous lawsuits. The entire blackberry lawsuit is example of things to come. Where another company had a patented that process of moving email to a phone for years but never used it. This company waited in the backgroun

[GENERAL] Can a pg_dump file loaded via pg_Admin tool??

Hello all, I have created a backup via 'pg_dump -c -f mydump.backup' - however when I try to load it via pg_Admin tool, it does not allow me to - the 'OK' button is grayed out even though I have selected the file to be restored...is this doable? Thanks...Michelle -- View this message in contex

[GENERAL] DRDB for Standby, Failover

Has anyone used DRDB (http://www.drbd.org/) with Postgres and can speak to its speed/value, specifically in its various replication modes ( http://www.drbd.org/users-guide/s-replication-protocols.html)? Thanks, Gavin

Re: [GENERAL] New MS patent: sounds like PG db rules

Justin wrote: I'm proposing a CYA that could be used to protect all open source projects not just postgresql. Instead of complaining about how wrong the system is and the need to change it is. Use the system to protect the project. Exactly. The real problem is that the first one to apply f

Re: [GENERAL] New MS patent: sounds like PG db rules

On Fri, May 30, 2008 at 03:07:17AM +0930, Shane Ambler wrote: > Exactly. The real problem is that the first one to apply for a patent > gets it. It really doesn't matter who invents it. If we have patents > that cover our work then we can control who uses it and for what > purpose, also preventing

Re: [GENERAL] New MS patent: sounds like PG db rules

There is https://priorart.ip.com/ to make claims to novel ideas (this costs money). I also share the idea that it would be amazing if companies could get together and fund a non-profit that would hold a "patent portfolio"/ideas of open source projects and their contributors. I'm no lawyer, but th

Re: [GENERAL] DRDB for Standby, Failover

On Thu, 29 May 2008, Gavin M. Roy wrote: Has anyone used DRDB (http://www.drbd.org/) with Postgres and can speak to its speed/value, specifically in its various replication modes ( http://www.drbd.org/users-guide/s-replication-protocols.html)? It performs quite well for us. Reads are local so

Re: [GENERAL] New MS patent: sounds like PG db rules

[EMAIL PROTECTED] (Martijn van Oosterhout) writes: > On Fri, May 30, 2008 at 03:07:17AM +0930, Shane Ambler wrote: >> Exactly. The real problem is that the first one to apply for a patent >> gets it. It really doesn't matter who invents it. If we have patents >> that cover our work then we can cont

Re: [GENERAL] is it a bug in rule system?

It's not a bug, just your misunderstanding of how rules work. Rules rewrite queries. What happen in your case is because of the condition your query will be split into two: once with your INSERT with a NOT EXISTS (subquery) and once as an UPDATE with the condition EXISTS (subquery). So the fir

Re: [GENERAL] is it a bug in rule system?

laser wrote: It's not a bug, just your misunderstanding of how rules work. Rules rewrite queries. What happen in your case is because of the condition your query will be split into two: once with your INSERT with a NOT EXISTS (subquery) and once as an UPDATE with the condition EXISTS (subquery

Re: [GENERAL] function cache effect still happening?

Hi Fernando, I ran into something similar ... with hard-coded queries in a function that ends up getting cached. My solution was to store the referenced table in a variable and, as you suggested, use EXECUTE to dynamically build up and run the query. Cheers, Kevin Fernando Moreno wrote: 2

Re: [GENERAL] PL/R download

> Joe Conway <[EMAIL PROTECTED]> wrote: >> Sorry, my bad. Fixed Ivan Zolotukhin wrote: Still does not work for me, HTTP timeout Yeah, my words above were so called "famous last words". Shortly after fixing the problem and writing that email, my ISP decided to make an unannounced router chang