Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Bruce Momjian
Doug Quale wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > The fact is the MySQL and the FSF want to make the GPL reach as far as > > possible, so there is no attempt to make a reasonable definition. In > > fact, they rely on that fuzzy definition, and the threat of legal action > > (leg

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Dann Corbit
> -Original Message- > From: Doug Quale [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2003 5:13 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] About GPL and proprietary software > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > The fact is the MySQL and the FSF wan

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Doug Quale
Bruce Momjian <[EMAIL PROTECTED]> writes: > The fact is the MySQL and the FSF want to make the GPL reach as far as > possible, so there is no attempt to make a reasonable definition. In > fact, they rely on that fuzzy definition, and the threat of legal action > (legal extortion) to further the r

Re: [GENERAL] insert duplicated unique/PK with no errors

2003-09-24 Thread Karsten Hilbert
>>...what is the best way to force duplicated unique >>or primary key'ed row inserts not to raise errors? Remove the columns' UNIQUE or PRIMARY KEY constraints. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---(end of

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Andrew Ayers
Dann Corbit wrote: > This is what I find odd about GPL software: > {an illustration} > A man named George opens a spoon factory. People flock to his shop to > make spoons with no charge for their labor. You see, it is a company in > combat with the mighty "Oneida" which makes lots of spoons and p

Re: [GENERAL] insert duplicated unique/PK with no errors

2003-09-24 Thread Gaetano Mendola
Mirek Rusin wrote: ...what is the best way to force duplicated unique or primary key'ed row inserts not to raise errors? Doesn't make sense, am I missing the point ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmas

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Dann Corbit
> -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2003 1:43 PM > To: Jan Wieck > Cc: Kaarel; Christopher Browne; [EMAIL PROTECTED]; > Marten G Mickos > Subject: Re: [GENERAL] About GPL and proprietary software > > > Jan Wieck wrote: >

Re: [GENERAL] PostgreSQL at OSCON 2004

2003-09-24 Thread Robby Russell
[EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The time and place for the Open Source Convention (OSCON) 2004 has just been announced: 2004 O'Reilly Open Source Convention July 26-30, 2004 Portland Marriott Downtown, Portland, OR Last year had a good PostgreSQL showing (in

[GENERAL] PostgreSQL at OSCON 2004

2003-09-24 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The time and place for the Open Source Convention (OSCON) 2004 has just been announced: 2004 O'Reilly Open Source Convention July 26-30, 2004 Portland Marriott Downtown, Portland, OR Last year had a good PostgreSQL showing (including our own track

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Bruce Momjian
Jan Wieck wrote: > > "Your PHP app that requires MySQL, if distributed, will either have > > to be GPL (or another OSI-approved and MySQL-approved open source > > licence ) or you will need a commercial licence of MySQL." In this case, it is almost saying that if the application requires MySQL

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Bruce Momjian
Marten G Mickos wrote: > Scott et co., > > Thanks for your comment. Here is my response. > > First of all, let's remember that neither I nor MySQL AB (nor any of > us) is an official authority for interpreting the GPL. Legally, > affirmative answers can only be given by a competent court. The F

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Bruce Momjian
Marten G Mickos wrote: > Scott et co., > > Thanks for your comment. Here is my response. > > First of all, let's remember that neither I nor MySQL AB (nor any of > us) is an official authority for interpreting the GPL. Legally, > affirmative answers can only be given by a competent court. The F

Re: [GENERAL] pltcl problem

2003-09-24 Thread Russ Brown
On Wed, 24 Sep 2003 15:02:49 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: Russ Brown <[EMAIL PROTECTED]> writes: Actually, I have done something stupid. I'm basically running the error log through a grep for DEBUG, and what I'm seeing is chunks of the function create being dumped to the error log.

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Bruce Momjian
Christopher Browne wrote: > > This is generally true, but it also created an issue where PHP, an open > > source project, can no longer distribute PHP with mysql connect libraries > > freely due to what I like to think of as an "impedence mismatch" of their > > licenses. I.e. more free licenses

Re: [GENERAL] pltcl problem

2003-09-24 Thread Tom Lane
Russ Brown <[EMAIL PROTECTED]> writes: > Actually, I have done something stupid. I'm basically running the error > log through a grep for DEBUG, and what I'm seeing is chunks of the > function create being dumped to the error log. My actual dumps aren't > getting into the error log at all, which

[GENERAL] mod_auth_pgsql 2.0.1 don't close the backend connection ?

2003-09-24 Thread Bruno BAGUETTE
Hello, I use mod_auth_pgsql 2.0.1 with PostgreSQL 7.3.2 and Apache 2.0.47. It seems like that mod_auth_pgsql don't close the connection with the Postmaster, so after a few moments I get the famous "Non-superuser connection limit exceeded" error message. The max_connections value is 256 and there

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Robert Treat
On Wed, 2003-09-24 at 13:50, Jan Wieck wrote: > > > Robert Treat wrote: > > On Tue, 2003-09-23 at 17:49, Christopher Browne wrote: > >> It would be most interesting if the makers of other GPLed software > >> such as Linux were to apply the same rule themselves. > >> > >> That way, for MySQL to b

Re: [GENERAL] BSD License

2003-09-24 Thread Jan Wieck
No. Fortunately we agreed to try not to change the license again before the "final" release of PostgreSQL. This _might_ take a while, but has the tremendeous benefit of reducing the license changes to one. Jan Evil Azrael wrote: Hi Folks! I don´t know whether it would be possible or not, but

Re: [GENERAL] GET LAST ID INSERT

2003-09-24 Thread Oliver Elphick
On Wed, 2003-09-24 at 11:49, Maurizio Faini wrote: > I tried to use CURRVAL, but it gives me this error: > IS NOT YET DEFINED IN THIS SECTION That indicates that in the current session you haven't yet used nextval() on the id specified in the currval() call. > this is what i do: > 1) INSERT (id,

Re: [GENERAL] About GPL and proprietary software

2003-09-24 Thread Jan Wieck
Robert Treat wrote: On Tue, 2003-09-23 at 17:49, Christopher Browne wrote: It would be most interesting if the makers of other GPLed software such as Linux were to apply the same rule themselves. That way, for MySQL to be distributed with Linux, MySQL AB might be required to pay $450/box to Linus

Re: [GENERAL] sequence's plpgsql

2003-09-24 Thread Richard Huxton
On Wednesday 24 September 2003 17:40, Tim McAuley wrote: > Hi, > > I've hit a little problem and was wondering if anyone might be able to > give some help. > > Set-up: > > - JBoss appserver using entity beans to access database > - Using sequence pattern to update primary keys for several tables. >

Re: [GENERAL] An idea for IPU ( We need another acronymn! )

2003-09-24 Thread Bruce Momjian
Let's get no-disk-format upgrades working first. --- Dennis Gearon wrote: > IPU, in place updates. > -- > > 1/ Put a version numbers on each record represented by a byte/word sized > number from a t

Re: [GENERAL] pltcl problem

2003-09-24 Thread Ian Harding
That line, in a context where it will get evaluated by the tcl interpreter, should work. Do you have a tcl variable called vchtablename available at that point in your script? If it is a tcl array, to get its contents, you need [array get vchtablename] instead of the $ dereference. However,

[GENERAL] sequence's plpgsql

2003-09-24 Thread Tim McAuley
Hi, I've hit a little problem and was wondering if anyone might be able to give some help. Set-up: - JBoss appserver using entity beans to access database - Using sequence pattern to update primary keys for several tables. Basically it is a method of getting primary keys without hitting the d

Re: [GENERAL] career in SQL/Database administration

2003-09-24 Thread Jonathan Bartlett
We dont' do hourly rates. We do it by the job. Therefore, the consumer doesn't have to think about how much they're paying us per hour. The just have to think about the benefits in relation to the cost. It also allows us to get better profit margins, because we can automate in innovative ways,

Re: [GENERAL] pltcl problem

2003-09-24 Thread Tom Lane
Russ Brown <[EMAIL PROTECTED]> writes: >> Can we see the whole function definition? I think you are somehow >> managing to include this string in a quoted argument of some other elog >> command, but without context it's hard to say more. > I thought that too but I can't see anything obvious (but

Re: [GENERAL] career in SQL/Database administration

2003-09-24 Thread btober
> I think most careers these days are shifting towards "package jobs" > where one guy does everything. Either that, or you work for a consulting/contractor outfit, and the customer periodically cancels the contract in order to play hardball and "negotiate" for lower rates. Then you find yourself

Re: [GENERAL] pltcl problem

2003-09-24 Thread Russ Brown
Can we see the whole function definition? I think you are somehow managing to include this string in a quoted argument of some other elog command, but without context it's hard to say more. regards, tom lane Actually, I have done something stupid. I'm basically running the error log through a

Re: [GENERAL] This mail list and its policies

2003-09-24 Thread Bruce Momjian
Tom Lane wrote: > [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 Bay

[GENERAL] 7.3.3 again - fixed

2003-09-24 Thread Daniel E. Fisher
It is working 2 differend postmasters on the computerhad to straigten the m out. -Dan ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] pltcl problem

2003-09-24 Thread Russ Brown
Can we see the whole function definition? I think you are somehow managing to include this string in a quoted argument of some other elog command, but without context it's hard to say more. regards, tom lane I thought that too but I can't see anything obvious (but then I am a tcl novice :-). T

Re: [GENERAL] pltcl problem

2003-09-24 Thread Tom Lane
Russ Brown <[EMAIL PROTECTED]> writes: > So, I'm using a command like this: > elog DEBUG "Trigger Call $vchtablename" > Trouble is, it's appearing in the error log exactly like that (including > the 'elog DEBUG' part. Can we see the whole function definition? I think you are somehow managing to

Re: [GENERAL] Is this "order by" logic right

2003-09-24 Thread Dennis Gearon
What should we comment on? 翽 wrote: Hello list, The query has the following in the where: UPPER(cty_Name) LIKE 'NEW%' ORDER BY cty_name it returns the data in this way: Newark Newark New Britain Newburgh New Cannan New Castle Newcomerstown The table has index on cty_name (btree), I'll appreci