[GENERAL] Another episode of the regular MySql-PostgreSQL war on Slashdot

As usual, a rather harmless article on Slashdot about MySql ("Major Changes To MySQL Coming Soon") turned into a flaming discussion about the different virtues of MySql and PostgreSQL. What strikes me is that this time the chief developer of MySql, Michael 'Monty' Widenius, had time available to

Re: [GENERAL] Ridicolus Postgresql review

Andrea Aime wrote: > If you want to get angry, take a look at: > http://www.iemagazine.com/010918/414feat3_1.shtml Seems that the article has been removed. I've sent a note to the editor, and he replied by asking if I wanted it published in the print edition, which I think will happen. -- Ales

[GENERAL] Re: personel appliactions?

Stan Brown wrote: > So, I was wandering if anyone knows wehre I could find a few small > applicationsUsing PostgreSQL as abckaends? I'm looking for. > > 1. CD/Music lirary management. gmmusic -- Alessio F. Bragadini[E

[GENERAL] News gateway down?

Hi, usually I track postgresql.org's lists using the Usenet news gateway at news.postgresql.org. Unfortunately, I haven't been able to connect to the server since Saturday. Is there any problem? Thanks. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://

[GENERAL] PostgreSQL packages for Debian potato

We have a number of client machines running Debian Linux, "potato" release (i.e. 2.2, latest stable). The provided PostgreSQL is release 6.5.3, but I managed to track changes in unstable ("woody") until 7.0.2, as long as packages were built using an older glibc. Now, unstable packages (of 7.0.3) a

Re: [GENERAL] 7.1beta4 initdb problem

Tim Barnard: > The program '/usr/local/pgsql/bin/postgres' needed by initdb does not belong to PostgreSQL version 7.1beta4. Check your installation. > Any ideas? Yes, happened to me, too. You need not to be root, but an unprivileged user (i.e. postgres). That's the strangest error message in

Re: [GENERAL] can't run on TCP/IP ports

Tom Lane wrote: > > I figured out the problem, postmaster when run as postgres didn't have > > write permissions to /var/run/postgresql directory (where the Debian > > version puts its socket files) and therefore didn't have permission to > > open the socket. . > > ROTFL ... score one for the De

Re: [GENERAL] Problems installing version 7.1beta4

Einar Karttunen wrote: > The program '/usr/local/pgsql/bin/postgres' needed by initdb does not > belong to > PostgreSQL version 7.1beta4. Check your installation. See previous thread. You must not run it as root. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services

[GENERAL] red hat/mysql fiasco

We should be nice and professional on holiday season but sorry, I couldn't help myself: at we can read "The MySQL packages shipped with Red Hat Linux 7 contained buggy assembler code. When compiled with optimization enabled, this code cause

Re: [GENERAL] Sequence value

Esa Pikkarainen wrote: > but unfortunately it did not solve my problem. Now I have no access > to the value of nextval('koe_pkey_id'). This query does not return > any recordset. Sorry, I didn't check this requirement. > Is it possible to embed Insert query as a subquery into a Select > query?

Re: [GENERAL] Sequence value

Esa Pikkarainen wrote: > SQL ="SELECT nextval('koe_pkey_id') as val; > INSERT INTO koe (id, name) values (val, 'uusi');" INSERT INTO koe (id, name) (SELECT nextval('koe_pkey_id'), 'uusi'); -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village

Re: [GENERAL] Problems with starting Postgres

Tom Lane wrote: > A plain kill (SIGTERM) should remove the socket file on its way out. > The only thing that wouldn't is kill -9 ... if you're doing it that > way, don't. The problem is an unexpected crash/reboot of the machine (which shouldn't happen, but...) that leaves socket files in /tmp an

Re: [GENERAL] Re: Large Objects

Neil Conway wrote: > > a BLOB. Conversely, Unix filesystems store directories as unsorted > > lists, which are a lot slower to search than the database's > > structured indexes. > Wow, can anyone confirm this (with Postgres preferrably)? In talking > with some developers at my old job, they all

Re: [GENERAL] Re: Slash on PostgreSQL mailing list

Christopher Smith wrote: > The better url i found is http://www.link.it/mailman/listinfo/slash-pgsql :) Sorry, ofcourse it's true, blame my tired mind. Thanks Alessio -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://www.sevenseas.org/~alessio Nicosia

[GENERAL] RDBMSs comparison (on Linux)

LinuxCare runs a comparison chart and poll about different databases available for Linux -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://www.sevensea

Re: [GENERAL] How do you live without OUTER joins?

Sarah Officer wrote: > How about using a union? > > select cc.com_cat_long, co.company_name > from company_category cc, company co > where cc.com_cat_abbr = co.com_cat_abbr > union > select 'unknown' as com_cat_long, company_name > from company > where com_cat_abbr is null; Yes, would be the be