Re: [GENERAL] Recursive row level security policy

Hello again > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Charles > Clavadetscher > Sent: Freitag, 16. Dezember 2016 07:41 > To: 'Simon Charette' > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Recur

Re: [GENERAL] Recursive row level security policy

Hello Simon > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Charette > Sent: Freitag, 16. Dezember 2016 07:02 > To: Charles Clavadetscher > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Recursive

Re: [GENERAL] Recursive row level security policy

Hello Charles, Unfortunately this will only return accounts matching the current_user's name. I would expect "SET ROLE foo; SELECT name FROM accounts" to return "foo" and "bar" and not only "foo" like your proposed solution would do. Simon 2016-12-16 0:57 GMT-05:00 Charles Clavadetscher : > Hel

Re: [GENERAL] Recursive row level security policy

Hello > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Simon Charette > Sent: Freitag, 16. Dezember 2016 06:15 > To: pgsql-general@postgresql.org > Subject: [GENERAL] Recursive row level security policy > > Hello t

Re: [GENERAL] CRM where pg is a first class citizen?

Also check Odoo (Python & PostgreSQL) & it has large community support. https://github.com/odoo/odoo -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Fri, Dec 16, 2016 at 8:58 AM, John DeSoi wrote: > > > On Dec 13, 2016, at 3:25 PM, I

[GENERAL] Recursive row level security policy

Hello there, I'm not sure I'm posting to the appropriate mailing list so don't hesitate to redirect me to the appropriate one. I've been trying to setup a policy that allows "accounts" table rows to only be seen by their owner by using the current_user to compare them by name. Unfortunately it l

Re: [GENERAL] CRM where pg is a first class citizen?

> On Dec 13, 2016, at 3:25 PM, Ivan Sergio Borgonovo > wrote: > > I don't develop on Drupal anymore but up to at least D7 Postgresql was still > not a first class citizen. > > I've heard DB abstraction layer in D8 is much better but I don't have > anything critical on Drupal anymore and life

[GENERAL] pgbench initialize

Hi, I have a couple of questions regarding pgbench. I'm new to PostgreSQL and databases in general, so these might be very trivial questions. 1. Is it necessary to initialize pgbench(-i option) before every run to get consistent results? 2. The vacuuming process after initialize consumes time, w

Re: [GENERAL] tuple data size and compression

On 12/15/2016 08:26 AM, Tom DalPozzo wrote: https://www.postgresql.org/docs/9.5/static/storage-toast.html "The TOAST management code is triggered only when a row value to be stored in a table is wider than T

Re: [GENERAL] Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

Richard Brosnahan =?utf-8?B?UmU6IFtHRU5FUkFMXSBQb3N0Z3JlU1FMIG1pcnJvcmluZyBmcm9tIFJQTSBp?= =?utf-8?B?bnN0YWxsIHRvIFNvdXJjZSBpbnN0YWxs?= writes: > The slave: > $ pg_controldata --version > pg_controldata (PostgreSQL) 9.4.1 > $ echo $PGDATA > /apps/database/postgresql-data > $ pg_controldata $PGDA

Re: [GENERAL] pg_dump and quoted identifiers

Von: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]" im Auftrag von "Thomas Kellerer [spam_ea...@gmx.net] Gesendet: Donnerstag, 15. Dezember 2016 17:15 An: pgsql-general@postgresql.org Betreff: Re: [GENERAL] pg_dump and quoted ide

Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

Richard Brosnahan writes: > I've got a PostgreSQL database server version 9.4.1 installed on an OEL 6 > server. I have a second PostgreSQL database server version 9.4.1 running on > an identical OEL 6 server. The first PostgreSQL was installed by system > admins using RPM. The second PostgreSQL

[GENERAL] PostgreSQL mirroring from RPM install to Source install

Good day to you! I've got a PostgreSQL database server version 9.4.1 installed on an OEL 6 server. I have a second PostgreSQL database server version 9.4.1 running on an identical OEL 6 server. The first PostgreSQL was installed by system admins using RPM. The second PostgreSQL was installed f

Re: [GENERAL] pg_dump and quoted identifiers

Thomas Kellerer writes: > Tom Lane schrieb am 15.12.2016 um 16:20: >> Hmm. It might shed some light if you put "echo" in front of that >> to see what gets printed: >> $ echo pg_dump -d postgres -t "\"Statuses\"" >> pg_dump -d postgres -t "Statuses" > Same here: > -bash-4.1$ echo pg_dump -d pos

Re: [GENERAL] pg_dump and quoted identifiers

On Thursday, December 15, 2016 5:15:44 PM EST Thomas Kellerer wrote: > Tom Lane schrieb am 15.12.2016 um 16:20: > >> Still doesn't work: > >> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\"" > >> pg_dump: no matching tables were found > > > > Hmm. It might shed some light if you put "echo" in

Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5

On Wed, Dec 14, 2016 at 1:17 PM, Patrick B wrote: > > > 2. To call the function, I have to login to postgres and then run: select > logextract(201612015, 201612015); > How can I do it on cron? because the dates will be different every time. > PostgreSQL already knows what date today is. Why doe

Re: [GENERAL] CRM where pg is a first class citizen?

>I was looking for a open source CRM, PHP or python based, with a large >community where Postgresql is a first class citizen. About 20 months ago when I started trading I settled for EspoCRM which uses PHP + MySQL. Despite some bugs I was quite enjoying it before my local VPS company disappeared

Re: [GENERAL] [pgsql-GENERAL] AUTOVACUUM and Streaming Replication in v9.5

On Fri, 16 Dec 2016, 12:10 a.m. Sameer Kumar, wrote: > Hi, > > I was wondering if there is some change in the way > max_standby_streaming_delay and hot_standby_feedback work in v9.5. > > Below is a scenario which I had built to test out something but the > behavior confused me. I would like to ch

Re: [GENERAL] tuple data size and compression

> > https://www.postgresql.org/docs/9.5/static/storage-toast.html >> > > "The TOAST management code is triggered only when a row value to be stored > in a table is wider than TOAST_TUPLE_THRESHOLD bytes (normally 2 kB). The > TOAST code will compress and/or move field values out-of-line until the r

Re: [GENERAL] pg_dump and quoted identifiers

Tom Lane schrieb am 15.12.2016 um 16:20: >> Still doesn't work: >> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\"" >> pg_dump: no matching tables were found > > Hmm. It might shed some light if you put "echo" in front of that > to see what gets printed: > > $ echo pg_dump -d postgres -t "\"

Re: [GENERAL] tuple data size and compression

On 12/15/2016 07:48 AM, Tom DalPozzo wrote: 2016-12-15 16:23 GMT+01:00 Adrian Klaver mailto:adrian.kla...@aklaver.com>>: On 12/15/2016 07:17 AM, Tom DalPozzo wrote: Hi, it's not clear to me when tuple data (max 1000 bytes total) get compressed o

[GENERAL] [pgsql-GENERAL] AUTOVACUUM and Streaming Replication in v9.5

Hi, I was wondering if there is some change in the way max_standby_streaming_delay and hot_standby_feedback work in v9.5. Below is a scenario which I had built to test out something but the behavior confused me. I would like to check if there is something/some parameter which I am missing or if m

Re: [GENERAL] pg_dump and quoted identifiers

On Thu, Dec 15, 2016 at 4:20 PM, Tom Lane wrote: ... > Hmm. It might shed some light if you put "echo" in front of that > to see what gets printed: > > $ echo pg_dump -d postgres -t "\"Statuses\"" > pg_dump -d postgres -t "Statuses" Also, when having strange issues, I've found the combo echo |

Re: [GENERAL] tuple data size and compression

2016-12-15 16:23 GMT+01:00 Adrian Klaver : > On 12/15/2016 07:17 AM, Tom DalPozzo wrote: Hi, > > it's not clear to me when tuple data (max 1000 bytes total) get > > compressed on disk and when not. > > I tried with pg_column_size to find the tuple's size but I get ambiguous > > results. > > > Wha

Re: [GENERAL] tuple data size and compression

On 12/15/2016 07:17 AM, Tom DalPozzo wrote: Hi, it's not clear to me when tuple data (max 1000 bytes total) get compressed on disk and when not. I tried with pg_column_size to find the tuple's size but I get ambiguous results. What is the table definition? Maybe this will help?: https://www.p

Re: [GENERAL] pg_dump and quoted identifiers

Thomas Kellerer writes: > Adrian Klaver schrieb am 14.12.2016 um 15:32: >> So have you tried the answer from the SO question?: > Still doesn't work: > -bash-4.1$ pg_dump -d postgres -t "\"Statuses\"" > pg_dump: no matching tables were found Hmm. It might shed some light if you put "echo" in

[GENERAL] tuple data size and compression

Hi, it's not clear to me when tuple data (max 1000 bytes total) get compressed on disk and when not. I tried with pg_column_size to find the tuple's size but I get ambiguous results. It seems to work but sometimes the tuples seem compressed and sometime not. I tried both with constant data and rand

Re: [GENERAL] pg_dump and quoted identifiers

On 12/14/2016 11:37 PM, Thomas Kellerer wrote: Adrian Klaver schrieb am 14.12.2016 um 15:32: I'm suspicious that you're not actually typing plain-ASCII single and double quotes, but some fancy curly quote character. Definitely not. I typed this manually on the command line using Putty So you