Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-08-29 Thread Merlin Moncure
On Tue, Aug 28, 2012 at 11:09 PM, Chris Travers ch...@metatrontech.com wrote: here's my sense from what I've done in this area so far. On Tue, Aug 28, 2012 at 9:54 AM, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: On Wed, Mar 14, 2012 at 07:19:14PM +0100, Rikard

[BUGS] BUG #7509: x NOT IN (select x from z) extremely slow in compare to select x from y except select x from z;

2012-08-29 Thread stefan
The following bug has been logged on the website: Bug reference: 7509 Logged by: Stefan de Konink Email address: ste...@konink.de PostgreSQL version: 9.1.5 Operating system: Linux Description: The following is relatively fast: bag-2012-aug=# explain select

Re: [HACKERS] [BUGS] BUG #6572: The example of SPI_execute is bogus

2012-08-29 Thread Rajeev rastogi
From: pgsql-bugs-ow...@postgresql.org [pgsql-bugs-ow...@postgresql.org] on behalf of Bruce Momjian [br...@momjian.us] Sent: Wednesday, August 29, 2012 8:46 AM To: Tom Lane Cc: Robert Haas; Hitoshi Harada; pgsql-bugs@postgresql.org;

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-29 Thread Stuart Bishop
I believe I just hit this same issue, but with PG 9.1.3: @:32407 2012-08-29 10:02:09 UTC LOG: shutting down @:32407 2012-08-29 10:02:09 UTC LOG: database system is shut down [unknown]@[unknown]:31687 2012-08-29 13:34:03 UTC LOG: connection received: host=[local] [unknown]@[unknown]:31687

Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-08-29 Thread Chris Travers
On Wed, Aug 29, 2012 at 6:55 AM, Merlin Moncure mmonc...@gmail.com wrote: Yeah -- the question at hand is whether certain table-ish mechanisms apply to a table's type when it's used in non-table-storage ways. In particular, defaults and constraints are interesting. I'm arguing that they

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-29 Thread Andres Freund
On Wednesday, August 29, 2012 05:32:31 PM Stuart Bishop wrote: I believe I just hit this same issue, but with PG 9.1.3: @:32407 2012-08-29 10:02:09 UTC LOG: shutting down @:32407 2012-08-29 10:02:09 UTC LOG: database system is shut down [unknown]@[unknown]:31687 2012-08-29 13:34:03 UTC

Re: [BUGS] BUG #7500: hot-standby replica crash after an initial rsync

2012-08-29 Thread Stuart Bishop
On Wed, Aug 29, 2012 at 10:59 PM, Andres Freund and...@2ndquadrant.com wrote: On Wednesday, August 29, 2012 05:32:31 PM Stuart Bishop wrote: I believe I just hit this same issue, but with PG 9.1.3: @:32407 2012-08-29 10:02:09 UTC LOG: shutting down @:32407 2012-08-29 10:02:09 UTC LOG:

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-29 Thread Andrew Hastie
Following up on getting PG built on AIXv7.1, I too have hit the same issue reported in BUG #6758. The posting of Thu, 26 Jul 2012 11:13:03 states that the problem does *not* occur using the IBM xlc v12 compiler but *does* occur using the v11 compiler. From what I have seen, the same issue

Re: [BUGS] BUG #6758: ./configure script sets HAVE_WCSTOMBS_L 1

2012-08-29 Thread Tom Lane
Andrew Hastie and...@ahastie.net writes: I'm currently working on a project where I need to get PGv9.1 up and running on an IBM AIXv7.1 server, so I do have access to a suitable machine for a period of time if I can provide any further diags to help resolve the issue. That would be

Re: [BUGS] BUG #6489: Alter table with composite type/table

2012-08-29 Thread Merlin Moncure
On Wed, Aug 29, 2012 at 10:44 AM, Chris Travers ch...@metatrontech.com wrote: I think there's a lot of circumstantial support for that argument; consider the case of plpgsql declared record variables for example...what happens to them? Again, the question is simply this: Are the table

[BUGS] PostGreSQL pgdac - C++ Builder 2007

2012-08-29 Thread lacmane
Hi, I am working with c++ Builder 2007, and try to work also with PostGreSQL. I have downloaded the following exe, http://www.devart.com/pgdac/pgdac11.exe But i have an error while building, [Linker Error] Unresolved external 'WSAIoctl' referenced from C:\PROGRAM FILES (X86)\CODEGEAR\RAD

Re: [BUGS] PostGreSQL pgdac - C++ Builder 2007

2012-08-29 Thread Craig Ringer
On 08/30/2012 12:08 AM, lacm...@sapo.pt wrote: Hi, I am working with c++ Builder 2007, and try to work also with PostGreSQL. Is that Borland/Embarcadero C++ builder? If so, I have to ask: *why*? I have downloaded the following exe, http://www.devart.com/pgdac/pgdac11.exe Which is

Re: [BUGS] PostGreSQL pgdac - C++ Builder 2007

2012-08-29 Thread Craig Ringer
On 08/30/2012 12:08 AM, lacm...@sapo.pt wrote: Does someone know what this could be? Also, this is *clearly* not a PostgreSQL bug, just to make that explicit. It's an issue in: - most likely your code or build systems; or - pgdac - C++builder - a compatibility issue between the two -

Re: [BUGS] BUG #3668: type error in serial

2012-08-29 Thread Dave Johansen
On Wednesday, October 10, 2007 2:32:17 PM UTC-7, Tom Lane wrote: Eric Weimer ewei...@thelocalphonecompany.net writes: Creating a table with a column of type serial causes the creation of a sequence tied as the default value for the column. The actual type of the column is integer, however

Re: [BUGS] BUG #7510: Very bad costing estimation on gin vs gist with FTS

2012-08-29 Thread Tom Lane
dan...@heroku.com writes: If one adds a GIN index and does a fresh analyze, the planner still produce a plan for the GiST index. Because there is no way to disable particular indexes in a session, it's impossible to quickly experiment with a new hypothetical situation with only the GIN index