@Ericson
I have the script (statements?) by which I created the triggers, but since
you asked I do not see them in pga4, from which I manage my postgres. I
don't know if this is significant or not. Also, this was originally done
quite a while ago, so my memory may be fuzzy. From the text of the
sta
On Tue, 2020-04-21 at 12:24 -0500, Malik Rumi wrote:
> More than a year ago, I implemented full text search on one of my sites.
> From the beginning, there was one problem (or at least, what I perceive
> to be a problem): when I use a script to insert many documents at once,
> they do *not* get ind
On 4/21/20 11:21 AM, Malik Rumi wrote:
@Ericson,
Forgive me for seeming dense, but how does COPY help or hurt here?
@Andreas,
I had to laugh at your reference to "prose". Would you believe I am
actually a published playwright? Long before I started coding, of
course. Old habits die hard.
My apologies - I did not look closely at the manual. Many many years ago
(6.xx days I had a similar problem and leapt to answer).
Could you post your CREATE TRIGGER statements as well?
On Wed, Apr 22, 2020 at 1:21 AM Malik Rumi wrote:
> @Ericson,
> Forgive me for seeming dense, but how does CO
@Ericson,
Forgive me for seeming dense, but how does COPY help or hurt here?
@Andreas,
I had to laugh at your reference to "prose". Would you believe I am
actually a published playwright? Long before I started coding, of course.
Old habits die hard.
entry_search_vector_trigger
BEG
On 4/21/20 11:04 AM, Ericson Smith wrote:
I think COPY bypasses the triggers.
No:
https://www.postgresql.org/docs/12/sql-copy.html
"COPY FROM will invoke any triggers and check constraints on the
destination table. However, it will not invoke rules."
Best Regards
- Ericson Smith
+1 876-3
I think COPY bypasses the triggers.
Best Regards
- Ericson Smith
+1 876-375-9857 (whatsapp)
+1 646-483-3420 (sms)
On Wed, Apr 22, 2020 at 12:32 AM Andreas Joseph Krogh
wrote:
> På tirsdag 21. april 2020 kl. 19:24:10, skrev Malik Rumi <
> malik.a.r...@gmail.com>:
>
> [...]
>
> I am not (yet) p
