2008/11/5 Tom Lane <tgl@sss.pgh.pa.us>:
> "Pavel Stehule" <pavel.stehule@gmail.com> writes:
>> 2008/11/4 Tom Lane <tgl@sss.pgh.pa.us>:
>>> "Pavel Stehule" <pavel.stehule@gmail.com> writes:
>>>> a) server crash after creating tsearch2 function (I use tsearch2
>>>> contrib from 8.3)
>>>
>>> I couldn't reproduce that with the script you gave.
>
>> I tested it on fe8, 32 bit without problem, so it's maybe related to 64bit.
>
> Can't reproduce it on 64-bit either. Looking closer, I don't believe
> that you were running this script at all --- the crash backtrace
> includes
>
> #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
>
> and there is no such command in this script.
I should send complet script on your private address. It has 2MB.
>
> Something else weird I just noticed: in this script, you've got
>
> --
> -- 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
> );
>
>
it's strange - you have different error. Script was truncated, but I
have error some time before.
ALTER FUNCTION
SET
SET
ERROR: type "tsvector" is only a shell
LINE 5: fulltext_index tsvector ^
that is wrong. type tsvector is normal type registrated from tsearch2 module.
regards
Pavel Stehule
> 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;
>
>
> The CREATE VIEW fails because there's no uniq_key column in "position".
> Either you edited this script before sending it in, or there's something
> a bit broken about pg_dump or the database you dumped from.
>
> regards, tom lane
>