On 3 October 2016 at 21:01, Tom Lane wrote:
> Benedikt Grundmann writes:
> > proddb_testing=# SELECT
> > conname,convalidated,conislocal,coninhcount,connoinherit
> > proddb_testing-# FROM pg_constraint WHERE conrelid =
> > 'js_activity_20110101'::regclass;
> >conname
On 4 October 2016 at 08:17, Benedikt Grundmann
wrote:
>
> On 3 October 2016 at 21:01, Tom Lane wrote:
>
>> Benedikt Grundmann writes:
>> > proddb_testing=# SELECT
>> > conname,convalidated,conislocal,coninhcount,connoinherit
>> > proddb_testing-# FROM pg_constraint WHERE conrelid =
>> > 'js_act
Dear Charles!
Sorry for late answer. Now I got a little time to check this again...
2016-09-14 18:43 GMT+02:00 Charles Clavadetscher :
> Hello
>
>
>
>
>
> Also try this:
>
>
>
> ALTER DEFAULT PRIVILEGES FOR ex_mainuser GRANT INSERT, SELECT, UPDATE,
> DELETE, TRUNCATE, REFERENCES, TRIGGER ON TAB
On 4 October 2016 at 09:28, Benedikt Grundmann
wrote:
>
>
> On 4 October 2016 at 08:17, Benedikt Grundmann
> wrote:
>
>>
>> On 3 October 2016 at 21:01, Tom Lane wrote:
>>
>>> Benedikt Grundmann writes:
>>> > proddb_testing=# SELECT
>>> > conname,convalidated,conislocal,coninhcount,connoinherit
Durumdara wrote:
[...]
> --- login with postgres:
[...]
> ALTER DEFAULT PRIVILEGES
> GRANT INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER
> ON TABLES
> TO u_tr_db;
>
> login with u_tr_main:
>
> create table t_canyouseeme_1 (k int);
>
> login
Hello
> > Also try this:
> > ALTER DEFAULT PRIVILEGES FOR ex_mainuser GRANT INSERT, SELECT, UPDATE,
> > DELETE, TRUNCATE, REFERENCES, TRIGGER
> >ON TABLES TO ex_dbuser;
> >
> > You execute the ALTER DEFAULT PRIVILEGES as su, so the grant applies to
> > objects created by su and n
Oh, WTF (Word Trade Fenster)! :-o
PGAdmin did that!
There are subdialog for Default Privileges, with Tables, and with ONLY ONE
ROLE. This role is used after "TO". But nowhere role is used after "FOR"...
Hm
Thank you!
2016-10-04 12:57 GMT+02:00 Albe Laurenz :
> Du
Please, ignore this double post. It came from wrong e-mail address.
The issue is already being discussed in another discussion thread.
Hi!
(sorry for top post, but I'm making a recall of current status - therefore
avoiding deep search in details)
In short:
OS = Oracle Enterprise Linux 7.2 with Oracle Unbreakeable Kernel (a.k.a RHEL
7.2)
Environment = Linux backup1.simfrete.com 3.8.13-118.11.2.el7uek.x86_64 #2 SMP
Wed Sep
On 30 September 2016 at 16:58, Aleksander Alekseev
wrote:
> I've just uploaded ZSON extension on GitHub:
>
> https://github.com/afiskon/zson
>
> ZSON learns on your common JSONB documents and creates a dictionary
> with strings that are frequently used in all documents. After that you
> can use Z
On Tue, Oct 4, 2016 at 4:20 PM, Simon Riggs wrote:
> On 30 September 2016 at 16:58, Aleksander Alekseev
> wrote:
>
> > I've just uploaded ZSON extension on GitHub:
> >
> > https://github.com/afiskon/zson
> >
> > ZSON learns on your common JSONB documents and creates a dictionary
> > with strings
Hello,
If you have jdk 1.8 or above installed go to www.executequery.org and
download the latest jar file. Download the JDBC driver from Postgres and
set it up. It's open source.
It has an ERD generator but obviously depends on having all your foreign
keys declared in order to link tables, etc. Af
Hello Johannes,
A new kid on the block – Database Workbench, a Windows application that works
fine on Linux and Mac via Wine.
http://www.upscene.com/database_workbench/
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL
Hello, Simon.
Thanks for you interest to this project!
> Will you be submitting this to core?
I could align ZSON to PostgreSQL code style. I only need to run pgindent
and write a few comments. Do you think community would be interested in
adding it to /contrib/ ? I mean doesn't ZSON solve a bit
@Aleksander
~everyone wants lower data storage and wants some kind of compression.
Can this be made to automatically retrain when analyzing (makes sense?)?
And create a new dictionary only if it changes compared to the last one.
On Tue, Oct 4, 2016 at 5:34 PM, Aleksander Alekseev <
a.aleks...@post
Hello,
With a heavy query, when line number results raise over 600k query hangs with
out of memory.
Here is the explain analyze:
CTE Scan on lista (cost=25066.66..47721.23 rows=3678 width=260)
CTE lista
-> Unique (cost=24956.32..25066.66 rows=3678 width=512)
-> Sort (
With a heavy query, when line number results raise over 600k query hangs with
out of memory.
Here is the explain analyze:
[...]
Work_mem is.512mb, shared buffers 3084mb and system Ram 10Gb. Postgres version
is 8.4.8 and for some months i cannot upgrade.
Is there a way to solve the problem?
H
I recently updated my systems from pg 9.1.8 to 9.5.3. A pg_dumpall was used
to migrate the data. Now I'm trying to re-establish replication between
master and slave. I'm getting stuck.
When I run pg_basebackup (via a script which worked flawlessly on 9.1.8,
AND via command line, ala "manual mode")
Hello,
I'm having an issue with using the new UPSERT feature in Postgres 9.5
I have a table that is used for aggregating data from another table. The
composite key is made up of 20 columns, 10 of which can be nullable.
Below I have created a smaller version of the issue i'm having, specifically
On Tue, Oct 4, 2016 at 10:42 PM, otheus uibk wrote:
> After a 3 to 4 minute delay, pg_basebackup started doing it's thing and
> finished within a few minutes. So now the question is: why the startup
> delay?
>
Sounds to me like it's doing a CHECKPOINT with spreading, which make it
take time. Tr
After a 3 to 4 minute delay, pg_basebackup started doing it's thing and
finished within a few minutes. So now the question is: why the startup
delay?
On Tue, Oct 04, 2016 at 07:46:48PM +, Shaun McCready wrote:
> Hello,
>
> I'm having an issue with using the new UPSERT feature in Postgres 9.5
>
> I have a table that is used for aggregating data from another table. The
> composite key is made up of 20 columns, 10 of which can be nullable.
>
On Wed, Oct 5, 2016 at 12:34 AM, Aleksander Alekseev
wrote:
> I could align ZSON to PostgreSQL code style. I only need to run pgindent
> and write a few comments. Do you think community would be interested in
> adding it to /contrib/ ? I mean doesn't ZSON solve a bit too specific
> problem for thi
Good evening,
I'm curious about a way to ask the following question of my vendors
table.
psuedo1 "select all vendors which exist in BUR and EBC and SNJ"
and
psuedo2 "select all vendors which DO NOT exist in all three show rooms
The data is from a Sage accounting system which I pull out and plac
> On Oct 4, 2016, at 9:31 PM, Bret Stern
> wrote:
>
> Good evening,
> I'm curious about a way to ask the following question of my vendors
> table.
>
> psuedo1 "select all vendors which exist in BUR and EBC and SNJ"
>
> and
> psuedo2 "select all vendors which DO NOT exist in all three show roo
Try this:
select distinct vendor_no, vendor_name
from ap_vendors
where vendor_no in (
select vendor_no from ap_vendors
group by vendor_no
having array_agg(company_code) @> ARRAY['BUR','EBC','SNJ'])
On Wed, Oct 5, 2016 at 1:31 PM, Bret Stern wrote:
> Good evening,
> I'm curious about a
To all who are planning to join PGConf.Asia:
http://www.pgconf.asia/EN/
The main conference is scheduled from December 2nd and December 3rd,
2016 (plus developer conference/unconference on December 1st). The
registration will be open by the end of this October.
If you need a visa to enter Japan,
On 10/4/16, Dorian Hoxha wrote:
> On Tue, Oct 4, 2016 at 5:34 PM, Aleksander Alekseev
> wrote:
>> Hello, Simon.
>>
>> Thanks for you interest to this project!
>>
>> > Will you be submitting this to core?
>>
>> I could align ZSON to PostgreSQL code style. I only need to run pgindent
>> and write
28 matches
Mail list logo
