Full text search parser dictionary

Hi all, I have tried utilizing the full text searh feature and works as charm, except for one think which I would like to suggest to improve. When a document is split into tokens the parser removes any whitespace or punctuation charactures not otherwise recognized. But some punctuation charactures

Re: Odd messages on reloading DB table

On Thursday, February 7, 2019, Steve Wampler wrote: > >(1) the table already exist and the immediately doesn't exist? >(2) report ERROR on UPDATE when there are no UPDATES in the input file > Most likely the first attempt was schema qualified and so found the existing targets table whil

Odd messages on reloading DB table

With PostgreSQL 9.5.15, I ran: pg_dump -t targets -d atst.experimentdb >nT.db then I ran: psql -h langley atst.experimentdbQUERY: UPDATE targets SET time_stamp=new.time_stamp,modified=new.modified, id=new.id,targets=new.targets WHERE (id=new

Re: Odd messages on reloading DB table

On 2/7/19 9:28 AM, Steve Wampler wrote: With PostgreSQL 9.5.15, I ran:    pg_dump -t targets -d atst.experimentdb >nT.db then I ran:    psql -h langley atst.experimentdb ...    ERROR:  relation "targets" already exists    ALTER TABLE    ERROR:  relation "targets" does not exist    LINE

Re: How to add a new psql command ?

You can also shell out to a command with \! and send data one way using a combo of \gset and \setenv, then bundle up the whole "function" as a .sql file you include when you want it with \i. For example here's a snippet I use to get the session pid, export it, then fire up another tmux pane runnin

Re: How to add a new psql command ?

Hi čt 7. 2. 2019 v 11:40 odesílatel Quentin Di-Fant napsal: > Hello, > > I was wondering : is it possible to add directly a new psql command which > can be run anytime in our PostgreSQL interpreter like any other normal psql > commands ? > > I explain myself : in the PostgreSQL interpreter, when

How to add a new psql command ?

Hello, I was wondering : is it possible to add directly a new psql command which can be run anytime in our PostgreSQL interpreter like any other normal psql commands ? I explain myself : in the PostgreSQL interpreter, when the command "\h" or "\help" is written in the shell, we can see all the co

Re: Connection issue

Just for the record, updating to Mac OS 10.14.3 resolved the issue. Thanks, Max

Re: Calling rest service from postgresql functions and stored proc

Hi čt 7. 2. 2019 v 10:53 odesílatel mahesh.sp napsal: > Hi, > > Would like to know whether postgresql supports calling a rest service from > function or stored procedure. > > Looking for Oracle to postgresql feasibility study. > > Searched in Google but could not find any official document regar

Re: Calling rest service from postgresql functions and stored proc

On Thu, Feb 7, 2019 at 10:53 AM mahesh.sp wrote: > Hi, > > Would like to know whether postgresql supports calling a rest service from > function or stored procedure. > > Looking for Oracle to postgresql feasibility study. > > Searched in Google but could not find any official document regarding t

Calling rest service from postgresql functions and stored proc

Hi, Would like to know whether postgresql supports calling a rest service from function or stored procedure. Looking for Oracle to postgresql feasibility study. Searched in Google but could not find any official document regarding the same. Appreciate if inputs or reference links are shared or c