postgresql – 在Amazon RDS Postgres上编写PostGIS设置脚本

我正在尝试在我的Amazon RDS POSTGRes实例上编写PostgIS的设置脚本.这是我正在运行的命令：

create extension Postgis;
create extension fuzzystrmatch;
create extension Postgis_tiger_geocoder;
create extension Postgis_topology;

create functION exec(text) returns text language plpgsql volatile AS $f$BEGIN EXECUTE $1; RETURN $1; END; $f$;
SELECT exec('alter table ' || quote_ident(s.nspName) || '.' || quote_ident(s.relname) || ' owneR TO rds_superuser')
  FROM (
    SELECT nspname,relname
    FROM pg_class c JOIN pg_namespace n ON (c.relnamespace = n.oid) 
    WHERE nspname in ('tiger','topology') AND
    relkind IN ('r','S','v') ORDER BY relkind = 'S')
s;

alter scheR_803_11845@a tiger owner to rds_superuser;
alter scheR_803_11845@a topology owner to rds_superuser;

当我使用psql客户端登录服务器并单独运行每个命令时,一切都很好.

测试结果：

dbname=> SELEct na.address,na.streetname,na.streettypeabbrev,na.zip from normalize_address('1 Devonshire Place,Boston,MA 02109') as na;
 address | streetname | streettypeabbrev |  zip  
---------+------------+------------------+-------
       1 | Devonshire | Pl               | 02109
(1 row)

当我将所有这些命令放入.sql文件然后尝试通过psql命令一次运行它们时…

PGpassworD='****' psql -h us-West-2-stg-db-1.***.rds.amazonaws.com -U dbuser -d dbname -f setup_Postgis.sql -o setup_Postgis.log

…尝试测试PostgIS功能时出现以下错误：

dbname=> SELEct na.address,MA 02109') as na;
ERROR:  function normalize_address(unknown) does not exist
LINE 2: from normalize_address('1 Devonshire Place,MA 02109...
             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

知道为什么在服务器上直接运行命令时这个命令的确切顺序有效,但是当通过命令行作为.sql文件运行时却没有？

注意：我确定我用来运行命令的db用户是rds_superuser角色