2008/8/18 Lucas Mocellin <[EMAIL PROTECTED]> > isso ja está feito. > > pode ver que a primeira notificacao eh que a linguagem "ja esta instalada". >
Tens razaão. Desculpe, foi a pressa. É isso, ao tentar criar a linguagem que já está criada dispara o erro. > > > Em 18/08/08, Ribamar Sousa <[EMAIL PROTECTED]> escreveu: >> >> 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 >> pgbr-geral@listas.postgresql.org.br >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- Ribamar FS - [EMAIL PROTECTED] http://ribafs.net
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral