Re: [HACKERS] url for TODO item, is it right?

2006-07-19 Thread Bruce Momjian
Marc G. Fournier wrote:
  Why can't we just write a script that creates new numbers as needed,
  such as msg00163.1.php and msg00163.2.php? As far as I can tell, there
  is nothing magical about the naming schema itself that would cause
  such URLs to break anything.
 
  Agreed.  It is nice to have the emails numbered in arrival order, but
  changes to old URLs are worse.
 
 'k, so is the concensus here that I regenerate everything with the 'broken 
 msg seperator', and then revert to the unbroken one for new stuff?  its no 
 sweat, I just fear this is going to re-crop up sometime in the future if 
 we ever have to regenerate from the mbox files, as well have some in 
 'broken format' and some in the 'unbroken', but renumbering *then* will 
 still affect everything ...
 
 Basically, we're just differing the headaches to a later date when we have 
 no choice :(

Well, ideally we could have the new items renumbered on to the end,
starting at 10,000 or something.  That way, the numbers aren't changed,
but the missing items are now visible.  Does the search system assume
that numering is always increasing?

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Bruce Momjian
Greg Sabino Mullane wrote:
[ There is text before PGP section. ]
 
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 
  http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php
 
  Yeah.  I think the TODO item is intended to point to what is now
  http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
  or one of the earlier messages in that thread.
 
 This is a very ugly problem. Note that there are also URLs that cannot
 be changed, such as older messages that point to archive posts, and
 many places on the web outside of our control.
 
 Why can't we just write a script that creates new numbers as needed,
 such as msg00163.1.php and msg00163.2.php? As far as I can tell, there
 is nothing magical about the naming schema itself that would cause
 such URLs to break anything.

Agreed.  It is nice to have the emails numbered in arrival order, but
changes to old URLs are worse.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Bruce Momjian
Tom Lane wrote:
 Michael Fuhr [EMAIL PROTECTED] writes:
  On Mon, Jul 17, 2006 at 12:25:09AM -0500, Jaime Casanova wrote:
  i found this on the Monitoring section:
  o Allow protocol-level BIND parameter values to be logged
  http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
  
  But i don't understand why that thread is related to the TODO item,
  i'm missing something?
 
  Possibly the message renumbering that Tom griped about:
  http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php
 
 Yeah.  I think the TODO item is intended to point to what is now
 http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
 or one of the earlier messages in that thread.
 
 Perhaps when Bruce realizes he needs to recheck every link in the
 TODO files, he'll get on the warpath with me ;-)

(Sorry, just catching up on this issue.)

Yes, I can fix the TODO item URLs, but many email messages reference
URLs themselves:

http://archives.postgresql.org/pgsql-patches/2006-06/msg00096.php

The URL in the email actually works, but I am sure others do not. 
Because we don't have control over the email contents (think Google), I
don't think we can renumber old email items without a continual stream
of complaints from users.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Tatsuo Ishii
 Tom Lane wrote:
  Michael Fuhr [EMAIL PROTECTED] writes:
   On Mon, Jul 17, 2006 at 12:25:09AM -0500, Jaime Casanova wrote:
   i found this on the Monitoring section:
   o Allow protocol-level BIND parameter values to be logged
   http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
   
   But i don't understand why that thread is related to the TODO item,
   i'm missing something?
  
   Possibly the message renumbering that Tom griped about:
   http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php
  
  Yeah.  I think the TODO item is intended to point to what is now
  http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
  or one of the earlier messages in that thread.
  
  Perhaps when Bruce realizes he needs to recheck every link in the
  TODO files, he'll get on the warpath with me ;-)
 
 (Sorry, just catching up on this issue.)
 
 Yes, I can fix the TODO item URLs, but many email messages reference
 URLs themselves:
 
   http://archives.postgresql.org/pgsql-patches/2006-06/msg00096.php
 
 The URL in the email actually works, but I am sure others do not. 
 Because we don't have control over the email contents (think Google), I
 don't think we can renumber old email items without a continual stream
 of complaints from users.

I always wonder why we don't add a unique id to each email message
itself.  I mean let the mail list program to add sequencial number to
each email's subject. For example, emails pgsql-jp ML (PostgreSQL general
discussion in Japanese managed by JPUG) have subject headers like
this:

[pgsql-jp: 34814] pgpool 2.5 released

By using this method our TODO list can referer emais logical id
(34814 in this case) which is independent on archive URL.
Archive URL is something like a phisical id and maybe changed
accidentaly and is not convenitent for this kind of usage IMO.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Marc G. Fournier

On Tue, 18 Jul 2006, Bruce Momjian wrote:


Greg Sabino Mullane wrote:
[ There is text before PGP section. ]


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1



http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php


Yeah.  I think the TODO item is intended to point to what is now
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
or one of the earlier messages in that thread.


This is a very ugly problem. Note that there are also URLs that cannot
be changed, such as older messages that point to archive posts, and
many places on the web outside of our control.

Why can't we just write a script that creates new numbers as needed,
such as msg00163.1.php and msg00163.2.php? As far as I can tell, there
is nothing magical about the naming schema itself that would cause
such URLs to break anything.


Agreed.  It is nice to have the emails numbered in arrival order, but
changes to old URLs are worse.


'k, so is the concensus here that I regenerate everything with the 'broken 
msg seperator', and then revert to the unbroken one for new stuff?  its no 
sweat, I just fear this is going to re-crop up sometime in the future if 
we ever have to regenerate from the mbox files, as well have some in 
'broken format' and some in the 'unbroken', but renumbering *then* will 
still affect everything ...


Basically, we're just differing the headaches to a later date when we have 
no choice :(



Marc G. Fournier   Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED]  MSN . [EMAIL PROTECTED]
Yahoo . yscrappy   Skype: hub.orgICQ . 7615664

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Tom Lane
Tatsuo Ishii [EMAIL PROTECTED] writes:
 Because we don't have control over the email contents (think Google), I
 don't think we can renumber old email items without a continual stream
 of complaints from users.

 I always wonder why we don't add a unique id to each email message
 itself.

But that doesn't do anything to fix the immediate problem ...

regards, tom lane

---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] url for TODO item, is it right?

2006-07-18 Thread Alvaro Herrera
Marc G. Fournier wrote:

 'k, so is the concensus here that I regenerate everything with the 'broken 
 msg seperator', and then revert to the unbroken one for new stuff?  its no 
 sweat, I just fear this is going to re-crop up sometime in the future if 
 we ever have to regenerate from the mbox files, as well have some in 
 'broken format' and some in the 'unbroken', but renumbering *then* will 
 still affect everything ...

One idea is to keep the old archives using the broken separator, and
regenerate the good archives in some other directory, or with a
different prefix (say, instead of msg0234.php have it be named
mesg0234.php or msg0234.1.php, etc).  That way the old URLs would
continue to work, and there wouldn't be a problem if the archives need
to be regenerated in the future.

OTOH it would be good to have a collection of messages by Message-Id
which could be used as a permalink.  For example

http://archives.postgresql.org/by-id/[EMAIL PROTECTED]

or something like that.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [HACKERS] url for TODO item, is it right?

2006-07-17 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] writes:
 On Mon, Jul 17, 2006 at 12:25:09AM -0500, Jaime Casanova wrote:
 i found this on the Monitoring section:
 o Allow protocol-level BIND parameter values to be logged
 http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
 
 But i don't understand why that thread is related to the TODO item,
 i'm missing something?

 Possibly the message renumbering that Tom griped about:
 http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php

Yeah.  I think the TODO item is intended to point to what is now
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
or one of the earlier messages in that thread.

Perhaps when Bruce realizes he needs to recheck every link in the
TODO files, he'll get on the warpath with me ;-)

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


Re: [HACKERS] url for TODO item, is it right?

2006-07-17 Thread Greg Sabino Mullane

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1


 http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php

 Yeah.  I think the TODO item is intended to point to what is now
 http://archives.postgresql.org/pgsql-hackers/2006-02/msg00163.php
 or one of the earlier messages in that thread.

This is a very ugly problem. Note that there are also URLs that cannot
be changed, such as older messages that point to archive posts, and
many places on the web outside of our control.

Why can't we just write a script that creates new numbers as needed,
such as msg00163.1.php and msg00163.2.php? As far as I can tell, there
is nothing magical about the naming schema itself that would cause
such URLs to break anything.

- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200607170743
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-BEGIN PGP SIGNATURE-

iD8DBQFEu3iovJuQZxSWSsgRAqafAKD51/vpiZnDkHyCQ2TrPkPEXPUQbwCfVRux
5Rw14QzglcYed2A54IGtKrc=
=hz49
-END PGP SIGNATURE-



---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


[HACKERS] url for TODO item, is it right?

2006-07-16 Thread Jaime Casanova

Sorry, i'm resending because i forgot the subject

On 7/17/06, Jaime Casanova [EMAIL PROTECTED] wrote:

Hi,

when searching the TODO list (http://www.postgresql.org/docs/faqs.TODO.html).

i found this on the Monitoring section:

o Allow protocol-level BIND parameter values to be logged
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php

But i don't understand why that thread is related to the TODO item,
i'm missing something?

--
Atentamente,
Jaime Casanova

Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning.
  Richard Cook




--
Atentamente,
Jaime Casanova

Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning.
  Richard Cook

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [HACKERS] url for TODO item, is it right?

2006-07-16 Thread Michael Fuhr
On Mon, Jul 17, 2006 at 12:25:09AM -0500, Jaime Casanova wrote:
 when searching the TODO list 
 (http://www.postgresql.org/docs/faqs.TODO.html).
 
 i found this on the Monitoring section:
 
 o Allow protocol-level BIND parameter values to be logged
 http://archives.postgresql.org/pgsql-hackers/2006-02/msg00165.php
 
 But i don't understand why that thread is related to the TODO item,
 i'm missing something?

Possibly the message renumbering that Tom griped about:

http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php

-- 
Michael Fuhr

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings