2008/8/18 Lucas Mocellin <[EMAIL PROTECTED]> > Desculpe mais uma vez, nem olhei a fundo a documentacao. > > dei uma lida e vi o procedimento de atualização, porém agora acontece o > seguinte, eu consigo migrar tudo certinho, as tabelas são criadas > corretamente, porém o script envia algumas mensagens de erro: > > could not access file "$libdir/liblwgeom.dll": No such file or directory > > Porém estou em um linux, no mínimo deveria dar o erro do ".so", estou > migrando de um windows para um linux, será que no banco antigo há algum > "resquício" dessa dll? > > ls -l /usr/lib/postgresql/8.1/lib/liblwgeom.so > lrwxrwxrwx 1 root root 16 2008-08-15 08:51 > /usr/lib/postgresql/8.1/lib/liblwgeom.so -> liblwgeom.so.1.1 > > está ai o modulo. > > entao fiz o seguinte, exportei a variavel "libdir" e criei um link do .dll > para o .so: > ln -s liblwgeom.so.1.1 liblwgeom.dll > > executei e agora os erros nao ocorreram, porém vieram os avisos/erros: > > createlang: language "plpgsql" is already installed in database "web" > NOTICE: type "histogram2d" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type histogram2d is only a shell > NOTICE: type "spheroid" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type spheroid is only a shell > NOTICE: type "geometry" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type geometry is only a shell > NOTICE: return type geometry is only a shell > NOTICE: argument type geometry is only a shell > NOTICE: type "box3d" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type box3d is only a shell > NOTICE: type "chip" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type chip is only a shell > NOTICE: type "box2d" is not yet defined > DETAIL: Creating a shell type definition. > NOTICE: argument type box2d is only a shell > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "spatial_ref_sys_pkey" for table "spatial_ref_sys" > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "geometry_columns_pk" for table "geometry_columns" > ERROR: language "plpgsql" already exists > ERROR: function "lockrow" already exists with same argument types > ERROR: function "lockrow" already exists with same argument types >
Erro mesmo, deve ser apenas um. Crie a linguagem antes de iniciar a importação: create language plpgsql; -- Ribamar FS - [EMAIL PROTECTED] http://ribafs.net
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
