Is there any penalty for repeatedly doing
SAVEPOINT eugene
without a corresponding
RELEASE SAVEPOINT
?
In my case, I have a table with a unique index constraint. Multiple
processes will be trying to "create or lookup" a record, so trapping the
unique index constraint seems the most robus
http://www.infoworld.com/d/open-source-software/the-stealth-success-of-postgresql-197584
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Adrian Klaver wrote:
>On 07/05/2012 07:46 AM, Stefan Schwarzer wrote:
>>> Now, when I launch a query which includes "crosstab()" as a postgres
>>> user, everything works fine. However, if I launch it as user XXX, it
>>> complaints:
>
The search path is indicated as:
On Sat, Jul 14, 2012 at 2:40 AM, Mike Christensen wrote:
> Wait, are you suggesting Olive Garden doesn't *actually* offer
> unlimited breadsticks?
I'm not American, and have only been to Olive Garden once (visited
your country and tried to cram way way too much into not nearly enough
time), so I
On Fri, Jul 13, 2012 at 12:05 AM, Chris Angelico wrote:
> On Fri, Jul 13, 2012 at 4:14 AM, Bartosz Dmytrak wrote:
>> I think there should be an explanation what *unlimited* really means.
>>
>
> Unlimited doesn't mean you can have infinite of something, but just
> that that specific attribute does
Hi, I'm trying to setup plpython on my machine but get message :
[WARNING ] CREATE EXTENSION plpythonu
ERREUR: n'a pas pu accéder au fichier « $libdir/plpython2 » : No
such file or directory
In libdir I only get plpython3.dll
depends22_x86
tells me it relies on python32.dl
there is no log, only thing which is left after failed installation
attempt is %TEMP%\postgresql_installer\
with following files:
http://gyazo.com/01c378f7c55c876f937ca3798b255d37.png?1342165847
On Fri, Jul 13, 2012 at 9:44 AM, Sachin Srivastava
wrote:
> Could you see anything wrong in the instal
HI,
El viernes, 2 de julio de 2010 10:26:43 UTC-3, (desconocido) escribió:
> Hello,
>
> I've got a problem with Functions in C using SPI.
>
> Using: PostgreSQL 8.3, Codeblocks, Windows Server 2003 R2
>
> I compiled the file "pgExampleSPI.c" with the following code
> without any error:
>
> /*
Also this may be a bit more than you asked for but I just put up a blog
entry a couple days going through CTE's generally and how we use them in
LedgerSMB. You might find it helpful.
http://ledgersmbdev.blogspot.com/2012/07/ctes-and-ledgersmb.html
Best Wishes,
Chris Travers
> not being an expert for Postgres…. I have a Postgis table with the countries
> of the world. Now, I would like to drop it. I got the error message:
>
> ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
>
> and thought that it would be easier
great,
many thanks for the excellent blog entry.
Marc Mamin
> -Original Message-
> From: dep...@depesz.com [mailto:dep...@depesz.com]
> Sent: Freitag, 13. Juli 2012 12:52
> To: Marc Mamin
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] WITH RECURSIVE question
>
> On Fri, Ju
On Fri, Jul 13, 2012 at 12:20:44PM +0200, Marc Mamin wrote:
> But How can I retrieve the complete structure in one query ?
> do I have to use a procedure for that ?
>
> Something like :
>
> WITH FOR_EACH (node) AS ( SELECT node from forest where parent IS NULL)
> SELECT * FROM (
> WITH RECURSIV
Marc Mamin wrote:
> WITH RECURSIVE struc (pref, id, depth ) AS (
> SELECT '', node, 1 from forest where node= 4
> UNION ALL
> SELECT (case when struc.pref= '' then '\' else struc.pref end )||
> '...' ,
> node,
> struc.depth +1
> FROM forest JOIN struc ON parent=struc.id
Hello,
WITH RECURSIVE queries are quite new for me, so I'm not sure if
following is possible
CREATE TEMP TABLE forest (node int,parent int);
INSERT INTO forest VALUES
(1, null),
(2, 1),
(3, 2),
(4, null),
(5, 4),
(6,5);
WITH RECURSIVE struc (pref, id, depth ) AS (
SELECT '', node, 1 from
On 07/13/2012 02:15 PM, Sergey Konoplev wrote:
On Fri, Jul 13, 2012 at 9:51 AM, Craig Ringer
wrote:
... but it feels like there must be a smarter way.
Well, may be kind of (h1 - h2), (h2 - h1) and derivatives will make sense?
I apparently have the reading skills of a stoned mole, as I comp
On Fri, Jul 13, 2012 at 4:14 AM, Bartosz Dmytrak wrote:
> I think there should be an explanation what *unlimited* really means.
>
Unlimited doesn't mean you can have infinite of something, but just
that that specific attribute doesn't have its own limit. For instance,
if I fly to England, I am al
16 matches
Mail list logo
