agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] Error during Adempiere data base import using PL/Java
Date: Thu, 8 May 2008 09:05:18 -0400
Message-ID: <d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com> (raw)
Dear forum members,
I install Adempiere_340s.tar on the following system:
OpenSUSE 10.2 (32bit)
PostgreSQL 8.1.11 i586
Java-1-6-0-sun 1.6.0 i586
PL/Java package: pljava-i686-pc-linux-gnu-pg8.1-1.4.0
During import process of the Database dump I get the error messages below:
...
SET
psql:/usr/Adempiere/data/Adempiere_pg.dmp:6: ERROR: Parameter
?standard_conforming_strings? cannot be changed
SET
SET
SET
CREATE SCHEMA
ALTER SCHEMA
COMMENT
CREATE SCHEMA
...
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: ERROR: Error
?Syntaxerror? by ?OWNED? at character 38
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648: LINE 1: ALTER
SEQUENCE jar_entry_entryid_seq OWNED BY jar_entry.entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20648:
^
setval
--------
10
(1 row)
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: ERROR: Error
?Syntaxerror? by ?OWNED? at character 41
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691: LINE 1: ALTER
SEQUENCE jar_repository_jarid_seq OWNED BY jar_reposit...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20691:
^
setval
--------
1
(1 row)
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: ERROR: Error
?Syntaxerror? by ?OWNED? at character 40
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732: LINE 1: ALTER
SEQUENCE typemap_entry_mapid_seq OWNED BY typemap_entr...
psql:/usr/Adempiere/data/Adempiere_pg.dmp:20732:
^
setval
--------
1
(1 row)
ALTER TABLE
ALTER TABLE
...
Regarding the first error I have found inside the PostgreSQL 8.2.7
documentation the description below. Can anybody tell me where I can
make this parameter
changeable? I did'nt find it in the postgresql.conf.
Chapter 17. Server Configuration
17.12. Version and Platform Compatibility
17.12.1. Previous PostgreSQL Versions
standard_conforming_strings (boolean)
This controls whether ordinary string literals ('...') treat
backslashes literally, as specified in the SQL standard. The default
is currently off, causing
PostgreSQL to have its historical behavior of treating backslashes as
escape characters. The default will change to on in a future release
to improve
compatibility with the standard. Applications may check this parameter
to determine how string literals will be processed. The presence of
this parameter can
also be taken as an indication that the escape string syntax (E'...')
is supported. Escape string syntax should be used if an application
desires backslashes
to be treated as escape characters.
Regarding the other three errors I would appreciate if anybody can
tell me if its a problem either with my PL/Java installation or an
issue of Adempiere. Maybe somebody has also an idea how I can fix it
;o)
Thanks in advance,
Hawky
view thread (3+ messages) latest in thread
Message-ID: <d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com>
Permalink: ../d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com/
Also on: postgresql.org/message-id/d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Error during Adempiere data base import using PL/Java
In-Reply-To: <d5711a020805080605q67c923cbp97c1a7bcff410de5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox