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 ==
* 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
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
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.
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
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
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/
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
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
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
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
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
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
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
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
I have this EXPLAIN ANALYZE output:
alvherre=# explain analyze select * from oficina join ciudad using
(codciudad) where codtipoofi in (4,5);
QUERY PLAN
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
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
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
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 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
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
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();
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
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;
25 matches
Mail list logo
