[HACKERS] Anyone tried compiling postgresql with the Intel compilers?

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?

Re: [HACKERS] Hot spare PSQL server

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... Darren

Re: [HACKERS] MySQL development MUST immdediately cease - Due to

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?

Re: [HACKERS] triggers procedures listing URGENT

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

Re: [HACKERS] Major change to CVS effective immediately ...

* 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 tried

[HACKERS] slow UNIONing

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

[HACKERS] CVS access problem

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

Re: [HACKERS] CVS access problem

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

[HACKERS] Large objects and ecpg

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

Re: [HACKERS] x = NULL

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 gram.y

Re: [HACKERS] Beta time

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

Re: [HACKERS] x = NULL

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

Re: [HACKERS] slow UNIONing

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

Re: [HACKERS] CVS access problem

The location of the cvs repository recently changed. It is know accessible as :pserver:userid@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:

Re: [HACKERS] CVS access problem

The location of the cvs repository recently changed. It is know accessible as :pserver:userid@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

Re: [HACKERS] CVS access problem

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:userid@cvs.postgresql.org:/cvsroot Your commandline for an

Re: [HACKERS] Trans-transactions cursors

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 rows.

Re: [HACKERS] Major change to CVS effective immediately ...

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:

Re: [HACKERS] MySQL development MUST immdediately cease - Due to

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