Le jeudi 27 août 2009 à 14:27 -0500, Jaime Casanova a écrit :
> the point was that if we simply were saying: hey! mysql can interpret
> this, make postgres do the same then we could end up with a lot of
> broken stuff... just because mysql users think is wonderful to not
> have to write sane code..
Le mercredi 26 août 2009 à 15:51 -0700, Josh Berkus a écrit :
> I doubt this would be an accurate description of all Drupal
> developers.
My opinion was :
Before adding replication to PostgreSQL, it would be better to support a
basic set of MySQL syntax seems relevant:
DELETE FROM table1, table
Dear all,
Just a quick message about postgresql.conf auto-configuration.
When MySQL users test PostgreSQL, they load their data and run simple
SQL queries. If postgresql.conf is configured with default values, it
may produce slow results.
Would there be a way for postgresql.conf to auto configu
Le mercredi 26 août 2009 à 16:56 -0400, Alvaro Herrera a écrit :
> Have you tried Drupal 7? It's said to have many of these corrected.
> Maybe you should stop wasting your time with 6.x.
I am running a large community on the Net and people would like to
migrate our framework to Drupal. We agreed
Le mercredi 26 août 2009 à 22:06 +0100, Greg Stark a écrit :
> With your current approach you're likely to get dismissed out of hand,
> not unlike what I can well believe happened in the Drupal world.
This is the case.
> That
> would be unfortunate because I think there are 2 or 3 real
> improvem
> Second, we're not going to support MySQL's *bugs* and *bad design
> decisions* which is what lazy developers actually want; they want
> something exactly the same as MySQL, including bugs. If they want
> that,
> they can use MySQL. We are not MySQL, and trying to out-MySQL MySQL
> is
> stupid,
Dear Kevin
> So when you talk about focusing on usablility improvements you mean
> that priority should be given to supporting MySQL-specific syntax
> extensions and ensuring that there are no queries where the MySQL
> optimizer comes up with a more efficient plan than PostgreSQL?
Yes. PostgreSQL
Le mercredi 26 août 2009 à 09:30 -0500, Kevin Grittner a écrit :
> It's not clear to me what you feel is needed. That could mean many
> things
Dear Kevin,
I rarely post on Hackers, so I will try to explain:
* I use PostgreSQL since 1998.
* I took part in the development of pgAdmin 1&2.
* I l
Le mercredi 26 août 2009 à 09:16 -0500, Kevin Grittner a écrit :
> Please repost with that the pgsql-performance list
Done: http://drupal.org/node/559986
Kind regards, JMP
signature.asc
Description: Ceci est une partie de message numériquement signée
Le mercredi 26 août 2009 à 10:07 -0400, Andrew Dunstan a écrit :
>
> Isn't that cast effectively a no-op?
What is no-op in English (I am French, pardon my English).
I will update table definition in 5 minutes.
Stay tuned.
Kind regards,
Jean-Michel
signature.asc
Description: Ceci est une parti
Le mercredi 26 août 2009 à 01:36 -0600, Rick Gigger a écrit :
> One possible reason that replication is more critical now than it
> was
> a year ago is the rise in cloud computing. The ability to fire up
> instances on demand is much more useful when some of those boxes can
> be database ser
Dear friends,
Thank you for your previous answers. I am running into a systemic
problem using Drupal under PostgreSQL 8.4
Drupal relies heavily on a domain derived from int:
CREATE DOMAIN int_unsigned
AS integer
CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0));
Analysing slow queries, I
> With proper foreign keys and ON DELETE CASCADE, why would supporting
> such syntax even be necessary?
Porting existing abstraction layers from ANSI JOINs to ON DELETE CASCADE
is complicated.
> What I don't get is why this is such a usability issue. Subqueries in
> DELETE FROM work perfectly we
Dear Friends,
First, thank you very much for considering a fix on the GROUP BY issue.
I am starting a new thread about another issue:
It seems that DELETE cannot understand INNER JOINS and needs HAVING.
Read:
http://drupal.org/node/62 (main message)
http://drupal.org/node/555648
I don't s
> I've registered for the Drupal site so that I can fix and/or expand
> some
> of your items.
Thanks. I corrected the index on dual fields page.
> If you want to discuss Drupal & PostgreSQL again, please post on the
> pgsql-advocacy list or the pgsql-php mailing lists. pgsql-hackers
> isn't
> th
Dear friends,
I have been using PostgreSQL since 6.3 releases and I am a real fan.
Of course, I never use nor trust MySQL to deliver data.
Now I use Drupal 6.3 with PostgreSQL 8.4.
I loose a lot of time correcting Drupal SQL.
You may be interested in my developer feedback.
I gathered some rea
Thank you all for these kind answers. Cheers, JMP
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Dear friends,
You may know me as I worked a long time ago on pgAdmin I with Dave.
As this is an XML related question and XML is quite new, I am posting
on hackers ML.
We would like to develop a free REST database (real-estate standard)
based on a PostgreSQL schema. This is a free solution for f
Dear friends,
You may know me as I worked a long time ago on pgAdmin I with Dave.
As this is an XML related question and XML is quite new, I am posting
on hackers ML. If any solution is being developped, please inform us.
We would like to develop a free REST database (real-estate standard)
base
choice.
I don't ask for more.
Now, I hope that the list can return to a more peaceful state.
Kind regards,
Jean-Michel Pouré
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
t be any kind of large sum of money, something between 100€ and
500€.
Kind regards and happy new year.
Jean-Michel Pouré
---(end of broadcast)---
TIP 6: explain analyze is your friend
. by a factor of 10 or more.
Kind regards and happy new year.
I hope that 2008 will be the year of materialized views.
Jean-Michel Pouré
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Dear friends and all,
Johnathan Gardner did a wonderful job on materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Are there any plans to integrate materialized views written in plain C in the
future. This can help gain a lot of time in Web applications.
F
Dear friends and all,
Johnathan Gardner did a wonderful job on materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Are there any plans to integrate materialized views written in plain C in the
future. This can help gain a lot of time in Web applications.
F
24 matches
Mail list logo
