pgsql-bugs - September 2009

If you find a bug, please use the bug reporting form.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 1, 2009

Thread Author Time
Re: BUG #4919: CREATE USER command slows down system performance Alvaro Herrera 02:59
Re: psql: FATAL: the database system is in recovery mode Bhushan Verma 05:10
Re: psql: FATAL: the database system is in recovery mode Tom Lane 05:17
Re: psql: FATAL: the database system is in recovery mode Bhushan Verma 06:47
Re: psql: FATAL: the database system is in recovery mode Guillaume Smet 06:54
Re: lost statistics; analyze needs to execute twice Magnus Hagander 08:09
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Heikki Linnakangas 08:11
Re: inconsistent composite type null handling in plpgsql out variable Sam Mason 09:35
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Hitoshi Harada 10:48
Re: inconsistent composite type null handling in plpgsql out variable Pavel Stehule 11:35
BUG #5026: No buffer space available error. Does any other solution exist other than changing windows paramete Narendra Shah 12:02
BUG #5027: SQL query error? Dmitry 13:51
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Tom Lane 15:06
BUG #5028: CASE returns ELSE value always when type is "char" Joseph Shraibman 16:36
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Merlin Moncure 16:39
Re: BUG #5028: CASE returns ELSE value always when type is "char" Joseph Shraibman 16:40
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason 16:49
Re: BUG #5028: CASE returns ELSE value always when type is "char" Joseph Shraibman 17:00
BUG #5029: Download Trouble Alan Rubin 17:34
Re: BUG #5029: Download Trouble John R Pierce 18:00
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Tom Lane 18:06
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane 18:17
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 18:30
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane 18:42
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 18:49
pg_ctl infinite loop and memory leak 📎 Jeff Davis 20:52
Re: BUG #5028: CASE returns ELSE value always when type is "char" Jeff Davis 23:48

Sept. 2, 2009

Thread Author Time
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Tom Lane 00:34
Re: pg_ctl infinite loop and memory leak Tom Lane 02:01
Re: pg_ctl infinite loop and memory leak Jeff Davis 02:38
Re: pg_ctl infinite loop and memory leak Tom Lane 02:50
Re: lost statistics; analyze needs to execute twice Tom Lane 04:25
Re: lost statistics; analyze needs to execute twice Magnus Hagander 07:57
Re: BUG #5028: CASE returns ELSE value always when type is "char" 📎 Sam Mason 09:16
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Heikki Linnakangas 11:00
Re: BUG #5027: SQL query error? Robert Haas 13:29
Re: BUG #5019: Nao funciona Magnus Hagander 13:39
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 13:57
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 14:11
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 14:24
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane 14:39
Re: BUG #5028: CASE returns ELSE value always when type is"char" Jeff Davis 14:44
Re: BUG #5028: CASE returns ELSE value always when type is"char" Greg Stark 14:50
Re: BUG #5028: CASE returns ELSE value always when typeis"char" Kevin Grittner 14:52
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Tom Lane 15:36
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 15:55
Re: BUG #5028: CASE returns ELSE value always when type is"char" Robert Haas 16:36
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Alvaro Herrera 16:52
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 16:57
Re: BUG #5025: Aggregate function with subquery in 8.3 and 8.4. Tom Lane 16:58
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 17:19
BUG #5030: Problem on "RETURN QUERY EXECUTE" when a column is dropped from a table Armando Taffarel Neto 17:25
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 17:44
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 17:45
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 17:54
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 17:58
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 18:09
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 18:18
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 18:21
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 18:27
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 18:37
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 18:38
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 18:41
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 18:49
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 18:55
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 19:07
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 19:08
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 19:34
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 19:41
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 19:59
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 20:04
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 20:07
Re: BUG #5028: CASE returns ELSE value always when type is"char" Sam Mason 20:17
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 20:22
Re: BUG #5030: Problem on "RETURN QUERY EXECUTE" when a column is dropped from a table Jaime Casanova 20:33
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 20:33
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 20:46
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 20:55
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 21:01
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 21:26
Re: BUG #5028: CASE returns ELSE value always when type is"char" Greg Stark 21:27
Re: BUG #5028: CASE returns ELSE value always when type is"char" Tom Lane 21:44
Re: BUG #5028: CASE returns ELSE value always when type is"char" Kevin Grittner 21:53
BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH Mark Douglas 23:07

Sept. 3, 2009

Thread Author Time
Re: BUG #5028: CASE returns ELSE value always when type is"char" Robert Haas 01:21
BUG #5032: unexpected syntax error for plpgsql function returns table Keith Cascio 01:22
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Pavel Stehule 03:27
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Keith Cascio 04:48
Re: BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH Tom Lane 05:01
Re: BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH Mark Douglas 05:06
Re: BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH Tom Lane 05:24
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Pavel Stehule 06:31
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Keith Cascio 06:39
Re: [NOVICE] psql: FATAL: the database system is in recovery mode Devrim GÜNDÜZ 07:44
Re: [BUGS] psql: FATAL: the database system is in recovery mode Bhushan Verma 09:03
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Merlin Moncure 12:20
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Robert Haas 13:13
Re: BUG #5032: unexpected syntax error for plpgsql function returns table Pavel Stehule 13:38
Re: lost statistics; analyze needs to execute twice Alvaro Herrera 16:01
Re: BUG #5031: DATE_TRUNC returns the wrong value when specifying MONTH Mark Douglas 19:19
BUG #5033: Fallback using Warm Standby Raja Rayaprol 20:53
BUG #5034: plperlu problem with gethostbyname Diego de Lima 21:21

Sept. 4, 2009

Thread Author Time
Re: BUG #5033: Fallback using Warm Standby Peter Eisentraut 06:16
BUG #5035: cast 'text' to 'name' doesnt work in plpgsql function tkarlik 10:27
BUG #5036: Advisory locks have unexpected behavior Dennis Seran 14:15
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane 15:15
Re: BUG #5028: CASE returns ELSE value always when type is "char" Robert Haas 15:50
Re: BUG #5036: Advisory locks have unexpected behavior Alvaro Herrera 15:50
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 15:59
Re: BUG #5028: CASE returns ELSE value always when type is "char" Robert Haas 16:37
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason 17:03
Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsql function Alvaro Herrera 17:23
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 17:26
Re: BUG #5028: CASE returns ELSE value always when type is "char" Jeff Davis 17:53
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason 17:59
Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsql function Tom Lane 18:04
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 19:01
Re: BUG #5028: CASE returns ELSE value always when type is "char" Tom Lane 19:19
Re: BUG #5028: CASE returns ELSE value always when type is "char" Kevin Grittner 19:32
Re: BUG #5028: CASE returns ELSE value always when type is "char" Sam Mason 19:37
BUG #5037: jdbc bug \uffff Rob Resendez 22:02
Re: lost statistics; analyze needs to execute twice Tom Lane 22:33

Sept. 5, 2009

Thread Author Time
Re: BUG #5034: plperlu problem with gethostbyname Robert Haas 03:27
BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 03:52
Re: BUG #5010: perl iconv function returns ? character Robert Haas 04:02
BUG #5039: 'i' flag i in regexp_replace ignored for polish letters Kamil Roman 09:42
Re: BUG #5036: Advisory locks have unexpected behavior Tom Lane 22:02
Re: BUG #5034: plperlu problem with gethostbyname Tom Lane 22:52
Re: BUG #5010: perl iconv function returns ? character Tom Lane 23:03

Sept. 6, 2009

Thread Author Time
Re: BUG #5010: perl iconv function returns ? character Lampa 05:20
Re: BUG #5007: could not reattach to shared memory Paragon Corporation 09:39
8.4 dropped Russian server translations Martin Pitt 13:33
Re: 8.4 dropped Russian server translations Tom Lane 14:24
BUG #5040: Latest version of PostgreSQL's JDBC driver is not available in Maven's central repository Clemens Fuchslocher 14:40
Re: 8.4 dropped Russian server translations Martin Pitt 15:32
Re: BUG #5034: plperlu problem with gethostbyname Robert Haas 15:58
Re: BUG #5010: perl iconv function returns ? character Tom Lane 16:38
Re: BUG #5010: perl iconv function returns ? character Tom Lane 16:52
BUG #5041: Changing data_directory problem Jonas 17:29
Re: BUG #5010: perl iconv function returns ? character Devrim GÜNDÜZ 17:55
Re: BUG #5010: perl iconv function returns ? character Tom Lane 18:27
Re: BUG #5040: Latest version of PostgreSQL's JDBC driver is not available in Maven's central repository Stefan Kaltenbrunner 20:12
Re: BUG #5040: Latest version of PostgreSQL's JDBC driver is not available in Maven's central repository Devrim GÜNDÜZ 20:13
Re: BUG #5041: Changing data_directory problem Andres Freund 20:41
Re: BUG #5041: Changing data_directory problem Martin Pitt 20:46
BUG #5042: Update numeric within a rule Ilian Georgiev 20:48

Sept. 7, 2009

Thread Author Time
Odp: Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsqlfunction Tomasz Karlik 06:28
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. 📎 Heikki Linnakangas 09:21
Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsqlfunction Pavel Stehule 13:47
Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsqlfunction Pavel Stehule 13:47
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Tom Lane 17:17
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 20:29

Sept. 8, 2009

Thread Author Time
Odp: Re: Re: BUG #5035: cast 'text' to 'name' doesnt work in plpgsqlfunction Tomasz Karlik 05:48
BUG #5043: Stored procedure returning different results for same arguments Martin Edlman 13:30
Re: BUG #5043: Stored procedure returning different results for same arguments Pavel Stehule 13:40
Re: BUG #5043: Stored procedure returning different results for same arguments Tom Lane 14:21
Re: BUG #5036: Advisory locks have unexpected behavior Dennis C. Seran 14:37

Sept. 9, 2009

Thread Author Time
error: message type 0x5a arrived from server while idle vyou zhi 03:38
BUG #5044: error: message type 0x5a arrived from server while idle vyouzhi 03:44
dblink generates orphaned connections 📎 Tatsuhito Kasahara 05:35
BUG #5045: java developer mahmoud badr 09:41
BUG #5046: java developer mahmoud badr 09:42
Re: BUG #5043: Stored procedure returning different results for same arguments Martin Edlman 09:58
Re: BUG #5043: Stored procedure returning different results for same arguments Pavel Stehule 10:19
Re: BUG #5044: error: message type 0x5a arrived from server while idle Alvaro Herrera 11:49
Re: BUG #5045: java developer Jim Mlodgenski 16:21
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 18:36
need higher extra_float_digits value (3) Keh-Cheng Chu 18:51
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Heikki Linnakangas 18:58
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Tom Lane 19:06
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 19:11
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Tom Lane 19:20
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 19:27
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Heikki Linnakangas 19:27
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Tom Lane 19:44
Re: need higher extra_float_digits value (3) Tom Lane 22:04

Sept. 10, 2009

Thread Author Time
Re: need higher extra_float_digits value (3) Robert Haas 01:18
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Heikki Linnakangas 05:36
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Heikki Linnakangas 09:44
BUG #5047: Not able to connect from Informatica Rohan jamadagni 11:17
BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query Andrew Deryabin 14:04
Re: BUG #5048: psql: \g doesn't redirect COPY TO STDOUT, but redirects next query Tom Lane 14:16

Sept. 11, 2009

Thread Author Time
Re: need higher extra_float_digits value (3) Tom Lane 19:17
BUG #5049: query crashing backend with TRAP: FailedAssertion Thomas 22:19

Sept. 12, 2009

Thread Author Time
Re: BUG #5049: query crashing backend with TRAP: FailedAssertion Tom Lane 00:06
Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. Luke Koops 03:37
BUG #5050: text to timestamp failure Aoyai Kouhei 15:49
Re: BUG #5050: text to timestamp failure Tom Lane 19:58
BUG #5051: SQLNumResultCols returns 0 for common table expression the6campbells 23:13
Re: dblink generates orphaned connections Joe Conway 23:22

Sept. 13, 2009

Thread Author Time
Re: BUG #5050: text to timestamp failure aoyogi kouhei 00:04
Re: BUG #5050: text to timestamp failure Tom Lane 02:01
BUG #5052: lost history wumarex 15:06
Re: BUG #5052: lost history Tom Lane 17:42
Re: BUG #5052: lost history Marek Wójtowicz 19:03
Re: BUG #5052: lost history Tom Lane 19:49

Sept. 14, 2009

Thread Author Time
BUG #5053: domain constraints still leak Andrew Gierth 02:03
Re: BUG #5053: domain constraints still leak Tom Lane 02:28
BUG #5054: PDO -> Query returns "" from Boolean type field, if it has false value. Yujin 09:59
Re: BUG #5053: domain constraints still leak Robert Haas 13:28

Browse Archives

Prev | Next