Re: [GENERAL] The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"

2015-03-10 Thread hailong Li
2015-03-05 16:34 GMT+08:00 Jim Nasby : > On 3/3/15 6:52 AM, hailong Li wrote: > >> >> Finally , I made a new slave instance on the slave server and it works >> fine until now. >> > > Just so you're aware, that error means there was page level corruption > either on the replica or possibly on the

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread PT
I've read this email over multiple times, and I don't understand what your question is. I don't see what it is that you think is working in an unexpected way, all the situations I see described you claim work. Did you possible forget to put something in the email or am I just a poor reader? On Mo

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread Andrzej Pilacik
Yes, it was a typo by me, the second insert should read: > --- Insert as superuser > delete from ap.table1 > Insert into ap.table1 values (12) --- permission issue inserting into table1 > , (SUPERUSER can't access schema ap) On Tue, Mar 10, 2015 at 8:18 AM, PT wrote: > > I've read this email

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread Stephen Frost
* Andrzej Pilacik (cypise...@gmail.com) wrote: > Can anyone explain how the FK constraint function works? Is it executed as > the owner of the object. That is the only thing that would make sense for > me. Yes. Thanks, Stephen signature.asc Description: Digital signat

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread Adrian Klaver
On 03/10/2015 05:41 AM, Stephen Frost wrote: * Andrzej Pilacik (cypise...@gmail.com) wrote: Can anyone explain how the FK constraint function works? Is it executed as the owner of the object. That is the only thing that would make sense for me. Yes. This brought back a memory. For the how

Re: [GENERAL] Postgres and data warehouses

2015-03-10 Thread Jim Nasby
On 3/8/15 11:02 PM, Rob Sargent wrote: I expected the latter but … some proprietors like to brag :) Standing down. On Mar 8, 2015, at 9:56 PM, John R Pierce wrote: On 3/8/2015 8:24 PM, Rob Sargent wrote: I strongly suspect many would like further details on your implementation. A user conf

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread Andrzej Pilacik
I see the issues that this person might be having. I am not doing a restore or working on an existing issue. My setup is very vanilla, anyone can create these tables and test, will get the same permission error... (I did it in a brand new environment) What I am asking here is why does a SUPERUS

[GENERAL] reltoastidxid altenates in postgresql 9.4

2015-03-10 Thread Yelai, Ramkumar IN BLR STS
Hi All, I am using the following code to know how much disk space could be saved after deleting certain tables (as a parameter to this function ) CREATE OR REPLACE FUNCTION Get_Tables_Recovery_Size( IN tableNames text[] ) RETURNS TABLE( table_size bigint ) AS $$ DECLARE BEGIN RETURN QUE

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread David G. Johnston
On Tue, Mar 10, 2015 at 8:20 AM, Andrzej Pilacik wrote: > I see the issues that this person might be having. I am not doing a > restore or working on an existing issue. > > My setup is very vanilla, anyone can create these tables and test, will > get the same permission error... (I did it in a

[GENERAL] Column is a computation

2015-03-10 Thread Vang P yang
Does postgresql have a way to determine if a query or view column is a computed column. What I mean by that is if say column c in the query or view is a result of say a + b as c or do_function() as c. If not a follow up question would be, is it bad convention then to name column c as c_calc and t

[GENERAL] FW: Installation

2015-03-10 Thread Martin Caverly
I am trying to install PostgresSQL 9.0.12 (stand-alone, fresh installation), but cannot pass the password screen. I have tried these passwords: root, Root, Superuser, superuser, postgres, Postgres, Postgressql, postgressql… none of them was accepted. Please kindly advise the default password fo

Re: [GENERAL] FW: Installation

2015-03-10 Thread Adrian Klaver
On 03/09/2015 09:35 AM, Martin Caverly wrote: I am trying to install PostgresSQL 9.0.12 (stand-alone, fresh installation), but cannot pass the password screen. I have tried these passwords: root, Root, Superuser, superuser, postgres, Postgres, Postgressql, postgressql… none of them was accepted.

Re: [GENERAL] Strange security issue with Superuser access

2015-03-10 Thread Jerry Sievers
"David G. Johnston" writes: > On Tue, Mar 10, 2015 at 8:20 AM, Andrzej Pilacik wrote: > > I see the issues that this person might be having.  I am not doing a > restore or working on an existing issue. > > My setup is very vanilla, anyone can create these tables and test, will > g

Re: [GENERAL] reltoastidxid altenates in postgresql 9.4

2015-03-10 Thread Josh Kupershmidt
On Thu, Mar 5, 2015 at 2:02 AM, Yelai, Ramkumar IN BLR STS wrote: > Hi All, > > I am using the following code to know how much disk space could be saved > after deleting certain tables (as a parameter to this function ) > > CREATE OR REPLACE FUNCTION Get_Tables_Recovery_Size( IN tableNames text[]