Postgre and SQLite upgrades

April 16, 2013, 05:58:04 pm

I'm not sure, so I'll post it here hoping someone with an idea can jump in...

---# Adding new settings ...
INSERT IGNORE INTO {$db_prefix}settings
	(variable, value)
VALUES
	('avatar_default', '0'),
	('visual_verification_num_chars', '6'),
	('gravatar_rating', 'g');
---#

Is this correct?
Does the upgrade take care of splitting this into 3 different queries for SQLite and Postgre?

ETA: and anyway the MySQL file has more settings...

Re: Postgre and SQLite upgrades

Reply #1 – April 17, 2013, 12:23:21 am

Quote from: emanuele – April 16, 2013, 05:58:04 pmI'm not sure, so I'll post it here hoping someone with an idea can jump in...

Code: [Select]
---# Adding new settings ...
INSERT IGNORE INTO {$db_prefix}settings
	(variable, value)
VALUES
	('avatar_default', '0'),
	('visual_verification_num_chars', '6'),
	('gravatar_rating', 'g');
---#
Is this correct?
Does the upgrade take care of splitting this into 3 different queries for SQLite and Postgre?

ETA: and anyway the MySQL file has more settings...

AFAIK no (one insert per line is needed) And, IIRC, you can blame me for this one