[BUGS] BUG #6423: max_standby_streaming_delay does not work

2012-01-31 Thread 139669962
The following bug has been logged on the website: Bug reference: 6423 Logged by: Weiyu Zhao Email address: 139669...@qq.com PostgreSQL version: 9.0.6 Operating system: Redhat 5.5 x86_64 Description: The parameter max_standby_streaming_delay does not work. The paramete

Re: [BUGS] BUG #6200: standby bad memory allocations on SELECT

2012-01-31 Thread Bridget Frey
We have no DDL whatsoever in the code. We do update rows in the logins table frequently, but we basically have a policy of only doing DDL changes during scheduled upgrades when we bring the site down. We have been discussing this issue a lot and we really haven't come up with anything that would

Re: [BUGS] BUG #6200: standby bad memory allocations on SELECT

2012-01-31 Thread Alvaro Herrera
Excerpts from Bridget Frey's message of lun ene 30 18:59:08 -0300 2012: > Anyway, here goes... Maybe a "bt full" could give more insight into what's going on ... > #0 0x003a83e30265 in raise () from /lib64/libc.so.6 > #1 0x003a83e31d10 in abort () from /lib64/libc.so.6 > #2 0x000

Re: [BUGS] BUG #6423: max_standby_streaming_delay does not work

2012-01-31 Thread Fujii Masao
On Tue, Jan 31, 2012 at 6:35 PM, <139669...@qq.com> wrote: > The following bug has been logged on the website: > > Bug reference:      6423 > Logged by:          Weiyu Zhao > Email address:      139669...@qq.com > PostgreSQL version: 9.0.6 > Operating system:   Redhat 5.5 x86_64 > Description: > >

[BUGS] inet subtraction fails with IPv6?

2012-01-31 Thread Jon Nelson
Example (using one of google's IPv6 addrs): jnelson=# select inet '0::0' - inet '2001:4860:4006:800::1011'; ERROR: result is out of range jnelson=# -- Jon -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [BUGS] BUG #6200: standby bad memory allocations on SELECT

2012-01-31 Thread Robert Haas
On Tue, Jan 31, 2012 at 12:05 AM, Tom Lane wrote: > I wrote: >> Hm.  The stack trace is definitive that it's finding the bad data in a >> tuple that it's trying to print to the client, not in an index. > > BTW, after a bit more reflection it occurs to me that it's not so much > that the data is ne

Re: [BUGS] inet subtraction fails with IPv6?

2012-01-31 Thread Robert Haas
On Tue, Jan 31, 2012 at 10:38 AM, Jon Nelson wrote: > Example (using one of google's IPv6 addrs): > > jnelson=# select inet '0::0' - inet '2001:4860:4006:800::1011'; > ERROR:  result is out of range > jnelson=# What were you expecting to get? There's no such thing as a negative IP address. --

Re: [BUGS] inet subtraction fails with IPv6?

2012-01-31 Thread Jon Nelson
On Tue, Jan 31, 2012 at 2:03 PM, Robert Haas wrote: > On Tue, Jan 31, 2012 at 10:38 AM, Jon Nelson > wrote: >> Example (using one of google's IPv6 addrs): >> >> jnelson=# select inet '0::0' - inet '2001:4860:4006:800::1011'; >> ERROR:  result is out of range >> jnelson=# > > What were you expect

Re: [BUGS] BUG #6200: standby bad memory allocations on SELECT

2012-01-31 Thread Tom Lane
Robert Haas writes: > On Tue, Jan 31, 2012 at 12:05 AM, Tom Lane wrote: >> BTW, after a bit more reflection it occurs to me that it's not so much >> that the data is necessarily *bad*, as that it seemingly doesn't match >> the tuple descriptor that the backend's trying to interpret it with. > Hm

Re: [BUGS] inet subtraction fails with IPv6?

2012-01-31 Thread Tom Lane
Jon Nelson writes: > On Tue, Jan 31, 2012 at 2:03 PM, Robert Haas wrote: >> What were you expecting to get? There's no such thing as a negative IP >> address. > True, but it works for IPv4: > jnelson=# select inet '255.255.255.255' - inet '0/0'; > ?column? > > 4294967295 > (1 r

Re: [BUGS] Fw: Re: [SQL] pg_dump not correctly saving schema with partitioned tables?

2012-01-31 Thread Tom Lane
chester c young writes: >> here is a test case: [ slightly less messed-up test case for anyone who wants to duplicate this: ] create schema s1; create schema s2; create table s1.t1( c1 bigserial primary key, c2 text ); create table s2.t1( c1 bigserial primary key ) inherits( s1