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?
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 ...). The
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 JO
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 ,
>
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 ,
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 times
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 ,
pr
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 ,
>
> "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 VALUE
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 created
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 to
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), whic
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 to
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.
>
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
>
> But
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 P
(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 content
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
On Tue, Oct 15, 2019 at 6:07 PM David Gauthier wrote:
> Users are going to be working with data through perl/DBI scripts which
> currently connect using a generic role with hardcoded password in the connect
> string. Access will be select/insert/update/delete We need to tighten up
> security
19 matches
Mail list logo
