[HACKERS] Help needed regarding DSA based in-memory index!

Hi Munro, Thanks for cautioning us about possible memory leaks(during error cases) incase of long-lived DSA segements(have a look in below thread for more details). https://www.postgresql.org/message-id/CAEepm%3D3c4WAtSQG4tAF7Y_VCnO5cKh7KuFYZhpKbwGQOF%3DdZ4A%40mail.gmail.com

Re: [HACKERS] Help required to debug pg_repack breaking logical replication

On Sat, Oct 7, 2017 at 2:37 PM, Daniele Varrazzo wrote: > (with a > custom addition to update the relfrozenxid which seems backwards to me > as it sets the older frozen xid on the new table [3]). > > [3] https://github.com/reorg/pg_repack/issues/152 Wow. That's

Re: [HACKERS] Help required to debug pg_repack breaking logical replication

On 08/10/17 15:21, Craig Ringer wrote: > On 8 October 2017 at 02:37, Daniele Varrazzo > wrote: >> Hello, >> >> we have been reported, and I have experienced a couple of times, >> pg_repack breaking logical replication. >> >> -

Re: [HACKERS] Help required to debug pg_repack breaking logical replication

On 8 October 2017 at 02:37, Daniele Varrazzo wrote: > Hello, > > we have been reported, and I have experienced a couple of times, > pg_repack breaking logical replication. > > - https://github.com/reorg/pg_repack/issues/135 > -

[HACKERS] Help required to debug pg_repack breaking logical replication

Hello, we have been reported, and I have experienced a couple of times, pg_repack breaking logical replication. - https://github.com/reorg/pg_repack/issues/135 - https://github.com/2ndQuadrant/pglogical/issues/113 In my experience, after the botched run, the replication slot was "stuck", and

Re: [HACKERS] help to identify the reason that extension's C function returns array get segmentation fault

Thanks for your clues. The system I have used to debug the code is x86 64bit based, Ubuntu 1404 and postgres 9.3.13, I have revised the code and it looks like as following: Datum vquery(PG_FUNCTION_ARGS) { int array_len = PG_GETARG_INT32(0); int64 * node_ids; ArrayType * retarr; Datum * vals ;

Re: [HACKERS] help to identify the reason that extension's C function returns array get segmentation fault

=?UTF-8?B?6ZKx5paw5p6X?= writes: > I have written an extension to manage openstreetmap data. There is a C > function to perform spatial top k query on several tables and return an > array of int8 type as result. The code skeleton of this function is as > follows: There are

[HACKERS] help to identify the reason that extension's C function returns array get segmentation fault

I have written an extension to manage openstreetmap data. There is a C function to perform spatial top k query on several tables and return an array of int8 type as result. The code skeleton of this function is as follows: Datum vquery(PG_FUNCTION_ARGS) { int array_len = PG_GETARG_INT32(0);

Re: [HACKERS] Help text for pg_basebackup -R

On Fri, Feb 17, 2017 at 5:21 PM, Tom Lane wrote: > Stephen Frost writes: > > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > >> Magnus Hagander wrote: > >>> I'm guessing if we backpatch something like that, it would cause > issues for > >>>

Re: [HACKERS] Help text for pg_basebackup -R

Stephen Frost writes: > * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: >> Magnus Hagander wrote: >>> I'm guessing if we backpatch something like that, it would cause issues for >>> translations, right? So we should make it head only? >> We've had the argument a number of

Re: [HACKERS] Help text for pg_basebackup -R

* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > Magnus Hagander wrote: > > On Wednesday, February 15, 2017, Alvaro Herrera > > wrote: > > > > > Magnus Hagander wrote: > > > > > > > printf(_(" -R, --write-recovery-conf\n" > > > > - "

Re: [HACKERS] Help text for pg_basebackup -R

Magnus Hagander wrote: > On Wednesday, February 15, 2017, Alvaro Herrera > wrote: > > > Magnus Hagander wrote: > > > > > printf(_(" -R, --write-recovery-conf\n" > > > - " write recovery.conf > > after backup\n")); > >

Re: [HACKERS] Help text for pg_basebackup -R

On Wednesday, February 15, 2017, Alvaro Herrera wrote: > Magnus Hagander wrote: > > > printf(_(" -R, --write-recovery-conf\n" > > - " write recovery.conf > after backup\n")); > > + "

Re: [HACKERS] Help text for pg_basebackup -R

Magnus Hagander wrote: > printf(_(" -R, --write-recovery-conf\n" > - " write recovery.conf after > backup\n")); > + " write recovery.conf for > replication\n")); > printf(_(" -S,

[HACKERS] Help text for pg_basebackup -R

The current help text for pg_basebackup -R is "write recovery.conf after backup". This says nothing about what it actually does. I've had a number of people ask me now why that's not default "because you need a recovery.conf to restore from backup". The point being that it doesn't say anything

[HACKERS] help for old extension, first_last_agg bug in install with pg9.5

The C implementation is simple, the problem is with the makefile, https://github.com/wulczer/first_last_agg/issues/2 *some clues?* - - - make Makefile:25: /usr/lib/postgresql/9.5/lib/pgxs/src/makefiles/pgxs.mk: No such file or directory make: *** No rule to make target

Re: [HACKERS] HELP!!! The WAL Archive is taking up all space

Hi all, Thank you for all of your responses. Meanwhile, I will repost this at pgsql-gene...@postgresql.org Regards, Fattah On 09/12/2015, David G. Johnston wrote: > On Tue, Dec 8, 2015 at 4:43 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On

Re: [HACKERS] HELP!!! The WAL Archive is taking up all space

On Tue, Dec 8, 2015 at 7:33 PM, FattahRozzaq wrote: > The WAL archive is at /home/postgres/archive/master/, right? > This directory consume more than 750GB of Disk-1. > Each segment in the /home/postgres/archive/master/ is 16MB each > There are currently 47443 files in this

[HACKERS] HELP!!! The WAL Archive is taking up all space

Hi all, Please help... I have 1 master PostgreSQL and 1 standby PostgreSQL. Both servers has the same OS Linux Debian Wheezy, the same hardware. Both server hardware: CPU: 24 cores RAM: 128GB Disk-1: 800GB SAS (for OS, logs, WAL archive directory) Disk-2: 330GB SSD (for PostgreSQL data

Re: [HACKERS] HELP!!! The WAL Archive is taking up all space

On Tue, Dec 8, 2015 at 3:33 AM, FattahRozzaq wrote: > Hi all, > > Please help... > > I have 1 master PostgreSQL and 1 standby PostgreSQL. > Both servers has the same OS Linux Debian Wheezy, the same hardware. > > Both server hardware: > CPU: 24 cores > RAM: 128GB > Disk-1:

Re: [HACKERS] HELP!!! The WAL Archive is taking up all space

On Tue, Dec 8, 2015 at 4:43 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Dec 8, 2015 at 3:33 AM, FattahRozzaq wrote: > >> Hi all, >> >> Please help... >> >> I have 1 master PostgreSQL and 1 standby PostgreSQL. >> Both servers has the same OS Linux

[HACKERS] Help on creating C function that reads int2[] (using "int2vector")

Hello PG Hackers, I created a custom C function with this signature: CREATE FUNCTION calculate_hash(numbers int2[]) RETURNS int8 AS 'MODULE_PATHNAME', 'pg_calculate_hash' LANGUAGE C IMMUTABLE STRICT; And here is the function source code (inspired in codes I found in

Re: [HACKERS] Help needed for PL/Ruby

On 29 April 2015 at 21:45, Szymon Guz mabew...@gmail.com wrote: Hi Devrim, I will take a look at this. regards, Szymon On 29 April 2015 at 18:24, Devrim Gündüz dev...@gunduz.org wrote: Hi, Anyone? :) Regards, Devrim On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote: Hi,

Re: [HACKERS] Help needed for PL/Ruby

Hi, Anyone? :) Regards, Devrim On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote: Hi, Background info first: PL/Ruby was originally maintained by Guy Decoux, who passed away in 2008: https://www.ruby-forum.com/topic/166658 . After his death, Akinori MUSHA forked the project and

[HACKERS] Help needed for PL/Ruby

Hi, Background info first: PL/Ruby was originally maintained by Guy Decoux, who passed away in 2008: https://www.ruby-forum.com/topic/166658 . After his death, Akinori MUSHA forked the project and maintained it until 2010: https://github.com/knu/postgresql-plruby . Last release was on Jan 2010,

Re: [HACKERS] Help me! Why did the salve stop suddenly ?

On Thu, Feb 12, 2015 at 3:27 AM, hailong Li shuhujiaol...@gmail.com wrote: Hi, dear pgsql-hackers Please have a look at https://wiki.postgresql.org/wiki/Guide_to_reporting_problems This is the wrong mailing list for this sort of question, and your report is pretty unclear, so it's hard to tell

[HACKERS] Help me! Why did the salve stop suddenly ?

Hi, dear pgsql-hackers *1. environment* *DB Master* $ cat /etc/issue CentOS release 6.5 (Final) Kernel \r on an \m $ uname -av Linux l-x1.xx.cnx 3.14.29-3.centos6.x86_64 #1 SMP Tue Jan 20 17:48:32 CST 2015 x86_64 x86_64 x86_64 GNU/Linux $ psql -U postgres psql (9.3.5) Type help for help.

Re: [HACKERS] Help to startup

Michael Paquier wrote: On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer cr...@2ndquadrant.com wrote: On 09/17/2014 01:51 AM, Tapan Halani wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about

Re: [HACKERS] Help to startup

On 09/17/2014 01:51 AM, Tapan Halani wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. Since you're asking on pgsql-hackers, you're presumably interested in getting involved in

Re: [HACKERS] Help to startup

On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer cr...@2ndquadrant.com wrote: On 09/17/2014 01:51 AM, Tapan Halani wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. Since you're

[HACKERS] Help to startup

Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. Thank you, Tapan Halani

Re: [HACKERS] Help to startup

On 09/16/2014 01:51 PM, Tapan Halani wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. The first thing you need to do is learn to ask your question in the right forum.

[HACKERS] [help] Is it possible to support remote COPY operation on PG?

Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance? --- ThanksRegards, Xiong He

Re: [HACKERS] [help] Is it possible to support remote COPY operation on PG?

To: PostgreSQL-development Subject: [HACKERS] [help] Is it possible to support remote COPY operation on PG? Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance

Re: [HACKERS] [help] Is it possible to support remote COPY operation on PG?

On Wed, Oct 24, 2012 at 3:54 PM, Xiong He iih...@qq.com wrote: Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance? With a psql client you can use the command ¥copy to perform that. -- Michael

Re: [HACKERS] Help me develop new commit_delay advice

From: Peter Geoghegan [mailto:pe...@2ndquadrant.com] Sent: Wednesday, August 01, 2012 8:49 PM On 1 August 2012 15:14, Amit Kapila amit.kap...@huawei.com wrote: I shall look into this aspect also(setting commit_delay based on raw sync). You also suggest if you want to run the test with

Re: [HACKERS] Help me develop new commit_delay advice

Peter, For some reason I didn't receive the beginning of this thread. Can you resend it to me, or (better) post it to the pgsql-performance mailing list? I have a linux system where I can test both on regular disk and on SSD. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com --

Re: [HACKERS] Help me develop new commit_delay advice

On 29 July 2012 16:39, Peter Geoghegan pe...@2ndquadrant.com wrote: Many of you will be aware that the behaviour of commit_delay was recently changed. Now, the delay only occurs within the group commit leader backend, and not within each and every backend committing a transaction: I've moved

Re: [HACKERS] Help me develop new commit_delay advice

From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Peter Geoghegan Sent: Sunday, July 29, 2012 9:09 PM I made what may turn out to be a useful observation during the development of the patch, which was that for both the tpc-b.sql and insert.sql

Re: [HACKERS] Help me develop new commit_delay advice

On 1 August 2012 15:14, Amit Kapila amit.kap...@huawei.com wrote: I shall look into this aspect also(setting commit_delay based on raw sync). You also suggest if you want to run the test with different configuration. Well, I was specifically interested in testing if half of raw sync time was a

[HACKERS] Help me develop new commit_delay advice

Many of you will be aware that the behaviour of commit_delay was recently changed. Now, the delay only occurs within the group commit leader backend, and not within each and every backend committing a transaction:

[HACKERS] Help with pg_locks query

I am writing a talk about the lock manager for PG Open and I would like suggestions on how to improve a query in my talk. The query creates a lockinfo_hierarchy view of a recursive query on other views. The output shows the locks held and the locks being waited for: \! psql -e -c

Re: [HACKERS] help with plug-in function for additional (partition/shard) visibility checks

hello … i have been thinking about this issue for quite a while ... given your idea i am not sure how this can work at all. consider: begin; insert 1 insert 2 commit assume this ends up in the same node, now you split it into two … 1 and 2 will have exactly the

Re: [HACKERS] help with plug-in function for additional (partition/shard) visibility checks

On Fri, 2011-09-02 at 14:01 +0200, PostgreSQL - Hans-Jürgen Schönig wrote: hello … i have been thinking about this issue for quite a while ... given your idea i am not sure how this can work at all. consider: begin; insert 1 insert 2 commit assume this ends

Re: [HACKERS] help with plug-in function for additional (partition/shard) visibility checks

hello … the goal of the entire proxy thing is to make the right query go to the right node / nodes. we determine this by using a partitioning function and so on … currently PL/proxy has only a handful of commands - one is RUN ON … which tells us where to put things. assume you issue a select …

Re: [HACKERS] help with plug-in function for additional (partition/shard) visibility checks

On Fri, 2011-09-02 at 14:51 +0200, PostgreSQL - Hans-Jürgen Schönig wrote: hello … the goal of the entire proxy thing is to make the right query go to the right node / nodes. we determine this by using a partitioning function and so on … currently PL/proxy has only a handful of commands -

Re: [HACKERS] help with plug-in function for additional (partition/shard) visibility checks

On Sep 2, 2011, at 2:59 PM, Hannu Krosing wrote: On Fri, 2011-09-02 at 14:51 +0200, PostgreSQL - Hans-Jürgen Schönig wrote: hello … the goal of the entire proxy thing is to make the right query go to the right node / nodes. we determine this by using a partitioning function and so on …

[HACKERS] help with plug-in function for additional (partition/shard) visibility checks

Hallow hackers I have the following problem to solve and would like to get advice on the best way to do it. The problem: When growing a pl/proxy based database cluster, one of the main operations is splitting a partition. The standard flow is as follows: 1) make a copy of the partitions

[HACKERS] help with sending email

Hi everybody: I am using pgmail to send email in an application, but I would like to use html format Does anybody has an example how to do this?, or what do you recommend me to use por doing this? Thanks in advance for your attention. Best Regards, Fernando Acosta Lima -

Re: [HACKERS] help with sending email

On Jul 13, 2011, at 12:29 PM, Fernando Acosta Torrelly fgaco...@gmail.com wrote: Hi everybody: I am using pgmail to send email in an application, but I would like to use html format Does anybody has an example how to do this?, or what do you recommend me to use por doing this?

Re: [HACKERS] Help: regarding patch development

nil nil unprecedente...@yahoo.com wrote: i want to develop a service for postgresql related to querry processing.but i dont know how to develop it. plz guide me so that i can take step. I think the root of all information on that is here: http://www.postgresql.org/developer/ with the

[HACKERS] Help required regarding patch development

Hello,    Sir, i am a student. i want to develop a patch for postgresql. but i dont know how to take the step.kindly guide me for this.        Thanks    Emman

Re: [HACKERS] Help required regarding patch development

nil nil wrote: Hello, ?? Sir, i am a student. i want to develop a patch for postgresql. but i dont know how to take the step.kindly guide me for this. Sure, look here: http://developer.postgresql.org -- Bruce Momjian br...@momjian.ushttp://momjian.us

[HACKERS] Help: regarding patch development

Hello,   Sir, i want to develop a service for postgresql related to querry processing.but i dont know how to develop it. plz guide me so that i can take step. i will be realy thankful to you.   Regards Emman

Re: [HACKERS] help: collation support on Windows

On fre, 2011-02-25 at 21:32 +0200, Peter Eisentraut wrote: According to the online documentation, the APIs are there: http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx Now we'd need someone brave try to make it work. The starting point would be to define HAVE_LOCALE_T and then make it

[HACKERS] help: collation support on Windows

According to the online documentation, the APIs are there: http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx Now we'd need someone brave try to make it work. The starting point would be to define HAVE_LOCALE_T and then make it build. Microsoft has all the relevant functions and types with

Re: [HACKERS] help: collation support on Windows

On 02/25/2011 02:32 PM, Peter Eisentraut wrote: According to the online documentation, the APIs are there: http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx Now we'd need someone brave try to make it work. The starting point would be to define HAVE_LOCALE_T and then make it build.

Re: [HACKERS] help: collation support on Windows

On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan and...@dunslane.net wrote: On 02/25/2011 02:32 PM, Peter Eisentraut wrote: According to the online documentation, the APIs are there: http://msdn.microsoft.com/en-ca/library/a7cwbx4t.aspx Now we'd need someone brave try to make it work.  The

Re: [HACKERS] help: collation support on Windows

On Fri, Feb 25, 2011 at 22:58, Dave Page dp...@pgadmin.org wrote: On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan and...@dunslane.net wrote: On 02/25/2011 02:32 PM, Peter Eisentraut wrote: According to the online documentation, the APIs are there:

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

Itagaki Takahiro itagaki.takah...@gmail.com writes: On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas robertmh...@gmail.com wrote: Oh - I didn't realize this meant marking lots of things in contrib that didn't otherwise need to be marked.  Why do other people need this if we don't? As I

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: As I mentioned, we don't need the marks in our build environment at all. In that case, anybody who does need it should fix their build environment. I grow really weary of the idea that we should submit to arbitrary amounts

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On 28/09/10 11:09, Itagaki Takahiro wrote: On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas robertmh...@gmail.com wrote: Since we have PGDLLEXPORT in 9.0, we can mark some of exported functions with it in tutorial codes and maybe contrib modules. If that (a) works and (b) reduces user confusion,

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 09:26, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: As I mentioned, we don't need the marks in our build environment at all. In that case, anybody who does need it should fix their build

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

Magnus Hagander escreveu: We might, however, want to add a specific section to the *documentation* about building extensions on Windows. +1. -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 6:16 PM, Magnus Hagander mag...@hagander.net wrote: We're talking about the export all symbols thing, right? I *don't* think we want to recommend people to do that - it creates bloated DLL files, for no really good reason. Also, it's not just a matter of a msvc project

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

Itagaki Takahiro escreveu: I had the same problems before, and I wrote some hacks for VC++. Isn't there such a code in core or am i missing something? Is it worth supporting the VC++ standalone projects? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira eu...@timbira.com wrote: Itagaki Takahiro escreveu: I had the same problems before, and I wrote some hacks for VC++. Isn't there such a code in core or am i missing something? Is it worth supporting the VC++ standalone projects?

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Mon, Sep 27, 2010 at 8:45 PM, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira eu...@timbira.com wrote: Itagaki Takahiro escreveu: I had the same problems before, and I wrote some hacks for VC++. Isn't there such a code in core

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas robertmh...@gmail.com wrote: Since we have PGDLLEXPORT in 9.0, we can mark some of exported functions with it in tutorial codes and maybe contrib modules. If that (a) works and (b) reduces user confusion, +1 from me.  We've gotten this question a

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Mon, Sep 27, 2010 at 11:09 PM, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas robertmh...@gmail.com wrote: Since we have PGDLLEXPORT in 9.0, we can mark some of exported functions with it in tutorial codes and maybe contrib modules. If that

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas robertmh...@gmail.com wrote: If we do so, many PGDLLEXPORT will be added:  *  17 in src/tutorial  * 507 in contrib for each exported PGFunction, _PG_init, and _PG_fini. Oh - I didn't realize this meant marking lots of things in contrib that

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Mon, Sep 27, 2010 at 11:26 PM, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas robertmh...@gmail.com wrote: If we do so, many PGDLLEXPORT will be added:  *  17 in src/tutorial  * 507 in contrib for each exported PGFunction, _PG_init, and

[HACKERS] Help with User-defined function in PostgreSQL with Visual C++

Hello I have problems defining user-defined types and functions in PostgreSQL using a Visual C++ development environment. In order to look for the solution I took the complex.c and complex.source files coming with the PostgreSQL distribution (src/tutorial). When I run the examples there is a

Re: [HACKERS] Help with User-defined function in PostgreSQL with Visual C++

On Sun, Sep 26, 2010 at 12:56 AM, Esteban Zimanyi estebanzima...@gmail.com wrote: When I run the examples there is a server crash. I used both Visual C++ 2008 and 2005 for building the dll. I also used both PostgreSQL versions 8.4 and 9.0. All versions produce the same problem. Do you know

[HACKERS] Help with Join Performance Testing

A hash join modification patch is under review for 8.4 that needs performance testing. We would appreciate help with this testing. A testing version of the patch is attached in addition to testing instructions and where to retrieve a sample data set. The basic idea of the patch is that it

Re: [HACKERS] Help in processing multiple parse nodes.

Hi all, I am having a project in Postgres where I had modified code in gram.y...I have added new command along with grammer and returning list of parse nodes as opposed to single node inside actions blockI want to process each of them in postgres.c file...But, I couldn't find any difference

[HACKERS] HELP

Hello, I am creating an agent that runs alongside the postgres written in c++, I have a question: How send sql queries directly for the database without going need to make any connection? What I call function, which I use file? Thanks, -- Pedro Belmino.

Re: [HACKERS] HELP

On Wed, Mar 26, 2008 at 11:10 PM, Pedro Belmino [EMAIL PROTECTED] wrote: Hello, I am creating an agent that runs alongside the postgres written in c++, I have a question: How send sql queries directly for the database without going need to make any connection? What I call function, which I

Re: [HACKERS] Help with release note items

Bruce Momjian [EMAIL PROTECTED] writes: I need help understanding the following two release note items (see XXX): I've tweaked the text for the first one. I do not think the second one needs any changes; the matter is discussed elsewhere in the docs, and the release notes are not the place to

[HACKERS] Help with release note items

I need help understanding the following two release note items (see XXX): listitem para Create a general mechanism that supports casts to and from the standard string types (typeTEXT/type, typeVARCHAR/type, typeCHAR/type) for emphasisevery/emphasis datatype, by

[HACKERS] Help! DLL make faild under windows mingw.

I am doing a DLL project, it is in the backend/utils/mb. But it can not be maked under windows mingw. I require everyone to help me. Thank your very much. The error infomations are as follows. Info: resolving _CurrentMemoryContext by linking to __imp__CurrentMemoryContext (auto-import) Info:

Re: [HACKERS] Help! DLL make faild under windows mingw.

Hi! What exactly are you trying to build? If you have own-written Makefile for this - post it here. Does your code contain #define BUILDING_DLL before inclusion of PostgreSQL headers? Wang Haiyong wrote: I am doing a DLL project, it is in the backend/utils/mb. But it can not be maked under

Re: [HACKERS] Help! DLL make faild under windows mingw.

,$(subdir))) override CPPFLAGS+= -DBUILDING_DLL endif endif - Original Message - From: Andrei Kovalevski [EMAIL PROTECTED] To: pgsql-hackers@postgresql.org Sent: Wednesday, May 30, 2007 1:35 AM Subject: Re: [HACKERS] Help! DLL make faild under windows mingw. Hi! What

[HACKERS] Help Required regarding implementing operators in postgreSQL

Dear Developers, Hi, I am Tasneem Memon doing MS Computer Science. I am working on my thesis these days, for which I have defined some operators theoritically as well as their algorithms, and intend to implement them in PostgreSQL. These operators(NEAR, NOT NEAR) are binary and work with

Re: [HACKERS] Help Required regarding implementing operators in postgreSQL

Tasneem Memon [EMAIL PROTECTED] writes: Hi, I am Tasneem Memon doing MS Computer Science. I am working on my thesis= these days, for which I have defined some operators theoritically as well = as their algorithms, and intend to implement them in PostgreSQL. These oper= ators(NEAR, NOT NEAR)

Re: [HACKERS] help required regarding queryin postgis database from google maps

On Feb 25, 9:34 am, [EMAIL PROTECTED] (Andrew Dunstan) wrote: Phani Kishore wrote: hi ! i think u people could probably help me i how to query the pgsql/postgis from google maps api to display the markers on the google maps which are stored in the postgis database. Phani Kishore

[HACKERS] help required regarding queryin postgis database from google maps

hi ! i think u people could probably help me i how to query the pgsql/postgis from google maps api to display the markers on the google maps which are stored in the postgis database. Phani Kishore Tata Consultancy Services Mailto: [EMAIL PROTECTED] Website: http://www.tcs.com

Re: [HACKERS] help required regarding queryin postgis database from google maps

Phani Kishore wrote: hi ! i think u people could probably help me i how to query the pgsql/postgis from google maps api to display the markers on the google maps which are stored in the postgis database. Phani Kishore Tata Consultancy Services Mailto: [EMAIL PROTECTED] Website:

[HACKERS] Help with Degree Work

Hello, I've suscribed to this mailing list for help, I will work on a Specialization Degree Thesis, this will be a PostgreSQL implementation of fsql, or fuzzy querys. http://www.lcc.uma.es/~ppgg/FSQL.html, this is a link to a webpage who made this in Oracle, but it's not inside of course,

Re: [HACKERS] Help with Degree Work

You should take a look at http://pgfoundry.org/projects/qbe, which deals with querying data by providing sample data that matches what you're looking for. On Wed, Jan 24, 2007 at 01:40:04PM -0400, Werner Echezuria wrote: Hello, I've suscribed to this mailing list for help, I will work on a

[HACKERS] Help me pack up postgresDB with my windows application.

Dear hackers,I'm working ona windows application with C# language and use npgsql to connectpostgres DB. I'm eager to learn how to make a solo setup file which included windows application and postgres DB. My develop environment is Visual Studio 2003 and Framework 1.1I don't know if there

Re: [HACKERS] Help me pack up postgresDB with my windows application.

du li wrote: Dear hackers, I'm working on a windows application with C# language and use npgsql to connect postgres DB. I'm eager to learn how to make a solo setup file which included windows application and postgres DB. My develop environment is Visual Studio 2003 and Framework 1.1

[HACKERS] help wanted (fmgr.c)

I am a little stuck of a question. In fmgr.c:1698, function InputFunctionCall at line 1718 /* Should get null result if and only if str is NULL */ if (str == NULL) { What are we testing to be NULL here? Do we expect str to changed at line 1715 ( result =

Re: [HACKERS] help wanted (fmgr.c)

At 2006-09-11 10:25:22 +0200, [EMAIL PROTECTED] wrote: What are we testing to be NULL here? Do we expect str to changed at line 1715 No. (Read the comment just above the function.) The code is like this, starting from line 1703: if (str == NULL flinfo-fn_strict) return (Datum)

Re: [HACKERS] help wanted (fmgr.c)

Thank you for your reply. I found my bug in the code which made the function behave strangely. On Mon, 2006-09-11 at 14:23 +0530, Abhijit Menon-Sen wrote: At 2006-09-11 10:25:22 +0200, [EMAIL PROTECTED] wrote: What are we testing to be NULL here? Do we expect str to changed at line

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

[EMAIL PROTECTED] (Peter Eisentraut) writes: Chris Browne wrote: In support of PG 8.2, we need to have the log trigger function do the following: - Save value of standards_conforming_string - Set value of standards_conforming_string to FALSE - proceed with saving data to sl_log_? -

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

Chris Browne [EMAIL PROTECTED] writes: Unfortunately (perhaps) standards_conforming_strings does not appear to be exported, so I'm not sure how to do this otherwise. Perhaps your problem is one of spelling? It's standard_conforming_strings, and it's certainly a global variable. You still

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

[EMAIL PROTECTED] (Tom Lane) writes: Chris Browne [EMAIL PROTECTED] writes: Unfortunately (perhaps) standards_conforming_strings does not appear to be exported, so I'm not sure how to do this otherwise. Perhaps your problem is one of spelling? It's standard_conforming_strings, and it's

[HACKERS] Help! - Slony-I - saving/setting/restoring GUC

In support of PG 8.2, we need to have the log trigger function do the following: - Save value of standards_conforming_string - Set value of standards_conforming_string to FALSE - proceed with saving data to sl_log_? - Recover value of standards_conforming_string The variable,

Re: [HACKERS] Help! - Slony-I - saving/setting/restoring GUC

Chris Browne wrote: In support of PG 8.2, we need to have the log trigger function do the following: - Save value of standards_conforming_string - Set value of standards_conforming_string to FALSE - proceed with saving data to sl_log_? - Recover value of standards_conforming_string

  1   2   3   >