Thread: An actually *useful* mail-list message footer

An actually *useful* mail-list message footer

From
Tom Lane
Date:
I present for your consideration an example of what Apple is appending to
lists.apple.com traffic these days:
 _______________________________________________Do not post admin requests to the list. They will be ignored.X11-users
mailinglist      (X11-users@lists.apple.com)Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/x11-users/tgl%40sss.pgh.pa.usThisemail sent to tgl@sss.pgh.pa.us
 

(This is in addition to List-Unsubscribe and the other standard headers.)

I don't know whether the mail software we use can cope with customizing
trailers per-user like this.  But if it can, I submit that an
unmistakable how-to-unsubscribe link would be lots more useful than the
TIPS are.
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 01 Mar 2008 15:20:23 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I don't know whether the mail software we use can cope with
> customizing trailers per-user like this.  But if it can, I submit
> that an unmistakable how-to-unsubscribe link would be lots more
> useful than the TIPS are.

+1

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHycTxATb/zqfZUUQRAjFjAJ98pWd7PnC1jjZV3/RPSeB51FiU2wCeIZE7
cQodvqlc5ybrRRTAjCMa6xM=
=4VTL
-----END PGP SIGNATURE-----

Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Done, almost ... can't do it "per user", since Majordomo sends out messasges in 
batches, not one per individual user, *unless* delivery has failed at which 
point it starts sending out individual messages for that particular user so 
that it can count 'bounces' ...

But, I have it showing hte same URL we have on the archives itself ...

In theory, it should show up on this message as such ...

- --On Saturday, March 01, 2008 15:20:23 -0500 Tom Lane <tgl@sss.pgh.pa.us>
wrote:

> I present for your consideration an example of what Apple is appending to
> lists.apple.com traffic these days:
>
>      _______________________________________________
>     Do not post admin requests to the list. They will be ignored.
>     X11-users mailing list      (X11-users@lists.apple.com)
>     Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/x11-users/tgl%40sss.pgh.pa.us     
>     This email sent to tgl@sss.pgh.pa.us
>
> (This is in addition to List-Unsubscribe and the other standard headers.)
>
> I don't know whether the mail software we use can cope with customizing
> trailers per-user like this.  But if it can, I submit that an
> unmistakable how-to-unsubscribe link would be lots more useful than the
> TIPS are.
>
>             regards, tom lane
>
> ---------------------------(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



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHyh9D4QvfyHIvDvMRAjl8AKCzW2yougOFxksbzL17vt/fifQPAQCfW0jx
WYe3XLityPef0lcYuMhRbHQ=
=vGQw
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Marc G. Fournier wrote:

> Done, almost ... can't do it "per user", since Majordomo sends out messasges in 
> batches, not one per individual user, *unless* delivery has failed at which 
> point it starts sending out individual messages for that particular user so 
> that it can count 'bounces' ...

Can we have the TIP start with "-- " on a line by itself?  That would
help email clients to mark it as a signature.

I tried on pgsql-es-ayuda, but I noticed that it removed the trailing
blank, which is significant :-(

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Example of what you mean?


- --On Sunday, March 02, 2008 01:58:34 -0300 Alvaro Herrera 
<alvherre@commandprompt.com> wrote:

> Marc G. Fournier wrote:
>
>> Done, almost ... can't do it "per user", since Majordomo sends out messasges
>> in  batches, not one per individual user, *unless* delivery has failed at
>> which  point it starts sending out individual messages for that particular
>> user so  that it can count 'bounces' ...
>
> Can we have the TIP start with "-- " on a line by itself?  That would
> help email clients to mark it as a signature.
>
> I tried on pgsql-es-ayuda, but I noticed that it removed the trailing
> blank, which is significant :-(
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHyjdS4QvfyHIvDvMRAiSBAJ46zovPu1dfSbz/q0Q8/oM+4A3FpACgiPP7
ojW5Uv+TfraYyOTuZCwkgwM=
=E/7j
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Tom Lane
Date:
"Marc G. Fournier" <scrappy@hub.org> writes:
> Example of what you mean?

I think Alvaro's point is that the traditional standard divider line for
signature-like stuff is "-- ".  Two dashes, one space, not more nor
less.  Right now we're using
"---------------------------(end of broadcast)---------------------------"
You can be sure there is no software anywhere in the world that
recognizes that as a divider line.
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hrmmm, I think there is a limitation on the footer, but ... try his one ...

- --On Sunday, March 02, 2008 00:25:12 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Marc G. Fournier" <scrappy@hub.org> writes:
>> Example of what you mean?
>
> I think Alvaro's point is that the traditional standard divider line for
> signature-like stuff is "-- ".  Two dashes, one space, not more nor
> less.  Right now we're using
> "---------------------------(end of broadcast)---------------------------"
> You can be sure there is no software anywhere in the world that
> recognizes that as a divider line.
>
>             regards, tom lane



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHyj/D4QvfyHIvDvMRAp5bAKDoSYPuDx19M2/9Of1smk/ZXcptoQCePI7a
20fDKxOvXYaUXzqflzP23Hk=
=giNm
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Tom Lane
Date:
"Marc G. Fournier" <scrappy@hub.org> writes:
> Hrmmm, I think there is a limitation on the footer, but ... try his one ...

I got one dash and no space ...
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


this may not be possible, but if "-- " generates just one dash,let's try "--- " 
and see if that makes a difference ...

- --On Sunday, March 02, 2008 00:57:02 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Marc G. Fournier" <scrappy@hub.org> writes:
>> Hrmmm, I think there is a limitation on the footer, but ... try his one ...
>
> I got one dash and no space ...
>
>             regards, tom lane



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHykPY4QvfyHIvDvMRArS6AKCOYWAnrjeTNaHM1t4MBRZLzV68oQCeMHHq
vgqzOU99t3CR1PNEwD3hcpQ=
=G67/
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Tom Lane
Date:
"Marc G. Fournier" <scrappy@hub.org> writes:
> this may not be possible, but if "-- " generates just one dash,let's try "--- " 
> and see if that makes a difference ...

Hm, two dashes and no space ... better, certainly, but not perfect.
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


'k, can't seem to do anything about the space at the end ... its stripping 
those off in the code itself

- --On Sunday, March 02, 2008 02:06:16 -0400 "Marc G. Fournier"
<scrappy@hub.org> 
wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> this may not be possible, but if "-- " generates just one dash,let's try "---
> "  and see if that makes a difference ...
>
> - --On Sunday, March 02, 2008 00:57:02 -0500 Tom Lane <tgl@sss.pgh.pa.us>
> wrote:
>
>> "Marc G. Fournier" <scrappy@hub.org> writes:
>>> Hrmmm, I think there is a limitation on the footer, but ... try his one ...
>>
>> I got one dash and no space ...
>>
>>             regards, tom lane
>
>
>
> - ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email . scrappy@hub.org                              MSN . scrappy@hub.org
> Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.4 (FreeBSD)
>
> iD8DBQFHykPY4QvfyHIvDvMRArS6AKCOYWAnrjeTNaHM1t4MBRZLzV68oQCeMHHq
> vgqzOU99t3CR1PNEwD3hcpQ=
> =G67/
> -----END PGP SIGNATURE-----
>
>
> --
> Do not post admin requests to the list. They will be ignored.
> pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
>
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHykar4QvfyHIvDvMRAvKsAKDkNnaVbLq8qLJlhLiU1JVeh8B+nQCg36sT
WgAfjQuZL8wbRnYSHz8D9c0=
=PdOR
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
NotDashEscaped: You need GnuPG to verify this message



> ---------------------------(end of broadcast)---------------------------
> Do not post admin requests to the list. They will be ignored.
> pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
>  http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www

The first line is, in my opinion, both obscure and rude. I doubt most
ordinary readers of our mailing list know exactly what an "admin request" is.
They may even think it has something to do with admin-ing Postgres itself.
It certainly will sound odd on the pgsql-admin list. :)

The link provided should be shorter: a http redirect would do that quite
nicely. Additionally, the above link does not work, and only brings you to
a generic page for all mailing lists at postgresql.org. Perhaps this one?:

http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general

If we are replacing the sig, I'd recommend something like this:

--
Sent from the pgsql-general@postgresql.org mailing list.
To unsubscribe or change your settings, please visit
http://postgresql.org/lists/pgsql-general
or email majordomo-owner@postgresql.org




--
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200803020926
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkfKud4ACgkQvJuQZxSWSshyJgCbB7OnCeHoDlLF0dfq4P4pIeT6
YFIAoN2oTGJFxvk2GqYL0OA06xFiEnMi
=mOUn
-----END PGP SIGNATURE-----




Re: An actually *useful* mail-list message footer

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

From: "Joshua D. Drake" <jd@commandprompt.com>

>> If we are replacing the sig, I'd recommend something like this:
>>
>> --
>> Sent from the pgsql-general@postgresql.org mailing list.
>> To unsubscribe or change your settings, please visit
>> http://postgresql.org/lists/pgsql-general
>> or email majordomo-owner@postgresql.org


> I would remove the comment about majordomo-owner as a whole. Email
> the address what?

Unsubscribe requests, problems, etc. Unless we are now at the point
where we are comfortable assuming that everyone has web access.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200803021032
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkfKyJYACgkQvJuQZxSWSsiX6QCeK0lrCU02xubHV0JfSYSZWuQw
2GgAn3sR72GyhS+4lQzRYxkXeIOAgis+
=Ee1e
-----END PGP SIGNATURE-----




Re: An actually *useful* mail-list message footer

From
"Joshua D. Drake"
Date:
On Sun,  2 Mar 2008 14:30:49 -0000
"Greg Sabino Mullane" <greg@turnstep.com> wrote:

> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general
>
> If we are replacing the sig, I'd recommend something like this:
>
> --
> Sent from the pgsql-general@postgresql.org mailing list.
> To unsubscribe or change your settings, please visit
> http://postgresql.org/lists/pgsql-general
> or email majordomo-owner@postgresql.org
>

I would remove the comment about majordomo-owner as a whole. Email the
address what?

Joshua D. Drake



--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit


Re: An actually *useful* mail-list message footer

From
Tom Lane
Date:
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> From: "Joshua D. Drake" <jd@commandprompt.com>
>> I would remove the comment about majordomo-owner as a whole. Email
>> the address what?

+1

> Unsubscribe requests, problems, etc. Unless we are now at the point
> where we are comfortable assuming that everyone has web access.

The List-foo headers already provide that info for anyone who's truly
web-disabled.  I agree with JD that that's got to be a tiny minority.

I would go with something like this:

--
Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
Help/Unsubscribe/Update your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www

BTW, I don't find that there's anything wrong with that link, whereas
the one suggested by Greg gives me a 404.
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Change made as written below ...

- --On Sunday, March 02, 2008 11:20:50 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Greg Sabino Mullane" <greg@turnstep.com> writes:
>> From: "Joshua D. Drake" <jd@commandprompt.com>
>>> I would remove the comment about majordomo-owner as a whole. Email
>>> the address what?
>
> +1
>
>> Unsubscribe requests, problems, etc. Unless we are now at the point
>> where we are comfortable assuming that everyone has web access.
>
> The List-foo headers already provide that info for anyone who's truly
> web-disabled.  I agree with JD that that's got to be a tiny minority.
>
> I would go with something like this:
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
>
> BTW, I don't find that there's anything wrong with that link, whereas
> the one suggested by Greg gives me a 404.
>
>             regards, tom lane
>
> --
> Do not post admin requests to the list. They will be ignored.
> pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
>
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHytvn4QvfyHIvDvMRAg6uAJ9Ax56owbLKArzZCYmP2yumq71iQACg3UCE
bZVT7imydN5lOB9KTO3Puho=
=/z8N
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 02 Mar 2008 11:20:50 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
> 
> BTW, I don't find that there's anything wrong with that link, whereas
> the one suggested by Greg gives me a 404.

This is the actual link (if we are going to use the main site):

http://www.postgresql.org/community/lists/subscribe

Sincerely,

Joshua D. Drake

- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHyzWRATb/zqfZUUQRAo0XAKCTRIQCiONqYIxRNTsH81bpsv7UgACfQ3Nc
SFBL2YwGs9F7vZdZ9pLZiOQ=
=qaf+
-----END PGP SIGNATURE-----

Re: An actually *useful* mail-list message footer

From
"Dave Page"
Date:
And this time for the list :-)

I'm not sure about 'subscribe' but 'unsubscribe' in a message causes
it to be held for moderation. We should check (and stop) that if
adding 'subscribe' to the footers, otherwise we'll have to start
moderating replies!


On 3/2/08, Joshua D. Drake <jd@commandprompt.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Sun, 02 Mar 2008 11:20:50 -0500
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> > --
> > Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> > Help/Unsubscribe/Update your Subscription:
> >
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
> >
> > BTW, I don't find that there's anything wrong with that link, whereas
> > the one suggested by Greg gives me a 404.
>
> This is the actual link (if we are going to use the main site):
>
> http://www.postgresql.org/community/lists/subscribe
>
> Sincerely,
>
> Joshua D. Drake
>
> - --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFHyzWRATb/zqfZUUQRAo0XAKCTRIQCiONqYIxRNTsH81bpsv7UgACfQ3Nc
> SFBL2YwGs9F7vZdZ9pLZiOQ=
> =qaf+
> -----END PGP SIGNATURE-----
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
>


-- 
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Good catch ... changed to "To make canges to your Subscription", which 
shouldn't catch anything, I don't believe ... this is the current list that we 
trap based on:

configset GLOBAL admin_body <<ENDAAB
/^accept$/i
/^reject$/i
/\badd me\b/i
/\bdelete me\b/i
/\bremove\s+me\b/i
/\bchange\b.*\baddress\b/
/\bsignoff\b/i
/\bsubscribe\b/i
/^sub\b/i
/\bunsubscribe\b/i
/^unsub\b/i
/^\s*help\s*$/i
/^\s*info\s*$/i
/^\s*info\s+\S+\s*$/i
/^\s*lists\s*$/i
/^\s*which\s*$/i
/^\s*which\s+\S+\s*$/i
/^\s*index\s*$/i
/^\s*index\s+\S+\s*$/i
/^\s*who\s*$/i
/^\s*who\s+\S+\s*$/i
/^\s*get\s+\S+\s*$/i
/^\s*get\s+\S+\s+\S+\s*$/i
/^\s*approve\b/i
/^\s*passwd\b/i
/^\s*newinfo\b/i
/^\s*newconfig\b/i
/^\s*writeconfig\b/i
/^\s*mkdigest\b/i
ENDAAB


- --On Sunday, March 02, 2008 23:34:48 +0000 Dave Page <dpage@pgadmin.org> wrote:

> And this time for the list :-)
>
> I'm not sure about 'subscribe' but 'unsubscribe' in a message causes
> it to be held for moderation. We should check (and stop) that if
> adding 'subscribe' to the footers, otherwise we'll have to start
> moderating replies!
>
>
> On 3/2/08, Joshua D. Drake <jd@commandprompt.com> wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> On Sun, 02 Mar 2008 11:20:50 -0500
>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> > --
>> > Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
>> > Help/Unsubscribe/Update your Subscription:
>> >
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
>> >
>> > BTW, I don't find that there's anything wrong with that link, whereas
>> > the one suggested by Greg gives me a 404.
>>
>> This is the actual link (if we are going to use the main site):
>>
>> http://www.postgresql.org/community/lists/subscribe
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>> - --
>> The PostgreSQL Company since 1997: http://www.commandprompt.com/
>> PostgreSQL Community Conference: http://www.postgresqlconference.org/
>> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>> PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit
>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (GNU/Linux)
>>
>> iD8DBQFHyzWRATb/zqfZUUQRAo0XAKCTRIQCiONqYIxRNTsH81bpsv7UgACfQ3Nc
>> SFBL2YwGs9F7vZdZ9pLZiOQ=
>> =qaf+
>> -----END PGP SIGNATURE-----
>>
>> --
>> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
>> Help/Unsubscribe/Update your Subscription:
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
>>
>
>
> --
> Dave Page
> EnterpriseDB UK Ltd: http://www.enterprisedb.com
> PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHyz/p4QvfyHIvDvMRAkDfAKC1jKWlBChGrULelBaTg4RONLC6cQCdHMAJ
M+x0T0QjD2tCtUBaAO7bulk=
=m9ug
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Tom Lane wrote:

> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> Help/Unsubscribe/Update your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
> 
> BTW, I don't find that there's anything wrong with that link, whereas
> the one suggested by Greg gives me a 404.

The bit that's wrong about this URL is that it's not specific to the
pgsql-www list -- it's a general form for all lists; the "extra=foo"
stuff is being ignored.  I don't understand why you got a 404 for Greg's
URL.  Are you sure you didn't mis-paste it?  I tried on a private web
session to make sure there are no cookies or open sessions, at it works
well for me.  It can also be made shorter easily (because we don't use
the virtual domain stuff):

http://mail.postgresql.org/mj/mj_wwwusr/?func=lists-long-full&extra=pgsql-www

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Magnus Hagander wrote:

> > http://mail.postgresql.org/mj/mj_wwwusr/?func=lists-long-full&extra=pgsql-www
> 
> At the risk of giving myself more work ;-), perhaps we should refer to some
> place on our main website that just does a redirect? That'll at least look
> prettier for the user. Something like
> http://wwwmaster.postgresql.org/unsub?pgsql-www or like that? Hmm. Maybe
> it's not all that much nicer looking...

Well, if you can make it so that 

http://wwwmaster.postgresql.org/unsubscribe/pgsql-www 

redirects to the URL above, it does seem a lot better.

Perhaps rather than "unsubscribe" we should use something like
"list-settings" etc, because the page does some more stuff than just
unsub.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Mon, Mar 03, 2008 at 11:42:02AM -0300, Alvaro Herrera wrote:
> Tom Lane wrote:
> 
> > Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> > Help/Unsubscribe/Update your Subscription:
> > http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www
> > 
> > BTW, I don't find that there's anything wrong with that link, whereas
> > the one suggested by Greg gives me a 404.
> 
> The bit that's wrong about this URL is that it's not specific to the
> pgsql-www list -- it's a general form for all lists; the "extra=foo"
> stuff is being ignored.  I don't understand why you got a 404 for Greg's
> URL.  Are you sure you didn't mis-paste it?  I tried on a private web
> session to make sure there are no cookies or open sessions, at it works
> well for me.  It can also be made shorter easily (because we don't use
> the virtual domain stuff):
> 
> http://mail.postgresql.org/mj/mj_wwwusr/?func=lists-long-full&extra=pgsql-www

At the risk of giving myself more work ;-), perhaps we should refer to some
place on our main website that just does a redirect? That'll at least look
prettier for the user. Something like
http://wwwmaster.postgresql.org/unsub?pgsql-www or like that? Hmm. Maybe
it's not all that much nicer looking...

//Magnus


Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Mon, Mar 03, 2008 at 12:27:20PM -0300, Alvaro Herrera wrote:
> Magnus Hagander wrote:
> 
> > > http://mail.postgresql.org/mj/mj_wwwusr/?func=lists-long-full&extra=pgsql-www
> > 
> > At the risk of giving myself more work ;-), perhaps we should refer to some
> > place on our main website that just does a redirect? That'll at least look
> > prettier for the user. Something like
> > http://wwwmaster.postgresql.org/unsub?pgsql-www or like that? Hmm. Maybe
> > it's not all that much nicer looking...
> 
> Well, if you can make it so that 
> 
> http://wwwmaster.postgresql.org/unsubscribe/pgsql-www 
> 
> redirects to the URL above, it does seem a lot better.
> 
> Perhaps rather than "unsubscribe" we should use something like
> "list-settings" etc, because the page does some more stuff than just
> unsub.

That should be doable with a .htaccess rule for mod_rewrite, so it's then
trivial. 

But even if you can't do it with mod_rewrite, we could do it with some
custom PHP, with a bit more work.

So - absolutely doable, once we decide where we want it to go.

//Magnus


Re: An actually *useful* mail-list message footer

From
Tom Lane
Date:
Magnus Hagander <magnus@hagander.net> writes:
> So - absolutely doable, once we decide where we want it to go.

+1 for a more readable link.  I don't much care what it is exactly,
but would suggest not exposing "wwwmaster" or anything that is part
of the website's internal infrastructure.
        regards, tom lane


Re: An actually *useful* mail-list message footer

From
Bruce Momjian
Date:
Magnus Hagander wrote:
> > The bit that's wrong about this URL is that it's not specific to the
> > pgsql-www list -- it's a general form for all lists; the "extra=foo"
> > stuff is being ignored.  I don't understand why you got a 404 for Greg's
> > URL.  Are you sure you didn't mis-paste it?  I tried on a private web
> > session to make sure there are no cookies or open sessions, at it works
> > well for me.  It can also be made shorter easily (because we don't use
> > the virtual domain stuff):
> > 
> > http://mail.postgresql.org/mj/mj_wwwusr/?func=lists-long-full&extra=pgsql-www
> 
> At the risk of giving myself more work ;-), perhaps we should refer to some
> place on our main website that just does a redirect? That'll at least look
> prettier for the user. Something like
> http://wwwmaster.postgresql.org/unsub?pgsql-www or like that? Hmm. Maybe
> it's not all that much nicer looking...

I have now realized the Postgres FAQ was lacking in providing
unsubscribe information, and in not promoting the use of eliminatecc and
selfcopy for people who want it.  I have added a new FAQ item:
1.15) How do I unsubscribe from the PostgreSQL email lists? How do Iavoid receiving duplicate emails?The PostgreSQL
Majordomo<URL> page allows subscribing orunsubscribing from any of the PostgreSQL email lists. (You mightneed to have
yourMajordomo password emailed to you to log in.)All PostgreSQL email lists are configured so a group reply goes to
theemaillist and the original email author. This is done so users receivethe quickest possible email replies. If you
wouldprefer not to receiveduplicate email from the list in cases where you already receive anemail directly, check
eliminateccfrom the Majordomo Change Settingspage. You can also prevent yourself from receiving copies of emails
youpostto the lists by unchecking selfcopy.
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


Re: An actually *useful* mail-list message footer

From
Peter Eisentraut
Date:
Am Montag, 3. März 2008 schrieb Marc G. Fournier:
> Good catch ... changed to "To make canges to your Subscription", which

"Subscription" should not be capitalized.


Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Bruce Momjian wrote:

> I have now realized the Postgres FAQ was lacking in providing
> unsubscribe information, and in not promoting the use of eliminatecc and
> selfcopy for people who want it.  I have added a new FAQ item:

May I suggest splitting it into two questions?  There doesn't seem to be
much point in keeping them together.


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


Re: An actually *useful* mail-list message footer

From
Bruce Momjian
Date:
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> 
> > I have now realized the Postgres FAQ was lacking in providing
> > unsubscribe information, and in not promoting the use of eliminatecc and
> > selfcopy for people who want it.  I have added a new FAQ item:
> 
> May I suggest splitting it into two questions?  There doesn't seem to be
> much point in keeping them together.

Uh, I can but the fact is I need to give them information about how to
log into that page for both items.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> writes:
> > So - absolutely doable, once we decide where we want it to go.
> 
> +1 for a more readable link.  I don't much care what it is exactly,
> but would suggest not exposing "wwwmaster" or anything that is part
> of the website's internal infrastructure.

*nudge*

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
> Tom Lane wrote:
> > Magnus Hagander <magnus@hagander.net> writes:
> > > So - absolutely doable, once we decide where we want it to go.
> > 
> > +1 for a more readable link.  I don't much care what it is exactly,
> > but would suggest not exposing "wwwmaster" or anything that is part
> > of the website's internal infrastructure.
> 
> *nudge*

Was there ever agreement on what page it should point to?

//Magnus


Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Magnus Hagander wrote:
> On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
> > Tom Lane wrote:
> > > Magnus Hagander <magnus@hagander.net> writes:
> > > > So - absolutely doable, once we decide where we want it to go.
> > > 
> > > +1 for a more readable link.  I don't much care what it is exactly,
> > > but would suggest not exposing "wwwmaster" or anything that is part
> > > of the website's internal infrastructure.
> > 
> > *nudge*
> 
> Was there ever agreement on what page it should point to?

The link Greg provided seems to be the best candidate:

http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Tue, Mar 04, 2008 at 12:13:04PM -0300, Alvaro Herrera wrote:
> Magnus Hagander wrote:
> > On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
> > > Tom Lane wrote:
> > > > Magnus Hagander <magnus@hagander.net> writes:
> > > > > So - absolutely doable, once we decide where we want it to go.
> > > > 
> > > > +1 for a more readable link.  I don't much care what it is exactly,
> > > > but would suggest not exposing "wwwmaster" or anything that is part
> > > > of the website's internal infrastructure.
> > > 
> > > *nudge*
> > 
> > Was there ever agreement on what page it should point to?
> 
> The link Greg provided seems to be the best candidate:
> 
> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general

Ok, I have a .htaccess rule that does this. Since we're sending it to a
preferences page, it seems reasonable to name it mailpref (or so) instead
of unsub.

So http://www.postgresql.org/mailpref/pgsql-www
seems reasonable?

You can test it out at
http://magnus-static.pgadmin.org/mailpref/pgsql-www

(by all means, try out other lists)


Good enough to commit?

//Magnus


Re: An actually *useful* mail-list message footer

From
Alvaro Herrera
Date:
Magnus Hagander wrote:

> Ok, I have a .htaccess rule that does this. Since we're sending it to a
> preferences page, it seems reasonable to name it mailpref (or so) instead
> of unsub.

Thanks.

> So http://www.postgresql.org/mailpref/pgsql-www
> seems reasonable?

Yeah.

> You can test it out at
> http://magnus-static.pgadmin.org/mailpref/pgsql-www
> 
> (by all means, try out other lists)

It doesn't seem to work for "change_the_name".  All other lists seem to
work.  (Yes, that's a valid list.  Yes, it's a stupid name.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Tue, Mar 04, 2008 at 12:41:36PM -0300, Alvaro Herrera wrote:
> Magnus Hagander wrote:
> 
> > Ok, I have a .htaccess rule that does this. Since we're sending it to a
> > preferences page, it seems reasonable to name it mailpref (or so) instead
> > of unsub.
> 
> Thanks.
> 
> > So http://www.postgresql.org/mailpref/pgsql-www
> > seems reasonable?
> 
> Yeah.
> 
> > You can test it out at
> > http://magnus-static.pgadmin.org/mailpref/pgsql-www
> > 
> > (by all means, try out other lists)
> 
> It doesn't seem to work for "change_the_name".  All other lists seem to
> work.  (Yes, that's a valid list.  Yes, it's a stupid name.)

Yeah, underscore wasn't in the allowed chars in the regexp. And yes, it
should've been change-the-name to be consistent with our other lists.
Is the list alive at all, or should it be deleted?

Either way, I've added underscore, and it works now. Any objections, or
shuld I commit?

//Magnus


Re: An actually *useful* mail-list message footer

From
"Dave Page"
Date:
On Tue, Mar 4, 2008 at 3:44 PM, Magnus Hagander <magnus@hagander.net> wrote:

>  Yeah, underscore wasn't in the allowed chars in the regexp. And yes, it
>  should've been change-the-name to be consistent with our other lists.
>  Is the list alive at all, or should it be deleted?

As far as I'm concerned, it should be removed. It was a knee-jerk
reaction to a problem that was eventually solved in a more appropriate
way (eventually being the major problem I'll admit).

-- 
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk


Re: An actually *useful* mail-list message footer

From
Bruce Momjian
Date:
Dave Page wrote:
> On Tue, Mar 4, 2008 at 3:44 PM, Magnus Hagander <magnus@hagander.net> wrote:
> 
> >  Yeah, underscore wasn't in the allowed chars in the regexp. And yes, it
> >  should've been change-the-name to be consistent with our other lists.
> >  Is the list alive at all, or should it be deleted?
> 
> As far as I'm concerned, it should be removed. It was a knee-jerk
> reaction to a problem that was eventually solved in a more appropriate
> way (eventually being the major problem I'll admit).

Agreed.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I thought the idea was to make a shorter URL that would then do a redirect to 
that URL ... ?

- --On Tuesday, March 04, 2008 12:13:04 -0300 Alvaro Herrera 
<alvherre@commandprompt.com> wrote:

> Magnus Hagander wrote:
>> On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
>> > Tom Lane wrote:
>> > > Magnus Hagander <magnus@hagander.net> writes:
>> > > > So - absolutely doable, once we decide where we want it to go.
>> > >
>> > > +1 for a more readable link.  I don't much care what it is exactly,
>> > > but would suggest not exposing "wwwmaster" or anything that is part
>> > > of the website's internal infrastructure.
>> >
>> > *nudge*
>>
>> Was there ever agreement on what page it should point to?
>
> The link Greg provided seems to be the best candidate:
>
> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long
> -full&extra=pgsql-general
>
> --
> Alvaro Herrera                                http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> To make changes to your Subscription:
> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-www



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHzg3a4QvfyHIvDvMRAi3rAKDEf+W0KsCIY8sLm5vpPDs8nZIdnQCgsSB1
oY9yWiKtT/rBmS4HmBU1vgw=
=crJM
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
"Marc G. Fournier"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- --On Tuesday, March 04, 2008 16:35:21 +0100 Magnus Hagander 
<magnus@hagander.net> wrote:

> On Tue, Mar 04, 2008 at 12:13:04PM -0300, Alvaro Herrera wrote:
>> Magnus Hagander wrote:
>> > On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
>> > > Tom Lane wrote:
>> > > > Magnus Hagander <magnus@hagander.net> writes:
>> > > > > So - absolutely doable, once we decide where we want it to go.
>> > > >
>> > > > +1 for a more readable link.  I don't much care what it is exactly,
>> > > > but would suggest not exposing "wwwmaster" or anything that is part
>> > > > of the website's internal infrastructure.
>> > >
>> > > *nudge*
>> >
>> > Was there ever agreement on what page it should point to?
>>
>> The link Greg provided seems to be the best candidate:
>>
>> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-lon
>> g-full&extra=pgsql-general
>
> Ok, I have a .htaccess rule that does this. Since we're sending it to a
> preferences page, it seems reasonable to name it mailpref (or so) instead
> of unsub.
>
> So http://www.postgresql.org/mailpref/pgsql-www
> seems reasonable?

I like it ... let me know when to make the change on the majordomo side ...

- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org                              MSN . scrappy@hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4 (FreeBSD)

iD8DBQFHzg4T4QvfyHIvDvMRApcsAKDQI3RNK8dFrhnpA/9o2gqSxu3/MwCg6s4X
5xNphVfw4k866zNVkqTVZwM=
=Qrsr
-----END PGP SIGNATURE-----



Re: An actually *useful* mail-list message footer

From
Magnus Hagander
Date:
On Tue, Mar 04, 2008 at 11:05:55PM -0400, Marc G. Fournier wrote:
> - --On Tuesday, March 04, 2008 16:35:21 +0100 Magnus Hagander 
> <magnus@hagander.net> wrote:
> 
> > On Tue, Mar 04, 2008 at 12:13:04PM -0300, Alvaro Herrera wrote:
> >> Magnus Hagander wrote:
> >> > On Tue, Mar 04, 2008 at 11:16:08AM -0300, Alvaro Herrera wrote:
> >> > > Tom Lane wrote:
> >> > > > Magnus Hagander <magnus@hagander.net> writes:
> >> > > > > So - absolutely doable, once we decide where we want it to go.
> >> > > >
> >> > > > +1 for a more readable link.  I don't much care what it is exactly,
> >> > > > but would suggest not exposing "wwwmaster" or anything that is part
> >> > > > of the website's internal infrastructure.
> >> > >
> >> > > *nudge*
> >> >
> >> > Was there ever agreement on what page it should point to?
> >>
> >> The link Greg provided seems to be the best candidate:
> >>
> >> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-lon
> >> g-full&extra=pgsql-general
> >
> > Ok, I have a .htaccess rule that does this. Since we're sending it to a
> > preferences page, it seems reasonable to name it mailpref (or so) instead
> > of unsub.
> >
> > So http://www.postgresql.org/mailpref/pgsql-www
> > seems reasonable?
> 
> I like it ... let me know when to make the change on the majordomo side ...

Ok, it works off at least one of the mirrors now, so give it a couple of
hours to make sure it has hit all the mirrors, and then go ahead with the
change.

//Magnus