On Wed, 2004-11-24 at 12:52, Neil Conway wrote:
> Bruce Momjian wrote:
> > I thought the new readers will sit after the writer in the FIFO queue so
> > the writer will not starve.
>
> AFAICS, that is not the case. See lwlock.c, circa line 264: in LW_SHARED
> mode, we check if "exclusive" is zero;
ElayaRaja S wrote:
Hi,
While configuring OpenCRX by using Postgresql i am facing probmelm.
The problem while creating db using the command ( createdb -h
localhost -E utf8 -U system crx-CRX ) .
Erro:
createdb: could not connect to database template1: could not connect
to server:
Connection refu
db=# CREATE FUNCTION schma.tbl_ins_upd() RETURNS TRIGGER AS 'BEGIN
EXECUTE public.mc_init();
EXECUTE public.mc_delete(''mc_key'');
RETURN NEW;
END;' LANGUAGE 'plpgsql';
db=# CREATE FUNCTION schma.tbl_del() RETURNS TRIGGER AS 'BEGIN
EXECUTE public.mc_init();
Simon Riggs wrote:
I'd been thinking about lock release order also, thinking that this
could be related to the CS storms observed earlier and the apparent
lock-step behaviour commented upon previously.
As much as I would love to believe this (because it would mean we could
probably solve the probl
On Thu, 2004-11-25 at 11:28, Neil Conway wrote:
> Simon Riggs wrote:
> > I'd been thinking about lock release order also, thinking that this
> > could be related to the CS storms observed earlier and the apparent
> > lock-step behaviour commented upon previously.
>
> As much as I would love to bel
I'm trying to compile beta5 on osx 10.3.6
without success, I have XCode 1.5 installed.
Could you please give me instructions?
I have readline installed from fink.
Bison is there from Apple.
This is from the Terminal.app:
~/Desktop/postgresql-8.0.0beta5 (alpha) ./configure
--bindir=/usr/local/bin -
On Wed, Nov 24, 2004 at 11:28:31AM -0600, Gavin M. Roy wrote:
> To a degree you are correct. AFAIK new downloads could not start if the
> tracker crashed. The tracker is the traffic cop that tells peer nodes
> about each other. I dont believe the tracker that comes from the main
> bit torrent
You shouldn't need to edit configure. I compiled 8.0b5 on 10.3.6 with no
problems yesterday
I am no expert, but this error seems to have come up on other platforms...
Here was the response in the mailing lists before
http://archives.postgresql.org/pgsql-ports/2004-07/msg1.php
You may also w
After some pretty tedious assembly debugging I've managed to locate the
source of my problem. It is probably similar to a bug involving
MemoryContext life cycle on IMMUTABLE functions that I struggled with
last winter (later fixed by Tom).
This is what happens:
I have an function declared as IM
I have this EXPLAIN ANALYZE output:
alvherre=# explain analyze select * from oficina join ciudad using
(codciudad) where codtipoofi in (4,5);
QUERY PLAN
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> What life span does the context->multi_call_memory_context have in case
> of IMMUTABLE functions that returns SETOF?
It should be long enough. What's your test case exactly?
regards, tom lane
---(end
Tom Lane wrote:
What life span does the context->multi_call_memory_context have in case
of IMMUTABLE functions that returns SETOF?
It should be long enough. What's your test case exactly?
It's my PL/Java test framework that fails so it's a bit complex but if
I'm right, any immutable, set
Will Arp <[EMAIL PROTECTED]> writes:
> checking whether the C compiler works... configure: error: cannot run C
> compiled programs.
You need to fix the problem, not rip out the configure test that told
you there was a problem.
It would be useful to look at the portion of config.log that records
On Monday 22 November 2004 14:33, vertigo wrote:
> Hello
> I need to "pg_dump" my database, but i want only to receive sql commands
> which will insert row which were inserted into database today. Is there
> any way to do it ?
> I have large database and i want to make "incremential backups".
>
Da
Thomas Hallgren <[EMAIL PROTECTED]> writes:
> It's my PL/Java test framework that fails so it's a bit complex but if
> I'm right, any immutable, set-returning function that allocates stuff in
> multi_call_memory_context at first call and then reused it, should show
> the same problem.
Well, you
Tom Lane <[EMAIL PROTECTED]> writes:
> This query would invoke the following code in int4div:
>
> if (arg2 == 0)
> ereport(ERROR,
> (errcode(ERRCODE_DIVISION_BY_ZERO),
> errmsg("division by zero")));
>
> result = arg1 / arg2;
>
> I suggest direc
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I have this EXPLAIN ANALYZE output:
> ...
>-> Hash (cost=13.99..13.99 rows=499 width=89) (actual time=5.947..5.947
> rows=0 loops=1)
> -> Seq Scan on ciudad (cost=0.00..13.99 rows=499 width=89) (actual
> time=0.018..3.909 rows=499 loop
Will Arp <[EMAIL PROTECTED]> writes:
> please find attached the config.log
configure:2008: checking for C compiler default output
configure:2011: gccconftest.c >&5
configure:2014: $? = 0
configure:2047: result: [31ma.out[m[m
configure:2052: checking whether the C compiler works
configure:2
Tom Lane wrote:
Well, you're not right ...
That's true. This time it was my own fault altogether I'm afraid.
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/
I've several times wanted a way to add multiple select output columns using a
single expression. A typical scenario would be if the columns come from a
subselect from another table where repeating the subselect means slow
performance as well as awkward and repetitive code.
Sometimes the subselect
I've several times wanted a way to add multiple select output columns
using a
single expression. A typical scenario would be if the columns come
from a
subselect from another table where repeating the subselect means slow
performance as well as awkward and repetitive code.
Sometimes the subselec
Thomas Hallgren wrote:
Gaetano Mendola wrote:
...so the very first client is the real server
that must be run 24/24.
I don't think this is correct. You need a tracker for downloaders to be
able to find each other but no client is more important than the others.
I'm sorry to say that you're wrong.
Hello, Francisco Figueiredo Jr.
yes, I'd like to. Thank you for talking with you. ^_^
>H, could you add a feature request in Npgsql project?
>
>This feature may be helpful for other users who are porting their apps
>to postgresql :)
>
>Also, if possible, please add a simple test case with th
* Marc G. Fournier ([EMAIL PROTECTED]) wrote:
> we're not talking load issues this time ... the way I understand it,
> bittorrent has a 'tracker' process that only one can be running on the "BT
> Distributed Network" at once ... so, if the bt "central server" goes down,
> the whole bt network go
following is only program fragment, original program structure is from sample
named Duwamish in ms vs.net 2002.
/
private const String ID_PARM= "@id";
private const String NAME_PARM = "@name";
public UserData GetUserById(int id)
{
if ( dataAdapter ==
25 matches
Mail list logo
