Thread: Need Postgres answer  |
|||||||||||||
|
Started 1 year, 11 months ago by NancyDru
I don't have Postgres and I'd like to make a change to a module that I support. For MySql, I know I can use "INSERT ... ON DUPLICATE KEY UPDATE ..." for part of my change and it will make the code so much simpler. ( http://dev.mysql.com/doc/refman/5.0/en/insert-on-d uplicate.html )
Does Postgres support this syntax? How about all the other DBs that are being considered for Drupal?
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
havran replied 1 year, 11 months ago
Here is some "sort of" solution: http://www.thescripts.com/forum/thread423068.html .
--
My blog - Havran's mini-blog
My first drupal site - http://www.enigma.sk/
Size: 470 bytes
Customize: 
NancyDru replied 1 year, 11 months ago
That tells me I can't do it the easy way... :(
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
Size: 350 bytes
Customize:
easy12 replied 1 year, 11 months ago
If you like things easy, you'll have difficulties; if you like problems, you'll succeed
Size: 119 bytes
Customize:
jmpoure replied 1 year, 11 months ago
I recommand doing an INSERT.
If it fails, then UPDATE.
Size: 93 bytes
Customize:
shobika replied 1 year, 11 months ago
use UPDATE, it should help in this
Size: 66 bytes
Customize:
fmatias replied 1 year, 11 months ago
Use transactions.
Example (a psql session) :
First case, no matching record :
rsln_devel_drupal=# begin ; BEGIN rsln_devel_drupal=# select count(*) from node where vid=1000 ; count ------- 0 (1 ligne) rsln_devel_drupal=# insert into node (vid, title) values (1000, 'my title') ; INSERT 0 1 rsln_devel_drupal=# commit ; COMMIT
Second case, matching record :
rsln_devel_drupal=# ...
Size: 1,461 bytes
Customize:
fmatias replied 1 year, 11 months ago
The previous examples are just wrong.
First case, no matching record :
rsln_devel_drupal=# begin ; BEGIN rsln_devel_drupal=# lock table node ; LOCK TABLE rsln_devel_drupal=# select count(*) from node where vid=1000 ; count ------- 0 (1 ligne) rsln_devel_drupal=# insert into node (vid, title) values (1000, 'my title') ; INSERT 0 1 rsln_devel_drupal=# commit ; COMMIT
Second case, ...
Size: 1,162 bytes
Customize:
NancyDru replied 1 year, 11 months ago
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
Size: 293 bytes
Customize:
shobika replied 1 year, 10 months ago
wrongly posted.
*deleted*
Size: 66 bytes
Customize:
|
Top contributing authorsRelated threads on "Forums | drupal.org":Related threads on other sites: |
||||||||||||
Thread profile page for "Need Postgres answer" on http://drupal.org.
This report page is a snippet summary view from a single thread "Need Postgres answer", located on the Message Board at http://drupal.org.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.