Re: [HACKERS] beta testing version

2000-12-02 Thread Prasanth A. Kumar
Don Baccus <[EMAIL PROTECTED]> writes: > At 04:42 AM 12/3/00 +, Thomas Lockhart wrote: > >> This statement of yours kinda belittles the work done over the past > >> few years by volunteers. > > > >imho it does not, > > Sure it does. You in essence are saying that "advanced replication is so

Re: [HACKERS] beta testing version

2000-12-02 Thread Vadim Mikheev
> There is risk here. It isn't so much in the fact that PostgreSQL, Inc > is doing a couple of modest closed-source things with the code. After > all, the PG community has long acknowleged that the BSD license would > allow others to co-op the code and commercialize it with no obligations. > >

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 09:29 PM 12/2/00 -0800, Adam Haberlach wrote: >> Red herring, and you know it. The question isn't whether or not your business >> generates income, but how it generates income. > > So far, Open Source doesn't. The VA Linux IPO made ME some income, >but I'm not sure that was part of thei

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 09:56 PM 12/2/00 -0700, Ron Chmara wrote: ... >And I really havn't seen much in the way of full featured products, complete >with printed docs, 24 hour support, tutorials, wizards, templates, a company >to sue if the code causes damage, GUI install, setup, removal, etc. etc. etc. > >Want to ma

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 04:42 AM 12/3/00 +, Thomas Lockhart wrote: >> This statement of yours kinda belittles the work done over the past >> few years by volunteers. > >imho it does not, Sure it does. You in essence are saying that "advanced replication is so hard that it could only come about if someone were wi

Re: [HACKERS] core dump? OID/database corruption?

2000-12-02 Thread Tom Lane
mlw <[EMAIL PROTECTED]> writes: > [ drop function on which a functional index is based ] > and strange things start to happen. All I get is messages like ERROR: fmgr_info: function 402432: cache lookup failed which is about what I'd expect. If you've seen a coredump in this situation, l

Re: [HACKERS] beta testing version

2000-12-02 Thread Peter Bierman
>And I really havn't seen much in the way of full featured products, complete >with printed docs, 24 hour support, tutorials, wizards, templates, a company >to sue if the code causes damage, GUI install, setup, removal, etc. etc. etc. Mac OS X. ;-) -pmb -- [EMAIL PROTECTED] "4 out of 5 people

Re: [HACKERS] beta testing version

2000-12-02 Thread Ron Chmara
Thomas Lockhart wrote: > > > PostgreSQL, Inc perhaps has that as a game plan. > > I'm not so much concerned about exactly what PG, Inc is planning to offer > > as a proprietary piece - I'm purist enough that I worry about what this > > signals for their future direction. > Hmm. What has kept repl

Re: [HACKERS] beta testing version

2000-12-02 Thread Thomas Lockhart
> This statement of yours kinda belittles the work done over the past > few years by volunteers. imho it does not, and if somehow you can read that into it then you have a much different understanding of language than I. I *am* one of those volunteers, and know that the hundreds of hours I have c

[HACKERS] SQL to retrieve FK's, Update/Delete action, etc.

2000-12-02 Thread Michael Fork
Given the name of a table, I need to find all foreign keys in that table and the table/column that they refer to, along with the action to be performed on update/delete. The following query works, but only when there is 1 foreign key in the table, when there is more than 2 it grows exponentially

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
On Sat, Dec 02, 2000 at 07:32:14PM -0800, Don Baccus wrote: > At 02:58 AM 12/3/00 +, Thomas Lockhart wrote: > >> PostgreSQL, Inc perhaps has that as a game plan. > >> I'm not so much concerned about exactly what PG, Inc is planning to offer > >> as a proprietary piece - I'm purist enough that

[HACKERS] core dump? OID/database corruption?

2000-12-02 Thread mlw
An obscure series of events seems to cause a core dump and OID corruption: -- tolower function for varchar create function varchar_lower(varchar) returns varchar as '/usr/local/lib/pgcontains.so', 'pglower' language 'c'; create index ztables_title_ndx on ztitles ( varchar_lowe

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 02:58 AM 12/3/00 +, Thomas Lockhart wrote: >> PostgreSQL, Inc perhaps has that as a game plan. >> I'm not so much concerned about exactly what PG, Inc is planning to offer >> as a proprietary piece - I'm purist enough that I worry about what this >> signals for their future direction. > >Hm

Re: [HACKERS] beta testing version

2000-12-02 Thread Thomas Lockhart
> PostgreSQL, Inc perhaps has that as a game plan. > I'm not so much concerned about exactly what PG, Inc is planning to offer > as a proprietary piece - I'm purist enough that I worry about what this > signals for their future direction. Hmm. What has kept replication from happening in the past?

Re: [HACKERS] COPY BINARY is broken...

2000-12-02 Thread Samuel Sieb
On Fri, Dec 01, 2000 at 05:56:57PM -0500, Tom Lane wrote: > Alfred Perlstein <[EMAIL PROTECTED]> writes: > > I would rip it out. > > I thought about that too, but was afraid to suggest it ;-) > > How many people are actually using COPY BINARY? > I have used it, I don't think I'm actually using

Re: [HACKERS] RI Types

2000-12-02 Thread Don Baccus
At 06:27 PM 12/2/00 -0500, Michael Fork wrote: >I am trying to set the update and delete rules that are returned from the >ODBC driver and the spec has the following to say: > >SQL_NO_ACTION: If a delete of a row in the referenced table would cause a >"dangling reference" in the referencing table

[HACKERS] RI Types

2000-12-02 Thread Michael Fork
I am trying to set the update and delete rules that are returned from the ODBC driver and the spec has the following to say: SQL_NO_ACTION: If a delete of a row in the referenced table would cause a "dangling reference" in the referencing table (that is, rows in the referencing table would have n

Re: [HACKERS] beta testing version

2000-12-02 Thread Ross J. Reedstrom
On Sat, Dec 02, 2000 at 03:47:19PM -0800, Adam Haberlach wrote: > > > > Where's the damn core code? I've seen a number of examples already of > > people asking about remote access/replication function, with an eye > > toward implementing it, and being told "PostgreSQL, Inc. is working > > on that

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 01:52 PM 12/2/00 -0800, Tom Samplonius wrote: > I doubt that. There is an IB (Interbase) replication option today, but >you must purchase it. That isn't so bad actually. PostgreSQL looks to be >going that way too: base functionality is open source, periphial >companies make money selling

Re: [HACKERS] beta testing version

2000-12-02 Thread Tom Samplonius
On Sat, 2 Dec 2000, Don Baccus wrote: ... > Will Great Bridge step to the plate and fund a truly open source alternative, > leaving us with a potential code fork? If IB gets its political problems > under control and developers rally around it, two years is going to be a > long time to just sit

Re: [HACKERS] beta testing version

2000-12-02 Thread Adam Haberlach
On Sat, Dec 02, 2000 at 03:51:15PM -0600, Ross J. Reedstrom wrote: > On Sat, Dec 02, 2000 at 11:31:37AM -0800, Don Baccus wrote: > > At 05:42 PM 12/2/00 +0100, Peter Eisentraut wrote: > > >Don Baccus writes: > > > > > >> Exactly what is PostgreSQL, Inc doing in this area? > > > > > >Good question.

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 03:51 PM 12/2/00 -0600, Ross J. Reedstrom wrote: >"We expect to have the source code tested and ready to contribute to >the open source community before the middle of October. Until that time >we are considering requests from a number of development companies and >venture capital groups to joi

Re: [HACKERS] beta testing version

2000-12-02 Thread Ross J. Reedstrom
On Sat, Dec 02, 2000 at 11:31:37AM -0800, Don Baccus wrote: > At 05:42 PM 12/2/00 +0100, Peter Eisentraut wrote: > >Don Baccus writes: > > > >> Exactly what is PostgreSQL, Inc doing in this area? > > > >Good question... See http://www.erserver.com/. > > > Boy, I can just imagine the uproar thi

Re: [HACKERS] beta testing version

2000-12-02 Thread Don Baccus
At 05:42 PM 12/2/00 +0100, Peter Eisentraut wrote: >Don Baccus writes: > >> Exactly what is PostgreSQL, Inc doing in this area? > >Good question... See http://www.erserver.com/. "Advanced Replication and Distributed Information capabilities are also under development to meet specific business

Re: [HACKERS] beta testing version

2000-12-02 Thread Magnus Naeslund\(f\)
From: "Nathan Myers" <[EMAIL PROTECTED]> > On Thu, Nov 30, 2000 at 07:02:01PM -0400, The Hermit Hacker wrote: > > [snip] > The logging in 7.1 protects transactions against many sources of > database crash, but not necessarily against OS crash, and certainly > not against power failure. (You might

Re: [HACKERS] beta testing version

2000-12-02 Thread Peter Eisentraut
Don Baccus writes: > Exactly what is PostgreSQL, Inc doing in this area? Good question... See http://www.erserver.com/. > I've not seen discussions about it here, and the two of the three most > active developers (Jan and Tom) work for Great Bridge, not PostgreSQL, > Inc... Vadim Mikheev and