On 3/2/2016 5:52 PM, Premsun Choltanwanich wrote:
And, almost tables are transferred to new server except tables which
contain lo data (all those tables are missing from the database) after
running pg_dump and psql following as per your suggestion.
The attachment is a log file created after all processes are completed.
your logfile shows a bunch of custom functions being defined which are
dependent on a missing binary library, apparently your previous install
of postgres has some customizations.
2016-03-02 18:06:25 ICT ERROR: could not find function "lo_in" in file "C:/Program
Files/PostgreSQL/9.5/lib/lo.dll"
2016-03-02 18:06:25 ICT STATEMENT: CREATE FUNCTION lo_in(cstring) RETURNS lo
LANGUAGE c IMMUTABLE STRICT
AS '$libdir/lo', 'lo_in';
these custom functions are being used to define a custom data type.
2016-03-02 18:06:25 ICT ERROR: function lo_in(cstring) does not exist
2016-03-02 18:06:25 ICT STATEMENT: CREATE TYPE lo (
INTERNALLENGTH = 4,
INPUT = lo_in,
OUTPUT = lo_out,
ALIGNMENT = int4,
STORAGE = plain
);
and your tables are using this custom data type 'lo', which is invalid
since the code to implement it is missing.
2016-03-02 18:06:26 ICT ERROR: type "lo" is only a shell at character 186
2016-03-02 18:06:26 ICT STATEMENT: CREATE TABLE t_familypic (
sysid bigint DEFAULT nextval('public.t_familypic_sysid_seq'::text)
NOT NULL,
mbrsysid bigint NOT NULL,
familysysid bigint NOT NULL,
familypic lo
);
do you have the source code to this lo.dll so you can be rebuild it for
9.5 ?
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
