diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-17 20:57:57 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-04-17 20:57:57 +0000 |
| commit | 27a54ae282d74ee471a5b34d136fe3d4f894a9de (patch) | |
| tree | 59aedb6b78d8b4ff8f26f6a945799a443dd6d571 /contrib/tsearch | |
| parent | d85a81cbc384614eec525ca19e1cf48687643725 (diff) | |
| download | postgresql-27a54ae282d74ee471a5b34d136fe3d4f894a9de.tar.gz | |
Opclasses live in namespaces. I also took the opportunity to create
an 'opclass owner' column in pg_opclass. Nothing is done with it at
present, but since there are plans to invent a CREATE OPERATOR CLASS
command soon, we'll probably want DROP OPERATOR CLASS too, which
suggests that a notion of ownership would be a good idea.
Diffstat (limited to 'contrib/tsearch')
| -rw-r--r-- | contrib/tsearch/tsearch.sql.in | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/contrib/tsearch/tsearch.sql.in b/contrib/tsearch/tsearch.sql.in index 48a5ae27e6..e53793cf71 100644 --- a/contrib/tsearch/tsearch.sql.in +++ b/contrib/tsearch/tsearch.sql.in @@ -155,10 +155,12 @@ CREATE FUNCTION gtxtidx_union(bytea, opaque) RETURNS _int4 CREATE FUNCTION gtxtidx_same(gtxtidx, gtxtidx, opaque) RETURNS opaque AS 'MODULE_PATHNAME' LANGUAGE 'c'; -INSERT INTO pg_opclass (opcamid, opcname, opcintype, opcdefault, opckeytype) +INSERT INTO pg_opclass (opcamid, opcname, opcnamespace, opcowner, opcintype, opcdefault, opckeytype) VALUES ( (SELECT oid FROM pg_am WHERE amname = 'gist'), 'gist_txtidx_ops', + (SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog'), + 1, -- UID of superuser is hardwired to 1 as of PG 7.3 (SELECT oid FROM pg_type WHERE typname = 'txtidx'), true, (SELECT oid FROM pg_type WHERE typname = 'gtxtidx')); |