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 ind
On Wednesday, October 10, 2007 2:32:17 PM UTC-7, Tom Lane wrote:
> "Eric Weimer" 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 the sequence created is o
On Mon, May 14, 2012 at 09:41:59PM +, iain.dal...@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6639
> Logged by: Ian
> Email address: iain.dal...@gmail.com
> PostgreSQL version: 9.1.3
> Operating system: GNU/Linux
> Description:
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
- someth
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 http://w
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 STUD
The following bug has been logged on the website:
Bug reference: 7510
Logged by: Daniel Farina
Email address: dan...@heroku.com
PostgreSQL version: 9.1.4
Operating system: Ubuntu 10.04
Description:
Summary: Planner chooses GiST even if GIN is much better.
We have a t
On Mon, Apr 9, 2012 at 02:07:43PM -0500, Kevin Grittner wrote:
> Bruce Momjian wrote:
> > On Mon, Apr 09, 2012 at 03:37:09PM -0300, Alvaro Herrera wrote:
>
> >> (Another related tool is clearxlogtail which zeroes areas from
> >> WAL files when they are empty because of an early switch due to
>
On Wed, Aug 29, 2012 at 10:44 AM, Chris Travers 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 constraints for
Andrew Hastie 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 helpful, because both
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 sti
On Wed, Aug 29, 2012 at 10:59 PM, Andres Freund 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: database system
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:
On Wed, Aug 29, 2012 at 6:55 AM, Merlin Moncure 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 don't apply: de
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
ste...@konink.de writes:
> The following is relatively fast:
> bag-2012-aug=# explain select count(*) from (select kvk from kvk_normal
> except select kvk from bag_kvk) as x;
> The 'normal' case basically doesn't finish:
> bag-2012-aug=# explain select count(*) from (select kvk_normal.kvk from
> k
MirrorX writes:
> i am facing a rather 'weird' issue so please if you have ideas/thoughs share
> them.
> i have a setup of a master server and hot standby one. the database settings
> on both are identical, the specs of the servers are the same except of the
> disks. the disks on the standby are
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;
pgsql-hack...@postgresql
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 count(*)
On Tue, Aug 28, 2012 at 11:09 PM, Chris Travers 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 wrote:
>>
>> Bruce Momjian writes:
>> > On Wed, Mar 14, 2012 at 07:19:14PM +0100, Rikard Pavelic wrote:
>> >> On 13.3.2012. 20:49, Merli
hello!
i am facing a rather 'weird' issue so please if you have ideas/thoughs share
them.
i have a setup of a master server and hot standby one. the database settings
on both are identical, the specs of the servers are the same except of the
disks. the disks on the standby are much slower than th
21 matches
Mail list logo
