Re: [HACKERS] [GENERAL] [SQL] pg_multixact issues

2014-09-26 Thread Dev Kumkar
On Fri, Sep 19, 2014 at 1:23 PM, Dev Kumkar wrote: > Apologies for the delay, was working/troubleshooting same issue and was > away from my emails. :( > Regards... > Received the database with huge pg_multixact directory of size 21G and there are ~82,000 files in "pg_multixact

Re: [HACKERS] [GENERAL] [SQL] pg_multixact issues

2014-09-19 Thread Dev Kumkar
On Fri, Sep 19, 2014 at 1:03 PM, Andres Freund wrote: > Yes: Learning some patience. You'd given the previous answer two hours > before this one. Nobody is paid to work on this list... Apologies for the delay, was working/troubleshooting same issue and was away from my emails. :( Regards...

Re: [HACKERS] [GENERAL] [SQL] pg_multixact issues

2014-09-18 Thread Dev Kumkar
On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar wrote: > On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund > wrote: > >> I don't think that's relevant for you. >> >> Did you upgrade the database using pg_upgrade? >> > > That's correct! No, there

Re: [HACKERS] [GENERAL] Case sensitivity

2013-12-12 Thread Dev Kumkar
On Thu, Dec 12, 2013 at 12:47 PM, Dev Kumkar wrote: > + hackers > > > > On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar wrote: > >> On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar wrote: >> >>> Actually for searches lower will work. >>> But the other im

Re: [HACKERS] [GENERAL] Case sensitivity

2013-12-11 Thread Dev Kumkar
+ hackers On Thu, Dec 12, 2013 at 12:34 PM, Dev Kumkar wrote: > On Wed, Dec 11, 2013 at 9:47 PM, Dev Kumkar wrote: > >> Actually for searches lower will work. >> But the other important aspect is 'inserts' which would result 2 rows if >> the values are '

Re: [HACKERS] Grouping Sets

2013-07-04 Thread Dev Kumkar
On Thu, Jul 4, 2013 at 7:53 PM, Atri Sharma wrote: > On Thu, Jul 4, 2013 at 6:56 PM, Dev Kumkar > wrote: > > Ok, no problem. Will await for any other pointers regarding any related > > patch here. > > > > Currently using UNION to archive similar results but lookin

Re: [HACKERS] Grouping Sets

2013-07-04 Thread Dev Kumkar
On Thu, Jul 4, 2013 at 6:31 PM, Pavel Stehule wrote: > Hello > > I don't work on this topic now, and my code is not usable for production. Ok, no problem. Will await for any other pointers regarding any related patch here. Currently using UNION to archive similar results but looking if anything

[HACKERS] Grouping Sets

2013-07-04 Thread Dev Kumkar
Hello, Am looking for the patch related to 'Implementation of GROUPING SETS'. Where can get this from? Related thread: http://www.postgresql.org/message-id/162867790905121420p7c910054x24d8e327abd58...@mail.gmail.com Regards...

Re: [HACKERS] "on existing update" construct

2013-05-15 Thread Dev Kumkar
Basically I was referring to this link http://mbk.projects.postgresql.org Any suggestions here? Thanks!

Re: [HACKERS] "on existing update" construct

2013-05-15 Thread Dev Kumkar
> Please do not top-post on the PostgreSQL lists. See < http://idallen.com/topposting.html> > Also, note that pgsql-hackers is entirely the wrong list for this sort of question. You should have been asking on pgsql-general. Apologies for top-post! Well I thought pgsql-hackers will suggest some new

Re: [HACKERS] "on existing update" construct

2013-05-15 Thread Dev Kumkar
Well ya, stored procedure also was thinking about pre-insert trigger. Am sure folks here must have gone thru this and had alternatives. Also was reading about merge_by_key. On Wed, May 15, 2013 at 12:51 PM, Daniel Farina wrote: > On Wed, May 15, 2013 at 11:44 AM, Dev Kumkar > wrote: >

[HACKERS] "on existing update" construct

2013-05-15 Thread Dev Kumkar
Hello, Is there an alternative of Sybase "on existing update" construct in pgsql. "ON DUPLICATE KEY UPDATE" doesn't work. Thanks in advance! Regards - Dev

Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Dev Kumkar
Apologies for posting on multiple lists, surely will take care of this next time. Yup adding user=username resolved this. Thanks to 'Laurenz Albe' and you too. Regards - Dev On Wed, Feb 6, 2013 at 7:12 PM, Andrew Dunstan wrote: > > On 02/06/2013 08:09 AM, Dev Kumkar wrote: >

[HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Dev Kumkar
Hello Everyone, I am using postgres 9.2 and when executing function dblink facing a fatal error while trying to execute dblink_connect as follows: * SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres password=test')* *ERROR*: could not establish connection DETAIL: FATA