But then when I do a psql < tsearch2.sql, it complains: bash-2.05a$ psql testdb < tsearch2.sql SET BEGIN NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pg_ts_dict_pkey' for table 'pg_ts_dict' CREATE TABLE ERROR: stat failed on file '$libdir/tsearch2': No such file or directory ERROR: current transaction is aborted, queries ignored until end of transaction block ERROR: current transaction is aborted, queries ignored until end of transaction block ... (and the ERROR message repeats many times)
Where did I do wrong?? Thanks Wei On Thu, 25 Sep 2003, Tom Lane wrote: > Wei Weng <[EMAIL PROTECTED]> writes: > > In my tsearch2.sql there are statements like : > > --dict interface > > CREATE FUNCTION lexize(oid, text) > > returns _text > > as '$libdir/tsearch2' > > language 'C' > > with (isstrict); > > > I don't think $libdir is the real value that we want. > > Yes it is. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
