Re: [BUGS] 8.4: COPY continues after client disconnects

2013-03-08 Thread Heikki Linnakangas
On 01.03.2013 17:15, Jon Nelson wrote: Using PostgreSQL 8.4.13 on ScientificLinux 6.3 (x86_64), I noticed that a pg_dump ran out of (local) disk space. However, the server was still using CPU and disk resources. An strace clearly showed this pattern: read() = 8192 sendto(...) = -1 EPIPE --

[BUGS] BUG #7924: Trigger update function don't take correct values

2013-03-08 Thread mv . gonzalez
The following bug has been logged on the website: Bug reference: 7924 Logged by: Maria Email address: mv.gonza...@cir.es PostgreSQL version: Unsupported/Unknown Operating system: RedHat Description: Hi! I have a trigger that when you update a value on a table, makes

Re: [BUGS] BUG #7924: Trigger update function don't take correct values

2013-03-08 Thread Kevin Grittner
mv.gonza...@cir.es mv.gonza...@cir.es wrote: On table_B appears:    id    | situation | when +---+-    23    | Started  | 2013-03-08 12:33:35    23    | Started  | 2013-03-08 12:33:37 I don't understand why after the second update, the insert done on

Re: [BUGS] Nested xmlagg doesn't give a result 9.2.3

2013-03-08 Thread Peter Kroon
Just to let everyone know that I haven't forgotten this. I just don't have any time to spend on it. The problem still occurs. 2013/2/20 Peter Kroon plakr...@gmail.com I've migrated everything to Linux and I'm able to continue my work. I'll get back on this next week. 2013/2/19 Lou Picciano

[BUGS] Issue with range types and casts?

2013-03-08 Thread Josh Berkus
select version(); version -- PostgreSQL 9.2.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4),

[BUGS] New kind of crash?

2013-03-08 Thread Josh Berkus
Folks, This is one I've never seen before: = select generate_master_tables(); WARNING: AbortTransaction while in COMMIT state PANIC: cannot abort transaction 9387287, it was already committed PANIC: cannot abort transaction 9387287, it was already committed The connection to the server was

Re: [BUGS] New kind of crash?

2013-03-08 Thread Mark Kirkwood
Do you have any non default procedural languages installed? I provoked exactly that error with a similar script which used a PL/R procedure (see BUGS thread PL/R Median Busts Commit...the cause is signal hi-jacking in that case). Regards Mark On 09/03/13 13:27, Josh Berkus wrote: Folks,

Re: [BUGS] New kind of crash?

2013-03-08 Thread Alvaro Herrera
Josh Berkus wrote: Folks, This is one I've never seen before: = select generate_master_tables(); WARNING: AbortTransaction while in COMMIT state PANIC: cannot abort transaction 9387287, it was already committed Anything that causes an ERROR in the final stages of a transaction commit