Re: [BUGS] BUG #8043: 9.2.4 doesn't open WAL files from archive, only looks in pg_xlog

2013-04-08 Thread Jeff Bohmer
On Apr 6, 2013, at 1:24 PM, Jeff Janes wrote: > On Sat, Apr 6, 2013 at 1:24 AM, Heikki Linnakangas > wrote: > >> >> Incidentally, I bumped into another custom backup script just a few weeks >> back that also excluded backup_label. I don't know what the author was >> thinking when he wrote that

Re: [BUGS] BUG #8043: 9.2.4 doesn't open WAL files from archive, only looks in pg_xlog

2013-04-08 Thread Jeff Bohmer
On Apr 6, 2013, at 2:24 AM, Heikki Linnakangas wrote: > Incidentally, I bumped into another custom backup script just a few weeks > back that also excluded backup_label. I don't know what the author was > thinking when he wrote that, but it seems to be a surprisingly common > mistake. Maybe i

[BUGS] BUG #8046: PL/pgSQL plan caching regression

2013-04-08 Thread dmitigr
The following bug has been logged on the website: Bug reference: 8046 Logged by: Dmitriy Igrishin Email address: dmit...@gmail.com PostgreSQL version: 9.2.4 Operating system: Linux Debian Wheezy x64 Description: -- -*- sql -*- -- A bug test case. -- PostgreSQL 9.2.4 o

Re: [BUGS] BUG #8046: PL/pgSQL plan caching regression

2013-04-08 Thread Tom Lane
dmit...@gmail.com writes: > CREATE OR REPLACE FUNCTION rec(type_name_ regclass, id_ bigint) > RETURNS record > LANGUAGE plpgsql > STABLE > AS $function$ > DECLARE > r_ record; > BEGIN > EXECUTE 'SELECT * FROM '||type_name_::text||' WHERE id = $1' > INTO r_ USING id_; > RAISE NOTICE '%

Re: [BUGS] BUG #8046: PL/pgSQL plan caching regression

2013-04-08 Thread Dmitriy Igrishin
2013/4/9 Tom Lane > dmit...@gmail.com writes: > > CREATE OR REPLACE FUNCTION rec(type_name_ regclass, id_ bigint) > > RETURNS record > > LANGUAGE plpgsql > > STABLE > > AS $function$ > > DECLARE > > r_ record; > > BEGIN > > EXECUTE 'SELECT * FROM '||type_name_::text||' WHERE id = $1' > >