Triggers and Full Text Search

2020-04-19 Thread Malik Rumi
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 indexed in fts. If a document is created or inserted one at a t

ACL error with 4.18

2020-02-07 Thread Malik Rumi
I just upgraded from 2.0. That's a big leap, so I fully expected issues, with my learning curve if not with the software itself. But to my delight everything seems to be in the same places and work the same way, and the interface is much nicer, too. My one issue (so far) is this warning I got on c

Re: Install upgrade

2020-01-21 Thread Malik Rumi
Great, thanks! *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Mon, Jan 13, 2020 at 12:36 AM Dave Page wrote: > > > On Sun, Jan 12, 2020 at 9:04 PM Malik Rumi wrote: > >> Why does the install documentation say to down

Install upgrade

2020-01-12 Thread Malik Rumi
Why does the install documentation say to download the wheel and *then* pip install, instead of just pip install like most Python programs? Is the procedure the same for new installs as it is for upgrading to a new version? Thanks.

Slow 1st time query

2019-07-28 Thread Malik Rumi
Last night I loaded a large number of text documents into my database. This morning I went to look at them through pga4. It was taking a really long time, so I started googling for slow queries. While I was still doing that, the query completed. This was the message: Successfully run. Tot

Re: pip, anyone?

2019-05-07 Thread Malik Rumi
w to add the relevant repository > is here: https://wiki.postgresql.org/wiki/Apt . > > The only caveat is that it tends to lag behind the releases for windows > and RPM (sometimes even skipping a version or two). > > Good luck, > > rik. > > On Tue, May 7, 2019 at 6:31 P

pip, anyone?

2019-05-07 Thread Malik Rumi
So I am finally getting around to upgrading my pgadmin4, and I was a little confused about the 'best' way to install or upgrade. The answer to this question may be out there, but I didn't see it. I checked pypi, and a search for pgadmin4 came up empty. But I have seen blogs and tutorials (out of d

Re: Either Find does not work or I don't know how to make it work

2019-02-13 Thread Malik Rumi
query only. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK:http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > On 13 Feb 2019, at 17:43, Malik Rumi wrote: > > My search strings have all been fields

Re: Either Find does not work or I don't know how to make it work

2019-02-13 Thread Malik Rumi
ld be most helpful. > > Just my $0.02. > > rik. > > On Wed, Feb 13, 2019 at 11:45 AM Malik Rumi > wrote: > >> I'm on ubuntu 17, Chrome 72. I am happy it is working for you, but I >> repeat, once I hit Enter, I got nothing, nada, zip. >> >> &

Re: Either Find does not work or I don't know how to make it work

2019-02-13 Thread Malik Rumi
, Feb 12, 2019 at 8:26 PM Malik Rumi wrote: > > > > I can't make heads or tails out of 'find'. When I click on the > magnifying glass, I get a little > > Search: > > But once I put something in there, nothing happens, and if I hit Enter, > it all just goes

Either Find does not work or I don't know how to make it work

2019-02-12 Thread Malik Rumi
I can't make heads or tails out of 'find'. When I click on the magnifying glass, I get a little Search: But once I put something in there, nothing happens, and if I hit Enter, it all just goes away like I hadn't done anything. I am looking at the docs https://www.pgadmin.org/docs/pgadmin4/dev/query

Re: could not connect to server, in order to operate pgAdmin/PostgreSQL

2018-11-24 Thread Malik Rumi
1. What is your operating system? It looks like Windows, but I'm not sure. Also what version number for the OS? 2. Look in the url. You are at 127.0.0.1. That is the same as localhost. But then it says 49194. Postgres uses 5432 by default. That's why you got that part of the error message, but we n

column type cannot be empty

2018-05-01 Thread Malik Rumi
I am trying to add a table in pga4 as shown in the attached screenshot. I have the error message column type cannot be empty but I don't know what it is referring to. There is no 'column type' on the Table page of the help, and all the data types are filled, as you can see, but the save button is i

Saving Twice, Once Correctly, Once with Errors

2018-02-28 Thread Malik Rumi
I think this is a scrapy problem, not a PG problem, but since I have yet to find an answer, I thought I would post here in case someone had had a similar experience and could shed some light for me. I have a scrapy pipeline which throws an integrityerror on one line in particular. However, at the

Re: upgrade and bundle

2018-02-16 Thread Malik Rumi
; I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > www.youtube.com/unusedhero/videos > Folk Alley - All Folk - 24 Hours a day > www.folkalley.com > > > > On Friday, February 16, 2018, 12:18:00 PM EST, Malik Rumi < >

Re: upgrade and bundle

2018-02-16 Thread Malik Rumi
move my old versions > automatically? > > *“None of you has faith until he loves for his brother or his neighbor > what he loves for himself.”* > > >>>… > > > > On Thu, Feb 15, 2018 at 9:48 PM, Malik Rumi > wrote: > > I was going to upgrade to PG 10

Re: upgrade and bundle

2018-02-15 Thread Malik Rumi
p.s. I guess I should also ask, will it remove my old versions automatically? *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Thu, Feb 15, 2018 at 9:48 PM, Malik Rumi wrote: > I was going to upgrade to PG 10 from the Postgresql APT r

upgrade and bundle

2018-02-15 Thread Malik Rumi
I was going to upgrade to PG 10 from the Postgresql APT repo, but I understand it is now bundled with PGAdmin 4, which I already have. Does apt know how to find both programs when they were separately installed originally? Can I remove PGAdmin 4 from the download? Etc. Thanks. *“None of you has f

Re: pgadmin4 from apt.postgresql.org - ubuntu xenial

2018-01-31 Thread Malik Rumi
Tony, this question has an answer, because I asked it. Search the list for a post titled 'flask' or 'flask again', and follow the steps in the answer I got there. *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Wed, Jan 31, 2018 at 11:59 AM,

Re: flask again

2017-12-12 Thread Malik Rumi
"/var/lib/pgadmin" > sudo chmod a+wrx "/var/lib/pgadmin" > > > On Wed, Dec 13, 2017 at 11:31 AM, Malik Rumi > wrote: > >> sorry, not sure why the support group got dropped from reply,,, >> >> *“None of you has faith until he loves for his brot

Re: flask again

2017-12-12 Thread Malik Rumi
sorry, not sure why the support group got dropped from reply,,, *“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”* On Tue, Dec 12, 2017 at 10:00 PM, Malik Rumi wrote: > >> Is there any specific reason for using sudo? > Yes: Per

flask again

2017-11-17 Thread Malik Rumi
For reasons unrelated to pga4, I had to reinstall it in a new venv. I am now on Python 3.6.3 and Ubuntu 16.04, and I am working with pga4.2.0, which is a newer version than I had before, and which worked with Python 3.5. I am getting the import error related to flask that I have seen many other pos