Re: [GENERAL] problems on solaris 7

2001-08-26 Thread Justin Clift
Ouch... Did you definitely make sure it was doing the test with Unix Domain Sockets instead of via TCP (it's a search and replace, as per that Installation Guide)? If so, then the test results are accurate and it could be a problem. Regards and best wishes, Justin Clift Peter Lauko wrote: >

Re: [GENERAL] problems on solaris 7

2001-08-26 Thread Peter Lauko
YESSS, it seems to work now!!! Thank you very very much!!! (of course everyone who tried to help) only one thing: regression test fails at 2 points abstime ... FAILED random ... failed (ignored) the regression.diffs file looks: *** ./expected/abstime-solaris-1947.out

Re: [GENERAL] Re: MySQL's (false?) claims... (was: Re: PL/java?)

2001-08-26 Thread Digital Wokan
As strange as this may sound, I had to do a cross database query at my last job. It involved moving information from our e-commerce database into the accounting system database. While there may have been another way of handling it, this did allow me to handle the move solely within MSSQL and not

[GENERAL] Interaction Record (Journal Table?)

2001-08-26 Thread Clark C . Evans
I was thinking that for the application I'm working on, it'd be nice to have a journal (as an XML fragment) which describes the interactions within the database... 3493 Clark Evans Cameron I was wondering if anyone has done something simi

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-26 Thread Sam Tregar
On Sun, 26 Aug 2001, Peter Eisentraut wrote: > Many of these advantages can easily interpreted as disadvantages. For > example: Have you ever considered a career in marketting? > => In MySQL you have to repair your tables manually if corruption occurs. > PostgreSQL is coded so that corruption

Re: [GENERAL] embedded SQL cursos declare fails

2001-08-26 Thread Bruce Momjian
OK, I have backed out that patch. Would you review that section of the SGML and either commit a patch or send me one. Thanks. > On Fri, Aug 24, 2001 at 02:07:48PM -0400, Bruce Momjian wrote: > > OK, I have applied the following patch. Interestingly, the SGML code > > marked this block as out

Re: [GENERAL] speed of communication and pgsql development

2001-08-26 Thread Bruce Momjian
> On Sun, 26 Aug 2001, Lamar Owen wrote: > > > On Saturday 25 August 2001 23:34, Gowey, Geoffrey wrote: > > > Not to whine or anything, but I really do think that pgsql development > > > seriously could be helped by usage of an official irc channel. > > > > While chat is usable for some things, d

[GENERAL] raw partition

2001-08-26 Thread newsreader
While people are discussing mysql vs pg I wonder if anyone of the two support raw partition. If not is it on the todo list? ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Re: MySQL's (false?) claims... (was: Re: PL/java?)

2001-08-26 Thread Stephan Szabo
> >* You can access many databases from the same connection (depending of > >course on your privileges). > > > >=> PostgreSQL does not allow you to access more than one database per > >connection. This makes the system much safer and allows for more robust > >design. > > How does that makes thin

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-26 Thread Peter Eisentraut
Me writes: > > > > http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html > > Many of these advantages can easily interpreted as disadvantages. For > example: I hope people aren't taking that feature comparison page as seriously as they took my parody of it. -- Peter Eisentraut [

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-26 Thread Trond Eivind Glomsrød
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Justin Clift writes: > > > If anyone else can see things blatantly wrong on that page, email me > > about them and I'll ask Monty (the MySQL guy) to please > > change/remove/fix them. > > > > > http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_fe

Re: [GENERAL] Re: MySQL's (false?) claims... (was: Re: PL/java?)

2001-08-26 Thread Tom Lane
Lincoln Yeoh <[EMAIL PROTECTED]> writes: >> => PostgreSQL does not allow you to access more than one database per >> connection. This makes the system much safer and allows for more robust >> design. > How does that makes things safer etc etc? I believe that this is a genuine > limitation. It'

Re: [GENERAL] version 1 C-Language Functions

2001-08-26 Thread Francesco Casadei
On Sat, Aug 25, 2001 at 08:04:37PM -0400, Gowey, Geoffrey wrote: > What would the correct syntax be in order to do what I want to? I need to > enter in a variable length email address as the parameter to my planned > function. The param will then become part of a select statement to get > record

[GENERAL] Re: store in bytea

2001-08-26 Thread Lincoln Yeoh
At 09:28 AM 8/24/01 -0400, Tom Lane wrote: >"Ben-Nes Michael" <[EMAIL PROTECTED]> writes: >> On the theoretical issue, can I use TEXT field to store binary ? > >TEXT will not handle null (zero) bytes. If you are using a multibyte >character set, it will likely also do the wrong thing with byte >s

[GENERAL] Re: MySQL's (false?) claims... (was: Re: PL/java?)

2001-08-26 Thread Lincoln Yeoh
At 03:21 PM 8/26/01 +0200, Peter Eisentraut wrote: >* There are far moore books in print on MySQL than on PostgreSQL. >O'Reilly, Sams, Que, and New Riders are all major publishers with books >about MySQL. > >=> MySQL is so hard to understand and poorly documented, a plethora of >books had to come

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-26 Thread Peter Eisentraut
Justin Clift writes: > If anyone else can see things blatantly wrong on that page, email me > about them and I'll ask Monty (the MySQL guy) to please > change/remove/fix them. > > > http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html Many of these advantages can easily interpreted

[GENERAL] Re: problems on solaris 7

2001-08-26 Thread Mark kirkwood
Is using Solaris 8 an option ? Postgresql 7.1.1, 7.1.2 and 7.2dev all seem to run ok on this release of Solaris. ( I used the 64 bit enabled kernel and upped shmmax) regards Mark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe command

Re: [GENERAL] store in bytea

2001-08-26 Thread Ben-Nes Michael
Im using PHP4.6 > What are you using to develop? If perl, DBD::Pg will escape/unescape bytea > data after 0.98 version. (Unescaping is automatic, to escape, you need to > do bind(.., SQL_BINARY)). > > -alex > > On Fri, 24 Aug 2001, Ben-Nes Michael wrote: > > > But Ill have to add double slashes a

Re: [GENERAL] embedded SQL cursos declare fails

2001-08-26 Thread Michael Meskes
On Fri, Aug 24, 2001 at 02:07:48PM -0400, Bruce Momjian wrote: > OK, I have applied the following patch. Interestingly, the SGML code > marked this block as outdated, but didn't remove it for some reason. I'm afraid this patch is incorrect. > - Don't know why this is said. > - >

WAL and Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-26 Thread Dr. Evil
You guys shouldn't even be worrying about this. Five years from now, MySQL will be a much more mature product, but the way I see it now is this: MySQL: Great for message boards (Slashdot), information retrieval (an on-line phone directory that's mostly static), or other lightweight applications