user defined data type problem while dumping?
| От | sarlav kumar |
|---|---|
| Тема | user defined data type problem while dumping? |
| Дата | |
| Msg-id | 20041227173233.98750.qmail@web51301.mail.yahoo.com обсуждение исходный текст |
| Ответы |
Re: user defined data type problem while dumping?
Re: [PERFORM] user defined data type problem while dumping? |
| Список | pgsql-novice |
-- TOC entry 5 (OID 19114)
-- Name: lo; Type: TYPE; Schema: public; Owner: user
-- Data Pos: 0
--
INTERNALLENGTH = 4,
INPUT = lo_in,
OUTPUT = lo_out,
DEFAULT = '-',
ALIGNMENT = int4,
STORAGE = plain
);
-- TOC entry 851 (OID 19115)
-- Name: lo_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
-- Data Pos: 0
--
AS '/usr/local/pgsql/lib/contrib/lo.so', 'lo_in'
LANGUAGE c;
-- TOC entry 852 (OID 19116)
-- Name: lo_out(lo); Type: FUNCTION; Schema: public; Owner: postgres
-- Data Pos: 0
--
AS '/usr/local/pgsql/lib/contrib/lo.so', 'lo_out'
LANGUAGE c;
--
-- TOC entry 853 (OID 19117)
-- Name: lo_manage(); Type: FUNCTION; Schema: public; Owner: postgres
-- Data Pos: 0
--
AS '/usr/local/pgsql/lib/contrib/lo.so', 'lo_manage'
LANGUAGE c;
--
-- TOC entry 854 (OID 19129)
-- Name: lo_oid(lo); Type: FUNCTION; Schema: public; Owner: postgres
-- Data Pos: 0
--
AS '/usr/local/pgsql/lib/contrib/lo.so', 'lo_oid'
LANGUAGE c;
-- TOC entry 855 (OID 19130)
-- Name: oid(lo); Type: FUNCTION; Schema: public; Owner: postgres
-- Data Pos: 0
--
AS '/usr/local/pgsql/lib/contrib/lo.so', 'lo_oid'
LANGUAGE c;
-- TOC entry 278 (OID 19119)
-- Name: session; Type: TABLE; Schema: public; Owner: user
-- Data Pos: 0
--
session_id text NOT NULL,
pid_owner integer DEFAULT 0,
pid_pending integer DEFAULT 0,
created timestamp with time zone DEFAULT now(),
accessed timestamp with time zone DEFAULT now(),
modified timestamp with time zone DEFAULT now(),
uid integer,
ip inet,
browser character varying(200),
params character varying(200),
content lo
);
psql:trialdump1:4364: NOTICE: type "lo" is not yet defined
DETAIL: Creating a shell type definition.
psql:trialdump1:4364: ERROR: could not access file "/usr/local/pgsql/lib/contrib/lo.so": No such file or directory
psql:trialdump1:4374: ERROR: type lo does not exist
psql:trialdump1:4391: ERROR: function lo_in(cstring) does not exist
psql:trialdump1:4403: ERROR: could not access file "/usr/local/pgsql/lib/contrib/lo.so": No such file or directory
psql:trialdump1:4425: ERROR: type "lo" does not exist
psql:trialdump1:4437: ERROR: type lo does not exist
psql:trialdump1:4447: ERROR: type lo does not exist
psql:trialdump1:4460: ERROR: type "lo" does not exist
psql:trialdump1:4472: ERROR: could not access file "/usr/lib/test_funcs.so": No such file or directory
psql:trialdump1:7606: ERROR: relation "session" does not exist
psql:trialdump1:10868: ERROR: relation "session" does not exist
psql:trialdump1:13155: ERROR: relation "session" does not exist
The session table uses type "lo" for one of it's columns and hence it does not get created.
What could the problem be? Is it some sort of access rights problem with respect to the files it is not able to access?
When I restored the dump after commenting out all tables/functions using the type "lo", everything works fine.
It will be great if someone could throw light on this problem.
Thanks,
Saranya
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
В списке pgsql-novice по дате отправления: