[HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-01-11 Thread Ashutosh Bapat
except inherit.sql passed. The expected output change is included in the patch. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 9ad54c5..2e87183 100644 --- a/src/backend

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-01-11 Thread Ashutosh Bapat
On Wed, Jan 11, 2012 at 5:25 PM, Chetan Suttraway chetan.suttra...@enterprisedb.com wrote: On Wed, Jan 11, 2012 at 5:13 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: Hi, After running regression, I ran EXPLAIN on one of the queries in regression (test create_misc) and got

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-01-30 Thread Ashutosh Bapat
of situation was more common than the other, but I'm not really sure why. Maybe what we need to do instead is create totally-made-up, unique aliases when something like this happens. regards, tom lane -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-01-30 Thread Ashutosh Bapat
qualify the fake aliases in the generated query. See examples in first post. regards, tom lane -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-02-01 Thread Ashutosh Bapat
: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: So, as I understand we have two problems here 1. Prefixing schemaname to the fake alises if there is another RTE with same name. There may not be a relation with that name (fake alias name given) in the schema chosen as prefix. 2. Fake

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-02-01 Thread Ashutosh Bapat
On Wed, Feb 1, 2012 at 10:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: Looking at the code, it seems that the fake aliases (eref) for relations (may be views as well) are not generated per say, but they do not get changed when

Re: [HACKERS] Confusing EXPLAIN output in case of inherited tables

2012-02-01 Thread Ashutosh Bapat
(for RTE_RELATION only) in ruleutils. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

Re: [HACKERS] pg_ctl idempotent option

2013-01-22 Thread Ashutosh Bapat
. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company -- Sent via pgsql

Re: [HACKERS] pg_ctl idempotent option

2013-01-23 Thread Ashutosh Bapat
? On Thu, Jan 24, 2013 at 12:36 AM, Bruce Momjian br...@momjian.us wrote: On Wed, Jan 23, 2013 at 09:00:25PM +0200, Heikki Linnakangas wrote: On 23.01.2013 20:56, Bruce Momjian wrote: On Tue, Jan 22, 2013 at 06:03:28PM +0530, Ashutosh Bapat wrote: anyway, +1 for making this as default option. Going

Re: [HACKERS] pg_ctl idempotent option

2013-01-28 Thread Ashutosh Bapat
, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

[HACKERS] Expressions without type

2012-08-22 Thread Ashutosh Bapat
criteria like they can not be composite type etc. exprType() throws error when it's passed expressions which do not have type and hence I can not use it directly. Is there a function, which would tell me whether a given expression can have a type or not? -- Best Wishes, Ashutosh Bapat EntepriseDB

[HACKERS] Reconstructing Insert queries with indirection

2012-03-21 Thread Ashutosh Bapat
in that case I punted and just made it print the source expression(s). So, there doesn't seem to be any serious reason behind the restriction. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

Re: [HACKERS] Reconstructing Insert queries with indirection

2012-03-22 Thread Ashutosh Bapat
On Wed, Mar 21, 2012 at 10:58 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: Consider following sequence of commands create type complex as (r float8, i float8); create type quad as (c1 complex, c2 complex); create temp table quadtable(f1

[HACKERS] Potential for bugs while using COPY_POINTER_FIELD to copy NULL pointer

2012-04-09 Thread Ashutosh Bapat
, if the pointer to be copied is NULL? -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

[HACKERS] dropping table in testcase alter_table.sql

2011-07-07 Thread Ashutosh Bapat
in alter_table.sql). PFA patch which drops these two tables from alter_table.sql and corresponding OUT change. The regression run clean with this patch. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company diff --git a/src/test/regress/expected/alter_table.out b/src

Re: [HACKERS] dropping table in testcase alter_table.sql

2011-07-07 Thread Ashutosh Bapat
On Thu, Jul 7, 2011 at 9:41 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, Jul 7, 2011 at 3:05 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: I noticed that the test alter_table.sql is creating two tables tab1 and tab2 and it's not dropping it. Any test which follows

Re: [HACKERS] dropping table in testcase alter_table.sql

2011-07-12 Thread Ashutosh Bapat
after themselves, which is useful in some cases (testing the cleaning, for one thing), but not useful for 2. and 3. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

[HACKERS] Doubt about boundParams

2011-08-02 Thread Ashutosh Bapat
, it looks like parameter values stored in EState are never used. Is this correct? Or somewhere we use those parameter values? -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

Re: [HACKERS] Doubt about boundParams

2011-08-02 Thread Ashutosh Bapat
On Tue, Aug 2, 2011 at 3:45 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 02.08.2011 12:54, Ashutosh Bapat wrote: Hi All, I am looking at usage of bound parameters. In functions SPI_cursor_open_with_args() and SPI_cursor_open_with_args() parameters are flagged

Re: [HACKERS] Functional dependencies and GROUP BY - for subqueries

2013-04-26 Thread Ashutosh Bapat
and needs a better shape. If community is willing to accept the extension, I can work on it further. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company gb_subquery_pk.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Functional dependencies and GROUP BY - for subqueries

2013-04-26 Thread Ashutosh Bapat
On Fri, Apr 26, 2013 at 7:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: The reason being, it doesn't look into the subqueries (in FROM clause) to infer that p.product_id is essentially product.product_id which is a primary key. Right

Re: [HACKERS] Functional dependencies and GROUP BY - for subqueries

2013-04-28 Thread Ashutosh Bapat
that we throw functional dependency related errors at the time of creation of views? regards, tom lane -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

Re: [HACKERS] Functional dependencies and GROUP BY - for subqueries

2013-04-29 Thread Ashutosh Bapat
On Mon, Apr 29, 2013 at 7:31 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: Is there any reason why do we want to check the functional dependencies at the time of parsing and not after rewrite? Obviously, by doing so, we will allow creation

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-28 Thread Ashutosh Bapat
historical reason? Regards, Vaibhav -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Enterprise Postgres Company

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-29 Thread Ashutosh Bapat
aggregates. Sum does not need all the aggregate infrastructure in place, for example finalisation function. May be after removing initialization part you want to run regression (or at least aggregates.sql) to see what it breaks. Regards, Vaibhav On Thu, Apr 28, 2011 at 2:38 PM, Ashutosh Bapat

Re: [HACKERS] What would AggrefExprState nodes' args contain?

2011-04-29 Thread Ashutosh Bapat
Kaushal vaibhavkaushal...@gmail.com wrote: I tried all aggregates - min,max,sum,count and avg. all are working. What do you suggest now? On Fri, Apr 29, 2011 at 11:30 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: On Thu, Apr 28, 2011 at 4:21 PM, Vaibhav Kaushal

[HACKERS] Problem building in a directory shared from Mac to Ubuntu

2013-06-24 Thread Ashutosh Bapat
to VM, the build goes fine. Is this a known issue? What's the cure? -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

Re: [HACKERS] Problem building in a directory shared from Mac to Ubuntu

2013-06-25 Thread Ashutosh Bapat
On Tue, Jun 25, 2013 at 12:03 PM, Craig Ringer cr...@2ndquadrant.comwrote: On 06/25/2013 01:14 PM, Ashutosh Bapat wrote: Hi, I am observing a strange problem when I build latest PostgreSQL head on Ubuntu 12.04. I am running Ubuntu 12.04 as VM on Mac 10.7. The build directory points

Re: [HACKERS] Removing Inner Joins

2013-07-09 Thread Ashutosh Bapat
. Thoughts/Comments? Regards, Atri Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation

Re: [HACKERS] AGG_PLAIN thinks sorts are free

2013-07-19 Thread Ashutosh Bapat
(pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

Re: [HACKERS] LATERAL quals revisited

2013-07-19 Thread Ashutosh Bapat
-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

Re: [HACKERS] query_planner() API change

2013-08-05 Thread Ashutosh Bapat
of them to pick up? Objections, better ideas? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB

Re: [HACKERS] pass-through queries to foreign servers

2013-08-11 Thread Ashutosh Bapat
. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

[HACKERS] Clarification on materialized view restriction needed

2013-08-27 Thread Ashutosh Bapat
-restricted operations I am wondering what are other restrictions on the queries whose results can be used to create materialized views. -- Best Wishes, Ashutosh Bapat EntepriseDB Corporation The Postgres Database Company

Re: [HACKERS] Clarification on materialized view restriction needed

2013-08-27 Thread Ashutosh Bapat
I would be good, if this set gets documented, lest users will be confused. Can you point me to relevant sections of document? I can add this documentation. On Wed, Aug 28, 2013 at 10:12 AM, Noah Misch n...@leadboat.com wrote: On Tue, Aug 27, 2013 at 01:57:49PM +0530, Ashutosh Bapat wrote: I

Re: [HACKERS] git apply vs patch -p1

2013-09-15 Thread Ashutosh Bapat
mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

[HACKERS] Example query causing param_info to be set in plain rel path

2013-10-25 Thread Ashutosh Bapat
.val) q using(val); This at least caused the outer reference to be added as parameter, but again no lateral_relid. Is there an example query (however impractial query it would be), which can make the lateral_relids set in RelOptInfo of plain base relation? -- Best Wishes, Ashutosh Bapat

Re: [HACKERS] Example query causing param_info to be set in plain rel path

2013-10-28 Thread Ashutosh Bapat
of a table, then it's very likely that relevant code is untested in PostgreSQL. On Fri, Oct 25, 2013 at 7:11 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: In order to test various cases of LATERAL join in Postgres-XC, I am trying to find a query where

Re: [HACKERS] [BUGS] BUG #8542: Materialized View with another column_name does not work?

2013-10-31 Thread Ashutosh Bapat
/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Compile and test in netbeans

2013-11-19 Thread Ashutosh Bapat
when I create a table or an index. I am printing just for testing purpose to get a feel of code. Please tel me the procedure to run and print using printf(). -- Regards, Rohit Goyal -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Question about sorting internals

2013-12-11 Thread Ashutosh Bapat
, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Example query causing param_info to be set in plain rel path

2013-12-18 Thread Ashutosh Bapat
have a testcase which tests this code path as well. On Mon, Oct 28, 2013 at 12:30 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: No adding OFFSET there too didn't give the expected result. The lateral was handled in subquery and passed as param to the underlying table scan. I am

Re: [HACKERS] identify table oid for an AggState during plan tree initialization

2014-01-15 Thread Ashutosh Bapat
. Is there another way to get the Oid? -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] identify table oid for an AggState during plan tree initialization

2014-01-15 Thread Ashutosh Bapat
of the table. Though this is simple for simple query given as example in your mail, the process is tricky for complex queries. On Wed, Jan 15, 2014 at 6:05 PM, Masterprojekt Naumann1 mpws201...@gmail.com wrote: 2014/1/15 Ashutosh Bapat ashutosh.ba...@enterprisedb.com Hi Cathleen, An aggregate

Re: [HACKERS] LIKE INCLUDING CONSTRAINTS is broken

2014-01-29 Thread Ashutosh Bapat
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

[HACKERS] Selecting large tables gets killed

2014-02-19 Thread Ashutosh Bapat
* /tmp/.s.PGSQL.5432 /tmp/.s.PGSQL.5432.lock Looks like a bug in psql to me. Does anybody see that behaviour? -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Selecting large tables gets killed

2014-02-20 Thread Ashutosh Bapat
| 222 222string . . skipped And other info amul@amul:~/work/postgresql$ psql postgres I installed from HEAD(ae5266f25910d6e084692a7cdbd02b9e52800046) I failed to reproduce it, do I missing something? Regards, Amul Sul -- Best Wishes, Ashutosh Bapat EnterpriseDB

Re: [HACKERS] Selecting large tables gets killed

2014-02-20 Thread Ashutosh Bapat
of memory while collecting the result set. Either the documentation or the behaviour should be modified. On Thu, Feb 20, 2014 at 2:35 PM, Pavan Deolasee pavan.deola...@gmail.comwrote: On Thu, Feb 20, 2014 at 2:32 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: May be each setup

Re: [HACKERS] Selecting large tables gets killed

2014-02-20 Thread Ashutosh Bapat
On Thu, Feb 20, 2014 at 3:26 PM, Bernd Helmle maili...@oopsware.de wrote: --On 20. Februar 2014 14:49:28 +0530 Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: If I set some positive value for this variable, psql runs smoothly with any size of data. But unset that variable

Re: [HACKERS] Priority table or Cache table

2014-02-20 Thread Ashutosh Bapat
, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company buffer_usage_objects.sql Description: Binary data buffer_usage_queries.sql Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Selecting large tables gets killed

2014-02-20 Thread Ashutosh Bapat
sufficiently large output is encountered (larger than some predefined value MAX_ROWS or something), psql behaves as if FETCH_COUNT is set to MAX_ROWS. Documenting this behaviour wouldn't be a problem and would not be a problem, I guess. -- Thanks Bernd -- Best Wishes, Ashutosh Bapat

Re: Custom Scan APIs (Re: [HACKERS] Custom Plan node)

2014-02-25 Thread Ashutosh Bapat
to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: Custom Scan APIs (Re: [HACKERS] Custom Plan node)

2014-02-25 Thread Ashutosh Bapat
just calling them at appropriate places. Thanks, -- NEC OSS Promotion Center / PG-Strom Project KaiGai Kohei kai...@ak.jp.nec.com -Original Message- From: Ashutosh Bapat [mailto:ashutosh.ba...@enterprisedb.com] Sent: Tuesday, February 25, 2014 5:59 PM To: Kohei KaiGai Cc

Re: [HACKERS] Avoiding deeply nested AND/OR trees in the parser

2014-02-26 Thread Ashutosh Bapat
, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: Custom Scan APIs (Re: [HACKERS] Custom Plan node)

2014-03-03 Thread Ashutosh Bapat
. Thanks, Stephen -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: Custom Scan APIs (Re: [HACKERS] Custom Plan node)

2014-03-04 Thread Ashutosh Bapat
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

[HACKERS] using arrays within structure in ECPG

2014-03-24 Thread Ashutosh Bapat
? -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company array_test.pgc Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] About adding a column to system catalog pg_attribute

2014-03-24 Thread Ashutosh Bapat
catalog pg_attribute for getting an oid for a column also. How do we add a column into pg_attribute ? -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] using arrays within structure in ECPG

2014-03-24 Thread Ashutosh Bapat
On Mon, Mar 24, 2014 at 3:40 PM, Boszormenyi Zoltan zbos...@pr.hu wrote: 2014-03-24 07:22 keltezéssel, Ashutosh Bapat írta: Hi, I tried using integer array within a structure array in ECPG code. But it resulted in some garbage values being printed from the table. Here are the details

Re: [HACKERS] using arrays within structure in ECPG

2014-04-01 Thread Ashutosh Bapat
not understand that the field is an array of integers (or for that matter array of anything) and store all the values in contiguous memory at the given address. On Thu, Mar 27, 2014 at 11:05 PM, Michael Meskes mes...@postgresql.orgwrote: On Mon, Mar 24, 2014 at 11:52:30AM +0530, Ashutosh Bapat

Re: [HACKERS] using arrays within structure in ECPG

2014-04-01 Thread Ashutosh Bapat
, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] using arrays within structure in ECPG

2014-04-02 Thread Ashutosh Bapat
with offset = size of that member, thus again corrupting memory, if there are more than one rows being saved through pointer. On Wed, Apr 2, 2014 at 3:10 PM, Michael Meskes mes...@postgresql.orgwrote: On Wed, Apr 02, 2014 at 09:33:15AM +0530, Ashutosh Bapat wrote: So, you are saying that we should try

Re: [HACKERS] using arrays within structure in ECPG

2014-04-03 Thread Ashutosh Bapat
into such complex structure. On Tue, Apr 1, 2014 at 4:34 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: Hi MIchael, I tried to fix the offset problem. PFA the patch. It does solve the problem of setting wrong offset in ECPGdo() call. But then there is problem of interpreting the result from

[HACKERS] Pointer to structure in ECPG

2014-04-09 Thread Ashutosh Bapat
allocations. The patch is based on development head. Please consider this to be backpatched to 9.3 as well. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company test_select.pgc Description: Binary data diff --git a/src/interfaces/ecpg/preproc/type.c b/src

Re: [HACKERS] Pointer to structure in ECPG

2014-04-09 Thread Ashutosh Bapat
at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org Jabber: michael.meskes at gmail dot com VfL Borussia! Força Barça! Go SF 49ers! Use Debian GNU/Linux, PostgreSQL -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Question about optimising (Postgres_)FDW

2014-04-16 Thread Ashutosh Bapat
: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

[HACKERS] using array of char pointers gives wrong results

2014-04-29 Thread Ashutosh Bapat
. While reading array of char pointer in ecpg_do_prologue(), use the address instead of the value at that address 3. The pointer arithmetic should treat such variable as char **, instead of char * ECPG regression tests do not show any failures with this patch. -- Best Wishes, Ashutosh Bapat

Re: [HACKERS] using array of char pointers gives wrong results

2014-05-05 Thread Ashutosh Bapat
Let me bring the bug fix again to the surface. Is anybody looking at this fix? On Tue, Apr 29, 2014 at 2:25 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: Hi, When array of char * is used as target for the FETCH statement returning more than one row, it tries to store all

Re: [HACKERS] using array of char pointers gives wrong results

2014-05-06 Thread Ashutosh Bapat
, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] inherit support for foreign tables

2014-06-23 Thread Ashutosh Bapat
of v11 up to the current master. regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat

Re: [HACKERS] inherit support for foreign tables

2014-06-30 Thread Ashutosh Bapat
...@lab.ntt.co.jp wrote: (2014/06/24 16:30), Etsuro Fujita wrote: (2014/06/23 18:35), Ashutosh Bapat wrote: Selecting tableoid on parent causes an error, ERROR: cannot extract system attribute from virtual tuple. The foreign table has an OID which can be reported as tableoid for the rows coming

Re: [HACKERS] inherit support for foreign tables

2014-06-30 Thread Ashutosh Bapat
On Mon, Jun 30, 2014 at 4:17 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/06/30 17:47), Ashutosh Bapat wrote: I checked that it's reporting the right tableoid now. Thank you for the check. BTW, why aren't you using the tlist passed to this function? I guess

Re: [HACKERS] inherit support for foreign tables

2014-07-01 Thread Ashutosh Bapat
to have attr_needed for child rels. regards, tom lane -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] inherit support for foreign tables

2014-07-01 Thread Ashutosh Bapat
On Tue, Jul 1, 2014 at 7:39 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/06/30 20:17), Ashutosh Bapat wrote: On Mon, Jun 30, 2014 at 4:17 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: (2014/06/30 17:47), Ashutosh Bapat wrote

Re: [HACKERS] inherit support for foreign tables

2014-07-01 Thread Ashutosh Bapat
On Tue, Jul 1, 2014 at 12:25 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/07/01 15:13), Ashutosh Bapat wrote: On Tue, Jul 1, 2014 at 7:39 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: We may want to modify use_physical_tlist

Re: [HACKERS] Issue while calling new PostgreSQL command from a Java Application

2014-07-04 Thread Ashutosh Bapat
in parsenodes.h --- Only the newly added char *inp_str(that is different from ANALYZE) value is NULL. I was able to retrieve the column name from va_cols. Any help is appreciated. Thanks! -- Regards, Ashoke -- Best Wishes, Ashutosh Bapat EnterpriseDB

Re: [HACKERS] Issue while calling new PostgreSQL command from a Java Application

2014-07-04 Thread Ashutosh Bapat
, corresponding _copy* is the first suspect. You may be able find why it worked in command line and why not through the connector by breaking on copyObject() in either cases. On Fri, Jul 4, 2014 at 11:49 AM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: You may have to add code to copy

[HACKERS] Extending constraint exclusion for implied constraints/conditions

2014-07-07 Thread Ashutosh Bapat
and Merge join implicitly eliminate the non-joining children. 2. We need a way to push join down append path, which PostgreSQL doesn't do today. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Extending constraint exclusion for implied constraints/conditions

2014-07-07 Thread Ashutosh Bapat
On Mon, Jul 7, 2014 at 7:37 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: Right now, constraint exclusion code looks only at the provided conditions. If we want avoid table scan based on constraints in the above example, it will need to look

Re: [HACKERS] Extending constraint exclusion for implied constraints/conditions

2014-07-08 Thread Ashutosh Bapat
infrastructure we've been talking about where Postgres would know what the partitioning key is and the order and range of the partitions so it can directly generate the matching subjoins in less than n^2 time. -- greg -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres

Re: [HACKERS] Extending constraint exclusion for implied constraints/conditions

2014-07-08 Thread Ashutosh Bapat
On Tue, Jul 8, 2014 at 7:57 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ashutosh Bapat ashutosh.ba...@enterprisedb.com writes: On Mon, Jul 7, 2014 at 7:37 PM, Tom Lane t...@sss.pgh.pa.us wrote: I doubt it. The extra code isn't the problem so much, it's the extra planning cycles spent trying

Re: [HACKERS] Introducing coarse grain parallelism by postgres_fdw.

2014-07-25 Thread Ashutosh Bapat
://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Introducing coarse grain parallelism by postgres_fdw.

2014-07-25 Thread Ashutosh Bapat
and if eof_reached is false. 2096 /* Must be EOF if we didn't get as many tuples as we asked for. */ 2097 fsstate-eof_reached = (numrows fetch_size); 2098 2099 PQclear(res); 2100 res = NULL; On Fri, Jul 25, 2014 at 3:37 PM, Ashutosh Bapat ashutosh.ba

Re: [HACKERS] Introducing coarse grain parallelism by postgres_fdw.

2014-08-05 Thread Ashutosh Bapat
. Is there any suggestions or opinions? regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] Introducing coarse grain parallelism by postgres_fdw.

2014-08-08 Thread Ashutosh Bapat
parallel costs in plan/path structs, and single-row mode for postgres_fdw. I hope it will go towards anything. regards, -- Kyotaro Horiguchi NTT Open Source Software Center -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-08 Thread Ashutosh Bapat
test, that feels a bit like the tail wagging the dog to me, especially as I do hope that some day we'll figure out a way to use a better compression algorithm than pglz. Thanks, Stephen -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database

Re: Compute attr_needed for child relations (was Re: [HACKERS] inherit support for foreign tables)

2014-08-14 Thread Ashutosh Bapat
[min_attr .. max_attr] */ Thanks, Best regards, Etsuro Fujita -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: Compute attr_needed for child relations (was Re: [HACKERS] inherit support for foreign tables)

2014-08-20 Thread Ashutosh Bapat
On Wed, Aug 20, 2014 at 3:25 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: Hi Ashutish, (2014/08/14 22:30), Ashutosh Bapat wrote: On Thu, Aug 14, 2014 at 10:05 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: (2014/08/08 18:51), Etsuro

Re: Compute attr_needed for child relations (was Re: [HACKERS] inherit support for foreign tables)

2014-08-21 Thread Ashutosh Bapat
On Thu, Aug 21, 2014 at 3:00 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/08/21 13:21), Ashutosh Bapat wrote: On Wed, Aug 20, 2014 at 3:25 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: Hi Ashutish, I am sorry that I mistook

Re: [HACKERS] Convert query plan to sql query

2014-11-04 Thread Ashutosh Bapat
to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-10 Thread Ashutosh Bapat
://commitfest.postgresql.org/action/patch_view?id=1599 Thanks, Best regards, Etsuro Fujita -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation

Re: [HACKERS] inherit support for foreign tables

2014-11-12 Thread Ashutosh Bapat
changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] inherit support for foreign tables

2014-11-12 Thread Ashutosh Bapat
@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company

Re: [HACKERS] inherit support for foreign tables

2014-11-12 Thread Ashutosh Bapat
On Thu, Nov 13, 2014 at 12:20 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: Hi Ashutosh, Thanks for the review! (2014/11/13 15:23), Ashutosh Bapat wrote: I tried to apply fdw-inh-3.patch on the latest head from master branch. It failed to apply using both patch and git apply

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-17 Thread Ashutosh Bapat
, it will good, if we add that to regression in postgres_fdw. On Mon, Nov 17, 2014 at 4:06 PM, Ashutosh Bapat ashutosh.ba...@enterprisedb.com wrote: Hi Fujita-san, Here are my comments about the patch fscan_reltargetlist.patch Sanity Patch applies and compiles cleanly. Regressions in test

Re: [HACKERS] inherit support for foreign tables

2014-11-18 Thread Ashutosh Bapat
On Mon, Nov 17, 2014 at 1:25 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/11/12 20:04), Ashutosh Bapat wrote: I reviewed fdw-chk-3 patch. Here are my comments Thanks for the review! Tests --- 1. The tests added in file_fdw module look good. We should add tests

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-18 Thread Ashutosh Bapat
On Wed, Nov 19, 2014 at 11:18 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/11/18 18:27), Ashutosh Bapat wrote: On Tue, Nov 18, 2014 at 1:50 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: (2014/11/17 19:36), Ashutosh Bapat wrote

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-18 Thread Ashutosh Bapat
On Wed, Nov 19, 2014 at 12:14 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/11/19 14:58), Ashutosh Bapat wrote: On Wed, Nov 19, 2014 at 11:18 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp mailto:fujita.ets...@lab.ntt.co.jp wrote: (2014/11/18 18:27), Ashutosh Bapat wrote

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-19 Thread Ashutosh Bapat
Ok. I added that comment to the commitfest and changed the status to ready for commiter. On Wed, Nov 19, 2014 at 1:10 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: (2014/11/19 15:56), Ashutosh Bapat wrote: On Wed, Nov 19, 2014 at 12:14 PM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp

Re: [HACKERS] postgres_fdw behaves oddly

2014-11-23 Thread Ashutosh Bapat
On Sun, Nov 23, 2014 at 2:46 AM, Tom Lane t...@sss.pgh.pa.us wrote: Etsuro Fujita fujita.ets...@lab.ntt.co.jp writes: (2014/11/19 18:21), Ashutosh Bapat wrote: Ok. I added that comment to the commitfest and changed the status to ready for commiter. Many thanks! I committed

  1   2   3   4   5   6   7   8   9   10   >