Re: PostgreSQL or mySQL

2006-07-03 Thread Karl Larsen
Chris White wrote: On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote: I have very little knowledge of either PostgreeSQL or mySQL. Please advise me as to which of these two software package to use? I need some specific examples as to superiority of one package over the other. I prefer usi

Re: PostgreSQL or mySQL

2006-07-03 Thread John Meyer
Chris White wrote: On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote: I have very little knowledge of either PostgreeSQL or mySQL. Please advise me as to which of these two software package to use? I need some specific examples as to superiority of one package over the other. I prefer using

Re: PostgreSQL or mySQL

2006-07-03 Thread Chris White
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote: > I have very little knowledge of either PostgreeSQL or mySQL. Please advise > me as to which of these two software package to use? I need some specific > examples as to superiority of one package over the other. I prefer using > the package wh

Re: PostgreSQL

2002-02-13 Thread David Steinbrunner
Shankar Unni writes: >And one big reason not: no native Windows port. Or Mac port (though that >has probably changed with OS/X - anyone working on that?). Here is an unofficial install package of the new PostgreSQL 7.2: http://www.entropy.ch/software/macosx/postgresql/ You can get an unofficial

Re: PostgreSQL

2002-02-13 Thread Shankar Unni
Sinisa Milivojevic wrote: > Shankar Unni writes: >>And one big reason not: no native Windows port. Or Mac port (though that >>has probably changed with OS/X - anyone working on that?). > When you are saying that there is no native Windows or OS X port, what > were you referring to ?? Oh, P

Re: PostgreSQL

2002-02-12 Thread Dibo Chen
The list seems having some problems. I've rereceived many emails, like this one, which were sent via the list last week!! Anyone else has the same problem? Trond Eivind Glomsrød wrote: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > Anyone know the difference between MySQL and PostgreSQL

Re: PostgreSQL

2002-02-12 Thread John Cichy
riginal Message- > > From: [EMAIL PROTECTED]=20 > > [mailto:[EMAIL PROTECTED]] On Behalf Of Trond=20 > > Eivind Glomsr=F8d > > Sent: Wednesday, February 06, 2002 12:10 PM > > To: Sinisa Milivojevic > > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subje

Re: PostgreSQL

2002-02-12 Thread Michael Widenius
Hi! > "Sinisa" =3D=3D Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsr=F8d writes: >> Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >>=20 >> There is a slight difference between advanced, non-standardized >> tuning/backup/load-balancing like that and core SQL func

Re: PostgreSQL

2002-02-12 Thread Sinisa Milivojevic
Shankar Unni writes: > > > And one big reason not: no native Windows port. Or Mac port (though that > has probably changed with OS/X - anyone working on that?). > > Cygwin is dandy, but I definitely don't trust a database that uses cygwin > as an emulation layer underneath for basic file acce

Re: PostgreSQL

2002-02-12 Thread Michael Widenius
Hi! > "Sinisa" =3D=3D Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsr=F8d writes: >> "Vernon A Webb" <[EMAIL PROTECTED]> writes: >>=20 >> > Anyone know the difference between MySQL and PostgreSQL?=20 >>=20 >> PostgreSQL has a lot of features MySQL don't have yet (

Re: PostgreSQL

2002-02-12 Thread Trond Eivind Glomsrød
"Vernon A Webb" <[EMAIL PROTECTED]> writes: > Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big l

RE: PostgreSQL

2002-02-12 Thread Alok K. Dhir
: Sinisa Milivojevic > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: PostgreSQL >=20 >=20 > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: >=20 > > Trond Eivind Glomsr=F8d writes: > > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > >=20

Re: PostgreSQL

2002-02-12 Thread Sinisa Milivojevic
Trond Eivind Glomsr=F8d writes: > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: >=20 > I said "everywhere" - you need to use Innobase to get foreign keys, a= nd=20 > innobase/db3 to get transactions. >=20 > --=20 > Trond Eivind Glomsr=F8d > Red Hat, Inc. >=20 >=20 As EVERY binary and source we d

Re: PostgreSQL

2002-02-12 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > > It's enabled in the MySQL rpms we distribute as part of RHL as well, but > > it's not the default type for created tables. Thus, most people won't be > > usi

Re: PostgreSQL

2002-02-11 Thread Jeremy Zawodny
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > PostgreSQL has a lot of features MySQL don't have yet (transactions > >

Re: PostgreSQL

2002-02-11 Thread Sinisa Milivojevic
Trond Eivind Glomsr=F8d writes: > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >=20 > There is a slight difference between advanced, non-standardized > tuning/backup/load-balancing like that and core SQL functionality not= > being present. >=20 > --=20 > Trond Eivind Glomsr=F8d > Red Hat, Inc.

Re: PostgreSQL

2002-02-11 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > > There is a slight difference between advanced, non-standardized > > tuning/backup/load-balancing like that and core SQL functionality not > > being present. >

RE: PostgreSQL

2002-02-11 Thread Alok K. Dhir
to choose PostgreSQL - subselects, triggers, user defined types, etc. > -Original Message- > From: [EMAIL PROTECTED]=20 > [mailto:[EMAIL PROTECTED]] On Behalf Of Trond=20 > Eivind Glomsr=F8d > Sent: Wednesday, February 06, 2002 3:15 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTE

Re: PostgreSQL

2002-02-10 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsrød writes: >> Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> >> There is a slight difference between advanced, non-standardized >> tuning/backup/load-balancing like that and core SQL functionalit

Re: PostgreSQL

2002-02-10 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsrød writes: >> "Vernon A Webb" <[EMAIL PROTECTED]> writes: >> >> > Anyone know the difference between MySQL and PostgreSQL? >> >> PostgreSQL has a lot of features MySQL don't have yet (transactions

Re: PostgreSQL

2002-02-07 Thread David Steinbrunner
Shankar Unni writes: >And one big reason not: no native Windows port. Or Mac port (though that >has probably changed with OS/X - anyone working on that?). Here is an unofficial install package of the new PostgreSQL 7.2: http://www.entropy.ch/software/macosx/postgresql/ You can get an unofficial

Re: PostgreSQL

2002-02-07 Thread Shankar Unni
Sinisa Milivojevic wrote: > Shankar Unni writes: >>And one big reason not: no native Windows port. Or Mac port (though that >>has probably changed with OS/X - anyone working on that?). > When you are saying that there is no native Windows or OS X port, what > were you referring to ?? Oh, P

Re: PostgreSQL

2002-02-07 Thread Sinisa Milivojevic
Shankar Unni writes: > > > And one big reason not: no native Windows port. Or Mac port (though that > has probably changed with OS/X - anyone working on that?). > > Cygwin is dandy, but I definitely don't trust a database that uses cygwin > as an emulation layer underneath for basic file acce

Re: PostgreSQL

2002-02-06 Thread Shankar Unni
Alok K. Dhir wrote: > That said, depending on your requirements, there are still compelling > reasons to choose PostgreSQL - subselects, triggers, user defined types, > etc. And one big reason not: no native Windows port. Or Mac port (though that has probably changed with OS/X - anyone working

RE: PostgreSQL

2002-02-06 Thread Alok K. Dhir
to choose PostgreSQL - subselects, triggers, user defined types, etc. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Trond > Eivind Glomsrød > Sent: Wednesday, February 06, 2002 3:15 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]

Re: PostgreSQL

2002-02-06 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > > There is a slight difference between advanced, non-standardized > > tuning/backup/load-balancing like that and core SQL functionality not > > being present. >

Re: PostgreSQL

2002-02-06 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > There is a slight difference between advanced, non-standardized > tuning/backup/load-balancing like that and core SQL functionality not > being present. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > This dep

Re: PostgreSQL

2002-02-06 Thread Trond Eivind Glomsrød
Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > > It's enabled in the MySQL rpms we distribute as part of RHL as well, but > > it's not the default type for created tables. Thus, most people won't be > > usi

Re: PostgreSQL

2002-02-06 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > It's enabled in the MySQL rpms we distribute as part of RHL as well, but > it's not the default type for created tables. Thus, most people won't be > using it. If memory serves, you need to set various options in

Re: PostgreSQL

2002-02-06 Thread Trond Eivind Glomsrød
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > > I said "everywhere" - you need to use Innobase to get foreign keys, and > > innobase/db3 to get transactions. > > As EVERY binary and source we distribute ha

Re: PostgreSQL

2002-02-06 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > I said "everywhere" - you need to use Innobase to get foreign keys, and > innobase/db3 to get transactions. > > -- > Trond Eivind Glomsrød > Red Hat, Inc. > > As EVERY binary and source we distribute has Inno

RE: PostgreSQL

2002-02-06 Thread Alok K. Dhir
ilivojevic > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: PostgreSQL > > > On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > > > Trond Eivind Glomsrød writes: > > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > >

Re: PostgreSQL

2002-02-06 Thread Jeremy Zawodny
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > PostgreSQL has a lot of features MySQL don't have yet (transactions > >

Re: PostgreSQL

2002-02-06 Thread Trond Eivind Glomsrød
On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: > Trond Eivind Glomsrød writes: > > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > > > Anyone know the difference between MySQL and PostgreSQL? > > > > PostgreSQL has a lot of features MySQL don't have yet (transactions > > everywhere, foreign k

Re: PostgreSQL

2002-02-06 Thread Sinisa Milivojevic
Trond Eivind Glomsrød writes: > "Vernon A Webb" <[EMAIL PROTECTED]> writes: > > > Anyone know the difference between MySQL and PostgreSQL? > > PostgreSQL has a lot of features MySQL don't have yet (transactions > everywhere, foreign keys, subselects, stored procedures, triggers, > etc), while M

Re: PostgreSQL

2002-02-06 Thread Trond Eivind Glomsrød
"Vernon A Webb" <[EMAIL PROTECTED]> writes: > Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big l

Re: PostgreSQL

2002-02-06 Thread Zak Greant
On Wed, 2002-02-06 at 07:59, Vernon A Webb wrote: > Hey All! > > Anyone know the difference between MySQL and PostgreSQL? > Are the both pretty much the same? So far I like MySQL, but > find that MS SQL is far greater, but only because it has > much more. Anyone have any comments on the matter

RE: PostgreSQL

2002-02-06 Thread Daniel Backhausen
Hi. No, Postgres has much more. The biggest point is, that it has Subselects ! But mySQL seems to be much faster in some points. That´s all I want to tell :) Greetz Daniel -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 3:59 PM To:

Re: PostgreSQL to MySQL

2001-10-05 Thread Ken Menzel
Hi Jani and Owen, Owen if you are dumping the data using pg_dump, I think I may be able to help. First suggestion is to dump the data and the data schema separetly. use, for schema: pg_dump -sxnc -f/tmp/schema.dump databasename for data: pg_dump -qxnd -f/tmp/data.dump databasename The data