>> 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?
>
s to be able to launch background concurrent
index creation via triggers.
--David
On Oct 28, 2012, at 2:35 PM, Kevin Grittner 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
Thanks. Is this something viable as a feature request?
On Oct 28, 2012 7:48 AM, "David Johnston" wrote:
> On Oct 27, 2012, at 19:20, David Lee wrote:
>
> > Hey folks,
> >
> > It seems like right now when you want to create an index concurrently,
> the in
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 k
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 tra
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
> > again
, 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)
--
On Dec 17, 2:30 pm, Andrew Gierth 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 ossp ones. I could put thi
t;feel"
for data. That always builds the unrandomized relation and then sorts 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).
--
that ended up not compiling.)
I still 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 PROTECT
me library.
Everything else is routine stuff that an experienced C++ developer would 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 pla
12 matches
Mail list logo
