On Wed, Jun 26, 2002 at 02:50:21PM -0400, Dave Cramer wrote:
> 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
I'd rather not call this open source. From th
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 t
> > 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 - wh
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,
> > 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 sa
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 determ
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
> 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 pro
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,
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
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
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 pa
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 wr
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 literatu
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 lo
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
"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
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
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, 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 i
> -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 noth
"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
>
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'
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 larg
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
> > 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 a
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.
>
> A
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 an
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
>
Kinda like the blind leading the blind, but:
I'm assuming you will need to do something similar to what you did in
the previous version in gram.y. That is, create an expression node with
the appropriate equations and pass that through ExecEvalExpr().
You can probably return the true or false fr
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; . ./.profil
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 in
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 jp
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:[EM
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 a
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 fa
>...
> 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
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
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 compatabili
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 h
The cvs docs say that we support the 'WITH CHECK OPTION' on views, but the
TODO says we don't...
Chris
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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.
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 pl
> -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
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.
46 matches
Mail list logo
