| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgsql & mnogosearch |
| Date: | 2001-01-08 23:06:18 |
| Message-ID: | Pine.BSF.4.31.0101081904450.21326-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
mnogosearch only does inserts into the database, it doesn't check for a
previous occurance of the record first, so you are getting what is
expected ...
I think they work under teh guise that better return an error then do two
queries ...
On Mon, 8 Jan 2001, Thomas T. Thai wrote:
> i'm starting to use mnogosearch 3.1.8 and pgsql-cvs on
> NetBSD/Alpha.
>
> i'm getting a tremendous amount of these errors in my log file when i'm
> running indexer:
> ...
> ERROR: Cannot insert a duplicate key into unique index url_url
> ERROR: Cannot insert a duplicate key into unique index url_url
> ERROR: Cannot insert a duplicate key into unique index url_url
> ERROR: Cannot insert a duplicate key into unique index url_url
> ERROR: Cannot insert a duplicate key into unique index url_url
> ...
>
> anyone else using this combo and seeing this?
>
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Troxell | 2001-01-08 23:10:57 | SELECT INTO Troubles |
| Previous Message | Brett W. McCoy | 2001-01-08 23:03:26 | Re: Dangling large objects |