[HACKERS] some strange bugs related to upgrade from 8.1 to 8.3

Pavel Stehule Tue, 04 Nov 2008 07:23:39 -0800

Hello

I started upgrade our databases from 8.1 to 8.3. I found two strange
bugs related to tsearch2.


a) server crash after creating tsearch2 function (I use tsearch2
contrib from 8.3)
(gdb) bt
#0  0x0000003838033075 in raise () from /lib64/libc.so.6
#1  0x0000003838034be3 in abort () from /lib64/libc.so.6
#2  0x000000000068db5d in ExceptionalCondition (conditionName=<value
optimized out>, errorType=<value optimized out>, fileName=<value
optimized out>, lineNumber=<value optimized out>) at assert.c:57
#3  0x0000000000a6cc79 in plpgsql_HashTableInit () at pl_comp.c:2016
#4  0x0000000000e95d72 in _PG_init () from /usr/lib64/pgsql/plpgsql.so
#5  0x0000000000693105 in internal_load_library (libname=0x1fd5c70
"/usr/lib64/pgsql/plpgsql.so") at dfmgr.c:296
#6  0x0000000000693506 in load_external_function (filename=<value
optimized out>, funcname=0x1fa8358 "plpgsql_call_handler",
signalNotFound=1 '\001', filehandle=0x7fff8eb5d678) at dfmgr.c:110
#7  0x00000000004bd1b9 in fmgr_c_validator (fcinfo=<value optimized
out>) at pg_proc.c:509
#8  0x00000000006964e6 in OidFunctionCall1 (functionId=<value
optimized out>, arg1=28155) at fmgr.c:1532
#9  0x00000000004bdab0 in ProcedureCreate (procedureName=0x1f6a430
"plpgsql_call_handler", procNamespace=2200, replace=0 '\0',
returnsSet=0 '\0', returnType=2280, languageObjectId=13,
    languageValidator=2247, prosrc=0x1f6a640 "plpgsql_call_handler",
probin=0x1f6a608 "/usr/lib64/pgsql/plpgsql", isAgg=0 '\0',
security_definer=0 '\0', isStrict=0 '\0', volatility=118 'v',
    parameterTypes=0x1fa7a90, allParameterTypes=0, parameterModes=0,
parameterNames=0, proconfig=0, procost=1, prorows=0) at pg_proc.c:413
#10 0x0000000000502588 in CreateFunction (stmt=0x1f6a890) at functioncmds.c:785
#11 0x00000000005e3da5 in PortalRunUtility (portal=0x1fc3678,
utilityStmt=0x1f6a890, isTopLevel=-1 '�', dest=0x1f6a948,
completionTag=0x7fff8eb5e020 "") at pquery.c:1173
#12 0x00000000005e53d5 in PortalRunMulti (portal=0x1fc3678,
isTopLevel=<value optimized out>, dest=0x1f6a948, altdest=0x1f6a948,
completionTag=0x7fff8eb5e020 "") at pquery.c:1266
#13 0x00000000005e5c1b in PortalRun (portal=0x1fc3678,
count=9223372036854775807, isTopLevel=64 '@', dest=0x1f6a948,
altdest=0x1f6a948, completionTag=0x7fff8eb5e020 "") at pquery.c:813
#14 0x00000000005e0a0c in exec_simple_query (
    query_string=0x1f69ae8 "CREATE FUNCTION plpgsql_call_handler()
RETURNS language_handler\n    AS '/usr/lib64/pgsql/plpgsql',
'plpgsql_call_handler'\n    LANGUAGE c;") at postgres.c:986
#15 0x00000000005e1f67 in PostgresMain (argc=4, argv=<value optimized
out>, username=0x1ed56a8 "pavel") at postgres.c:3572
#16 0x00000000005ae96a in BackendRun () at postmaster.c:3207
#17 BackendStartup () at postmaster.c:2830
#18 ServerLoop () at postmaster.c:1274
#19 0x00000000005af685 in PostmasterMain (argc=3, argv=0x1ed1540) at
postmaster.c:1029
#20 0x000000000055f208 in main (argc=3, argv=0x1ed1540) at main.c:188
(gdb)

ERROR:  function public.lexize(text) does not exist
STATEMENT:  ALTER FUNCTION public.lexize(text) OWNER TO postgres;
ERROR:  could not find function "parse" in file
"/usr/local/pgsql8.3/lib/tsearch2.so"
STATEMENT:  CREATE FUNCTION parse(oid, text) RETURNS SETOF tokenout
<------>    AS '$libdir/tsearch2', 'parse'
<------>    LANGUAGE c STRICT;
ERROR:  function public.parse(oid, text) does not exist
STATEMENT:  ALTER FUNCTION public.parse(oid, text) OWNER TO postgres;
ERROR:  could not find function "parse_byname" in file
"/usr/local/pgsql8.3/lib/tsearch2.so"
STATEMENT:  CREATE FUNCTION parse(text, text) RETURNS SETOF tokenout
<------>    AS '$libdir/tsearch2', 'parse_byname'
<------>    LANGUAGE c STRICT;
ERROR:  function public.parse(text, text) does not exist
STATEMENT:  ALTER FUNCTION public.parse(text, text) OWNER TO postgres;
ERROR:  could not find function "parse_current" in file
"/usr/local/pgsql8.3/lib/tsearch2.so"
STATEMENT:  CREATE FUNCTION parse(text) RETURNS SETOF tokenout
<------>    AS '$libdir/tsearch2', 'parse_current'
<------>    LANGUAGE c STRICT;
ERROR:  function public.parse(text) does not exist
STATEMENT:  ALTER FUNCTION public.parse(text) OWNER TO postgres;
TRAP: FailedAssertion("!(plpgsql_HashTable == ((void *)0))", File:
"pl_comp.c", Line: 2016)
LOG:  server process (PID 4672) was terminated by signal 6: Aborted
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2008-11-04 15:01:14 CET
LOG:  database system was not properly shut down; automatic recovery in progress

b) after instalation tsearch2 (8.3) postgresql knows tsvector type

template1=# select 'tsvector'::regtype;
 regtype
----------
 tsvector
(1 row)

template1=# create table foo(a tsvector);
CREATE TABLE
template1=#

but inside import pg should forget this type and use tsvector only as shell type

ERROR:  type "tsvector" is only a shell
STATEMENT:  CREATE TYPE tsdebug AS (
<------><------>ts_name text,
<------><------>tok_type text,
<------><------>description text,
<------><------>token text,
<------><------>dict_name text[],
<------><------>tsvector tsvector
<------>);
ERROR:  type "public.tsdebug" does not exist
STATEMENT:  ALTER TYPE public.tsdebug OWNER TO postgres;
NOTICE:  argument type tsvector is only a shell
STATEMENT:  CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
<------>    AS '$libdir/tsearch2', 'concat'
<------>    LANGUAGE c IMMUTABLE STRICT;
NOTICE:  argument type tsvector is only a shell
STATEMENT:  CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
<------>    AS '$libdir/tsearch2', 'concat'

in this moment we cannot do tables
ERROR:  type "tsvector" is only a shell at character 1274
STATEMENT:  CREATE TABLE "position" (CREATE TYPE tsvector;

<------>    id integer NOT NULL,
<------>    title character varying(255) NOT NULL,
<------>    description text,
<------>    work_address character varying(255),
<------>    reward character varying(100),
<------>    time_info character varying(100),
<------>    work_type character varying(80),
<------>    date_enter integer NOT NULL,
<------>    date_expire integer NOT NULL,
<------>    date_expire_original integer NOT NULL,
<------>    id_status integer NOT NULL,
<------>    submitter_name character varying(50),
<------>    submitter_email character varying(80),
<------>    submitter_phone character varying(50),
<------>    uniq_key character varying(55),
<------>    id_svl_work_kind character(3),
<------>    submitter_ip character varying(40),
<------>    source character(1),
<------>    target character varying(2) NOT NULL,
<------>    iswarranty character(1),
<------>    url_pdjd character varying(255),
<------>    g2_id integer,
<------>    rejection_description text,
<------>    g2_id_personnel integer,
<------>    g2_id_company integer,
<------>    contact_company_name character varying(100),
<------>    contact_company_info character varying(255),
<------>    contact_person character varying(50),
<------>    contact_phone character varying(50),
<------>    contact_email character varying(80),
<------>    contact_address character varying(255),
<------>    date_enter_modified integer,
<------>    ispaid character(1) DEFAULT 0,
<------>    date_enter_touched integer,
<------>    fulltext_index tsvector
<------>);

build script is in attachement, log too

--
-- PostgreSQL database cluster dump
--

\connect postgres

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET escape_string_warning = 'off';

CREATE ROLE lmc;
ALTER ROLE lmc WITH SUPERUSER NOINHERIT CREATEROLE CREATEDB LOGIN;


--
-- Database creation
--

CREATE DATABASE brigady WITH TEMPLATE = template0 OWNER = lmc ENCODING = 'UTF8';


--
-- PostgreSQL database dump complete
--

\connect brigady

--
-- PostgreSQL database dump
--

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
--

CREATE PROCEDURAL LANGUAGE plpgsql;


ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO postgres;

SET search_path = public, pg_catalog;

--
-- Name: gtsvector; Type: SHELL TYPE; Schema: public; Owner: postgres
--

CREATE TYPE gtsvector;


--
-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
    AS '$libdir/tsearch2', 'gtsvector_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.gtsvector_in(cstring) OWNER TO postgres;

--
-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
    AS '$libdir/tsearch2', 'gtsvector_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.gtsvector_out(gtsvector) OWNER TO postgres;

--
-- Name: gtsvector; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE gtsvector (
    INTERNALLENGTH = variable,
    INPUT = gtsvector_in,
    OUTPUT = gtsvector_out,
    ALIGNMENT = int4,
    STORAGE = plain
);


ALTER TYPE public.gtsvector OWNER TO postgres;

--
-- Name: tsquery; Type: SHELL TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tsquery;


--
-- Name: tsquery_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tsquery_in(cstring) RETURNS tsquery
    AS '$libdir/tsearch2', 'tsquery_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsquery_in(cstring) OWNER TO postgres;

--
-- Name: tsquery_out(tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tsquery_out(tsquery) RETURNS cstring
    AS '$libdir/tsearch2', 'tsquery_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsquery_out(tsquery) OWNER TO postgres;

--
-- Name: tsquery; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tsquery (
    INTERNALLENGTH = variable,
    INPUT = tsquery_in,
    OUTPUT = tsquery_out,
    ALIGNMENT = int4,
    STORAGE = plain
);


ALTER TYPE public.tsquery OWNER TO postgres;

--
-- Name: tsvector; Type: SHELL TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tsvector;


--
-- Name: tsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tsvector_in(cstring) RETURNS tsvector
    AS '$libdir/tsearch2', 'tsvector_in'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsvector_in(cstring) OWNER TO postgres;

--
-- Name: tsvector_out(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tsvector_out(tsvector) RETURNS cstring
    AS '$libdir/tsearch2', 'tsvector_out'
    LANGUAGE c STRICT;


ALTER FUNCTION public.tsvector_out(tsvector) OWNER TO postgres;

--
-- Name: tsvector; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tsvector (
    INTERNALLENGTH = variable,
    INPUT = tsvector_in,
    OUTPUT = tsvector_out,
    ALIGNMENT = int4,
    STORAGE = extended
);


ALTER TYPE public.tsvector OWNER TO postgres;

--
-- Name: statinfo; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE statinfo AS (
	word text,
	ndoc integer,
	nentry integer
);


ALTER TYPE public.statinfo OWNER TO postgres;

--
-- Name: tokenout; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tokenout AS (
	tokid integer,
	token text
);


ALTER TYPE public.tokenout OWNER TO postgres;

--
-- Name: tokentype; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tokentype AS (
	tokid integer,
	alias text,
	descr text
);


ALTER TYPE public.tokentype OWNER TO postgres;

--
-- Name: tsdebug; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE tsdebug AS (
	ts_name text,
	tok_type text,
	description text,
	token text,
	dict_name text[],
	tsvector tsvector
);


ALTER TYPE public.tsdebug OWNER TO postgres;

--
-- Name: _get_parser_from_curcfg(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION _get_parser_from_curcfg() RETURNS text
    AS $$ select prs_name from pg_ts_cfg where oid = show_curcfg() $$
    LANGUAGE sql IMMUTABLE STRICT;


ALTER FUNCTION public._get_parser_from_curcfg() OWNER TO postgres;

--
-- Name: concat(tsvector, tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION concat(tsvector, tsvector) RETURNS tsvector
    AS '$libdir/tsearch2', 'concat'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.concat(tsvector, tsvector) OWNER TO postgres;


--
-- Name: dex_init(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dex_init(internal) RETURNS internal
    AS '$libdir/tsearch2', 'dex_init'
    LANGUAGE c;


ALTER FUNCTION public.dex_init(internal) OWNER TO postgres;

--
-- Name: dex_lexize(internal, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION dex_lexize(internal, internal, integer) RETURNS internal
    AS '$libdir/tsearch2', 'dex_lexize'
    LANGUAGE c STRICT;


ALTER FUNCTION public.dex_lexize(internal, internal, integer) OWNER TO postgres;

--
-- Name: exectsq(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION exectsq(tsvector, tsquery) RETURNS boolean
    AS '$libdir/tsearch2', 'exectsq'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.exectsq(tsvector, tsquery) OWNER TO postgres;

--
-- Name: FUNCTION exectsq(tsvector, tsquery); Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON FUNCTION exectsq(tsvector, tsquery) IS 'boolean operation with text index';


--
-- Name: get_covers(tsvector, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION get_covers(tsvector, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'get_covers'
    LANGUAGE c STRICT;


ALTER FUNCTION public.get_covers(tsvector, tsquery) OWNER TO postgres;


--
-- Name: FUNCTION get_min_last_sync(character varying); Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON FUNCTION get_min_last_sync(character varying) IS 'vraci nejmensi datum synchronizace';


--
-- Name: gtsvector_compress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_compress(internal) RETURNS internal
    AS '$libdir/tsearch2', 'gtsvector_compress'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_compress(internal) OWNER TO postgres;

--
-- Name: gtsvector_consistent(gtsvector, internal, integer); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_consistent(gtsvector, internal, integer) RETURNS boolean
    AS '$libdir/tsearch2', 'gtsvector_consistent'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_consistent(gtsvector, internal, integer) OWNER TO postgres;

--
-- Name: gtsvector_decompress(internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_decompress(internal) RETURNS internal
    AS '$libdir/tsearch2', 'gtsvector_decompress'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_decompress(internal) OWNER TO postgres;

--
-- Name: gtsvector_penalty(internal, internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_penalty(internal, internal, internal) RETURNS internal
    AS '$libdir/tsearch2', 'gtsvector_penalty'
    LANGUAGE c STRICT;


ALTER FUNCTION public.gtsvector_penalty(internal, internal, internal) OWNER TO postgres;

--
-- Name: gtsvector_picksplit(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_picksplit(internal, internal) RETURNS internal
    AS '$libdir/tsearch2', 'gtsvector_picksplit'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_picksplit(internal, internal) OWNER TO postgres;

--
-- Name: gtsvector_same(gtsvector, gtsvector, internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_same(gtsvector, gtsvector, internal) RETURNS internal
    AS '$libdir/tsearch2', 'gtsvector_same'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_same(gtsvector, gtsvector, internal) OWNER TO postgres;

--
-- Name: gtsvector_union(bytea, internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_union(bytea, internal) RETURNS integer[]
    AS '$libdir/tsearch2', 'gtsvector_union'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_union(bytea, internal) OWNER TO postgres;

--
-- Name: gtsvector_union(internal, internal); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION gtsvector_union(internal, internal) RETURNS integer[]
    AS '$libdir/tsearch2', 'gtsvector_union'
    LANGUAGE c;


ALTER FUNCTION public.gtsvector_union(internal, internal) OWNER TO postgres;

--
-- Name: headline(oid, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(oid, text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(oid, text, tsquery, text) OWNER TO postgres;

--
-- Name: headline(oid, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(oid, text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(oid, text, tsquery) OWNER TO postgres;

--
-- Name: headline(text, text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(text, text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline_byname'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, text, tsquery, text) OWNER TO postgres;

--
-- Name: headline(text, text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(text, text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline_byname'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, text, tsquery) OWNER TO postgres;

--
-- Name: headline(text, tsquery, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(text, tsquery, text) RETURNS text
    AS '$libdir/tsearch2', 'headline_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, tsquery, text) OWNER TO postgres;

--
-- Name: headline(text, tsquery); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION headline(text, tsquery) RETURNS text
    AS '$libdir/tsearch2', 'headline_current'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.headline(text, tsquery) OWNER TO postgres;


--
-- Name: length(tsvector); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION length(tsvector) RETURNS integer
    AS '$libdir/tsearch2', 'tsvector_length'
    LANGUAGE c IMMUTABLE STRICT;


ALTER FUNCTION public.length(tsvector) OWNER TO postgres;

--
-- Name: lexize(oid, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION lexize(oid, text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(oid, text) OWNER TO postgres;

--
-- Name: lexize(text, text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION lexize(text, text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize_byname'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(text, text) OWNER TO postgres;

--
-- Name: lexize(text); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION lexize(text) RETURNS text[]
    AS '$libdir/tsearch2', 'lexize_bycurrent'
    LANGUAGE c STRICT;


ALTER FUNCTION public.lexize(text) OWNER TO postgres;

--
-- Name: list_admin_stopword(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION list_admin_stopword() RETURNS SETOF record
    AS $$
DECLARE

        row     RECORD;
    BEGIN
       FOR row IN SELECT word
                    FROM admin_stopword LOOP
                        RETURN NEXT row;
                        END LOOP;
            RETURN;
    END;
$$
    LANGUAGE plpgsql;


ALTER FUNCTION public.list_admin_stopword() OWNER TO postgres;


SET default_tablespace = '';

SET default_with_oids = false;


--
-- Name: position; Type: TABLE; Schema: public; Owner: lmc; Tablespace: 
--

CREATE TABLE "position" (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    description text,
    fulltext_index tsvector
);


ALTER TABLE public."position" OWNER TO lmc;

--
-- Name: view_position_uniq; Type: VIEW; Schema: public; Owner: lmc
--

CREATE VIEW view_position_uniq AS
    SELECT p.uniq_key FROM "position" p;

You are now connected to database "postgres".
SET
SET
SET
ERROR:  role "lmc" already exists
ALTER ROLE
CREATE DATABASE
You are now connected to database "brigady".
SET
SET
SET
SET
SET
CREATE LANGUAGE
ALTER LANGUAGE
SET
CREATE TYPE
ERROR:  could not find function "gtsvector_in" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_in(cstring) does not exist
ERROR:  could not find function "gtsvector_out" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_out(gtsvector) does not exist
ERROR:  function gtsvector_in(cstring) does not exist
ALTER TYPE
CREATE TYPE
ERROR:  could not find function "tsquery_in" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.tsquery_in(cstring) does not exist
ERROR:  could not find function "tsquery_out" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.tsquery_out(tsquery) does not exist
ERROR:  function tsquery_in(cstring) does not exist
ALTER TYPE
CREATE TYPE
ERROR:  could not find function "tsvector_in" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.tsvector_in(cstring) does not exist
ERROR:  could not find function "tsvector_out" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.tsvector_out(tsvector) does not exist
ERROR:  function tsvector_in(cstring) does not exist
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
ERROR:  type "tsvector" is only a shell
ERROR:  type "public.tsdebug" does not exist
CREATE FUNCTION
ALTER FUNCTION
ERROR:  could not find function "concat" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.concat(tsvector, tsvector) does not exist
ERROR:  could not find function "dex_init" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.dex_init(internal) does not exist
ERROR:  could not find function "dex_lexize" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.dex_lexize(internal, internal, integer) does not exist
ERROR:  could not find function "exectsq" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.exectsq(tsvector, tsquery) does not exist
ERROR:  function exectsq(tsvector, tsquery) does not exist
ERROR:  could not find function "get_covers" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.get_covers(tsvector, tsquery) does not exist
ERROR:  function get_min_last_sync(character varying) does not exist
ERROR:  could not find function "gtsvector_compress" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_compress(internal) does not exist
ERROR:  could not find function "gtsvector_consistent" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_consistent(gtsvector, internal, integer) does 
not exist
ERROR:  could not find function "gtsvector_decompress" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_decompress(internal) does not exist
ERROR:  could not find function "gtsvector_penalty" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_penalty(internal, internal, internal) does 
not exist
ERROR:  could not find function "gtsvector_picksplit" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_picksplit(internal, internal) does not exist
ERROR:  could not find function "gtsvector_same" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_same(gtsvector, gtsvector, internal) does not 
exist
ERROR:  could not find function "gtsvector_union" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_union(bytea, internal) does not exist
ERROR:  could not find function "gtsvector_union" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.gtsvector_union(internal, internal) does not exist
ERROR:  could not find function "headline" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(oid, text, tsquery, text) does not exist
ERROR:  could not find function "headline" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(oid, text, tsquery) does not exist
ERROR:  could not find function "headline_byname" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(text, text, tsquery, text) does not exist
ERROR:  could not find function "headline_byname" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(text, text, tsquery) does not exist
ERROR:  could not find function "headline_current" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(text, tsquery, text) does not exist
ERROR:  could not find function "headline_current" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.headline(text, tsquery) does not exist
ERROR:  could not find function "tsvector_length" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.length(tsvector) does not exist
ERROR:  could not find function "lexize" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.lexize(oid, text) does not exist
ERROR:  could not find function "lexize_byname" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.lexize(text, text) does not exist
ERROR:  could not find function "lexize_bycurrent" in file 
"/usr/local/pgsql8.3/lib/tsearch2.so"
ERROR:  function public.lexize(text) does not exist
CREATE FUNCTION
ALTER FUNCTION
SET
SET
ERROR:  type "tsvector" is only a shell
LINE 5:     fulltext_index tsvector
                           ^
ERROR:  relation "public.position" does not exist
ERROR:  relation "position" does not exist

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] some strange bugs related to upgrade from 8.1 to 8.3

Reply via email to