Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
On Friday 25 June 2010 02:23:17 Iwao Shikase wrote:
Hi Roeleveld-san,
Thank you for your advice. But My purpose is to test PostgreSQL
which data cluster is in NFS server.
As your says, Cluster Filesystem is one of answer of sharing files.
But my company still want to use NFS server. So I
On Fri, Jun 25, 2010 at 12:04 AM, Wang, Mary Y mary.y.w...@boeing.com wrote:
Hi,
I'm trying to find some write-ups about the differences between Postgres and
MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
There are features, are there not, that Postgres has that MySQL does
not have?
I refer in particular to things like tsvector.
Am I mistaken in this?
John
On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
unless there was a specific reason to migrate
--
Sent via pgsql-general mailing
On Fri, Jun 25, 2010 at 1:22 AM, John Gage jsmg...@numericable.fr wrote:
There are features, are there not, that Postgres has that MySQL does not
have?
I refer in particular to things like tsvector.
Am I mistaken in this?
John
On Jun 25, 2010, at 3:46 AM, Rob Wultsch wrote:
unless
On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wult...@gmail.com wrote:
MySQL has several full text search solutions. The built in MyISAM
solution is the best known, but there is also an engine for using
sphinx.
...
And there are features that MySQL has that PG does not. Index only
queries
On 25 June 2010 09:44, Dave Page dp...@pgadmin.org wrote:
On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wult...@gmail.com wrote:
MySQL has several full text search solutions. The built in MyISAM
solution is the best known, but there is also an engine for using
sphinx.
...
And there are
On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown thombr...@gmail.com wrote:
Didn't PostgreSQL used to have more than 1 storage engine in the past?
I thought I read somewhere it did, but it was decided it was a
compromise on stability and/or quality, so ended up using a single
kick-ass engine?
Forgive me for being somewhat stupid, but is MyISAM a text search
engine? The Wikipedia article doesn't make it sound like one.
Could you be more specific as to how, for example, MySQL implements
regular expressions or the tsvector funcitionality?
John
On Jun 25, 2010, at 10:33 AM, Rob
In response to Dave Page :
On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown thombr...@gmail.com wrote:
Didn't PostgreSQL used to have more than 1 storage engine in the past?
I thought I read somewhere it did, but it was decided it was a
compromise on stability and/or quality, so ended up
Hi List,
Thanks for this great product.
We have a database with many schema's and we are trying to migrate the db from
version 8.1.9 to 8.3.8.
So we made a pg_dumpall.
Now, when we try to restore with psql, we get loads of errors and warnings:
PROBLEM 1
In response to John Gage :
Forgive me for being somewhat stupid, but is MyISAM a text search
engine? The Wikipedia article doesn't make it sound like one.
MyISAM provides textsearch and other features, but no referential
integrity. It's just one of many storage engines.
Could you be more
On Fri, Jun 25, 2010 at 10:22 AM, A. Kretschmer
andreas.kretsch...@schollglas.com wrote:
In response to Dave Page :
On Fri, Jun 25, 2010 at 9:52 AM, Thom Brown thombr...@gmail.com wrote:
Didn't PostgreSQL used to have more than 1 storage engine in the past?
I thought I read somewhere it
In the words of Dwight Eisenhower, I couldn't fail to disagree with
you less. That said...
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please
On 25 June 2010 10:50, John Gage jsmg...@numericable.fr wrote:
In the words of Dwight Eisenhower, I couldn't fail to disagree with you
less. That said...
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
John Gage, 25.06.2010 11:50:
Replying to my own post, and on further examination of the MySQL
documentation, I am astonished to discover that MySQL does not support
regular expressions much less something like tsvector. Please disabuse
me of this idea if I am mistaken.
Getting really off-topic
Disabused.
On Jun 25, 2010, at 11:59 AM, Thomas Kellerer wrote:
Getting really off-topic now: but MySQL does support Regex
http://dev.mysql.com/doc/refman/5.1/en/regexp.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Fri, Jun 25, 2010 at 4:22 AM, John Gage jsmg...@numericable.fr wrote:
There are features, are there not, that Postgres has that MySQL does not
have?
My favorite pgsql feature is partial and functional indexes. For
instance, let's say you have a work queue, and in it you have a boole
called
On 25 Jun 2010, at 10:54, Dick Kniep wrote:
Hi List,
Thanks for this great product.
We have a database with many schema's and we are trying to migrate the db
from version 8.1.9 to 8.3.8.
So we made a pg_dumpall.
Using which version? The one that came with 8.3? I'm suspecting that
On Fri, Jun 25, 2010 at 7:58 AM, Scott Marlowe scott.marl...@gmail.com wrote:
This shows several things about the MySQL release philosophy, at least
at the time. 1: Introducing performance enhancments without thorough
testing in a production release is A-OK. 2: The fix may or may not
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 and
plan to watch a
Hello!
I have user-defined procedure (C procedure) realised in dll
('c_some_text_dll'). It is called in the following way:
1. CREATE OR REPLACE FUNCTION app_text () RETURNS text AS
'$libdir/c_some_text_dll', 'getTextValueFromApplication'
LANGUAGE 'c' VOLATILE RETURNS NULL ON NULL INPUT SECURITY
On Fri, Jun 25, 2010 at 6:58 AM, Scott Marlowe scott.marl...@gmail.comwrote:
Biggest difference between MySQL and PostgreSQL? The developers.
I like that... It has a nice ring to it.
Thomas Kellerer, 25.06.2010 14:32:
Wang, Mary Y, 25.06.2010 01:04:
Hi,
I'm trying to find some write-ups about the differences between Postgres
and MySql. A lot of stuff showed up on Google, but most of them are old.
I saw this wiki over here
Thank you all for the responses. I got a requirement from my boss that I
need to give read only access to only tables , so that users can write some
queries. At that time, he also mentioned that the users should not see the
code. I read the document , but not able to figure out how to do that and
Dave Page dp...@pgadmin.org writes:
Hmm, I think I misread Thom's question. The smgr API used to be far
more rigidly designed as I understand it, to allow the possibility of
having different storage engines (for example, maybe one that used raw
devices). I don't know that any other storage
Remove me from your email chain.
Date: Fri, 25 Jun 2010 10:44:34 +0100
Subject: Re: [GENERAL] Need Some Recent Information on the Differences
between Postgres and MySql
From: dp...@pgadmin.org
To: andreas.kretsch...@schollglas.com
CC: pgsql-general@postgresql.org
On Fri, Jun 25, 2010
Remove me from your email chain!
Date: Fri, 25 Jun 2010 08:13:36 -0400
Subject: Re: [GENERAL] Need Some Recent Information on the Differences
between Postgres and MySql
From: scott.marl...@gmail.com
To: jsmg...@numericable.fr
CC: wult...@gmail.com; mary.y.w...@boeing.com;
On Fri, Jun 25, 2010 at 2:02 PM, Jim Montgomery monty1...@hotmail.com wrote:
Remove me from your email chain.
You need to unsubscribe from the mailing list. Until now your weren't
explicitly included on any of the messages that I can see.
http://www.postgresql.org/community/lists/
--
Dave
Hi,
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say use name_database on postgre sql?
Thanks in advance 4 the help!!
--
View this
Remove me from your email chain.
Date: Thu, 24 Jun 2010 21:57:15 -0400
Subject: Re: [GENERAL] Need Some Recent Information on the Differences
between Postgres and MySql
From: scott.marl...@gmail.com
To: wult...@gmail.com
CC: mary.y.w...@boeing.com; pgsql-general@postgresql.org
On Thu,
On Thu, Jun 24, 2010 at 10:03 PM, Jim Montgomery monty1...@hotmail.com wrote:
Remove me from your email chain.
Remove yourself.
--
Rob Wultsch
wult...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi List,
Thanks for this great product.
We have a database with many schema's and we are trying to migrate the db from
version 8.1.9 to 8.3.8.
So we made a pg_dumpall.
Now, when we try to restore with psql, we get loads of errors and warnings:
PROBLEM 1
On Fri, Jun 25, 2010 at 7:10 AM, javijava welove.e.mu...@gmail.com wrote:
Hi,
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say use
javijava welove.e.mu...@gmail.com wrote:
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say use name_database on postgre sql?
You must
Scott Marlowe scott.marl...@gmail.com writes:
On Fri, Jun 25, 2010 at 7:10 AM, javijava welove.e.mu...@gmail.com wrote:
How can I say use name_database on postgre sql?
You have to re-connect to use a different db in pgsql.
But keep in mind that mysql databases are more nearly akin to what
On Jun 25, 2010, at 10:48 AM, Scott Marlowe wrote:
On Fri, Jun 25, 2010 at 7:10 AM, javijava welove.e.mu...@gmail.com wrote:
Hi,
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after
On 25/06/10 19:10, javijava wrote:
Hi,
i'm newby in postgre sql world.
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
http://wiki.postgresql.org/wiki/FAQ
Jim Montgomery monty1...@hotmail.com writes:
Remove me from your email chain.
Jim, are you trying to win the Jerk of the Month award? There's an
unsubscribe link on every PG list message. All you're accomplishing
with this is to annoy other list members who cannot unsubscribe you.
Excerpts from Dick Kniep's message of vie jun 25 04:54:15 -0400 2010:
PROBLEM 2
Furthermore the following errors are shown:
psql:db03.ak1.sql:251166: ERROR: column a.transaction does not exist
LINE 2: SELECT (a.relation)::regclass AS table, a.transaction...
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way as
such: /opt/local/lib/postgresql84/bin/pg_restore -d Trading-Access
On 25 June 2010 16:28, Dennis C dcsw...@gmail.com wrote:
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access -Z 5
Trading-Access
But then when I tried restoring it my usual way as
such:
On Fri, Jun 25, 2010 at 1:44 AM, Dave Page dp...@pgadmin.org wrote:
On Fri, Jun 25, 2010 at 9:33 AM, Rob Wultsch wult...@gmail.com wrote:
MySQL has several full text search solutions. The built in MyISAM
solution is the best known, but there is also an engine for using
sphinx.
...
And
On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch wult...@gmail.com wrote:
- Innodb : The primary transactional storage engine for MySQL. It does
not have all the features of PG (like check contraints), but it has
some features (like Compression!!!) which are *exceptionally* useful.
You do know
On Fri, 2010-06-25 at 08:28 -0700, Dennis C wrote:
Greetings;
As I've been doing for quite some time, backed up my database as
such: /opt/local/lib/postgresql84/bin/pg_dump -c -f ./Trading-Access
-Z 5 Trading-Access
But then when I tried restoring it my usual way as
such:
On Fri, Jun 25, 2010 at 4:58 AM, Scott Marlowe scott.marl...@gmail.com wrote:
Next up: PostgreSQL stores its system catalogs in transaction safe
table types, like everything else it stores. MySQL stores its table
defs in myisam, even if the whole of the db you create is innodb and
innodb is
It says Trading-Access: gzip compressed data, from Unix
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
On Fri, Jun 25, 2010 at 8:37 AM, Thom Brown
On Fri, Jun 25, 2010 at 8:56 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch wult...@gmail.com wrote:
- Innodb : The primary transactional storage engine for MySQL. It does
not have all the features of PG (like check contraints), but it has
some
On Jun 23, 2010, at 6:01 PM, A.M. wrote:
Hello,
I am trying to make a query which will flatten pg_auth_members into a table
with two columns user and group which will recurse inherited roles so
that each login role is associated once with any inherited roles (assuming
all associated
On Fri, Jun 25, 2010 at 10:00 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Fri, Jun 25, 2010 at 7:10 AM, javijava welove.e.mu...@gmail.com
wrote:
How can I say use name_database on postgre sql?
You have to re-connect to use a different db in
On Fri, Jun 25, 2010 at 09:44:04AM +0100, Dave Page wrote:
It could also be argued that having a storage engine API means that
the query planner/optimiser cannot have nearly as much knowledge
about how the data is stored and what access characteristics it may
have thus preventing it from being
I never used PostgreSQL in production environment. Now I got an opportunity to
migrate a MySQL production database to PostgreSQL. Before migrating, I have few
queries on data recovery:
Is there any feature of scheduled backups?In case there is no backup and I want
to shift my data files to a
On Fri, 2010-06-25 at 23:24 +0530, RP Khare wrote:
I never used PostgreSQL in production environment. Now I got an
opportunity to migrate a MySQL production database to PostgreSQL.
Before migrating, I have few queries on data recovery:
1. Is there any feature of scheduled backups?
You
On 06/25/10 4:10 AM, javijava wrote:
i need to know how to do a simple script that create a database,the y
select it (in other languajes using USE) and after create tables with this
database.
How can I say use name_database on postgre sql?
Thanks in advance 4 the help!!
IF you are
On 06/25/2010 09:04 AM, Dennis C wrote:
It says Trading-Access: gzip compressed data, from Unix
About the idea of not using pg_restore for these dumps, what I'm still
missing is how it's worked for all these years before. Are there now more
stringent standards being enforced?
You have
I am having an issue with extracting data from the arguments within my ‘C’
function, inside my Stored Library.
Let’s put the pieces together first:
I have a type called rank_post which has two one character fields:
CREATE TYPE rank_post AS
(
rank character(1),
post character(1)
);
I am
On Fri, 25 Jun 2010 08:48:11 -0700
Rob Wultsch wult...@gmail.com wrote:
The freedom of the storage engine interface allows for much more
varied backend characteristics. Some examples:
This is *really* fascinating but pg transactional engine is very
mature and solid.
Before any of the
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The options for the configure are:
/configure
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The options for the configure are:
/configure
On 06/25/10 2:21 PM, MOLINA BRAVO FELIPE DE JESUS wrote:
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of postgres: 8.4.4 ) with plperl for 64
bits. The
OK well the gunzip seemed to do the trick, but I don't recall before
having to do anything other than run the pg_restore command. Anyway, thanks
to everyone for all your help!
On Fri, Jun 25, 2010 at 11:29 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 06/25/2010 09:04 AM, Dennis C wrote:
On Friday 25 June 2010 4:59:17 pm Dennis C wrote:
OK well the gunzip seemed to do the trick, but I don't recall before
having to do anything other than run the pg_restore command. Anyway,
thanks to everyone for all your help!
My guess is that previously the dump command was actually:
On 6/25/2010 4:22 AM, John Gage wrote:
There are features, are there not, that Postgres has that MySQL does not
have?
Yes, a big one would be data integrity. Most people would not consider
data integrity an optional feature in a DBMS, but apparently MySQL does.
Try this in MySQL:
create
2010/6/25 John R Pierce pie...@hogranch.com
On 06/25/10 2:21 PM, MOLINA BRAVO FELIPE DE JESUS wrote:
Hi
I don't have experience with solaris. I know it is a 64 bits:
bash-2.05# isainfo -v
64-bit sparcv9 applications
32-bit sparc applications
I tried to compile postgres (Version of
On 06/25/10 9:28 PM, Felipe de Jesús Molina Bravo wrote:
original perl is 5.6. so i installed perl 5.8.9 for 64 bit and the
error is the same... maybe my error is with the compiler, it is gcc
(3.4.6). is it possible?
where did this 64bit 5.8.9 come from?
I try to downloaded SunStudio
On 26/06/2010 2:07 AM, Joshua D. Drake wrote:
On Fri, 2010-06-25 at 23:24 +0530, RP Khare wrote:
I never used PostgreSQL in production environment. Now I got an
opportunity to migrate a MySQL production database to PostgreSQL.
Before migrating, I have few queries on data recovery:
1. Is
66 matches
Mail list logo