Since I've mentioned my use case, I might as well mention another issue I
stumbled across, which is that concurrent index creation cannot happen from
within trigger functions. I'm able to non-concurrently create indexes from
within trigger functions. Why is there this disparity?
Because
Thanks. Is this something viable as a feature request?
On Oct 28, 2012 7:48 AM, David Johnston pol...@yahoo.com wrote:
On Oct 27, 2012, at 19:20, David Lee davidomu...@gmail.com wrote:
Hey folks,
It seems like right now when you want to create an index concurrently,
the index creation
to launch background concurrent
index creation via triggers.
--David
On Oct 28, 2012, at 2:35 PM, Kevin Grittner kgri...@mail.com wrote:
David Lee wrote:
It seems like right now when you want to create an index
concurrently, the index creation will get canceled if you cancel
the statement
Hey folks,
It seems like right now when you want to create an index concurrently, the
index creation will get canceled if you cancel the statement (i.e. you must
keep your statement open).
Is there a way to launch an index creation in the background so that the
statement doesn't need to be
Hi,
I was trying to create foreign key constraints on a sub-column of a
composite-type column, but couldn't find a way to do it. After asking around on
IRC, it seems like this isn't supported in PostgreSQL.
I wanted to do something like:
create type profile as (account_id integer);
On 6 mar, 22:44, and...@dunslane.net (Andrew Dunstan) wrote:
Holger Hoffstaette wrote:
On Fri, 06 Mar 2009 14:32:25 -0600, Kenneth Marshall wrote:
On Fri, Mar 06, 2009 at 02:58:30PM -0500, Andrew Dunstan wrote:
Yes, I discovered this a few weeks ago. [...]
Maybe someone can trace the
On 7 feb, 23:44, da...@fetter.org (David Fetter) wrote:
On Sat, Feb 07, 2009 at 10:44:48PM -0500, David Lee Lambert wrote:
In the same spirit as the FreeBSD-native UUID generator that was
discussed here a couple months ago, I was able to link Postgres 8.4
against the UUID generator
, there isn't a link-conflict issue that requires this;
it's just Another Way To Do It.
--
David Lee Lambert ... Software Developer, member IEEE, ACM
Cell phone: +1 586-873-8813
GPG key at http://www.lmert.com/keyring.txt
IM: davidleelambert (Yahoo!) or lambe...@cse.msu.edu (MSN)
--
Sent via
On Dec 17, 2:30 pm, Andrew Gierth and...@tao11.riddles.org.uk wrote:
Has anyone ever managed to get uuid generation working on FreeBSD? [...]
([...] The only solution I could come up with was to knock
off a quick uuid-freebsd module that uses the base system uuid
functions rather than the
it. I
guess an alternate path for single-table queries would be to randomly choose
a block number and then a tuple number; but that would be biased toward long
rows (of which fewer can appear in a block).
--
David Lee Lambert ... Software Developer
Cell phone: +1 586-873-8813 ; alt. email [EMAIL
end
up catching while trying to get his build-system for a new project running;
but it could certainly scare away someone with less experience. Better to
deal with this way ahead of time and test it on a few platforms.
--
David Lee Lambert ... Software Developer
Cell phone: +1 586-873-8813
have not tried this with my own C++ code, but it seems to have less
impact on the build process than some might have feared.
--
David Lee Lambert ... Software Developer
Cell phone: +1 586-873-8813 ; alt. email [EMAIL PROTECTED] or
[EMAIL PROTECTED]
GPG key at http://www.lmert.com/keyring.txt
12 matches
Mail list logo