| From: | Marcus Engene <mengpg(at)engene(dot)se> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | oids and tsearch2 |
| Date: | 2005-11-14 14:23:37 |
| Message-ID: | 43789DE9.8060104@engene.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi list.
I have a table as
CREATE TABLE mytable
(
objectid INTEGER PRIMARY KEY NOT NULL
,description TEXT
,idxfti tsvector -- for tsearch2
)
WITHOUT OIDS;
CREATE INDEX mytable_fts ON mytable USING gist(idxfti);
...and the update trigger when description is changed.
I wonder, was it a bad idea to create mytable without oids? Does the
tsearch2 indexing require it? If yes, must I recreate the table or can I
add oids on an existing table?
From the user doc about oids, I haven't really figured out when to use
them or not. So by habit I disable them.
Thanks,
Marcus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sebastian Scarano | 2005-11-14 15:52:32 | Re: connecting to linux server from windows xp |
| Previous Message | Gan Uesli Starling | 2005-11-14 10:16:29 | Re: My bad...user and database not recognized after reboot |