pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedbugzilla.pgaccess.org
14+ messages / 7 participants
[nested] [flat]
* bugzilla.pgaccess.org
@ 2002-07-09 18:41 Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 14+ messages in thread
From: Iavor Raytchev @ 2002-07-09 18:41 UTC (permalink / raw)
To: pgaccess - developers <developers@pgaccess.org>; pgaccess - users <users@pgaccess.org>; +Cc: pgsql-hackers <pgsql-hackers@postgresql.org>; pgsql-interfaces
Hello,
As of today, a Bugzilla has been made available at -
bugzilla.pgaccess.org
This is a pretty straight forward installation of Bugzilla 2.14.2
It is currently empty. There are even no components so the first bug
submissions can be either request for components or have to wait a few days.
As we do not have much experience setting Bugzila for open source project
(we use it for internal projects - with groups and permissions), all
comments are welcome.
Iavor
--
Iavor Raytchev
very small technologies (a company of CEE Solutions)
in case of emergency -
call: + 43 676 639 46 49
or write to: support@verysmall.org
www.verysmall.org
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
@ 2002-07-09 21:28 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
0 siblings, 1 reply; 14+ messages in thread
From: Jan Wieck @ 2002-07-09 21:28 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: pgaccess - developers <developers@pgaccess.org>; pgaccess - users <users@pgaccess.org>; pgsql-hackers <pgsql-hackers@postgresql.org>; pgsql-interfaces
Iavor Raytchev wrote:
>
> Hello,
>
> As of today, a Bugzilla has been made available at -
>
> bugzilla.pgaccess.org
>
> This is a pretty straight forward installation of Bugzilla 2.14.2
>
> It is currently empty. There are even no components so the first bug
> submissions can be either request for components or have to wait a few days.
>
> As we do not have much experience setting Bugzila for open source project
> (we use it for internal projects - with groups and permissions), all
> comments are welcome.
Just out of curiosity, what database is backing it?
If it isn't PostgreSQL, what about using PHP BugTracker instead? That
runs on top of PostgreSQL.
http://sourceforge.net/projects/phpbt/
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
@ 2002-07-09 21:37 ` Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
0 siblings, 1 reply; 14+ messages in thread
From: Ned Lilly @ 2002-07-09 21:37 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: pgaccess - developers <developers@pgaccess.org>; pgaccess - users <users@pgaccess.org>; pgsql-hackers <pgsql-hackers@postgresql.org>; pgsql-interfaces
----- Original Message -----
From: "Jan Wieck" <JanWieck@Yahoo.com>
To: "Iavor Raytchev" <iavor.raytchev@verysmall.org>
Cc: "pgaccess - developers" <developers@pgaccess.org>; "pgaccess - users" <users@pgaccess.org>; "pgsql-hackers" <pgsql-hackers@postgresql.org>; "pgsql-interfaces" <pgsql-interfaces@postgresql.org>
Sent: Tuesday, July 09, 2002 5:28 PM
Subject: Re: [HACKERS] bugzilla.pgaccess.org
> Iavor Raytchev wrote:
> >
> > Hello,
> >
> > As of today, a Bugzilla has been made available at -
> >
> > bugzilla.pgaccess.org
> >
> > This is a pretty straight forward installation of Bugzilla 2.14.2
> >
> > It is currently empty. There are even no components so the first bug
> > submissions can be either request for components or have to wait a few days.
> >
> > As we do not have much experience setting Bugzila for open source project
> > (we use it for internal projects - with groups and permissions), all
> > comments are welcome.
>
> Just out of curiosity, what database is backing it?
>
> If it isn't PostgreSQL, what about using PHP BugTracker instead? That
> runs on top of PostgreSQL.
>
> http://sourceforge.net/projects/phpbt/
>
>
> Jan
Or Gborg... ;-)
http://gborg.postgresql.org/project/gborg/projdisplay.php
Cheers,
Ned
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
@ 2002-07-10 07:55 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 14+ messages in thread
From: Iavor Raytchev @ 2002-07-10 07:55 UTC (permalink / raw)
To: Ned Lilly <ned@nedscape.com>; Jan Wieck <JanWieck@Yahoo.com>; +Cc: pgaccess - developers <developers@pgaccess.org>; pgaccess - users <users@pgaccess.org>; pgsql-hackers <pgsql-hackers@postgresql.org>; pgsql-interfaces
> > Just out of curiosity, what database is backing it?
> >
> > If it isn't PostgreSQL, what about using PHP BugTracker instead? That
> > runs on top of PostgreSQL.
> >
> > http://sourceforge.net/projects/phpbt/
> >
> >
> > Jan
>
>
> Or Gborg... ;-)
>
> http://gborg.postgresql.org/project/gborg/projdisplay.php
>
> Cheers,
> Ned
Any other suggestions?
Iavor
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
@ 2002-07-10 15:44 ` Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
0 siblings, 1 reply; 14+ messages in thread
From: Josh Berkus @ 2002-07-10 15:44 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; Ned Lilly <ned@nedscape.com>; Jan Wieck <JanWieck@Yahoo.com>; +Cc: pgaccess - developers <developers@pgaccess.org>; pgaccess - users <users@pgaccess.org>; pgsql-hackers <pgsql-hackers@postgresql.org>; pgsql-interfaces
Iavor,
> Any other suggestions?
I can tell you from experience that Double-Choco-Latte, another
PHP/PostgreSQL tool, is really set up just for single projects. So it
would work fine for PGAccess-only. However, DCL has its own problems
and is not necessarily better than Mozilla; I personally don't think
it's worth switching tools just to eat our own dogfood if we don't gain
some functionality in the process.
I'd love to re-write one of these tools someday; they all have ghastly
UI problems. Right. Just after I do the accounting program, and get
caught up on my tax filing, and re-paint the bathroom ...
The one thing that really "bugs" me about Mozilla/Issuezilla is that,
if you click the link on an issue e-mail, you don't get automatically
logged in, forcing you to search for the bug a second time if you want
to commment or close the issue. Grrr. Also there's no option *not* to
get the darned e-mails for people who check the web interface
regularly.
-Josh
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
@ 2002-07-10 16:49 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
0 siblings, 1 reply; 14+ messages in thread
From: Iavor Raytchev @ 2002-07-10 16:49 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: iavor.raytchev@verysmall.org; ned@nedscape.com; JanWieck@Yahoo.com; developers@pgaccess.org; users@pgaccess.org; pgsql-hackers@postgresql.org; pgsql-interfaces
Josh Berkus said:
> Iavor,
>
>> Any other suggestions?
>
> I can tell you from experience that Double-Choco-Latte, another
> PHP/PostgreSQL tool, is really set up just for single projects. So it
> would work fine for PGAccess-only. However, DCL has its own problems
> and is not necessarily better than Mozilla; I personally don't think
> it's worth switching tools just to eat our own dogfood if we don't gain
> some functionality in the process.
>
> I'd love to re-write one of these tools someday; they all have ghastly
> UI problems. Right. Just after I do the accounting program, and get
> caught up on my tax filing, and re-paint the bathroom ...
Thanks, Josh. This was the answer I wanted to hear.
> The one thing that really "bugs" me about Mozilla/Issuezilla is that,
> if you click the link on an issue e-mail, you don't get automatically
> logged in, forcing you to search for the bug a second time if you want
> to commment or close the issue. Grrr. Also there's no option *not* to
> get the darned e-mails for people who check the web interface
> regularly.
What don't you try bugzilla.bugzilla.org or something like that :)
I mean - the guys at Mozilla have made a great product using Bugzilla. I
would be happy if we bring pgaccess at least to the level of Mozilla. Then
we can talk about changing the bug tracking system. Agreed?
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
@ 2002-07-10 14:16 ` Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
0 siblings, 1 reply; 14+ messages in thread
From: Hannu Krosing @ 2002-07-10 14:16 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: josh@agliodbs.com; ned@nedscape.com; JanWieck@Yahoo.com; developers@pgaccess.org; users@pgaccess.org; pgsql-hackers@postgresql.org; pgsql-interfaces
On Wed, 2002-07-10 at 21:49, Iavor Raytchev wrote:
> Josh Berkus said:
> > Iavor,
> >
> >> Any other suggestions?
> >
> > I can tell you from experience that Double-Choco-Latte, another
> > PHP/PostgreSQL tool, is really set up just for single projects. So it
> > would work fine for PGAccess-only. However, DCL has its own problems
> > and is not necessarily better than Mozilla; I personally don't think
> > it's worth switching tools just to eat our own dogfood if we don't gain
> > some functionality in the process.
Still we could use the bugzilla variant that uses PostgreSQL for its DB.
You can download it from the link uder the perl seal on the page
https://bugzilla.redhat.com/bugzilla/index.cgi
It points to ftp://people.redhat.com/dkl where are variants for mysql,
oracle and postgresql.
The only thing you have to do after install is changing the first lines
of scripts as they currently ppoint to #!/usr/bonsaitools/bin/perl which
you may not have ;)
---------------
Hannu
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
@ 2002-07-10 16:35 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
0 siblings, 1 reply; 14+ messages in thread
From: Iavor Raytchev @ 2002-07-10 16:35 UTC (permalink / raw)
To: Hannu Krosing <hannu@tm.ee>; +Cc: developers@pgaccess.org; users@pgaccess.org; pgsql-interfaces
> Still we could use the bugzilla variant that uses PostgreSQL for its DB.
>
> You can download it from the link uder the perl seal on the page
> https://bugzilla.redhat.com/bugzilla/index.cgi
>
> It points to ftp://people.redhat.com/dkl where are variants for mysql,
> oracle and postgresql.
>
> The only thing you have to do after install is changing the first lines
> of scripts as they currently ppoint to #!/usr/bonsaitools/bin/perl which
> you may not have ;)
Don't you think it is better to wait for Bugzilla 2.18 that will support
PostgreSQL fresh from the bugzilla.org - I would like to focus on pgaccess
now :)
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
@ 2002-07-11 21:20 ` Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Re: bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
0 siblings, 1 reply; 14+ messages in thread
From: Hannu Krosing @ 2002-07-11 21:20 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: developers@pgaccess.org; users@pgaccess.org; pgsql-interfaces
On Wed, 2002-07-10 at 18:35, Iavor Raytchev wrote:
> > Still we could use the bugzilla variant that uses PostgreSQL for its DB.
...
>
> Don't you think it is better to wait for Bugzilla 2.18 that will support
> PostgreSQL fresh from the bugzilla.org - I would like to focus on pgaccess
> now :)
How hard will the migration from MySQLzilla to PostgreSQLzilla be ?
-----------
Hannu
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
@ 2002-07-11 20:50 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 22:28 ` Re: bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 14+ messages in thread
From: Iavor Raytchev @ 2002-07-11 20:50 UTC (permalink / raw)
To: Hannu Krosing <hannu@tm.ee>; +Cc: developers@pgaccess.org; pgsql-interfaces
> How hard will the migration from MySQLzilla to PostgreSQLzilla be ?
Is this a rhetoric question?
I have no idea.
A posting I saw (by one of the Bugzilla guys, I think) required something to
be done in PostgreSQL before they can migrate - something exactly related to
the issue of upgrading from one Bugzilla version to another.
That means - Bugzilla takes care of the database upon upgrade. I am pretty
sure somebody will write a migration tool. Otherwise the whole noise is
somehow useless.
Or not?
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Re: bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
@ 2002-07-11 22:28 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 01:35 ` Re: [HACKERS] bugzilla.pgaccess.org Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 14+ messages in thread
From: Jan Wieck @ 2002-07-11 22:28 UTC (permalink / raw)
To: Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: Hannu Krosing <hannu@tm.ee>; PostgreSQL HACKERS <pgsql-hackers@PostgreSQL.org>; pgsql-interfaces
In reply to Hannu Krosing
Iavor Raytchev wrote:
>
> > How hard will the migration from MySQLzilla to PostgreSQLzilla be ?
>
> Is this a rhetoric question?
>
> I have no idea.
>
> A posting I saw (by one of the Bugzilla guys, I think) required something to
> be done in PostgreSQL before they can migrate - something exactly related to
> the issue of upgrading from one Bugzilla version to another.
I have included pgsql-hackers again, where this discussion originally
started crossposted.
Hannu's question is absolutely not rhetoric. I see a concern about using
a MySQL based tool for PostgreSQL related project management on a public
site in it.
The Bugzilla project plans to support PostgreSQL in one of their future
releases, but this requires functionality in PostgreSQL, that is not
even scheduled for 7.3. So the availability of a supported PostgreSQL
port of Bugzilla is unpredictable at this time.
My opinion is that a project as closely related to PostgreSQL as
pgaccess should try to use PostgreSQL backed management tools. The
switch to PHP BugTracker or something else at this time would be
easiest, since the Bugzilla installation on pgaccess.org is virgin and
does not contain any data yet.
This is reason why I suggested that switch when you asked for comments
originally. And I have not yet seen any argument against it, nor any
reason why to start off with a MySQL based Bugzilla version now.
Especially when there are equivalent solutions using PostgreSQL
available.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Re: bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 22:28 ` Re: bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
@ 2002-07-12 01:35 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-07-12 02:46 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
0 siblings, 1 reply; 14+ messages in thread
From: Christopher Kings-Lynne @ 2002-07-12 01:35 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; Iavor Raytchev <iavor.raytchev@verysmall.org>; +Cc: Hannu Krosing <hannu@tm.ee>; PostgreSQL HACKERS <pgsql-hackers@postgresql.org>; pgsql-interfaces
> The Bugzilla project plans to support PostgreSQL in one of their future
> releases, but this requires functionality in PostgreSQL, that is not
> even scheduled for 7.3. So the availability of a supported PostgreSQL
> port of Bugzilla is unpredictable at this time.
I think he said that they needed DROP COLUMN functionality, which is being
worked on for 7.3. (Although I haven't had time to work on it for a few
days)
Chris
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Re: bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 22:28 ` Re: bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 01:35 ` Re: [HACKERS] bugzilla.pgaccess.org Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2002-07-12 02:46 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 02:50 ` Re: [HACKERS] bugzilla.pgaccess.org Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 14+ messages in thread
From: Jan Wieck @ 2002-07-12 02:46 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: Iavor Raytchev <iavor.raytchev@verysmall.org>; Hannu Krosing <hannu@tm.ee>; PostgreSQL HACKERS <pgsql-hackers@postgresql.org>; pgsql-interfaces
Christopher Kings-Lynne wrote:
>
> > The Bugzilla project plans to support PostgreSQL in one of their future
> > releases, but this requires functionality in PostgreSQL, that is not
> > even scheduled for 7.3. So the availability of a supported PostgreSQL
> > port of Bugzilla is unpredictable at this time.
>
> I think he said that they needed DROP COLUMN functionality, which is being
> worked on for 7.3. (Although I haven't had time to work on it for a few
> days)
DROP COLUMN is the one we might solve in 7.3. ALTER COLUMN ...
TYPE was mentioned too and I don't know when or how we will have
that one.
REPLACE INTO is one more. Though you can work around it. If you
setup a BEFORE INSERT trigger, in which you do a table lock, then
try to UPDATE an existing row with NEW's key. If that succeeds,
you return NULL, suppressing the INSERT. If it fails, you return
NEW letting the INSERT happen. The table lock (what Bradley
called "heavy locking") is required because otherwise someone can
sneak in between your update attempt and letting the INSERT
happen, getting exactly the same result and ... boom, duplicate
key error.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: [HACKERS] bugzilla.pgaccess.org
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Re: [HACKERS] bugzilla.pgaccess.org Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Re: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Re: bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 22:28 ` Re: bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 01:35 ` Re: [HACKERS] bugzilla.pgaccess.org Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-07-12 02:46 ` Re: [HACKERS] bugzilla.pgaccess.org Jan Wieck <JanWieck@Yahoo.com>
@ 2002-07-12 02:50 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 14+ messages in thread
From: Bruce Momjian @ 2002-07-12 02:50 UTC (permalink / raw)
To: Jan Wieck <JanWieck@Yahoo.com>; +Cc: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; Iavor Raytchev <iavor.raytchev@verysmall.org>; Hannu Krosing <hannu@tm.ee>; PostgreSQL HACKERS <pgsql-hackers@postgresql.org>; pgsql-interfaces
Jan Wieck wrote:
> Christopher Kings-Lynne wrote:
> >
> > > The Bugzilla project plans to support PostgreSQL in one of their future
> > > releases, but this requires functionality in PostgreSQL, that is not
> > > even scheduled for 7.3. So the availability of a supported PostgreSQL
> > > port of Bugzilla is unpredictable at this time.
> >
> > I think he said that they needed DROP COLUMN functionality, which is being
> > worked on for 7.3. (Although I haven't had time to work on it for a few
> > days)
>
> DROP COLUMN is the one we might solve in 7.3. ALTER COLUMN ...
> TYPE was mentioned too and I don't know when or how we will have
> that one.
Christopher plans to work on that when he is done DROP COLUMN.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2002-07-12 02:50 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-09 18:41 bugzilla.pgaccess.org Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-09 21:28 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-09 21:37 ` Ned Lilly <ned@nedscape.com>
2002-07-10 07:55 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 15:44 ` Josh Berkus <josh@agliodbs.com>
2002-07-10 16:49 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-10 14:16 ` Hannu Krosing <hannu@tm.ee>
2002-07-10 16:35 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 21:20 ` Hannu Krosing <hannu@tm.ee>
2002-07-11 20:50 ` Iavor Raytchev <iavor.raytchev@verysmall.org>
2002-07-11 22:28 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 01:35 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-07-12 02:46 ` Jan Wieck <JanWieck@Yahoo.com>
2002-07-12 02:50 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox