On Lun 17 Sep 2001 23:28, Christopher Kings-Lynne wrote:
> Would it be an idea to add timestamps to the PostgreSQL error/debug/notice
> log?
>
> Sometimes I would really like to know when an event has occurred!
Use syslog and you'll get timestamps in your log.
Saludos... :-)
--
Porqué usar una
> 1. Should not "break" out of loop over indexes after detecting a
> matching non-primary-key index. This allows detection of the NOTICE
> condition to distract you from detecting the ERROR condition on a
> later index. I'd suggest issuing the NOTICE inside the loop, actually,
> and not breaking
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Attached is the CONSTR_PRIMARY switch block from command.c. I've marked the
> problem test with '@@'.
Hmmm this code has got a number of problems, but I don't see why
*that* would fail. Anyone?
What I do see:
1. Should not "break" o
Attached is the CONSTR_PRIMARY switch block from command.c. I've marked the
problem test with '@@'.
Basically the patch all seems to work properly, except that it doesn't
recognise existing primarty keys. ie. You can go ALTER TABLE test ADD
PRIMARY KEY(a) multiple times and it will keep adding
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I'm getting tired of this, so unless someone can present a reason not to,
> I'll implement a GUC parameter to turn this off -- and turn it off by
> default.
You'll have to push the switch-driven transformation into analyze.c ---
it is not okay for gr
Kovacs,
A 'union all' will be much faster than 'union'. 'union all' returns all
results from both queries, whereas 'union' will return all distinct
records. The 'union' requires a sort and a merge to remove the
duplicate values. Below are explain output for a union query and a
union all q
I'm getting tired of this, so unless someone can present a reason not to,
I'll implement a GUC parameter to turn this off -- and turn it off by
default.
I wrote:
> The x = NULL hack keeps biting people. Innocent people should not be
> exposed to incorrect behaviour because of (supposed) MS Acce
Hi all,
Can I use ecpg with large objects? All examples in documentation are for
libpq.
Thanks
Shridhar
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---(end of broadcast)-
"Marc G. Fournier" wrote:
>
> anoncvs.postgresql.org, not cvs.postgresql.org ... Arne posted the wrong
> one :(
Whoops! I'm sorry, I overlooked that!
Arne Weiner.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an a
I'm following the instructions on the web site which say's:
---
Do an initial login to the CVS server:
$ cvs -d :pserver:[EMAIL PROTECTED]:/home/projects/pgsql/cvsroot login
You will be prompted for a password; enter 'postgresql'. You shoul
I experienced that UNIONs in 7.1.1 are rather slow:
tir=# explain (select nev from cikk) union (select tevekenyseg from log);
NOTICE: QUERY PLAN:
Unique (cost=667.63..687.18 rows=782 width=12)
-> Sort (cost=667.63..667.63 rows=7817 width=12)
-> Append (cost=0.00..162.17 rows=7817
* "Marc G. Fournier" <[EMAIL PROTECTED]> wrote:
|
| anoncvs.postgresql.org is going to be out of sync until, most likely,
| tomorrow, for anyone trying to use that ... anoncvs is *no longer*
| available through the main cvs repository either ...
Is anoncvs.postgresql.org working yet ?
I just tr
To whoever sent this posting (being Al Dev, or someone spoofing),
Please stop posting to the PostgreSQL mailing lists.
You are not helping PostgreSQL with your postings, instead you are
inciting anger and hostility.
Cease and desist these postings immediately.
Justin Clift
peace_flower wrot
Thus spake Marc G. Fournier
> This will most likely screw some ppl up, and fix others ...
>
> CVSROOT has now moved to the new machine, finally ... and I've cleaned up
> pathing ... and CVS_RSH=ssh now works again too ...
>
> So, now CVSROOT is accessible as:
>
> :pserver:@cvs.postgresql.org:/c
anoncvs.postgresql.org, not cvs.postgresql.org ... Arne posted the wrong
one :(
On Tue, 18 Sep 2001, Christopher Kings-Lynne wrote:
> > The location of the cvs repository recently changed. It is know
> > accessible as
> >
> > :pserver:@cvs.postgresql.org:/cvsroot
> >
> > Your commandline f
Chamanya wrote:
> I am currently building a small web based app, with postgres as back end. I
> found that in ecpg you can declare and use cursor without declaring a
> transaction. In several places I have used cursors for selects only. That's
> the only way I found to make ecpg fetch multiple ro
Within psql
examine the system tables
pg_proc
pg_trigger
Refer to the documentation
Chapter System Catalogs
Regards, Christoph
PS
I was sending this mail yesterday
to '[EMAIL PROTECTED]'
but it seemed to disappear,
at least I did not get it back.
Has anybody experienced similar effects
> The location of the cvs repository recently changed. It is know
> accessible as
>
> :pserver:@cvs.postgresql.org:/cvsroot
>
> Your commandline for an initial login should be:
>
> $ cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login
>
> Arne Weiner.
I'm trying that exact command line a
The location of the cvs repository recently changed. It is know
accessible as
:pserver:@cvs.postgresql.org:/cvsroot
Your commandline for an initial login should be:
$ cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login
Arne Weiner.
"news.grapid1.mi.home.com" wrote:
>
>
> "Darren" == Darren Johnson <[EMAIL PROTECTED]> writes:
>> Unfortunatly this seems to be asynchronous replication (you
>> manually have to initiate the syncronization)... I'd like to
>> have synchronous replication...
Darren> There is a synchronous replication project here.
I agree.
This mailing list is not a forum to express
aversions to other software products,
no matter how justified these aversions are.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/
Hi has anyone tried Intel's compiler yet?
http://developer.intel.com/software/products/eval/
Just wondering what would happen.
Cheerio,
Link.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lo
22 matches
Mail list logo
