Hi Joon,I have no source code for this contrib/lo and dll/function seem already be stored with my 8.0.13 installation package.Any suggestion?Regards,NETsolutions Asia Limited +66 2 401 9250 >>> John R Pierce <pierce@hogranch.com> 2016-03-03 09:05 >>>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
NETsolutions Asia Limited +66 2 401 9250
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных