I have an slightly different perspective on this. I hope it will be a bit useful
Background:
I'm a senior developer for a consulting firm. I too have experience with DB/2, Oracle, Sybase, Adabase, and M$ SQL.
In the last few years of work I've been moving from the technical side of things to be
Begin forwarded message:
I said:
BTW - Oracle other commercial vendors handle these contingencies by
buying insurance policies.
I think I should probably correct the above statement. I think Oracle
specifically has a large enough revenue stream that they have no need to
purchase an
Hmmm...
I think this is a common fallacy. It's like arguing that if windoze crashes
and you lose important data then you have some sort of legal recourse
against Microsoft. Ever read one of their EULAs? $10 says that Oracle's
license grants them absolute immunity to any kind of damages claim.
-Original Message-
From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2002 08:08
To: [EMAIL PROTECTED]; Tim Hart
Cc: Andrew Sullivan; [EMAIL PROTECTED]
Subject: Re: [HACKERS] Support (was: Democracy and organisation)
Hmmm...
I think this is a common
I think PostgreSQL's standards are a bit too high. From my point of view, the team as a whole has no desire to build the worlds best open source database from the point of view of functionality. They seem more interested in the writing the open source database with the world's most aesthetically
On Thu, Jun 27, 2002 at 10:13:26AM +0530, Nishkala wrote:
I am a student doing my graduation in India. I want to know what are the
other OODBMS features ( other than inheritance ) available
in PostGreSQL. It would be great if you can help me out with some
information regarding this.
Hi,
Based on recent discussion, I went thru and got together the work I'd done
on the BETWEEN node. It's not as far along as I thought. I ran into a few
hurdles:
* ExecEvalBetweenExpr is probably beyond my powers - I've done my best and
marked my hopelessness with '@@' symbols. I don't know
On Wed, 26 Jun 2002, Tom Lane wrote:
I don't really mind hacks^H^H^Hpartial solutions that are clean subsets
of the functionality we want to have eventually. I do object to hacks
that will create a backwards-compatibility problem when we want to do it
right.
If the backwards compatability
I've just come across a case in Oracle 8.0.6 where important queries
could have been several orders of magnitude faster if only the optimizer
had realized that it was doing case-insensitive comparisons against a
constant that wasn't affected by case (a string of all digits).
The query was of the
...
if (upper('001234') == lower('001234'))
SELECT * FROM table
WHERE id = '001234';
else
SELECT * FROM table
WHERE upper(id) = '001234';
Even without the index I guess that would have saved it a lot of work.
I'm no
On Thu, 2002-06-27 at 02:10, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Perhaps it wouldn't be such a terrible idea after all to store the casting
paths separately, such as in a system table pg_cast (from, to, func,
implicit). This would implement the SQL99 spec fairly
Josh,
1) There is an open source implementation of java
2) The jdbc driver is much better than it was recently we have made lots
of improvements, and it won't affect jpgadmin anyway. I actually think
writing the admin tool in java will make the driver better.
3) Don't see this as a big issue we
Dave,
Would you consider java as a platform independant language? I have
started a project on sf.net called jpgadmin, but I see the duplication
of effort as a waste of time.
Dave
On Wed, 2002-06-26 at 09:45, Dave Page wrote:
-Original Message-
From: Josh Berkus [mailto:[EMAIL
On Wed, 2002-06-26 at 14:50, Josh Berkus wrote:
Dave,
1) There is an open source implementation of java
Really? I thought Sun had a patent.
www.blackdown.org
2) The jdbc driver is much better than it was recently we have made lots
of improvements, and it won't affect jpgadmin
Begin forwarded message:
I said:
BTW - Oracle other commercial vendors handle these contingencies by
buying insurance policies.
I think I should probably correct the above statement. I think Oracle
specifically has a large enough revenue stream that they have no need to
purchase an
Hi
i just upgrading postgres from 7.0 to 7.2 and i have the folowing error in
configuration process
what happen ? how to fix this problem ?
Enter default encoding (SQL_ASCII):
Now installing the PostgreSQL database files in /var/lib/postgres/data
su - postgres -c cd /var/lib/postgres; .
Josh,
What do you see as the drawbacks with java, and how can they be
circumvented?
Dave
On Wed, 2002-06-26 at 14:08, Josh Berkus wrote:
Daves,
Would you consider java as a platform independant language? I have
started a project on sf.net called jpgadmin, but I see the duplication
of
Marc,
I tried to create it on gborg originally, but could not complete the
form ??
But to answer your question I would prefer to have it at gborg, so I
will try again and let you know the results.
Dave
On Wed, 2002-06-26 at 10:21, Marc G. Fournier wrote:
could we get this added to gborg and
On Thu, 27 Jun 2002, Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
http://archives.postgresql.org/ ... better?
Yup, although I'd suggest making the classification line up with
the one on the main website --- docs and cygwin are listed as
developer lists there.
Also, someone
Also, someone suggested listing the by-month indexes back-to-front
(most recent month first), which seems like a great idea if not
difficult.
Better?
http://archives.postgresql.org/pgsql-jdbc
The rest will 'fall in line' once there is something for mhonarc to work
on again ...
I
On 26 Jun 2002 14:36:15 EDT, the world broke into rejoicing as
Dave Cramer [EMAIL PROTECTED] said:
Josh,
1) There is an open source implementation of java
2) The jdbc driver is much better than it was recently we have made lots
of improvements, and it won't affect jpgadmin anyway. I
On Thu, 2002-06-27 at 02:52, Tim Hart wrote:
Begin forwarded message:
I said:
BTW - Oracle other commercial vendors handle these contingencies by
buying insurance policies.
I think I should probably correct the above statement. I think Oracle
specifically has a large enough
On 27 Jun 2002, Rod Taylor wrote:
Also, someone suggested listing the by-month indexes back-to-front
(most recent month first), which seems like a great idea if not
difficult.
Better?
http://archives.postgresql.org/pgsql-jdbc
The rest will 'fall in line' once there is
Fouad Fezzi [EMAIL PROTECTED] writes:
i just upgrading postgres from 7.0 to 7.2 and i have the folowing error in
configuration process
what happen ? how to fix this problem ?
Enter default encoding (SQL_ASCII):
Now installing the PostgreSQL database files in /var/lib/postgres/data
su -
-Original Message-
From: Dave Cramer [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2002 12:12
To: Dave Page
Subject: RE: [HACKERS] Postgres idea list
Dave,
Thanks for the response.
On Wed, 2002-06-26 at 15:21, Dave Page wrote:
I do, but I've had nothing but bad
Marc, did you do anything to the format of the individual archive
message pages? The top index pages look great, but when I go to,
say,
http://archives.postgresql.org/pgsql-hackers/2002-05/index.php
I see only a blank page. View Source shows there is stuff there,
but my browser ain't coping.
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
So, when we review patches, we shouldn't be turning up our noses at
imperfect solutions if the solution meets needs of our users.
I think our standards have gone up over the years, and properly so.
The fact that we put in hacks
shows up fine for me ... browser issue? :( is there a tag missing that
you can pick out in view source? *raised eyebrow*
On Thu, 27 Jun 2002, Tom Lane wrote:
Marc, did you do anything to the format of the individual archive
message pages? The top index pages look great, but when I go to,
Marc G. Fournier [EMAIL PROTECTED] writes:
shows up fine for me ... browser issue? :( is there a tag missing that
you can pick out in view source? *raised eyebrow*
Looks like table problems. I tried W3C's validator on it, and it had a ton
of minor gripes, but the missing table end-tag is
Hannu Krosing [EMAIL PROTECTED] writes:
Are the docs on our schema usage already available someplace ?
Yes, although there's not a pulled-together introduction (someone needs
to write a section for the tutorial, I think). Try
http://developer.postgresql.org/docs/postgres/sql-naming.html
and
Could very well be. As I said, I'm not a lawyer. I do know that depending upon the
laws in a region, EULAs can be proven to be legally invalid.
I do personally find it hard to believe that Oracle could be legally immune from *all*
damages claims. In practice proving fault could be very hard to
On Fri, 14 Jun 2002, Gavin Sherry wrote:
On Thu, 13 Jun 2002, Mike Mascari wrote:
CREATE TEMPORARY TABLE
...
ON COMMIT DROP;
pseudo-compatible with the SQL-standard of:
ON COMMIT { DELETE | PRESERVE } ROWS;
so one day PostgreSQL's grammar would look like:
...
Tim,
If a catastrophic software failure results in a high percentage of
lost revenue, a corporation might be able to seek monetary
compensation from a commercial vendor. They could even be taken to
court - depending upon licensing, product descriptions, promises made
in product literature,
Slight bug in the previous patch. Logically (and according to SQL99's
treatment of ON COMMIT), it can be specified only for CREATE TEMP
TABLE. The patch throws an error if only CREATE TABLE has been specified.
Gavin
On Fri, 28 Jun 2002, Gavin Sherry wrote:
On Fri, 14 Jun 2002, Gavin Sherry
Gavin Sherry wrote:
Slight bug in the previous patch. Logically (and according to SQL99's
treatment of ON COMMIT), it can be specified only for CREATE TEMP
TABLE. The patch throws an error if only CREATE TABLE has been specified.
...
Attached is a patch implementing this. The patch is
On Thursday, 27, 2002, at 10:07AM, Josh Berkus [EMAIL PROTECTED] wrote:
Or from a financial perspective: An enterprise MS SQL 2000 user can
expect to pay, under Licensing 6.0, about $10,000 - $20,000 a year in
licnesing fees -- *not including any support*. Just $2000-$5000 buys
you a
Is this sort of like Oracle guaranteeing its uncrackable, but as soon as
someone comes to them to prove it is, Oracle's response is but DBA didn't
enable the obscure security feature that can be found here, that is
disabled by default?
On Thu, 27 Jun 2002, Tim Hart wrote:
Could very well be.
Karel,
OO in PostgreSQL means that you can create own operators, datetypes,
functions...
Last I checked, all of these things were part of the SQL spec. I believe our
only OO functionality is inheritance ... which I have yet to find a use
for.
Of course, I agree with Fabian Pascal,
Last I checked, all of these things were part of the SQL spec. I believe
our
only OO functionality is inheritance ... which I have yet to find a use
for.
Well, it's lower maintenance than the 14-clause SELECT...UNION...UNION...
I'd have to write for ``correct'' code, in my current
On Fri, 2002-06-28 at 03:21, Josh Berkus wrote:
Karel,
OO in PostgreSQL means that you can create own operators, datetypes,
functions...
Last I checked, all of these things were part of the SQL spec. I believe our
only OO functionality is inheritance ...
Actually _single_
Tom Lane writes:
Thomas appears to want your schema search path to have some effect on
which casts you can see --- which I'm not at all sure I agree with,
but if that's the requirement then the above doesn't do it either.
If I understand this right, this would be nearly analogous to
OO in PostgreSQL means that you can create own operators, datetypes,
functions...
Last I checked, all of these things were part of the SQL spec. I believe our
only OO functionality is inheritance ... which I have yet to find a use
for.
Can you tell me what the SQL99 spec says
On Thu, 27 Jun 2002, Tom Lane wrote:
...but the missing table end-tag is probably the killer:
That kills me in Netscape 4.78 all the time. It's a well known problem.
cjs
--
Curt Sampson [EMAIL PROTECTED] +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age,
Anyone else keen for this feature?
Attached is a patch implementing this. The patch is against 7.2.1
source. The grammar introduced is of the form:
CREATE TEMP TABLE ... ON COMMIT DROP;
Is this a desirable feature? Seems pretty useful to me.
It's useful, there's a patch - what more
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
Thomas appears to want your schema search path to have some effect on
which casts you can see --- which I'm not at all sure I agree with,
but if that's the requirement then the above doesn't do it either.
If I understand this
45 matches
Mail list logo