[GENERAL] Er Data Modeller for PostgreSQL

Hi All, I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium for postgresql and the tool has a modeller but I would like to display a database modeller that belonging to a tables of an schema under a database. If I use Navicat for modeller, I have to drag and drop whole

[GENERAL] Fwd: idea for big speed optimization

-- Forwarded message -- From: Андрей Брюхов Date: 2016-12-22 17:08 GMT+03:00 Subject: idea for big speed optimization To: jdr...@postgresql.org Hello! Can Postgres Organization use free super optimizaing C compiler for compile postgres (advenced builds) ?

Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10

Hi John,    I agree with you.  On Solaris I should not have to set LD_LIBRARY_PATH.  The location of the *.so files is baked in.  The strange part is that postgres starts up without errors and can be accessed from pgAdmin 4.  The problem is occurring from the replication functionality.  I am

Re: [GENERAL] error updating a tuple after promoting a standby

2016-12-22 10:23 GMT+01:00 Brian Sutherland : > Perhaps try 9.5.5 which has a fix for a problem with the same symptoms: > > https://wiki.postgresql.org/wiki/Free_Space_Map_Problems > https://www.postgresql.org/docs/9.5/static/release-9-5-5. > html#AEN126074 > >

Re: [GENERAL] Disabling inheritance with query.

Sorry the full message is this I want to do that because, I have a partitioned table (big_table like master and child like ...t201610,t201611,t201612...) and others t1,t2,t3,t4 have foreign keys reference to big_table and i had many trobules at insert data, reading the doc: "A

Re: [GENERAL] Disabling inheritance with query.

On Thu, Dec 22, 2016 at 9:51 AM, Edmundo Robles wrote: > I want to do that because, I have a partitioned table (big_table) and > others (t1,t2,t3,t4) have foreign keys reference to big_table and i > had many trobules at insert data, reading the doc: > "A serious

Re: [GENERAL] Disabling inheritance with query.

I want to do that because, I have a partitioned table (big_table) and others (t1,t2,t3,t4) have foreign keys reference to big_table and i had many trobules at insert data, reading the doc: "A serious limitation of the inheritance feature is that indexes (including unique constraints) and

Re: [GENERAL] How well does PostgreSQL 9.6.1 support unicode?

On Wed, Dec 21, 2016 at 11:31 AM, Tom Lane wrote: > Well, we're picky to the extent that RFC 3629 tells us to be picky: > http://www.faqs.org/rfcs/rfc3629.html > And I'm *GLAD* it is that way. Who wants garbage in their database? :)

Re: [GENERAL] Disabling inheritance with query.

You should use alter table XX NO INHERIT parent_table; 2016-12-22 9:49 GMT+01:00 Francisco Olarte : > Edmundo: > > On Wed, Dec 21, 2016 at 11:36 PM, Edmundo Robles > wrote: > > i need disable inheritance from many tables in a query like > >

Re: [GENERAL] error updating a tuple after promoting a standby

Perhaps try 9.5.5 which has a fix for a problem with the same symptoms: https://wiki.postgresql.org/wiki/Free_Space_Map_Problems https://www.postgresql.org/docs/9.5/static/release-9-5-5.html#AEN126074 On Wed, Dec 21, 2016 at 10:51:47AM +0100, Tom DalPozzo wrote: > Hi, > I was doing some

Re: [GENERAL] Disabling inheritance with query.

Edmundo: On Wed, Dec 21, 2016 at 11:36 PM, Edmundo Robles wrote: > i need disable inheritance from many tables in a query like > "delete from pg_inherits where inhparent=20473" instead alter table ... > but is safe? which is the risk for database if i delete it?