Re: [HACKERS] Latches API on windows

Thanks for the suggestion. On Mon, Oct 9, 2017 at 6:56 PM, Tom Lane wrote: > Craig Ringer writes: > > On 9 October 2017 at 21:26, Abbas Butt > wrote: > >> In my case this is not true, I am calling InitSharedLatch in _PG_init > >> which gets called at CREATE EX

[HACKERS] Latches API on windows

t the latches API work on windows the way it is working on Linux? Best Regards -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> *Follow us on Twitter* @EnterpriseDB Visit EnterpriseDB for tu

Re: [HACKERS] How to run PG TAP tests on windows?

On Tue, Aug 1, 2017 at 7:35 PM, Michael Paquier wrote: > On Tue, Aug 1, 2017 at 10:24 AM, Abbas Butt > wrote: > > Can anyone point out to a tutorial or a list of steps required to run PG > TAP > > tests on windows? > > Only MSVC has a special handling: > https:/

[HACKERS] How to run PG TAP tests on windows?

Hi, Can anyone point out to a tutorial or a list of steps required to run PG TAP tests on windows? Regards -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> *Follow us on Twitter* @

Re: [HACKERS] PG_TRY & PG_CATCH in FDW development

Thanks for the reply. On Tue, Apr 25, 2017 at 7:45 PM, Tom Lane wrote: > Abbas Butt writes: > > What is happening for me is that PG_RE_THROW takes me to PG_TRY in the > same > > function and then PG_TRY jumps to PG_CATCH where PG_RE_THROW again jumps > to > >

[HACKERS] PG_TRY & PG_CATCH in FDW development

supposed to throw the error and quit. My question is what could possibly cause this infinite loop? Thanks in advance. -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m <http://www.enterprisedb.com/> *Follow us on Twitter* @

Re: [HACKERS] An issue in remote query optimization

Sorry for the confusion. ANALYZE works for the foreign table 'foreign_numbers'. test=# analyze foreign_numbers; ANALYZE test=# On Tue, Jan 31, 2017 at 5:04 AM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > On Tue, Jan 31, 2017 at 5:23 PM, Abbas Butt > wro

Re: [HACKERS] An issue in remote query optimization

On Tue, Jan 31, 2017 at 3:15 AM, Etsuro Fujita wrote: > On 2017/01/31 19:53, Abbas Butt wrote: > >> On Tue, Jan 31, 2017 at 2:25 AM, Etsuro Fujita >> mailto:fujita.ets...@lab.ntt.co.jp>> wrote: >> On 2017/01/31 18:24, Abbas Butt wrote: >> > >

Re: [HACKERS] An issue in remote query optimization

On Tue, Jan 31, 2017 at 2:25 AM, Etsuro Fujita wrote: > On 2017/01/31 18:24, Abbas Butt wrote: > >> Postgres_fdw optimizes remote queries by pushing down the where clause. >> This feature does not work consistently when the query is executed from >> within a pl/pgsql fu

[HACKERS] An issue in remote query optimization

test_pg_fdw() Note that the remote query does not contain the WHERE clause after the 5th invocation. I understand that this is because PostgreSQL starts using generic plan with pulled up where clause after the 5th invocation hoping that it would be faster since we have skiped planni

Re: [HACKERS] Using a latch between a background worker process and a thread

Thanks every body for the detailed advise. Let me try replacing latches by condition variables. I will report the results here. On Wed, Nov 2, 2016 at 11:54 AM, Craig Ringer wrote: > On 2 November 2016 at 02:10, Robert Haas wrote: > > On Tue, Nov 1, 2016 at 12:35 PM, Abbas Butt

[HACKERS] Using a latch between a background worker process and a thread

The thread blocks by calling WaitLatch. 5. The process after some time sets the latch using SetLatch. The thread does not notice that the latch has been set and keeps waiting. My question is: Are latches supposed to work between a process and a thread created by that process? Thanks. -- -- *A

Re: [HACKERS] 9.5 open items

> Michael > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <htt

Re: [HACKERS] varattno remapping

kers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- -- *Abbas* Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/> *Follow us on Twitter*

Re: [HACKERS] A problem with dump/restore of views containing whole row references

op" cast in all cases or in the case only when the parser somehow detects a column of the same name as the relation? > >regards, tom lane > -- Abbas EnterpriseDB Corporation The Enterprise PostgreSQL Company

Re: [HACKERS] A problem with dump/restore of views containing whole row references

On Fri, Apr 27, 2012 at 6:25 PM, Andrew Dunstan wrote: > > > On 04/27/2012 08:25 AM, Abbas Butt wrote: > >> >> The notation "relation.*" represents a whole-row reference. >> While parsing a whole-row reference is transformed into a Var with varno >>

[HACKERS] A problem with dump/restore of views containing whole row references

ole tuple. (For reference see comments of function makeWholeRowVar) While deparsing we need to take care of this case. The attached patch provides deparsing of a whole-row reference. A whole row reference will be deparsed either into alias.*::relation or relation.*::relation depending on alias -- Abbas Enterpri

Re: [HACKERS] [REVIEW] Prototype: In-place upgrade v02

On Mon, 2008-09-29 at 14:42 +0200, Zdenek Kotala wrote: > Abbas napsal(a): > > Hi, > > > > I have gone through the following stuff > > > > 1) previous emails on the patch > > 2) http://wiki.postgresql.org/wiki/In-place_upgrade > > 3) h

Re: [HACKERS] [REVIEW] Prototype: In-place upgrade v02

read the same using the 8.4 with your patch applied. What database objects should I create in the test database, should I just create objects of my choice? Does sizes (both length and breadth) of tables matter? Do I have to perform performance tests too? Regards Abbas On Fri, 2008-09-19 at 14

Re: [HACKERS] [REVIEW] Prototype: In-place upgrade v02

Even with that a hunk failed for bufpage.c, but I applied that part manually to move on. Regards Abbas On Thu, 2008-09-18 at 12:17 +0200, Zdenek Kotala wrote: > Abbas napsal(a): > > Hi, > > I downloaded latest postgresql source code from > > git clone git://git.postgresql.o

[HACKERS] [REVIEW] Prototype: In-place upgrade v02

Hi, I downloaded latest postgresql source code from git clone git://git.postgresql.org/git/postgresql.git and tried to apply the patch http://archives.postgresql.org/pgsql-hackers/2008-09/gza1fGXLvf3L.gz It does not apply cleanly, see the failures in attached file. Regards Abbas

[HACKERS] Postgresql coding conventions

*currentLogDir; Chapter 46 of the documentation does not say much about variable or function naming. While writing code or reviewing a path are we supposed to consider the camel cased names correct or the under-score separated names correct? Regards Abbas www.enterprisedb.com -- Sent via pgsql

Re: [HACKERS] Need more reviewers!

t to be one, we need > your > > help reviewing patches! There are several "easy" patches in the list, so > > I can assign them to beginners. > > > > Please volunteer now! > > Hi Josh, I volunteer as a reviewer, assign a patch to me. Regards Abbas www.enterprisedb.com

[HACKERS] temp table problem

uggestions on how to tackle this problem? Regards Abbas EnterpriseDB http://www.enterprisedb.com -- 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] psql slash# command

gt; > New patch submitted: http://archives.postgresql.org/pgsql-patches/2008-04/msg00240.php regards, -- Sibte Abbas

Re: [HACKERS] [PATCHES] psql slash# command

diately executing it. Actual execution is only a away, > but this definition would allow you to edit the command a bit more > before you execute it --- including \e to use an editor. It also > closes the loop in terms of providing some confidence that you typed > the number you should have typed. > This makes more sense and also appears to be much safer. I will start modifying the patch as per this approach now. regards, -- Sibte Abbas

Re: [HACKERS] NULL and plpgsql rows

know what tuple descriptor it will actually contain, however, maybe we can have "special" tuple descriptors for un-assigned record types. For example, if for NULL/unassigned record type we create a tuple descriptor of "VOID" type, and then initialize its corresponding (one

Re: [HACKERS] Raw device I/O for large objects

ld be highly appreciated! > http://www.postgresql.org/docs/techdocs http://www.postgresql.org/docs/faq/ The postgresql documentation: http://www.postgresql.org/docs/8.2/interactive/index.html Also, If you have the source, the src/tools/backend directory has some useful material for starter

Re: [HACKERS] TODO item: add \# which lists line numbers, and allows command execution

On 9/8/07, Sibte Abbas <[EMAIL PROTECTED]> wrote: > > > Hi all, > > Realizing that the mentioned TODO item discussed at > http://archives.postgresql.org/pgsql-hackers/2006-12/msg00255.php > <http://archives.postgresql.org/pgsql-hackers/2006-12/msg00255.php> can

[HACKERS] TODO item: add \# which lists line numbers, and allows command execution

. Comments are welcomed. regards, -- Sibte Abbas

Re: [HACKERS] [GENERAL] 8.2.4 signal 11 with large transaction

tters/2007-07/msg00215.php Makes sense. regards, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [GENERAL] 8.2.4 signal 11 with large transaction

_server_log() function in elog.c? thanks, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] schema_to_xmlschema() seems a bit less than finished

when a column gets removed from a table as a result of drop cascade, the tuple descriptor (more specifically rel->rd_att field) for that relation is not updated properly? regards, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)

Re: [HACKERS] unchecked malloc

This dicussion reminds me of a possible memory leak in plpgsql's code. In case you are interested in it; in pl_comp.c, plpgsql_build_variable takes a pointer to a PLpgSQL_type structure, which is always a malloc'ed instance(since we always use plpgsql_build_datatype function). The switch stateme

Re: [HACKERS] getting oid of function

On Tue, 15 Feb 2005 14:55:38 +1100, Neil Conway <[EMAIL PROTECTED]> wrote: > On Mon, 2005-02-14 at 17:02 +0500, Sibtay Abbas wrote: > > thank you for the detailed reply > > But what i wanted to know is that how can we actually get a function's > > oid from its &

Re: [HACKERS] getting oid of function

ach I would be thankful if anyone can correct me. On Mon, 14 Feb 2005 01:14:07 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Mon, Feb 14, 2005 at 12:47:44PM +0500, Sibtay Abbas wrote: > > > > Is it possible to get the oid of a function on the basis of its name?. > >

[HACKERS] getting oid of function

Hello all Is it possible to get the oid of a function on the basis of its name?. The scenario which i am currently facing is that i have the function name, now i want search the pg_proc system catalog on the basis of the function name and retrieve its Oid. Another confusion which i am facing is

[HACKERS] passing parameters by reference

hello all as i have mentioned this before, as part of my academic project i am required to make modifications in postgresql. One of my tasks includes allowing plpgsql functions to pass parameters by reference. For this purpose I have been digging in the code for plpgsql and postgresql for 2 days

[HACKERS] storage of compiled functions

Hello everyone i have been studying postgres's function handling philosophy lately. I got stuck at a point where i could'nt get the answer myself All the information related to functions are stored in pg_proc system catalog. But when a function is compiled (probably the data structure that contai

[HACKERS] exception handling in plpgsql

hello I am using the following sytex to handle exceptions in plpgsql (I am using postgres 8 rc1) some code EXCEPTION WHEN NO_DATA THEN RAISE NOTICE 'NO DATA'; WHEN OTHERS THEN RAISE NOTICE 'An exception occurred'; RETURN emp_rec; and i receive

[HACKERS] CreateFunctionStmt struct

hello, typedef struct CreateFunctionStmt { NodeTag type; boolreplace; List *funcname; List *parameters; TypeName *returnType; List *options; List

Re: [HACKERS] cant execute yyparse() within postgresql

Datum mylanguage_handler(PG_FUNCTION_ARGS){ if (CALLED_AS_TRIGGER(fcinfo)) /*do nothing else{ char *proc_source; Datum prosrcdatum; boolisnull; //get the oid of the function

Re: [HACKERS] cant execute yyparse() within postgresql

dont understand someone's question the nice way is to ask him the details instead of trying to insult him. thank you --- Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Sibtay Abbas wrote: > > i am not able to execute the yyparse() function > > generated by flex from within t

[HACKERS] cant execute yyparse() within postgresql

hello i am not able to execute the yyparse() function generated by flex from within the pl call handler function. does any one knows the reason for this failure? and how can it be rectified thank you __ Do you Yahoo!? Send a seasonal email gr

[HACKERS] yyin's value of postgresql parser

hello what is the value of yyin variable for postgresql parser. It might be the default("stdout") when postgresql is in interactive backend mode...but what happens when clients from different workstations sends their queries? __ Do you Yahoo!?

[HACKERS] cant write to file within call handler interface

hello i am not able to write to file until the pl call handler interface. this is the template which i am following PG_FUNCTION_INFO_V1(my_call_handler); Datum my_call_handler(PG_FUNCTION_ARGS) { ...my code... int fd = open("filename",O_WRONLY); write(fd,buffer,strlen(bu

[HACKERS] old-style handler error

i have added my own pocedural language in postgresql. by using the Create function command i ve also written a procedure in that language. now when invoke that function with SELECT (func_name) i receive the following error message ERROR: language 17254 has old-style handler.

[HACKERS] old-style handler problem

hi everyone i ve added my own pl language in postgresql. i ve followed the process mentioned in the documentation. for the handler function i ve followed the following template PG_FUNCTION_INFO_V1(myhandler); Datum plsample_call_handler(PG_FUNCTION_ARGS) { Datum rv; ...m

[HACKERS] adding procedural languages

hi everyone ok i ve tried to add my own procedural language using the call handler interface. I am doining nothing in the handler function except tyring to print a mess through errmsg function (plz correct me if i am wrong here, since i cant see the message which i am printing) Now my question

Re: [HACKERS] spi and other languages

i am still in my R&D phase so i ve not yet tried it. actually i chose the wrong example. We can call SQL statements like SPI_Execute("SELECT * FROM sometable") from the spi interface. My question is that can we enter other procedural languages as well, like pgplsql statements.

[HACKERS] spi and other languages

i guess the answer to my previous question was spi...i ve got another question, can we call pgsql or plpgsql functions using spi? like can we do something like SPI_execute("CREATE FUNCTION blah() RETURNS Integer ." __ Do you Yahoo!?

[HACKERS] how can i add my own procedural language?

hi is "Procedural language handler function" the interface for adding your own procedural languages to postgres? I ve read the documentation but i am not able to understand where do we deal with stuff like parse trees, query trees, plan trees etc. Ofcourse any procedural language should pass th

[HACKERS] main entry point for queries?

hello i am trying to understand the source code of postgresql. Whenever a user enters a query, whether from the Socket end or the interactive back end, which function is always invoked that would start manipulation of that query... i ve noticed that the primitive parsing is done by the raw_parse

[HACKERS] Oid?

hi everyone i see an attribute 'oid_value' with 'Oid' type in the ListCell union. can anyone tell me what does it represents? Thank you __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.