diff options
author | Steven Wittens <steven@10.no-reply.drupal.org> | 2005-02-28 18:00:59 +0000 |
---|---|---|
committer | Steven Wittens <steven@10.no-reply.drupal.org> | 2005-02-28 18:00:59 +0000 |
commit | ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8 (patch) | |
tree | 592832e68e3c2d24c8e7634f847c033896cfc03d /database | |
parent | a203f728bd012a101448633f29e35d16e820575d (diff) | |
download | brdo-ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8.tar.gz brdo-ff386b90bbee1abcf9e6cf38a9571e65f5e6a8b8.tar.bz2 |
#17747: PGSQL improvements
Diffstat (limited to 'database')
-rw-r--r-- | database/updates.inc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/database/updates.inc b/database/updates.inc index 534fa611d..d5b9ed5c1 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -1961,7 +1961,7 @@ function update_110() { #$ret[] = update_sql('ALTER TABLE {blocks} DROP path'); $ret[] = update_sql('ALTER TABLE {blocks} ADD visibility smallint'); - $ret[] = update_sql("ALTER TABLE {blocks} ALTER COLUMN type set default ''"); + $ret[] = update_sql("ALTER TABLE {blocks} ALTER COLUMN visibility set default 0"); $ret[] = update_sql('UPDATE {blocks} SET visibility = 0'); $ret[] = update_sql('ALTER TABLE {blocks} ALTER COLUMN visibility SET NOT NULL'); $ret[] = update_sql('ALTER TABLE {blocks} ADD pages text'); @@ -2291,7 +2291,7 @@ function update_125() { if ($GLOBALS['db_type'] == 'pgsql') { - $ret[] = update_sql[] = ("CREATE FUNCTION "if"(boolean, anyelement, anyelement) RETURNS anyelement AS ' + $ret[] = update_sql("CREATE OR REPLACE FUNCTION if(boolean, anyelement, anyelement) RETURNS anyelement AS ' SELECT CASE WHEN $1 THEN $2 ELSE $3 END; ' LANGUAGE 'sql'"); |