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 insu
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 bu
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.
Thanks,
Nishkala
--
Being yourself in the world which is constan
"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 suggested listing the by-month indexes
http://archives.postgresql.org/ ... better?
On Wed, 26 Jun 2002, Marc G. Fournier wrote:
>
> will do it tonight :)
>
> On Wed, 26 Jun 2002, Tom Lane wrote:
>
> > Rod Taylor <[EMAIL PROTECTED]> writes:
> > > Any chance of getting a pgsql-patches link on archives.postgresql.org?
> > > I know the
On Wed, 26 Jun 2002, Josh Berkus wrote:
> Depends on your level of write activity, and the size of the records.
> Clustered indexes work nicely for some tables. Not for others.
Well, I'm sure everyone would agree with that. The point is that
SQL Server gives you the option, posgres doesn't.
cj
On Wed, 26 Jun 2002, Dann Corbit wrote:
> I have worked as an MS SQL Server DBA (also database designer and
> programmer along with just about anything else that could be done with
> it) and am aware of the difficulties associated with SQL Server. It's a
> very good product.
Yeah, I agree. Mayb
> DROP TYPE widget RESTRICT; -- fail
> NOTICE: operator <% depends on type widget
> NOTICE: operator >% depends on type widget
> NOTICE: operator >=% depends on type widget
> ERROR: Cannot drop type widget because other objects depend on it
> Use DROP ... CASCADE to drop the dependent objects
Hi everyone,
This is Jonah's explanation of what Nextgres is, as his response didn't
make it to the list (some kind of software or network problem).
:-)
Regards and best wishes,
Justin Clift
Original Message
Subject: Re: [HACKERS] Nextgres?
Date: Wed, 26 Jun 2002 12:18:57 -
On Wed, 26 Jun 2002, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > Note that your proposal of using mmap to replace sysv shared memory
> > relies on the behaviour I've described too.
>
> True, but I was not envisioning mapping an actual file --- at least
> on HPUX, the only way t
On Wed, 2002-06-26 at 20:54, Josh Berkus wrote:
>
> Dann,
>
> > From a growth standpoint, I think it is a much better idea to focus on
> > their strong points. Look at the things each competitor can do best.
> > Try to think of ways to get the same functionality from PostgreSQL. If
> > it is i
On Wed, 26 Jun 2002, Josh Berkus wrote:
> As a professional MS SQL Server 7.0 manager
Well, I wouldn't call myself a professional at managing SQL Server, but
I did do about two years of work on an application (database design,
programming and day-to-day running of the production system) that
Justin,
It doesn't appear that my response was posted to the list. I can thank
YANOCC for that. However, did you receive it?
Bruce,
Does make for a good joke, but nowhere is compatibility mentioned. It was
discussing the SQL grammar. And, it should have read PostgreSQL 7.1.2. The
last upda
-patches added ... I've gotta redo that page, as it was just a
'quick-n-dirty' when I did it ...
On 27 Jun 2002, Rod Taylor wrote:
> > > Vince, we can get -advocacy listed on the web site? There has been no
> > > traffic over there until now, but there are ppl subscribed to it ...
> >
> > all
will do it tonight :)
On Wed, 26 Jun 2002, Tom Lane wrote:
> Rod Taylor <[EMAIL PROTECTED]> writes:
> > Any chance of getting a pgsql-patches link on archives.postgresql.org?
> > I know the archives are created (I use them) but there is no obvious
> > link.
>
> > Secondly, could the links that
Rod Taylor <[EMAIL PROTECTED]> writes:
> Any chance of getting a pgsql-patches link on archives.postgresql.org?
> I know the archives are created (I use them) but there is no obvious
> link.
> Secondly, could the links that do exist be ordered alphabetically?
I'm for that too. Every time I go
Dann,
> From a growth standpoint, I think it is a much better idea to focus on
> their strong points. Look at the things each competitor can do best.
> Try to think of ways to get the same functionality from PostgreSQL. If
> it is impossible [or currently infeasible] to meet the functionality,
Rod Taylor wrote:
> > David Kaplan reminded me that there is another UI issue to be
> > considered: when we *are* doing a DROP CASCADE, should the dropped
> > dependent objects be reported somehow? As it stands, Rod's patch emits
> > elog(NOTICE) messages in this case, but I am wondering whether
On 27 Jun 2002, Rod Taylor wrote:
> > > Vince, we can get -advocacy listed on the web site? There has been no
> > > traffic over there until now, but there are ppl subscribed to it ...
> >
> > all done.
>
> Any chance of getting a pgsql-patches link on archives.postgresql.org?
> I know the archi
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 exactly.
Well, maybe. One question is how that
> > Vince, we can get -advocacy listed on the web site? There has been no
> > traffic over there until now, but there are ppl subscribed to it ...
>
> all done.
Any chance of getting a pgsql-patches link on archives.postgresql.org?
I know the archives are created (I use them) but there is no o
On Wed, 2002-06-26 at 22:30, Tom Lane wrote:
> Joe Conway <[EMAIL PROTECTED]> writes:
> > It would be nice if the recursive dependency checking function was
> > available as an end user function too, so you could analyze dependencies
> > before even trying to drop something, or even just to unde
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 some years ago doesn't
Joe Conway <[EMAIL PROTECTED]> writes:
> It would be nice if the recursive dependency checking function was
> available as an end user function too, so you could analyze dependencies
> before even trying to drop something, or even just to understand a
> database schema you've inherited from som
Followup set to -advocacy
On Wed, Jun 26, 2002 at 12:01:18PM -0700, Dann Corbit wrote:
> Customer support is also a big issue comparing free database systems
> with commercial ones. I know that there are a couple groups that do
> this, but that genre of businesses do not have a good track recor
Jan Wieck wrote:
> As for project coordination, I am willing to setup and maintain a page
> similar to the (horribly outdated) ones that I did for Toast and RI.
> Summarizing project status, pointing to resources, instructions, maybe a
> roadmap, TODO, you name it.
Great. Please see roadmap in T
On Wed, 2002-06-26 at 13:50, Josh Berkus wrote:
>
> BTW, does anyone on this list know about Command Prompt, Inc.'s tools? There
> seems to be a lot of duplicte development going on in the commercial space.
I know for my PERSONAL stuff, commercial tools ($$) mean I don't even
bother. I have s
On Tue, 25 Jun 2002, Marc G. Fournier wrote:
>
> Well hidden, but so far 86 have found it and subscribed to it *grin*
It's on the subscription form.
[snip]
> Vince, we can get -advocacy listed on the web site? There has been no
> traffic over there until now, but there are ppl subscribed to i
On Wed, 26 Jun 2002 11:35:07 PDT, the world broke into rejoicing as
Josh Berkus <[EMAIL PROTECTED]> said:
> > What do you see as the drawbacks with java, and how can they be
> > circumvented?
>
> 1. Java is not Open Source. It's an open standard, but not OS.
The problem is not with the languag
Tom Lane writes:
> IIRC, a function is only considered to be a cast function if it matches
> by name *and schema* with the target type. So if you, for example,
> make a function public.int4(something), it'll never be considered a
> cast function for pg_catalog.int4. I had some doubts about that
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2002 19:21
> To: PostgreSQL-development
> Subject: [HACKERS] Why I like partial solutions
>
>
> If we want to grow PostgreSQL, we need to meet users needs,
> even if that requires stomaching some hac
Dann,
> Totally false:
> http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp
The microsoft benchmarks aren't worth the screen space they take up. I don't
consider these "evidence". I'm basing this on real experience of working
with real production databases, not some idealized b
> -Original Message-
> From: Dave Cramer [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2002 19:01
> To: Dave Page
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Rod Taylor
> Subject: Re: [HACKERS] Postgres idea list
>
>
> Dave,
>
> Would you consider java as a platform independant language
On Wed, 26 Jun 2002, Dave Page wrote:
>
>
> > -Original Message-
> > From: Greg Sabino Mullane [mailto:[EMAIL PROTECTED]]
> > Sent: 25 June 2002 20:04
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] Postgres idea list
> >
> >
> > 12. Offer something "fun": a naming contest for the elepha
> -Original Message-
> From: Jan Wieck [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2002 15:45
> To: HACKERS
> Subject: [HACKERS] (A) native Windows port
>
>
> As for project coordination, I am willing to setup and
> maintain a page similar to the (horribly outdated) ones that
> I did
I think that the people on this list tend to make a mistake.
They try to pick apart the competition by focusing on their weak points.
From a growth standpoint, I think it is a much better idea to focus on
their strong points. Look at the things each competitor can do best.
Try to think of ways
Dave,
> 1) There is an open source implementation of java
Really? I thought Sun had a patent.
> 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 drive
> -Original Message-
> From: Josh Berkus [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 26, 2002 9:18 AM
> To: Curt Sampson; [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Democracy and organisation : let's make a
>
>
> Curt,
>
> You do point out some good areas in which PostgreSQL need
Dave,
> What do you see as the drawbacks with java, and how can they be
> circumvented?
1. Java is not Open Source. It's an open standard, but not OS.
2. I understand that there are some serious limitations to the current
Postgres JDBC drivers. I have not used them, so I'm reporting rumor,
Tom Lane wrote:
> Also, would it be a good idea to make it *recursively* report all
> the indirect as well as direct dependencies? The output might get
> a little bulky, but if you really want to know what DROP CASCADE
> will get you into, seems like that is the only way to know.
>
> To work rec
Tom Lane wrote:
>
> DROP TYPE widget RESTRICT; -- fail
> NOTICE: operator <% depends on type widget
> NOTICE: operator >% depends on type widget
> NOTICE: operator >=% depends on type widget
> ERROR: Cannot drop type widget because other objects depend on it
> Use DROP ... CASCADE to dr
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 effort as a waste of time.
Java has its drawbacks, but a JPgAdmin tool would significantly encourage
Postgres-OpenOffice.org integration.
--
I find myself repeatedly arguing for partial solutions, and having to
struggle with other developers who feel these solutions are hacks.
Let me explain why I like these hacks.
When we have a feature that users want, often we can't get it
implemented promptly in a clean way. It can take several r
what is gborg ? :)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
> Sent: Wednesday, June 26, 2002 11:21 AM
> To: Dave Cramer
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Democracy and organisation : let's make a
> revolution
>
Justin Clift wrote:
> Hi Jonah,
>
> Was just looking around your company website, and it mentions a product
> called "Nextgres" which looks interesting :
>
> http://www.nightstarcorporation.com/?op=products
>
> How do you guys implement the PostgreSQL SQL parser as well as the
> Interbase and O
Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > Note that your proposal of using mmap to replace sysv shared memory
> > relies on the behaviour I've described too.
>
> True, but I was not envisioning mapping an actual file --- at least
> on HPUX, the only way to generate an arbitra
Curt,
You do point out some good areas in which PostgreSQL needs to improve
if we're going to go after the MS SQL market.The rest of this
e-mail, though, is a refutation of your comparison.
As a professional MS SQL Server 7.0 manager, I have to disagree.
However, I have not used MS SQL 200
I guess the website is really good. The only thing I'd do is to add a
section listing the core features of PostgreSQL - I think this could be
an important point.
In my opinion MySQL is not a competitor and we should not benchmark
PostgreSQL and compare it with MySQL. Those features which are r
I have been reviewing Rod Taylor's pg_depend patch, which among other
things adds SQL-compliant DROP RESTRICT/CASCADE syntax and prevents
you from dropping things that other things depend on, as in ye olde
novice error of dropping a function used by a trigger.
As submitted, the patch gives elog(E
Hi Tom,
Tom Lane wrote:
>
> "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > You mean a list like ... oh, I don't know ...
> > [EMAIL PROTECTED]? :)
>
> You know, I seemed to remember that we had such a list, but I looked at
> http://archives.postgresql.org/
> and saw no archive for it, so I
On Wed, Jun 26, 2002 at 12:22:54PM +0900, Emilio Uy III wrote:
>
> I am just wondering, because I have installed PostgreSQL on my Cygwin
> (Windows NT) and this is my first time to attempt a dive into the database
> realm. I am not sure of this, but there should be a way to access a database
> th
On Mon, 24 Jun 2002 12:53:42 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
>the extra level of struct naming for pd_opaque has no obvious
>usefulness.
>
>> [...] should I post a patch that puts pagesize directly into
>> PageHeaderData?
>
>If you're so inclined. Given that pd_opaque is hidden in thos
Hackers,
as some of you figured already, Katie Ward and I are working fulltime on
PostgreSQL and are actually doing a native Win32 port. This port is not
based on CygWIN, Apache or any other compatibility library but uses 100%
native Windows functionality only.
We already have it far enough to
> -Original Message-
> From: Josh Berkus [mailto:[EMAIL PROTECTED]]
> Sent: 26 June 2002 01:51
> To: [EMAIL PROTECTED]
> Cc: Rod Taylor
> Subject: Re: [HACKERS] Postgres idea list
>
>
>
> Folks,
>
> > What would be a win is an SQL like interface to editing pg_hba.conf
> > and postg
> -Original Message-
> From: Greg Sabino Mullane [mailto:[EMAIL PROTECTED]]
> Sent: 25 June 2002 20:04
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] Postgres idea list
>
>
> 12. Offer something "fun": a naming contest for the elephant (I know,
> I know),
Isn't the elephant called Slo
Curt Sampson <[EMAIL PROTECTED]> writes:
> Note that your proposal of using mmap to replace sysv shared memory
> relies on the behaviour I've described too.
True, but I was not envisioning mapping an actual file --- at least
on HPUX, the only way to generate an arbitrary-sized shared memory
regio
"Jonah H. Harris" wrote:
>
> Who originally did the TPC-C benchmarks? Is the source available for them?
Great Bridge once ran some sort of (what they thought it would be) TPC-C
benchmark. They used the proprietary Benchmark Factory software for
doing so.
While working there I had some time to
This mail was sent to pgadmin-hackers list by Mark Radulovich
<[EMAIL PROTECTED]>. It is quite interesting:
*
I've been following these mailing lists for over two years, and I guess now
is the time to chime in.
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Tue, 25 Jun 2002, Tom Lane wrote:
>> It also occurs to me that discussing this on -hackers, which is a
>> technically focused list, is itself somewhat wrongheaded. The best
>> list we have for it at the moment is -general, but I wonder whether w
Hi, my name is Emil, I am a software engineer at NEC, Japan. This is not in
any way related to my work, but I am that interested in cygwin that I
installed it on my own PC and right now I am enjoying it. Your work is a
good one really, I appreciate what you guys are doing.
I am just wondering, b
I have started a java admin tool on sourceforge just 2 weeks ago
actually, www.sf.net/jpgadmin
Dave
On Wed, 2002-06-26 at 02:51, Christopher Kings-Lynne wrote:
> > What other development options do we have for soemthing that is GUI and
> > portable to all platforms that postgresql runs on? Java
Julian Mehnle wrote:
>
> Yeah, it does *not* exhibit the faulty CRLF<->LF conversion behavior.
> Is this a custom build of the ODBC driver done by you? Will the
> official driver be fixed soon?
I would commit the fix to cvs this week.
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue
> > Yeah, a point-and-drool installation wizard for postgres under windows
> > would be great. I think, from looking at PGAdminII, that we've already
> > got great admin tools; it seems just as good as SQL Server Enterprise
> > Manager to me.
>
> Once we have a proper Win32 native version, the guy
Two points to this discussion.
I hate to admit this, but to some people, a Windows version is important.
Yesterday I learned that one product developed here will have a MySQL
implementation because marketing wants a free implementation.
The biggest advantage seems to be that it's working on Wi
64 matches
Mail list logo
