Skip to main content ↑ ↓
Postgre and SQLite upgrades Started by emanuele · · Read 9290 times 0 Members and 1 Guest are viewing this topic. previous topic - next topic

Postgre and SQLite upgrades

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

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... :P
Bugs creator.
Features destroyer.
Template killer.
 

Re: Postgre and SQLite upgrades

Reply #1 –

Quote from: emanuele – I'm not sure, so I'll post it here hoping someone with an idea can jump in... O:-)

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... :P
AFAIK no (one insert per line is needed) And, IIRC, you can blame me for this one  ;D
Thorsten "TE" Eurich
------------------------