[BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread terje
The following bug has been logged on the website: Bug reference: 8410 Logged by: Terje Elde Email address: te...@elde.net PostgreSQL version: Unsupported/Unknown Operating system: FreeBSD Description: Running: PostgreSQL 9.3beta1 on amd64-portbld-freebsd9.1

[BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
xpect it to behave more as an insert on cars. Terje

Re: [BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
On Jul 24, 2013, at 2:37 PM, Terje Elde wrote: > Short summary: > If I run a single INSERT against an updateable VIEW on top of a partitioned > table, it's run against all the tables/partitions. I'd expect that with > UPDATE and DELETE, but not with INSERT. Result

[BUGS] Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

2013-07-24 Thread Terje Elde
xpect it to behave more as an insert on cars. Terje

Re: [BUGS] BUG #8375: pg_hba.conf: Include_dir like in postgresql.conf

2013-08-08 Thread Terje Elde
plifying (wildcard usernames, etc), look at other authentication-systems (PAM), or set up a build-sytem for pg_hba. Terje -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Terje Elde
On Aug 30, 2013, at 11:23 PM, Tom Lane wrote: > Sounds like a bug all right, but I'm not convinced it explains Terje's > report. The thing this theory doesn't explain is why would Terje be > having trouble reproducing the failure? Seems like re-running the same > quer

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Terje Elde
On Aug 30, 2013, at 10:46 PM, te...@elde.net wrote: > The following bug has been logged on the website: That didn't work out too well, rendering-wize. Sending the explain analyze by email as well, hoping it'll be more readable:

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Terje Elde
On 30. aug. 2013, at 23:05, Andres Freund wrote: > No need, found the bug. And I think can build a testcase myself. Sounds good. :) Please do let me know if there's anything I can do. Terje -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Terje Elde
On Aug 30, 2013, at 11:49 PM, Andres Freund wrote: > Even better explanation: The merge append is some steps below a LockRows > node, so the number of rescans might depend on the concurrency because > we'll do the EvalPlanQual dance on a concurrent row update. > > Te

Re: [BUGS] BUG #8410: out of binary heap slots

2013-08-30 Thread Terje Elde
if I can set up some synthetic load to provoke the error more rapidly, then patch and re-check. It's getting quite late, and has been a bit of a long day, so it'll unfortunately have to wait until tomorrow I think, sorry. :( Terje

Re: [BUGS] BUG #8516: Calling VOLATILE from STABLE function

2013-10-11 Thread Terje Elde
when executing any VOLATILE function? If a volatile function checks the bit, and you're "inside" a stable function, you could then raise an exception for calling volatile inside stable? Terje signature.asc Description: Message signed with OpenPGP using GPGMail