Re: unsubscribe

On 21/11/2017 09:19, Craig Ringer wrote: On 21 November 2017 at 15:17, Rafal Pietrak > wrote: Hi all, Have anyone noticed, that last couple of days on the list, can become a nice example of HOWTO turn the best list on the planet into a

Re: unsubscribe

Hi all, Have anyone noticed, that last couple of days on the list, can become a nice example of HOWTO turn the best list on the planet into a nightmare? Pls forgive rudeness, but IMHO, whoever made the "upgrade" should manually take all the "unsubscribe" messages from archive and do that

Re: [GENERAL] Query Using Massive Temp Space

On Mon, Nov 20, 2017 at 9:36 AM Tom Lane wrote: > 9.6.what exactly? > 9.6.5 > > The only thing I can think of offhand that could create temp files far in > excess of the actual data volume is if a hash join repeatedly decides that > it needs to increase the number of hash

Re: unsubscribe

On 11/20/2017 7:40 PM, Tom Lane wrote: Depending on what mail software you use, you might have to use some command like "View raw headers" or "View original message" to see commonly-hidden headers like List-Unsubscribe. in gmail, its Show Original, on the down-tick menu next to the 'Reply'

One Partition by list is always chosen by planner

Hello, after creating a table wiki_data_part with partition by list (category); and creating partitions like CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part FOR VALUES IN ('ang.q',...,'arc'); CREATE TABLE wiki_data_part_b PARTITION OF wiki_data_part FOR VALUES IN ('bs.s',...,'bg.n');

Re: unsubscribe

.Hmm, yes, indeed. I tried to login to that site with my listserv account credentials, and that got me nowhere either. Also, I just checked this message too. Downloaded the raw message including headers. Search in text editor for string "List-Unsubscribe" and anything at all like it comes up with

Re: unsubscribe

Danyelle Davis writes: > https://lists.postgresql.org/manage/ But note that that's only going to help if you've set up a "PG community account", which up to now nobody has needed unless they wanted to edit our wiki or work in our commitfest app, so it's a good bet that most

Re: unsubscribe

https://lists.postgresql.org/manage/ Virus-free. www.avast.com

Re: unsubscribe

Ryan writes: > All right, so not for lack of trying, I cannot figure out how to > unsubscribe. I've tried three different things, but they've either been > ineffective or result in me getting an automatic email that the attempt > failed. Kindly help? I enjoyed my daily

Re: To all who wish to unsubscribe

On Mon, Nov 20, 2017 at 1:11 PM, Tom Lane wrote: > Vick Khera writes: > > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. > > Yes - did you not see either of the "migration to pglister"

Re: unsubscribe

Hi, All right, so not for lack of trying, I cannot figure out how to unsubscribe. I've tried three different things, but they've either been ineffective or result in me getting an automatic email that the attempt failed. Kindly help? I enjoyed my daily digest of PostgreSQL messages, but this has

Re: To all who wish to unsubscribe

On 21/11/17 09:20, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake > wrote: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to

Re: To all who wish to unsubscribe

> On Nov 20, 2017, at 2:18 PM, Piotr Stefaniak > wrote: > > On 2017-11-20 21:03, Tom Lane wrote: >> "Joshua D. Drake" writes: >>> On 11/20/2017 11:40 AM, Magnus Hagander wrote: >>> One thing I would note is that there is no longer a footer

Re: Procmail recipe for new setup

Greetings Rich, all, * Rich Shepard (rshep...@appl-ecosys.com) wrote: > On Mon, 20 Nov 2017, Steve Litt wrote: > > >The following procmail recipe works for me: > > > >=== > >:0: > >* ^(To|Cc).*pgsql-gene...@postgresql.org > >.Postgres/ >

Re: Procmail recipe for new setup

Greetings Piotr, * Piotr Stefaniak (postg...@piotr-stefaniak.me) wrote: > On 2017-11-20 23:10, Steve Litt wrote: > > > The following procmail recipe works for me: > > I use this: > > :0 > * ^List-Id: \/.* > { > :0 > * $MATCH ?? [<]+\/.*[^>]+ > $MATCH/ > > :0 > $MATCH/

Re: Procmail recipe for new setup

On 2017-11-20 23:10, Steve Litt wrote: > The following procmail recipe works for me: I use this: :0 * ^List-Id: \/.* { :0 * $MATCH ?? [<]+\/.*[^>]+ $MATCH/ :0 $MATCH/ }

Re: To all who wish to unsubscribe

On 2017-11-20 21:03, Tom Lane wrote: > "Joshua D. Drake" writes: >> On 11/20/2017 11:40 AM, Magnus Hagander wrote: >> One thing I would note is that there is no longer a footer that >> tells people what to do if they want to unsubscribe. Perhaps one >> thing that could be

Re: Procmail recipe for new setup

On 11/20/2017 02:10 PM, Steve Litt wrote: Hi all, The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === You may want to use TO ... See here:

Re: Procmail recipe for new setup

On Mon, 20 Nov 2017, Steve Litt wrote: The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === Hi, Steve! Here's an alternative recipe: :0: *

Test 501, please don't reply

-- SteveT Steve Litt November 2017 featured book: Troubleshooting: Just the Facts http://www.troubleshooters.com/tjust

Re: To all who wish to unsubscribe

Greetings, * Tom Lane (t...@sss.pgh.pa.us) wrote: > In principle, the List-Unsubscribe: headers that are now included in > mailing list headers allow MUAs to offer convenient unsubscribe > buttons. Not sure how many of the people who are complaining use > mail agents that don't handle that.

Re: To all who wish to unsubscribe

Magnus Hagander wrote: > So do you have any suggestions for actually fixing that? Given that we have > more lists to migrate, if you can figure out a way to make those changes > without peoples filters not matching, we'd be happy to hear it.. I guess it's a bit late at this point, but in

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

The link to this simple form below is right at the top of the other link where it says "How to Subscribe or Unsubscribe, Fill out this form." https://www.postgresql.org/community/lists/subscribe/ On Mon, Nov 20, 2017 at 4:25 PM, Bennett Hitchcox-Lain wrote: > Yeah, that

Re: Migration to PGLister - After

Mike, * Michael Nolan (htf...@gmail.com) wrote: > On Mon, Nov 20, 2017 at 9:45 AM, Stephen Frost wrote: > > This list has now been migrated to new mailing list software known as > > 'PGLister'. This migration will impact all users of this mailing list > > in one way or

Re: [MESSAGE PUBLICITAIRE- VIGILANCE] RE: Unsubscribe

Yeah, that link is pretty much useless... The go to this other link for what you want, but then go to another link, and login, then go to. Why can I just put in my email and click unsubscribe. On Mon, Nov 20, 2017, 11:11 AM Jaimi McEntire wrote: > To all wanting

Re: Migration to PGLister - After

Kinda looking like you should have unsubscribed everybody and those of us that would miss the feed would re-connect. On 11/20/2017 02:09 PM, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:31 PM, Michael Nolan > wrote: On Mon, Nov 20, 2017

Unsubscribe

Please unsubscribe me from all PostgreSQL mailing lists

Unsubscribe

Please unsubscribe me from all PostgreSQL mailing lists

Re: To all who wish to unsubscribe

On Mon, Nov 20, 2017 at 9:58 PM, John R Pierce wrote: > On 11/20/2017 12:49 PM, John R Pierce wrote: > >> Sigh, not surprised about gmail, its amazing how many .com's and .org's >> use it now. I'm not at ALL a fan of how the web client handles a bunch of >> stuff like

Re: To all who wish to unsubscribe

Edson Carlos Ericksson Richter wrote: > I've been affected also, in a minor way, because I used to receive digest  2 > or 3 times a day, and now I'm receiving every e-mail again. > This is, at least, annoying. > would be better to keep the user options when migrating from one software to >

Re: To all who wish to unsubscribe

On 11/20/2017 12:49 PM, John R Pierce wrote: Sigh, not surprised about gmail, its amazing how many .com's and .org's use it now.  I'm not at ALL a fan of how the web client handles a bunch of stuff like replies, & hiding your own messages from yourself. oh and my biggest gripe, gmail seems

Re: To all who wish to unsubscribe

On 11/20/2017 12:20 PM, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake > wrote: Not even remotely. People use gmail. See https://blog.hagander.net/mail-agents-in-the-postgresql-community-233/

Re: To all who wish to unsubscribe

Em 20/11/2017 18:07, Joshua D. Drake escreveu: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't

RE: To all who wish to unsubscribe

Vick, I thought it was just me. Yes, the sender changed: pgsql-general-ow...@postgresql.org -> pgsql-general@lists.postgresql.org I have updated my rules accordingly. -Ted From: Vick Khera

Re: Unsubscribe

Please unsubscribe me from all PostgreSQL mailing lists. Best regards, Claudio 2017-11-20 18:07 GMT-02:00 Marek Przywara : > Please unsubscribe me from all PostgreSQL mailing lists. > > Best regards, > > Marek Przywara >

unsubcribe

 unsubcribe ricardohiroshisakam...@yahoo.com.brRicardo Hiroshi Sakamoto

Re: Migration to PGLister - After

Ben Coleman writes: > On 11/20/2017 09:45 AM, Stephen Frost wrote: >> This list has now been migrated to new mailing list software known as >> 'PGLister'. This migration will impact all users of this mailing list >> in one way or another. > I note the

Re: Migration to PGLister - After

On 11/20/2017 09:45 AM, Stephen Frost wrote: > Greetings! > > This list has now been migrated to new mailing list software known as > 'PGLister'. This migration will impact all users of this mailing list > in one way or another. I note the conspicuous absence of pgsql-annou...@postgresql.org in

Re: To all who wish to unsubscribe

On Mon, Nov 20, 2017 at 9:12 PM, Tom Lane wrote: > Magnus Hagander writes: > > Right. This is why you can send an emtil to say > > pgsql-general-unsubscr...@lists.postgresql.org to unsubscribe. > > Oh? First I've heard of that, and I do not see it

Re: To all who wish to unsubscribe

On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake wrote: > On 11/20/2017 12:03 PM, Tom Lane wrote: > >> Unfortunately, the removal of the footer is a feature not a bug. >> In order to be DKIM-compatible and thus help avoid becoming classified >> as spammers, we can't

Re: To all who wish to unsubscribe

On 11/20/2017 12:07 PM, Joshua D. Drake wrote: I use Thunderbird which I imagine most people on the lists are using. I can't find where these would work to unsubscribe. In Thunderbird, ctrl-U shows the full headers, but the List-Unsubscribe links are NOT shown as hotlinks, so you have to

Re: To all who wish to unsubscribe

On 11/20/2017 11:44 AM, Mengxuan Xia wrote: A common feature in modern Email client is to allow users to unsubscribe in one line. This works by sending a email titled "unsubscribe" to the listserv, which most listserv these days are able to understand and unsubscribe the user. thats a

Re: To all who wish to unsubscribe

On 11/20/2017 11:45 AM, Joshua D. Drake wrote: Perhaps one thing that could be done is a header (for a temporary time period) that says: The mailing list software of Postgresql.org has changed. Please see this page on instructions on how to manage your subscription and filters. vast

Unsubscribe

Please unsubscribe me from all PostgreSQL mailing lists. Best regards, Marek Przywara

Re: To all who wish to unsubscribe

On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't mangle the Subject: line. Ugh, o.k. In

Re: To all who wish to unsubscribe

"Joshua D. Drake" writes: > On 11/20/2017 11:40 AM, Magnus Hagander wrote: > One thing I would note is that there is no longer a footer > that tells people what to do if they want to unsubscribe. Perhaps one > thing that could be done is a header (for a temporary time

Re: To all who wish to unsubscribe

On 11/20/2017 11:45 AM, Joshua D. Drake wrote: So do you have any suggestions for actually fixing that? Given that we have more lists to migrate, if you can figure out a way to make those changes without peoples filters not matching, we'd be happy to hear it.. I was thinking about that. I

Re: To all who wish to unsubscribe

On 11/20/2017 11:40 AM, Magnus Hagander wrote: https://wiki.postgresql.org/wiki/PGLister_Announce Those looking to unsubscribe should also read that page.  Sending "unsubscribe" messages to the list will not

RE: To all who wish to unsubscribe

A common feature in modern Email client is to allow users to unsubscribe in one line. This works by sending a email titled "unsubscribe" to the listserv, which most listserv these days are able to understand and unsubscribe the user. -Original Message- From: Alban Hertroys

unsubscribe

Best regards, Ronny Abraham From: Pedro Antonio [mailto:pedro.osp...@gmail.com] Sent: Monday, November 20, 2017 1:22 PM To: Rasha Osman Cc: pgsql-general@lists.postgresql.org Subject: unsubscribe El 20/11/2017 1:20 p.m., "Rasha Osman" >

Re: To all who wish to unsubscribe

On 11/20/2017 11:11 AM, Tom Lane wrote: Vick Khera writes: Did the list software change? All my messages from here are not being properly auto-files by the filter I have set up. Yes - did you not see either of the "migration to pglister" messages? There's a summary of the

Re: To all who wish to unsubscribe

Vick Khera writes: > Did the list software change? All my messages from here are not being > properly auto-files by the filter I have set up. Yes - did you not see either of the "migration to pglister" messages? There's a summary of the changes at

Re: Unsubscribe

Do it yourself guys ... Am Montag, 20. November 2017, 19:58:05 MEZ hat MARTIN PAREDES Folgendes geschrieben: Please unsubscribe me to all PostgreSQL mailing lists.  Thanks and best regards    |       | | |     |   ING. MARTIN PAREDES DOMINGUEZ  

RE: Unsubscribe

I tried multiple ways to remove myself from groups but no luck. Please remove me from groups and communication lists. From: MARTIN PAREDES [mailto:map...@hotmail.com] Sent: Monday, November 20, 2017 10:58 AM To: pgsql-ad...@postgresql.org; pgsql-general@lists.postgresql.org;

Re: [GENERAL] postmaster deadlock while logging after syslogger exited

Responding to several points below. Tom Lane wrote: > David's report isn't too clear: did the syslogger process actually run > out of memory and exit of its own volition after an ENOMEM, or did it get > killed by the dreaded OOM killer? In either case, it's unclear whether > it was really using

Re: Migration to PGLister - After

On Mon, 20 Nov 2017, Joshua D. Drake wrote: Yep, but that is why the list-id filter is bad advice (at least for me). I filter on the list email address and it works flawlessly. Joshua, This does not work if the procmail recipe is for pgsql-gene...@postgresql.org and the source includes the

unsubscribe

Re: Migration to PGLister - After

Josh, * Joshua D. Drake (j...@commandprompt.com) wrote: > Yep, but that is why the list-id filter is bad advice (at least for > me). I filter on the list email address and it works flawlessly. Indeed, this depends on what you're looking to do. Filtering on addresses listed in the To/CC is

Re: Migration to PGLister - After

On 11/20/2017 09:32 AM, John R Pierce wrote: On 11/20/2017 6:45 AM, Stephen Frost wrote: The changes which we expect to be most significant to users can be found on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  the current version of which is also included below. A peeve

Re: [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

Luca Ferrari writes: > I don't think it is what I'm looking for, I would like something ,like: > select unnest( histogram_bounds::text::text[] ), unnest( > most_common_freqs ) from pg_stats > but with correlation between the two array indexes. Is it something > achievable