Re: [BUGS] BUG #5985: CLUSTER ... USING can fail with ERROR: index xxx does not belong to table yyy

2011-04-19 Thread Dewin
But if that theory is correct, this isn't a new > problem in 9.1, it goes back to 8.3. Have you been running this script > successfully on older versions? > On 9.0. Though... now that I think about it, I found a bug with the script itself (I was braindead when I wrote the commandline parser and

Re: [BUGS] BUG #5987: Rows created by WITH (INSERT ... RETURNING) are not visible to the rest of the query

2011-04-19 Thread Tom Lane
"Daniel Grace" writes: > Description:Rows created by WITH (INSERT ... RETURNING) are not > visible to the rest of the query This is not a bug but the designed behavior. See http://developer.postgresql.org/pgdocs/postgres/queries-with.html particularly this bit: The sub-statements in WI

[BUGS] BUG #5987: Rows created by WITH (INSERT ... RETURNING) are not visible to the rest of the query

2011-04-19 Thread Daniel Grace
The following bug has been logged online: Bug reference: 5987 Logged by: Daniel Grace Email address: dgr...@wingsnw.com PostgreSQL version: 9.1-alpha5 Operating system: Win7 x64 Description:Rows created by WITH (INSERT ... RETURNING) are not visible to the rest of the

[BUGS] help

2011-04-19 Thread anij ninan
hi, > i install posgresql in remote server linux(centos).when i changed the > configuration. > and it has not working.could you help me please how to config pg_bha.cnf > in a remote server.our ip address is 67.23.238.200. > I would be thankful to you if you could send me the details as early as > p

Re: [BUGS] BUG #5986: pg_dump output is not ordered

2011-04-19 Thread Peter Eisentraut
On Tue, 2011-04-19 at 12:52 +, Daniel Migowski wrote: > I would love to give pg_dump an option to produce ordered output. This would > make it much easier to create dump files that are comparable with a textual > diff tools. > > The following orderings are required: > > * Dump objects ordered

Re: [BUGS] BUG #5986: pg_dump output is not ordered

2011-04-19 Thread Kevin Grittner
"Daniel Migowski" wrote: > I would love to give pg_dump an option to produce ordered output. This is a feature request, not a bug -- so this list is not the right place to discuss it. A discussion like this would be more appropriate on the pgsql-general list. When starting a new thread, it m

[BUGS] BUG #5986: pg_dump output is not ordered

2011-04-19 Thread Daniel Migowski
The following bug has been logged online: Bug reference: 5986 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 8.3.14 Operating system: Many Description:pg_dump output is not ordered Details: Hi, I would love to give pg_dump an op