Problemas na Instalação

ezequiellorenzatti · 2008-01-23 15:22:13 UTC

Olá
Estou fazendo minha primeira instalalção do Adempiere com postgres no Windows XP Pro

Versão do Adempiere: Adempiere_331b
Versão do Postgres: postgresql-8.2.6-1
Versão do Java: jdk-1_5_0_14-windows-i586-p

Procurei na internet, tutoriais em portugues, mas nenhum se mostrou suficiente, parti então para o tutorial oficial, conforme link adempiere.com/wiki/index.php … tall_WinXp

Parei no Passo 7
estou com a seguinte dúvida:
os erros apresentados no arquivo dump_erros, gerado conforme instrução.
são normais ??
esqueci algum detalhe na instalação do postgres.

Aguardo informações
Ezequiel
TI - Simps

segue o conteudo do arquivo:

psql:Adempiere_pg.dmp:44: ERROR: could not load library “C:/Arquivos de programas/PostgreSQL/8.2/lib/pljava.dll”: unknown error 127
psql:Adempiere_pg.dmp:47: ERROR: function sqlj.java_call_handler() does not exist
psql:Adempiere_pg.dmp:53: ERROR: function java_call_handler() does not exist
psql:Adempiere_pg.dmp:62: ERROR: could not load library “C:/Arquivos de programas/PostgreSQL/8.2/lib/pljava.dll”: unknown error 127
psql:Adempiere_pg.dmp:65: ERROR: function sqlj.javau_call_handler() does not exist
psql:Adempiere_pg.dmp:71: ERROR: function javau_call_handler() does not exist
psql:Adempiere_pg.dmp:78: ERROR: language “plpgsql” already exists
psql:Adempiere_pg.dmp:89: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:92: ERROR: function adempiere.acctbalance(integer, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:100: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:103: ERROR: function adempiere.acctbalance(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:111: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:114: ERROR: function adempiere.adddays(timestamp with time zone, integer) does not exist
psql:Adempiere_pg.dmp:157: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:160: ERROR: function adempiere.adempiereproperties() does not exist
psql:Adempiere_pg.dmp:168: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:171: ERROR: function adempiere.adempiereproperty(character varying) does not exist
psql:Adempiere_pg.dmp:179: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:182: ERROR: function adempiere.adempiereversion() does not exist
psql:Adempiere_pg.dmp:301: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:304: ERROR: function adempiere.bompricelimit(integer, integer) does not exist
psql:Adempiere_pg.dmp:312: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:315: ERROR: function adempiere.bompricelimit(numeric, numeric) does not exist
psql:Adempiere_pg.dmp:323: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:326: ERROR: function adempiere.bompricelist(integer, integer) does not exist
psql:Adempiere_pg.dmp:334: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:337: ERROR: function adempiere.bompricelist(numeric, numeric) does not exist
psql:Adempiere_pg.dmp:345: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:348: ERROR: function adempiere.bompricestd(integer, integer) does not exist
psql:Adempiere_pg.dmp:356: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:359: ERROR: function adempiere.bompricestd(numeric, numeric) does not exist
psql:Adempiere_pg.dmp:367: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:370: ERROR: function adempiere.bomqtyavailable(integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:378: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:381: ERROR: function adempiere.bomqtyavailable(integer, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:389: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:392: ERROR: function adempiere.bomqtyavailable(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:400: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:403: ERROR: function adempiere.bomqtyavailable(numeric, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:411: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:414: ERROR: function adempiere.bomqtyonhand(integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:422: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:425: ERROR: function adempiere.bomqtyonhand(integer, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:433: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:436: ERROR: function adempiere.bomqtyonhand(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:444: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:447: ERROR: function adempiere.bomqtyonhand(numeric, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:455: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:458: ERROR: function adempiere.bomqtyordered(integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:466: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:469: ERROR: function adempiere.bomqtyordered(integer, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:477: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:480: ERROR: function adempiere.bomqtyordered(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:488: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:491: ERROR: function adempiere.bomqtyordered(numeric, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:499: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:502: ERROR: function adempiere.bomqtyreserved(integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:510: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:513: ERROR: function adempiere.bomqtyreserved(integer, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:521: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:524: ERROR: function adempiere.bomqtyreserved(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:532: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:535: ERROR: function adempiere.bomqtyreserved(numeric, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:543: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:546: ERROR: function adempiere.bpartnerremitlocation(integer) does not exist
psql:Adempiere_pg.dmp:554: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:557: ERROR: function adempiere.bpartnerremitlocation(numeric) does not exist
psql:Adempiere_pg.dmp:565: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:568: ERROR: function adempiere.charat(character varying, integer) does not exist
psql:Adempiere_pg.dmp:576: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:579: ERROR: function adempiere.currencybase(numeric, integer, timestamp with time zone, integer, integer) does not exist
psql:Adempiere_pg.dmp:587: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:590: ERROR: function adempiere.currencybase(numeric, numeric, timestamp with time zone, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:598: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:601: ERROR: function adempiere.currencyconvert(numeric, integer, integer, timestamp with time zone, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:609: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:612: ERROR: function adempiere.currencyconvert(numeric, numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:620: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:623: ERROR: function adempiere.currencyrate(integer, integer, timestamp with time zone, integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:631: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:634: ERROR: function adempiere.currencyrate(numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:642: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:645: ERROR: function adempiere.daysbetween(timestamp with time zone, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:653: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:656: ERROR: function adempiere.documentno(integer) does not exist
psql:Adempiere_pg.dmp:664: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:667: ERROR: function adempiere.documentno(numeric) does not exist
psql:Adempiere_pg.dmp:675: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:678: ERROR: function adempiere.firstof(timestamp with time zone, character varying) does not exist
psql:Adempiere_pg.dmp:701: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:704: ERROR: function adempiere.invoicediscount(integer, timestamp with time zone, integer) does not exist
psql:Adempiere_pg.dmp:712: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:715: ERROR: function adempiere.invoicediscount(numeric, timestamp with time zone, numeric) does not exist
psql:Adempiere_pg.dmp:723: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:726: ERROR: function adempiere.invoiceopen(integer, integer) does not exist
psql:Adempiere_pg.dmp:734: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:737: ERROR: function adempiere.invoiceopen(numeric, numeric) does not exist
psql:Adempiere_pg.dmp:745: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:748: ERROR: function adempiere.invoicepaid(integer, integer, integer) does not exist
psql:Adempiere_pg.dmp:756: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:759: ERROR: function adempiere.invoicepaid(numeric, numeric, numeric) does not exist
psql:Adempiere_pg.dmp:767: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:770: ERROR: function adempiere.nextid(integer, character varying) does not exist
psql:Adempiere_pg.dmp:778: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:781: ERROR: function adempiere.paymentallocated(integer, integer) does not exist
psql:Adempiere_pg.dmp:789: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:792: ERROR: function adempiere.paymentallocated(numeric, numeric) does not exist
psql:Adempiere_pg.dmp:800: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:803: ERROR: function adempiere.paymentavailable(integer) does not exist
psql:Adempiere_pg.dmp:811: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:814: ERROR: function adempiere.paymentavailable(numeric) does not exist
psql:Adempiere_pg.dmp:822: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:825: ERROR: function adempiere.paymenttermdiscount(numeric, integer, integer, timestamp with time zone, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:833: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:836: ERROR: function adempiere.paymenttermdiscount(numeric, numeric, numeric, timestamp with time zone, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:844: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:847: ERROR: function adempiere.paymenttermduedate(integer, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:855: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:858: ERROR: function adempiere.paymenttermduedate(numeric, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:866: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:869: ERROR: function adempiere.paymenttermduedays(integer, timestamp with time zone, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:877: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:880: ERROR: function adempiere.paymenttermduedays(numeric, timestamp with time zone, timestamp with time zone) does not exist
psql:Adempiere_pg.dmp:888: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:891: ERROR: function adempiere.productattribute(integer) does not exist
psql:Adempiere_pg.dmp:899: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:902: ERROR: function adempiere.productattribute(numeric) does not exist
psql:Adempiere_pg.dmp:999: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1002: ERROR: function sqlj.add_type_mapping(character varying, character varying) does not exist
psql:Adempiere_pg.dmp:1010: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1013: ERROR: function sqlj.drop_type_mapping(character varying) does not exist
psql:Adempiere_pg.dmp:1021: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1024: ERROR: function sqlj.get_classpath(character varying) does not exist
psql:Adempiere_pg.dmp:1032: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1035: ERROR: function sqlj.install_jar(character varying, character varying, boolean) does not exist
psql:Adempiere_pg.dmp:1043: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1046: ERROR: function sqlj.install_jar(bytea, character varying, boolean) does not exist
psql:Adempiere_pg.dmp:1054: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1057: ERROR: function sqlj.remove_jar(character varying, boolean) does not exist
psql:Adempiere_pg.dmp:1065: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1068: ERROR: function sqlj.replace_jar(character varying, character varying, boolean) does not exist
psql:Adempiere_pg.dmp:1076: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1079: ERROR: function sqlj.replace_jar(bytea, character varying, boolean) does not exist
psql:Adempiere_pg.dmp:1087: ERROR: language “java” does not exist
psql:Adempiere_pg.dmp:1090: ERROR: function sqlj.set_classpath(character varying, character varying) does not exist
psql:Adempiere_pg.dmp:9508: ERROR: function firstof(timestamp with time zone, character varying) does not exist
LINE 2: …c((o.dateordered)::timestamp with time zone) <= ((firstof(ge…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:9511: ERROR: relation “adempiere.c_invoice_candidate_v” does not exist
psql:Adempiere_pg.dmp:9837: ERROR: function productattribute(numeric) does not exist
LINE 2: … uomsymbol, COALESCE(c.name, (((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:9840: ERROR: relation “adempiere.c_invoice_linetax_v” does not exist
psql:Adempiere_pg.dmp:9922: ERROR: function productattribute(numeric) does not exist
LINE 2: …E(c.name, (((COALESCE(pt.name, p.name))::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:9925: ERROR: relation “adempiere.c_invoice_linetax_vt” does not exist
psql:Adempiere_pg.dmp:9961: ERROR: function charat(character varying, integer) does not exist
LINE 2: …nvoicecollectiontype, i.dunninggrace, CASE WHEN ((charat((d…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:9964: ERROR: relation “adempiere.c_invoice_v” does not exist
psql:Adempiere_pg.dmp:9971: ERROR: function charat(character varying, integer) does not exist
LINE 2: …schedule_id, i.invoicecollectiontype, CASE WHEN ((charat((d…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:9974: ERROR: relation “adempiere.c_invoice_v1” does not exist
psql:Adempiere_pg.dmp:10060: ERROR: relation “c_invoice_v” does not exist
psql:Adempiere_pg.dmp:10063: ERROR: relation “adempiere.c_invoiceline_v” does not exist
psql:Adempiere_pg.dmp:10305: ERROR: function productattribute(numeric) does not exist
LINE 2: … uomsymbol, COALESCE(c.name, (((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:10308: ERROR: relation “adempiere.c_order_linetax_v” does not exist
psql:Adempiere_pg.dmp:10315: ERROR: function productattribute(numeric) does not exist
LINE 2: … uomsymbol, COALESCE(c.name, (((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:10318: ERROR: relation “adempiere.c_order_linetax_vt” does not exist
psql:Adempiere_pg.dmp:10557: ERROR: function bpartnerremitlocation(numeric) does not exist
LINE 2: …s, bpg.greeting AS bpgreeting, bp.name, bp.name2, bpartnerre…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:10560: ERROR: relation “adempiere.c_payselection_check_v” does not exist
psql:Adempiere_pg.dmp:10567: ERROR: function bpartnerremitlocation(numeric) does not exist
LINE 2: …s, bpg.greeting AS bpgreeting, bp.name, bp.name2, bpartnerre…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:10570: ERROR: relation “adempiere.c_payselection_check_vt” does not exist
psql:Adempiere_pg.dmp:11576: ERROR: function productattribute(numeric) does not exist
LINE 2: …ibutesetinstance_id, COALESCE(((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:11579: ERROR: relation “adempiere.c_rfqresponseline_v” does not exist
psql:Adempiere_pg.dmp:11586: ERROR: function productattribute(numeric) does not exist
LINE 2: …ibutesetinstance_id, COALESCE(((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:11589: ERROR: relation “adempiere.c_rfqresponseline_vt” does not exist
psql:Adempiere_pg.dmp:15747: ERROR: function productattribute(numeric) does not exist
LINE 2: …D AS qtybackordered, COALESCE(((p.name)::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:15750: ERROR: relation “adempiere.m_inout_line_v” does not exist
psql:Adempiere_pg.dmp:15757: ERROR: function productattribute(numeric) does not exist
LINE 2: …, COALESCE(((COALESCE(pt.name, p.name))::text || (productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:15760: ERROR: relation “adempiere.m_inout_line_vt” does not exist
psql:Adempiere_pg.dmp:18705: ERROR: function firstof(timestamp with time zone, character varying) does not exist
LINE 2: …er_id, a.ad_user_id, a.serno, a.lot, a.versionno, firstof((a…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:18708: ERROR: relation “adempiere.rv_asset_summonth” does not exist
psql:Adempiere_pg.dmp:18725: ERROR: relation “c_invoice_v” does not exist
psql:Adempiere_pg.dmp:18728: ERROR: relation “adempiere.rv_bpartneropen” does not exist
psql:Adempiere_pg.dmp:18735: ERROR: function charat(character varying, integer) does not exist
LINE 2: … loc.postal, loc.city, i.c_charge_id, CASE WHEN ((charat((d…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:18738: ERROR: relation “adempiere.rv_c_invoice” does not exist
psql:Adempiere_pg.dmp:18745: ERROR: relation “rv_c_invoice” does not exist
psql:Adempiere_pg.dmp:18748: ERROR: relation “adempiere.rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18755: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18758: ERROR: relation “adempiere.rv_c_invoice_customerprodqtr” does not exist
psql:Adempiere_pg.dmp:18765: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18768: ERROR: relation “adempiere.rv_c_invoice_customervendqtr” does not exist
psql:Adempiere_pg.dmp:18775: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18778: ERROR: relation “adempiere.rv_c_invoice_day” does not exist
psql:Adempiere_pg.dmp:18785: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18788: ERROR: relation “adempiere.rv_c_invoice_month” does not exist
psql:Adempiere_pg.dmp:18795: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18798: ERROR: relation “adempiere.rv_c_invoice_prodmonth” does not exist
psql:Adempiere_pg.dmp:18805: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18808: ERROR: relation “adempiere.rv_c_invoice_productmonth” does not exist
psql:Adempiere_pg.dmp:18815: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18818: ERROR: relation “adempiere.rv_c_invoice_productqtr” does not exist
psql:Adempiere_pg.dmp:18825: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18828: ERROR: relation “adempiere.rv_c_invoice_prodweek” does not exist
psql:Adempiere_pg.dmp:18835: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18838: ERROR: relation “adempiere.rv_c_invoice_vendormonth” does not exist
psql:Adempiere_pg.dmp:18845: ERROR: relation “rv_c_invoiceline” does not exist
psql:Adempiere_pg.dmp:18848: ERROR: relation “adempiere.rv_c_invoice_week” does not exist
psql:Adempiere_pg.dmp:18855: ERROR: function charat(character varying, integer) does not exist
LINE 2: …ocumentno, i.ispaid, i.c_currency_id, CASE WHEN ((charat((d…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:18858: ERROR: relation “adempiere.rv_c_invoicetax” does not exist
psql:Adempiere_pg.dmp:18885: ERROR: function currencyconvert(numeric, numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
LINE 2: …iption, cl.cashtype, cl.c_currency_id, cl.amount, currencyco…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:18888: ERROR: relation “adempiere.rv_cash_detail” does not exist
psql:Adempiere_pg.dmp:18948: ERROR: function firstof(timestamp with time zone, character varying) does not exist
LINE 2: …, cc.description, cc.targeturl, cc.c_bpartner_id, firstof((c…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:18951: ERROR: relation “adempiere.rv_click_month” does not exist
psql:Adempiere_pg.dmp:19018: ERROR: function firstof(timestamp with time zone, character varying) does not exist
LINE 2: … fact_acct.c_acctschema_id, fact_acct.account_id, firstof((f…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19021: ERROR: relation “adempiere.rv_fact_acct_day” does not exist
psql:Adempiere_pg.dmp:19048: ERROR: function productattribute(numeric) does not exist
LINE 2: …duct_id, l.c_uom_id, l.m_attributesetinstance_id, productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19051: ERROR: relation “adempiere.rv_inoutdetails” does not exist
psql:Adempiere_pg.dmp:19098: ERROR: relation “rv_c_invoice” does not exist
psql:Adempiere_pg.dmp:19101: ERROR: relation “adempiere.rv_openitem” does not exist
psql:Adempiere_pg.dmp:19108: ERROR: function productattribute(numeric) does not exist
LINE 2: …d, l.m_warehouse_id, l.m_attributesetinstance_id, productatt…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19111: ERROR: relation “adempiere.rv_orderdetail” does not exist
psql:Adempiere_pg.dmp:19118: ERROR: function paymentallocated(numeric, numeric) does not exist
LINE 2: …N ‘Y’::bpchar THEN 1 ELSE -1 END AS multiplierap, paymentall…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19121: ERROR: relation “adempiere.rv_payment” does not exist
psql:Adempiere_pg.dmp:19148: ERROR: function currencyconvert(numeric, numeric, numeric, timestamp with time zone, numeric, numeric, numeric) does not exist
LINE 2: …mmittedqty * cs.relativeweight) AS committedqty, (currencyco…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19151: ERROR: relation “adempiere.rv_projectcycle” does not exist
psql:Adempiere_pg.dmp:19198: ERROR: function daysbetween(timestamp with time zone, timestamp with time zone) does not exist
LINE 2: …serno, asi.lot, asi.m_lot_id, asi.guaranteedate, daysbetwee…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19201: ERROR: relation “adempiere.rv_storage” does not exist
psql:Adempiere_pg.dmp:19228: ERROR: function bompricelist(numeric, numeric) does not exist
LINE 2: …name, p.upc, p.sku, uom.c_uom_id, uom.uomsymbol, bompriceli…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
psql:Adempiere_pg.dmp:19231: ERROR: relation “adempiere.rv_warehouseprice” does not exist

mgrigioni · 2008-01-23 17:51:45 UTC

Ezequiel, vc parou na parte mais chata da instalação do Adempiere + Postgres, o PL/JAVA.

Estes erros no Import não podem acontecer, pois várias funções do banco são em PL/JAVA

abaixo, o arquivo Postgresql.conf que estou utilizando na minha máquina, de uma olhada nas últimas linhas

[code:39fd7]# -----------------------------

PostgreSQL configuration file

-----------------------------

This file consists of lines of the form:

name = value

(The ‘=’ is optional.) White space may be used. Comments are introduced

with ‘#’ anywhere on a line. The complete list of option names and

allowed values can be found in the PostgreSQL documentation. The

commented-out settings shown in this file represent the default values.

Please note that re-commenting a setting is NOT sufficient to revert it

to the default value, unless you restart the server.

Any option can also be given as a command line switch to the server,

e.g., ‘postgres -c log_connections=on’. Some options can be changed at

run-time with the ‘SET’ SQL command.

This file is read on server startup and when the server receives a

SIGHUP. If you edit the file on a running system, you have to SIGHUP the

server for the changes to take effect, or use “pg_ctl reload”. Some

settings, which are marked below, require a server shutdown and restart

to take effect.

Memory units: kB = kilobytes MB = megabytes GB = gigabytes

Time units: ms = milliseconds s = seconds min = minutes h = hours d = days

#---------------------------------------------------------------------------

FILE LOCATIONS

#---------------------------------------------------------------------------

The default values of these variables are driven from the -D command line

switch or PGDATA environment variable, represented here as ConfigDir.

#data_directory = ‘ConfigDir’ # use data in another directory
# (change requires restart)
#hba_file = ‘ConfigDir/pg_hba.conf’ # host-based authentication file
# (change requires restart)
#ident_file = ‘ConfigDir/pg_ident.conf’ # ident configuration file
# (change requires restart)

If external_pid_file is not explicitly set, no extra PID file is written.

#external_pid_file = ‘(none)’ # write an extra PID file
# (change requires restart)

#---------------------------------------------------------------------------

CONNECTIONS AND AUTHENTICATION

#---------------------------------------------------------------------------

- Connection Settings -

listen_addresses = ‘’ # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to ‘localhost’, '’ = all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 500 # (change requires restart)

Note: increasing max_connections costs ~400 bytes of shared memory per

connection slot, plus lock space (see max_locks_per_transaction). You

might also need to raise shared_buffers to support more connections.

#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directory = ‘’ # (change requires restart)
#unix_socket_group = ‘’ # (change requires restart)
#unix_socket_permissions = 0777 # octal
# (change requires restart)
#bonjour_name = ‘’ # defaults to the computer name
# (change requires restart)

- Security & Authentication -

#authentication_timeout = 1min # 1s-600s
#ssl = off # (change requires restart)
#password_encryption = on
#db_user_namespace = off

Kerberos

#krb_server_keyfile = ‘’ # (change requires restart)
#krb_srvname = ‘postgres’ # (change requires restart)
#krb_server_hostname = ‘’ # empty string matches any keytab entry
# (change requires restart)
#krb_caseins_users = off # (change requires restart)

- TCP Keepalives -

see ‘man 7 tcp’ for details

#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
# 0 selects the system default
#tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
# 0 selects the system default
#tcp_keepalives_count = 0 # TCP_KEEPCNT;
# 0 selects the system default

#---------------------------------------------------------------------------

RESOURCE USAGE (except WAL)

#---------------------------------------------------------------------------

- Memory -

shared_buffers = 32MB # min 128kB or max_connections*16kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 5 # can be 0 or more
# (change requires restart)

Note: increasing max_prepared_transactions costs ~600 bytes of shared memory

per transaction slot, plus lock space (see max_locks_per_transaction).

#work_mem = 6MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 6MB # min 100kB

- Free Space Map -

max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each
# (change requires restart)
#max_fsm_relations = 1000 # min 100, ~70 bytes each
# (change requires restart)

- Kernel Resource Usage -

#max_files_per_process = 1000 # min 25
# (change requires restart)
#shared_preload_libraries = ‘’ # (change requires restart)

- Cost-Based Vacuum Delay -

#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 0-10000 credits

- Background writer -

#bgwriter_delay = 200ms # 10-10000ms between rounds
#bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round
#bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round
#bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round
#bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round

#---------------------------------------------------------------------------

WRITE AHEAD LOG

#---------------------------------------------------------------------------

- Settings -

#fsync = on # turns forced synchronization on or off
#wal_sync_method = fsync # the default is the first option
# supported by the operating system:
# open_datasync
# fdatasync
# fsync
# fsync_writethrough
# open_sync
#full_page_writes = on # recover from partial page writes
#wal_buffers = 64kB # min 32kB
# (change requires restart)
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000

- Checkpoints -

#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 5min # range 30s-1h
#checkpoint_warning = 30s # 0 is off

- Archiving -

#archive_command = ‘’ # command to use to archive a logfile segment
#archive_timeout = 0 # force a logfile segment switch after this
# many seconds; 0 is off

#---------------------------------------------------------------------------

QUERY TUNING

#---------------------------------------------------------------------------

- Planner Method Configuration -

#enable_bitmapscan = on
#enable_hashagg = on
#enable_hashjoin = on
#enable_indexscan = on
#enable_mergejoin = on
#enable_nestloop = on
#enable_seqscan = on
#enable_sort = on
#enable_tidscan = on

- Planner Cost Constants -

#seq_page_cost = 1.0 # measured on an arbitrary scale
#random_page_cost = 4.0 # same scale as above
#cpu_tuple_cost = 0.01 # same scale as above
#cpu_index_tuple_cost = 0.005 # same scale as above
#cpu_operator_cost = 0.0025 # same scale as above
#effective_cache_size = 128MB

- Genetic Query Optimizer -

#geqo = on
#geqo_threshold = 12
#geqo_effort = 5 # range 1-10
#geqo_pool_size = 0 # selects default based on effort
#geqo_generations = 0 # selects default based on effort
#geqo_selection_bias = 2.0 # range 1.5-2.0

- Other Planner Options -

#default_statistics_target = 10 # range 1-1000
#constraint_exclusion = off
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit
# JOINs

#---------------------------------------------------------------------------

ERROR REPORTING AND LOGGING

#---------------------------------------------------------------------------

- Where to Log -

log_destination = ‘stderr’ # Valid values are combinations of
# stderr, syslog and eventlog,
# depending on platform.

This is used when logging to stderr:

redirect_stderr = on # Enable capturing of stderr into log
# files
# (change requires restart)

These are only used if redirect_stderr is on:

#log_directory = ‘pg_log’ # Directory where log files are written
# Can be absolute or relative to PGDATA
#log_filename = ‘postgresql-%Y-%m-%d_%H%M%S.log’ # Log file name pattern.
# Can include strftime() escapes
#log_truncate_on_rotation = off # If on, any existing log file of the same
# name as the new log file will be
# truncated rather than appended to. But
# such truncation only occurs on
# time-driven rotation, not on restarts
# or size-driven rotation. Default is
# off, meaning append to existing files
# in all cases.
#log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 to
# disable.
#log_rotation_size = 10MB # Automatic rotation of logfiles will
# happen after that much log
# output. 0 to disable.

These are relevant when logging to syslog:

#syslog_facility = ‘LOCAL0’
#syslog_ident = ‘postgres’

- When to Log -

#client_min_messages = notice # Values, in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# log
# notice
# warning
# error

#log_min_messages = notice # Values, in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic

#log_error_verbosity = default # terse, default, or verbose messages

#log_min_error_statement = error # Values in order of increasing severity:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# fatal
# panic (effectively off)

#log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
# and their durations.

#silent_mode = off # DO NOT USE without syslog or
# redirect_stderr
# (change requires restart)

- What to Log -

#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = off
#log_connections = off
#log_disconnections = off
#log_duration = off
log_line_prefix = '%t ’ # Special values:
# %u = user name
# %d = database name
# %r = remote host and port
# %h = remote host
# %p = PID
# %t = timestamp (no milliseconds)
# %m = timestamp with milliseconds
# %i = command tag
# %c = session id
# %l = session line number
# %s = session start timestamp
# %x = transaction id
# %q = stop here in non-session
# processes
# %% = ‘%’
# e.g. '<%u%%%d> ’
#log_statement = ‘none’ # none, ddl, mod, all
#log_hostname = off

#---------------------------------------------------------------------------

RUNTIME STATISTICS

#---------------------------------------------------------------------------

- Query/Index Statistics Collector -

#stats_command_string = on
#update_process_title = on

stats_start_collector = on # needed for block or row stats
# (change requires restart)
#stats_block_level = off
stats_row_level = on
#stats_reset_on_server_start = off # (change requires restart)

- Statistics Monitoring -

#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off

#---------------------------------------------------------------------------

AUTOVACUUM PARAMETERS

#---------------------------------------------------------------------------

autovacuum = on # enable autovacuum subprocess?
# ‘on’ requires stats_start_collector
# and stats_row_level to also be on
#autovacuum_naptime = 1min # time between autovacuum runs
#autovacuum_vacuum_threshold = 500 # min # of tuple updates before
# vacuum
#autovacuum_analyze_threshold = 250 # min # of tuple updates before
# analyze
#autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before
# vacuum
#autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before
# analyze
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
# (change requires restart)
#autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
# autovacuum, -1 means use
# vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovacuum, -1 means use
# vacuum_cost_limit

#---------------------------------------------------------------------------

CLIENT CONNECTION DEFAULTS

#---------------------------------------------------------------------------

- Statement Behavior -

#search_path = ‘"$user",public’ # schema names
#default_tablespace = ‘’ # a tablespace name, ‘’ uses
# the default
#check_function_bodies = on
#default_transaction_isolation = ‘read committed’
#default_transaction_read_only = off
#statement_timeout = 0 # 0 is disabled
#vacuum_freeze_min_age = 100000000

- Locale and Formatting -

datestyle = ‘iso, mdy’
#timezone = unknown # actually, defaults to TZ
# environment setting
#timezone_abbreviations = ‘Default’ # select the set of available timezone
# abbreviations. Currently, there are
# Default
# Australia
# India
# However you can also create your own
# file in share/timezonesets/.
#extra_float_digits = 0 # min -15, max 2
#client_encoding = sql_ascii # actually, defaults to database
# encoding

These settings are initialized by initdb – they might be changed

lc_messages = ‘C’ # locale for system error message
# strings
lc_monetary = ‘C’ # locale for monetary formatting
lc_numeric = ‘C’ # locale for number formatting
lc_time = ‘C’ # locale for time formatting

- Other Defaults -

#explain_pretty_print = on
#dynamic_library_path = ‘$libdir;C:\Program Files\PostgreSQL\8.2\share\pljava\’
#local_preload_libraries = ‘’

#---------------------------------------------------------------------------

LOCK MANAGEMENT

#---------------------------------------------------------------------------

#deadlock_timeout = 1s
#max_locks_per_transaction = 64 # min 10
# (change requires restart)

Note: each lock table slot uses ~270 bytes of shared memory, and there are

max_locks_per_transaction * (max_connections + max_prepared_transactions)

lock table slots.

#---------------------------------------------------------------------------

VERSION/PLATFORM COMPATIBILITY

#---------------------------------------------------------------------------

- Previous Postgres Versions -

#add_missing_from = off
#array_nulls = on
#backslash_quote = safe_encoding # on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = on
#standard_conforming_strings = off
#regex_flavor = advanced # advanced, extended, or basic
#sql_inheritance = on

- Other Platforms & Clients -

#transform_null_equals = off

#---------------------------------------------------------------------------

CUSTOMIZED OPTIONS

#---------------------------------------------------------------------------

#custom_variable_classes = ‘’ # list of custom variable class names
custom_variable_classes = ‘pljava’
pljava.classpath = ‘C:\Program Files\PostgreSQL\8.2\share\pljava\pljava.jar’
pljava.release_lingering_savepoints = true
pljava.debug = false
[/code:39fd7]

PL/JAVA, descompactar na pasta share do Postgres
[attachment=0:39fd7]pljava.zip[/attachment:39fd7]

PATH do Windows

[code:39fd7]%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\PostgreSQL\8.2\bin;C:\Program Files\PostgreSQL\8.2\lib;C:\Program Files\Java\jdk1.5.0_12\jre\bin;C:\Program Files\Java\jdk1.5.0_12\jre\bin\client;C:\Program Files\Java\jdk1.5.0_12\bin;C:\Program Files\Java\jdk1.5.0_12\lib[/code:39fd7]

acho que isso deve resolver o problema da sua instalação

ezequiellorenzatti · 2008-01-24 15:34:21 UTC

Olá

Revisei o postgresql.conf, e o path, a unica diferença é a versão do java e a pasta program file, está arquivos de programas, pq meu win xp é em portugues.

da mesma forma continuo obtendo os mesmo erros, baixei o pljava, que vc deixou o link, e não tem jeito.

oque pode estar acontecendo ??

ezequiellorenzatti · 2008-01-24 15:36:08 UTC

complementando, o post anterior

vou atualizar o java para a versao 6 update 4 com netbeans, pra ver se consigo alguma mudança.

efcunha · 2008-01-24 19:17:10 UTC

Boa tarde,

Tive um problema utilizando

Versão do Postgres: postgresql-8.2.6-1
Versão do Java: jdk-1_6
as bibliotecas do pl/java estavam dando pau consegui resolver baixando pljava-i686-pc-mingw32-pg8.2-1.3.1.tar e substituindo as que vem com o banco postgresql-8.2.6

pgfoundry.org/projects/pljava/

ai vc pode rodar os scripts que vem no arquivo zip para instalar no postgresql o pl/java

ai o restante da configuração é só seguir os que foi passado

#---------------------------------------------------------------------------

CUSTOMIZED OPTIONS

#---------------------------------------------------------------------------

dynamic_library_path =’$libdir;C:\Arquivos de Programas\PostgreSQL\8.2\lib’
custom_variable_classes = ‘pljava’
pljava.classpath = ‘C:\Arquivos de Programas\PostgreSQL\8.2\share\pljava\pljava.jar’
pljava.release_lingering_savepoints = true
pljava.vmoptions = ‘-Xmx64M -Dbackchannel.port=48’
pljava.debug = false

Espero ter ajudado

ezequiellorenzatti · 2008-01-25 12:27:16 UTC

tentei a solução apresentada, mas nada ainda.

Já procurei na internet, informações sobre o erro, mas meu ingles é muito fraco

pelo meu entendimento, o problema está na hora qu a dll vai ser carregada

psql:Adempiere_pg.dmp:44: ERROR: could not load library “C:/Arquivos de programas/PostgreSQL/8.2/lib/pljava.dll”: unknown error 127

podem nao encontro documentação disponível sobre esse erro.

ezequiellorenzatti · 2008-02-02 12:23:00 UTC

Após diversas tentativas e buscas na internet, encontrei a solução para o problema.

o mesmo encontra-se na definição da váriavel $libdir

o postgres procura o arquivo pljava.dll no caminho c:\arquivos de programas\postgresql\8.2\lib e não encontra

A Solução que eu encontrei foi adicionar o caminho do arquivo pljava.dll no arquivo postgresql.conf
dynamic_library_path = ‘c:\arquiv~1\postgresql\8.3rc2\share\pljava:$libdir’

A propósito estou usando a versão 8.3rc2.

Só uma questão que não entendo, porque mesmo optando pela intalação do pljava desde o inicio o postgres não é configurado automaticamente.

é isso, estou partindo para os testes.

Abraço a todos
E caso eu puder ajudar estarei a disposição.

Ezequiel · 2008-02-25 18:49:46 UTC

ezequiellorenzatti, fala xará!!!

Veja se vc me ajuda. eu não consigo fazer rodar o procedimento abaixo. Instalei o Java1.5_10 e o Postgres8.2 no Windows Xp (Máquina DELL NOVA).

O erro acontece no passo 4.3 do link compierebrasil.com.br/2006/i … ao_pg2.htm

veja:

C:\Documents and Settings\Ezequiel>createuser -U postgres compiere -P
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
Password:
CREATE ROLE

C:\Documents and Settings\Ezequiel>createdb -U compiere compiere -E UTF8
Password:
CREATE DATABASE

C:\Documents and Settings\Ezequiel>java -cp c:\arquiv~1\postgresql\8.2\share\plj
ava\deploy.jar;c:\arquiv~1\postgresql\8.2\jdbc\postgresql-8.1-405.jdbc3.jar org.
postgresql.pljava.deploy.Deployer -install -user compiere -database compiere -pa
ssword compiere

C:\Documents and Settings\Ezequiel>psql -U compiere compiere
Password for user compiere:
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (850) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page “Notes for Windows users” for details.

compiere=# create schema compiere;
CREATE SCHEMA
compiere=# SET search_path TO compiere,sqlj;
SET
compiere=# SELECT sqlj.install_jar(‘file:///c:\Compiere2\lib\sqlj.jar’, 'sqlj
‘, true);
WARNING: nonstandard use of \ in a string literal
LINE 1: SELECT sqlj.install_jar(‘file:///c:\Compiere2\lib\sqlj.ja…
^
HINT: Use the escape string syntax for backslashes, e.g., E’\’.
WARNING: java.lang.NoClassDefFoundError: org/postgresql/pljava/internal/Backend

ERROR: Unable to load class org/postgresql/pljava/internal/Backend using CLASSP
ATH ‘-Djava.class.path=C:\Program Files\PostgreSQL\8.2\share\pljava\pljava.jar’
compiere=#

mgrigioni · 2008-02-25 19:58:20 UTC

Ezequiel, pule este passo do site compierebrasil.

execute este script e se estiver OK, o pl/java foi instalado corretamente

vá no prompt e entre na pasta onde está o pljava.jar e execute o comando (importante, a pasta bin do Postgres deve estar no PATH no windows)

psql -f install.sql

este processo, vai instalar as funções pl/java no seu banco.

sds, Mario

Ezequiel · 2008-02-26 14:20:00 UTC

[quote=“mgrigioni”:79ce4]
Ezequiel, pule este passo do site compierebrasil.

execute este script e se estiver OK, o pl/java foi instalado corretamente

vá no prompt e entre na pasta onde está o pljava.jar e execute o comando (importante, a pasta bin do Postgres deve estar no PATH no windows)

psql -f install.sql

este processo, vai instalar as funções pl/java no seu banco.

sds, Mario
[/quote:79ce4]
olá amigo, finalmente consegui mas pelo processo da compiere brasil mesmo só q com algumas modificações. Agora estou apanhando pra arrumar o arquivo pg_hba.conf. como eu coloco a configuração certinha nele??? tipo meu ip é 10.11.244.198 e não vou usar o compiere em rede por enquanto não. Aguardo uma ajudinha!!!

Ezequiel · 2008-02-26 14:24:27 UTC

belezinha!!! já acertei o arquivo agora sim!!!