Re: [HACKERS] Surprising behaviour of \set AUTOCOMMIT ON

Just for information, PG current behavior, "\set AUTOCOMMIT OFF" implicitly does/open "BEGIN;" block So, "\set AUTOCOMMIT ON" has no effect once "\set AUTOCOMMIT OFF" is issued until "END;" or "COMMIT;" or "ROLLBACK;" however, I think if exit session release the transactions then change

Re: [HACKERS] Online DW

, every online archive db is use case for this. Thanks Sridhar Opentext On 10 Jun 2016 22:36, "David G. Johnston" <david.g.johns...@gmail.com> wrote: > On Fri, Jun 10, 2016 at 4:11 AM, Sridhar N Bamandlapally < > sridhar@gmail.com> wrote: > >> Hi >>

Re: [HACKERS] Online DW

is Archive/DW DB may need to build WITHOUT CONSTRAINTS May need to introduce ARCHIVE system/tag in pg_hba.conf Thanks Sridhar OpenText On Fri, Jun 10, 2016 at 2:22 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 10 June 2016 at 16:11, Sridhar N Bamandlapally

[HACKERS] Online DW

Hi Is there any feature in PostgreSQL where online DW (Dataware housing) is possible ? am looking for scenario like 1. Production DB will have CURRENT + LAST 7 DAYS data only 2. Archive/DW DB will have CURRENT + COMPLETE HISTORY expecting something like streaming, but not ETL Thanks Sridhar

Re: [HACKERS] OUT parameter and RETURN table/setof

g Thanks Sridhar OpenText On Mon, Jun 6, 2016 at 5:57 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Jun 6, 2016 at 7:17 AM, Sridhar N Bamandlapally < > sridhar@gmail.com> wrote: > >> Hi >> >> Is there any option in PGPLS

[HACKERS] OUT parameter and RETURN table/setof

Hi Is there any option in PGPLSQL which can RETURNS table or SETOF rows along with an OUT parameter? please Thanks Sridhar OpenText

Re: [HACKERS] [GENERAL] NULL concatenation

o Sridhar, > > Have you tried the 'coalesce' function to handle the nulls? > > > Kind Regards, > > Adam Pearson > -- > *From:* pgsql-general-ow...@postgresql.org < > pgsql-general-ow...@postgresql.org> on behalf of Sridhar N Bamandla

Re: [HACKERS] NULL concatenation

Thanks Pavel Great !! I was thinking both || and CANCAT does same Thanks again - Sridhar OpenText On Thu, May 12, 2016 at 2:22 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hi > > 2016-05-12 10:47 GMT+02:00 Sridhar N Bamandlapally <sridhar@gmai

[HACKERS] NULL concatenation

Hi In migration, am facing issue with NULL concatenation in plpgsql, by concatenating NULL between any where/position to Text / Varchar, the total string result is setting value to NULL *In Oracle:* declare txt1 VARCHAR2(100) := 'ABCD'; txt2 VARCHAR2(100) := NULL; txt3

[HACKERS] pg_largeobject

Hi pg_largeobject is creating performance issues as it grow due to single point storage(for all tables) is there any alternate apart from bytea ? like configuration large-object-table at table-column level and oid PK(primary key) stored at pg_largeobject Thanks Sridhar

[HACKERS] Nested funtion

Hi Is there any way to create nested function? oracle to postgres migration required super function variable reference into nested function without nested function parameter Oracle sample: --- create or replace function f1(n number) return number is vs number:=1;

Re: [HACKERS] [JDBC] JDBC behaviour

this up with those creating the actual database (that’s the request to > move this to the ‘-hackers’ list); yet you persist. > > I’m only chiming in because it’s getting quite annoying to have you keep > this thread alive when the situation has been made quite clear to you