Re: Text search lexer's handling of hyphens and negatives

On Tue, Oct 15, 2019 at 3:35 PM Alan Hodgson wrote: > My company has found the pg_trm extension to be more useful for partial text > searches than the full text functions. I don't know specifically how it might > help with your hyphens but it would be worth testing. The docs actually > suggest

Text search lexer's handling of hyphens and negatives

(I sent a similar message before subscribing to the list but it hasn't gone through yet, so sorry if you see a duplicate of this...) We've been happily using pgsql to store user-generated documents for a while now. We also wanted to be able to search the documents so we tossed the document

Re: Securing records using linux grou permissions

It can be done, but you'd need much tighter integration with the OS, which would probably lock you in to only one platform ("Unix", not just Linux). On 10/15/19 12:10 PM, David Gauthier wrote: Ok, thanks. I was hoping there was a way to integrate the user/permissions/groups in linux with the

Re: Securing records using linux grou permissions

Ok, thanks. I was hoping there was a way to integrate the user/permissions/groups in linux with the PG permissions functionality. On Tue, Oct 15, 2019 at 12:32 PM Michael Lewis wrote: > It sounds like you want row level security- > https://www.postgresql.org/docs/9.6/ddl-rowsecurity.html > >

Re: Securing records using linux grou permissions

It sounds like you want row level security- https://www.postgresql.org/docs/9.6/ddl-rowsecurity.html But, you will need to define separate roles on the database and ensure that the users and connecting with separate roles. The db can't magically know about the permissions on the OS side. >

Re: SELECT returnig a constant

On 15/10/2019 15:01, stan wrote: Thanks, as you can see from my SOLVED reply, I go that part figured out. Now I am trying to figure out how to complete this. The SELECT returns more than 1 row, and when I put that in the VALUES clause this does not work. Please reply to the list, rather than

Securing records using linux grou permissions

Hi: psql (9.6.7, server 11.3) on linux What are the possibilities regarding restricting user access to records given this scenario. I have a DB with tables that are organized in a hierarchical way. For example, a "projects" table is the parent of >1 recs in a "domains" table (PK/FK setup),

Re: SELECT returnig a constant

On Tue, Oct 15, 2019 at 8:25 AM Geoff Winkless wrote: > On Tue, 15 Oct 2019 at 14:35, Ray O'Donnell wrote: > > > > On 15/10/2019 14:28, stan wrote: > > > I used to be able to return a constant value in a SELECT statement in > > > ORACLE. I need to populate a table for testing, and I was going

Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound

Hi Alvaro,     sorry for late reply, I've been out of office. Il 09/10/19 19:51, Alvaro Herrera ha scritto: On 2019-Oct-07, Moreno Andreo wrote: Unfortunately, it didn't work :( db0=# select * from failing_table where ctid='(3160,31)' for update; ERROR:  MultiXactId 12800 has not been

Re: Inserting multiple rows wtih a SELECt in the values clause

> "stan" == stan writes: stan> I suspect this may be because the SELECT in the values clause stan> returns multiple rows? Understand this: VALUES is really just a special form of SELECT that returns only the specific rows that you tell it to construct. Every single row returned by a

Re: SELECT returnig a constant

On Tue, 15 Oct 2019 at 14:35, Ray O'Donnell wrote: > > On 15/10/2019 14:28, stan wrote: > > I used to be able to return a constant value in a SELECT statement in > > ORACLE. I need to populate a table for testing, and I was going to do so > > like this: > > > > SELECT > > employee.id , >

Inserting multiple rows wtih a SELECt in the values clause

OK, now that figured out how to return the constant, this is the final query I need to run. INSERT into rate ( employee_key , project_key , work_type_key , rate ) VALUES ( ( SELECT employee.employee_key ,

Re: timescaleDB & WAL replication

On Tue, Oct 15, 2019 at 09:28:27AM +0200, basti wrote: Hello, I have a Master / Slave Postgres setup with WAL Replication. Now I want to add timescaleDB. I found this todo: https://docs.timescale.com/latest/tutorials/replication As I understand that in the right way I just need to add the

Re: SELECT returnig a constant

On 15/10/2019 14:28, stan wrote: I used to be able to return a constant value in a SELECT statement in ORACLE. I need to populate a table for testing, and I was going to do so like this: SELECT employee.id , project.proj_no , work_type.type ,

SOLVED Re: SELECT returnig a constant

On Tue, Oct 15, 2019 at 09:28:51AM -0400, stan wrote: > I used to be able to return a constant value in a SELECT statement in > ORACLE. I need to populate a table for testing, and I was going to do so > like this: > > SELECT > employee.id , > project.proj_no , >

SELECT returnig a constant

I used to be able to return a constant value in a SELECT statement in ORACLE. I need to populate a table for testing, and I was going to do so like this: SELECT employee.id , project.proj_no , work_type.type , 'rate' 1 FROM employee CROSS

Re: How to make runtime partition pruning work?

Notice that only subqueries and parameterized nested loop joins are mentioned. The above text does not really go into the detail of which types of subqueries can be used, but I can confirm that they must be subqueries that can only return a scalar value. e.g WHERE x = (SELECT y FROM ...).

timescaleDB & WAL replication

Hello, I have a Master / Slave Postgres setup with WAL Replication. Now I want to add timescaleDB. I found this todo: https://docs.timescale.com/latest/tutorials/replication As I understand that in the right way I just need to add the timescaleDB extention on the master side?