Magnus Hagander's PostgreSQL blog - Comments

Magnus Hagander: Finding gaps in partitioned sequences

nospam@example.com (Magnus Hagander) — Mon, 30 Jan 2012 17:25:34 +0000

No, there are no user defined functions in this.

seq is the column name, then minus the operator, then lag the builtin window function. So a standard integer minus, while calling the window function lag(), which is a standard one.

mark: Finding gaps in partitioned sequences

nospam@example.com (mark) — Mon, 30 Jan 2012 17:23:33 +0000

what is seq-lag ? i assume this is a user defined func.

Magnus Hagander: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (Magnus Hagander) — Thu, 22 Dec 2011 17:41:57 +0000

Yeah, unfortunately we are still waiting on David to migrate the content over there.

Dave: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (Dave) — Thu, 22 Dec 2011 16:55:42 +0000

The weekly news page (http://www.postgresql.org/community/weeklynews/) seems to be broken. I see only a couple of articles from 2005.

Magnus Hagander: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (Magnus Hagander) — Thu, 22 Dec 2011 14:08:48 +0000

I didn't see that when I checked, but there was a bug that caused it to cache the internal errors for several hours, instead of 10 seconds. This is probably what happened to you - and the error was temporarily returned when we restarted the backend database due to an upgrade.

Hans: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (Hans) — Thu, 22 Dec 2011 11:14:25 +0000

The page with the mail archive is no longer working:

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

Shows me "An internal server error occured."

daamien: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (daamien) — Wed, 21 Dec 2011 22:20:22 +0000

you know your upgrade is a success when nobody notices anything

kudos to the webmaster team !

gabrielle: www.postgresql.org - brand new, yet old and familiar

nospam@example.com (gabrielle) — Wed, 21 Dec 2011 14:13:16 +0000

Thanks for all your hard work! (And that goes for the rest of the team, too.)

Piotr Adamiak: PGConf.EU 2011 - the speakers and the presentations

nospam@example.com (Piotr Adamiak) — Tue, 08 Nov 2011 10:57:08 +0000

Thanks for the link Pavel and also thanks for your very useful blog !

Pavel Golub: PGConf.EU 2011 - the speakers and the presentations

nospam@example.com (Pavel Golub) — Mon, 07 Nov 2011 14:50:52 +0000

Piotr, here they are: http://wiki.postgresql.org/wiki/PostgreSQL_Conference_Europe_Talks_2011

Piotr Adamiak: PGConf.EU 2011 - the speakers and the presentations

nospam@example.com (Piotr Adamiak) — Mon, 07 Nov 2011 14:36:35 +0000

Any chance of the presentations from PGConf.EU 2011 being released for download online ?

Thanks !

Pavel Golub: PGConf.EU 2011 - the speakers and the presentations

nospam@example.com (Pavel Golub) — Sun, 06 Nov 2011 19:49:35 +0000

Ram Mohan was damn good, but frankly speaking there was a little bit of technical stuff...

PS Smitty was the best as for me!

Magnus Hagander: PGConf.EU 2011 - the feedback is in

nospam@example.com (Magnus Hagander) — Fri, 04 Nov 2011 12:07:47 +0000

Hi!

This has not been decided yet. We have received feedback and are soon going to start looking at making that decision.

Pavel Golub: PGConf.EU 2011 - the feedback is in

nospam@example.com (Pavel Golub) — Fri, 04 Nov 2011 12:06:16 +0000

Magnus which city is the chosen for the next year?

Magnus Hagander: Help us test a patch for the Win32 shared memory issue

nospam@example.com (Magnus Hagander) — Wed, 17 Aug 2011 11:38:15 +0000

8.3 is a supported version, so it is already solved. According to the release notes, you need 8.3.8 or newer (http://www.postgresql.org/docs/8.3/static/release-8-3-8.html). Obviously, you should be on 8.3.15 if you are using 8.3.