[HACKERS] Query regarding permission on table_column%type access

2017-10-31 Thread Neha Sharma
ow) postgres=> select * from t1; ERROR: permission denied for relation t1 Is this an expected behaviour? What if the user does not wants the object type to be accessed across? Thanks. -- Regards, Neha Sharma

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-21 Thread Neha Sharma
ncel () from /lib64/libc.so.6 #13 0x007dde88 in ServerLoop () at postmaster.c:1717 #14 0x007dd67d in PostmasterMain (argc=3, argv=0x2eb8b00) at postmaster.c:1361 #15 0x0071a218 in main (argc=3, argv=0x2eb8b00) at main.c:228 (gdb) print ShmemVariableCache->oldestXid $3 = 548

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Hi, Attached is the core dump file received on PG 10beta2 version. ​ myfile.tgz <https://drive.google.com/a/enterprisedb.com/file/d/0B4_zX36siXF0MHJTTjZHZjNtN1E/view?usp=drive_web> ​ Regards, Neha Sharma On Thu, Jul 20, 2017 at 2:45 PM, Neha Sharma <neha.sha...@enterprisedb.c

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
Regards, Neha Sharma On Thu, Jul 20, 2017 at 1:28 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 20 July 2017 at 15:00, Neha Sharma <neha.sha...@enterprisedb.com> > wrote: > >> Hi Craig, >> >> I had done a fresh initdb,the default parameter configura

Re: [HACKERS] [TRAP: FailedAssertion] causing server to crash

2017-07-20 Thread Neha Sharma
leep 5 # Run pgbench ./pgbench -c $threads -j $threads -T $time_for_reading -M prepared test >> /home/centos/test_results.txt sleep 10 ./psql -d test -c "checkpoint" >> /home/centos/test_results.txt ./pg_ctl stop done; done; sleep 1

[HACKERS] pg_restore failed for foreign key constraint

2017-07-17 Thread Neha Sharma
6 16399 FK CONSTRAINT test_tbl test_tbl_fk_c1 edb pg_restore: [archiver (db)] could not execute query: ERROR: schema "test" does not exist Command was: ALTER TABLE ONLY test.test_tbl DROP CONSTRAINT test_tbl_fk_c1; Is this an expected behaviour? -- Regards, Neha Sharma

Re: [HACKERS] Proposal : For Auto-Prewarm.

2017-06-06 Thread Neha Sharma
and maybe reword the sentence a little. > There's a lot of little things like this which I have tended be quite > strict about changing before commit; I occasionally wonder whether > it's really worth the effort. It's not really wrong, it just sounds > weird to me as an American. > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Regards, Neha Sharma

Re: [HACKERS] Gather Merge

2017-02-03 Thread Neha Sharma
exercising system views. > > Please find attached latest patch. > > > > On Wed, Feb 1, 2017 at 5:55 PM, Rushabh Lathia <rushabh.lat...@gmail.com> > wrote: > >> I am sorry for the delay, here is the latest re-based patch. >> >> my colleague Neha Sharm