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

2017-10-24 Thread Gaddam Sai Ram
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

2017-10-12 Thread Robert Haas
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 really bad. It will corrupt your

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

2017-10-10 Thread Petr Jelinek
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. >> >> - https://github.com/reorg/pg_repack/issues/135 >> - https://github.com/

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

2017-10-08 Thread Craig Ringer
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 > - https://github.com/2ndQuadrant/pglogical/issues/113 Yeah, I was going

[HACKERS] Help required to debug pg_repack breaking logical replication

2017-10-07 Thread Daniele Varrazzo
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 any

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

2017-02-28 Thread 钱新林
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

2017-02-27 Thread Tom Lane
=?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 a remarkable lot of bu

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

2017-02-27 Thread 钱新林
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); long

Re: [HACKERS] Help text for pg_basebackup -R

2017-02-18 Thread Magnus Hagander
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 > >>> translations, right? So we should make it head onl

Re: [HACKERS] Help text for pg_basebackup -R

2017-02-17 Thread Tom Lane
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 times. My stand is t

Re: [HACKERS] Help text for pg_basebackup -R

2017-02-17 Thread Stephen Frost
* 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" > > > > - " write r

Re: [HACKERS] Help text for pg_basebackup -R

2017-02-17 Thread Alvaro Herrera
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

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

Re: [HACKERS] Help text for pg_basebackup -R

2017-02-15 Thread Alvaro Herrera
Magnus Hagander wrote: > printf(_(" -R, --write-recovery-conf\n" > - " write recovery.conf after > backup\n")); > + " write recovery.conf for > replication\n")); > printf(_(" -S, --slot=SLOTNA

[HACKERS] Help text for pg_basebackup -R

2017-02-15 Thread Magnus Hagander
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 abo

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

2016-03-28 Thread Peter Krauss
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 `/usr/lib/postgresq

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

2015-12-08 Thread FattahRozzaq
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 Tue, Dec 8, 2015 at 3:33 AM, Fat

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

2015-12-08 Thread David G. Johnston
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 Debian Wheezy, the same h

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

2015-12-08 Thread David G. Johnston
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: 800GB SAS (for OS, logs

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

2015-12-08 Thread Michael Paquier
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 folder. > > I want to l

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

2015-12-08 Thread FattahRozzaq
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 directory

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

2015-12-01 Thread Rodrigo Hjort
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 src/backend/utils/adt/int.c

Re: [HACKERS] Help needed for PL/Ruby

2015-05-01 Thread Szymon Guz
On 29 April 2015 at 21:45, Szymon Guz wrote: > Hi Devrim, > I will take a look at this. > > regards, > Szymon > > On 29 April 2015 at 18:24, Devrim Gündüz wrote: > >> >> Hi, >> >> Anyone? :) >> >> Regards, Devrim >> >> On Wed, 2015-03-18 at 15:19 +0200, Devrim Gündüz wrote: >> > Hi, >> > >> > Ba

Re: [HACKERS] Help needed for PL/Ruby

2015-04-29 Thread Szymon Guz
Hi Devrim, I will take a look at this. regards, Szymon On 29 April 2015 at 18:24, Devrim Gündüz wrote: > > 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, >

Re: [HACKERS] Help needed for PL/Ruby

2015-04-29 Thread Devrim Gündüz
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

2015-03-18 Thread Devrim Gündüz
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, a

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

2015-02-13 Thread Robert Haas
On Thu, Feb 12, 2015 at 3:27 AM, hailong Li 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 what might have gone wr

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

2015-02-12 Thread hailong Li
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

2014-09-22 Thread Alvaro Herrera
Michael Paquier wrote: > On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer 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 proje

Re: [HACKERS] Help to startup

2014-09-21 Thread Michael Paquier
On Sun, Sep 21, 2014 at 4:52 PM, Craig Ringer 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 asking on pg

Re: [HACKERS] Help to startup

2014-09-21 Thread Craig Ringer
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

Re: [HACKERS] Help to startup

2014-09-20 Thread Andrew Dunstan
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 to startup

2014-09-20 Thread Tapan Halani
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] Is it possible to support remote COPY operation on PG?

2012-10-24 Thread Michael Paquier
On Wed, Oct 24, 2012 at 3:54 PM, Xiong He 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 Paquier h

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

2012-10-23 Thread Dann Corbit
: 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

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

2012-10-23 Thread Xiong He
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? --- Thanks&Regards, Xiong He

Re: [HACKERS] Help me develop new commit_delay advice

2012-08-02 Thread Peter Geoghegan
On 29 July 2012 16:39, Peter Geoghegan 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 this to the pgsql-

Re: [HACKERS] Help me develop new commit_delay advice

2012-08-02 Thread Josh Berkus
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 -- Sen

Re: [HACKERS] Help me develop new commit_delay advice

2012-08-02 Thread Amit Kapila
> From: Peter Geoghegan [mailto:pe...@2ndquadrant.com] > Sent: Wednesday, August 01, 2012 8:49 PM On 1 August 2012 15:14, Amit Kapila 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

Re: [HACKERS] Help me develop new commit_delay advice

2012-08-01 Thread Peter Geoghegan
On 1 August 2012 15:14, Amit Kapila 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 widely useful setting

Re: [HACKERS] Help me develop new commit_delay advice

2012-08-01 Thread Amit Kapila
> 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

[HACKERS] Help me develop new commit_delay advice

2012-07-31 Thread Peter Geoghegan
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: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=f11e8be3e812cdbbc139c1

[HACKERS] Help with pg_locks query

2011-09-05 Thread Bruce Momjian
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 'SELECT

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

2011-09-02 Thread PostgreSQL - Hans-Jürgen Schönig
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 a

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

2011-09-02 Thread Hannu Krosing
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 comman

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

2011-09-02 Thread PostgreSQL - Hans-Jürgen Schönig
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 … s

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

2011-09-02 Thread Hannu Krosing
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

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

2011-09-02 Thread PostgreSQL - Hans-Jürgen Schönig
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 sa

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

2011-09-01 Thread Hannu Krosing
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 table(s

Re: [HACKERS] help with sending email

2011-07-14 Thread Robert Haas
On Jul 13, 2011, at 12:29 PM, "Fernando Acosta Torrelly" 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? > > Thanks in adv

[HACKERS] help with sending email

2011-07-14 Thread Fernando Acosta Torrelly
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 - Pe

Re: [HACKERS] Help required regarding patch development

2011-05-12 Thread Bruce Momjian
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 http://momjian.us EnterpriseDB

[HACKERS] Help required regarding patch development

2011-05-12 Thread nil nil
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: regarding patch development

2011-05-12 Thread Kevin Grittner
nil nil 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 linked developer FAQ bein

[HACKERS] Help: regarding patch development

2011-05-11 Thread nil nil
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

2011-04-07 Thread Peter Eisentraut
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

Re: [HACKERS] help: collation support on Windows

2011-02-25 Thread Magnus Hagander
On Fri, Feb 25, 2011 at 22:58, Dave Page wrote: > On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan 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 >>> >>> No

Re: [HACKERS] help: collation support on Windows

2011-02-25 Thread Dave Page
On Fri, Feb 25, 2011 at 9:54 PM, Andrew Dunstan 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 startin

Re: [HACKERS] help: collation support on Windows

2011-02-25 Thread Andrew Dunstan
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. Micros

[HACKERS] help: collation support on Windows

2011-02-25 Thread Peter Eisentraut
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 an

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

2010-09-28 Thread Itagaki Takahiro
On Tue, Sep 28, 2010 at 6:16 PM, Magnus Hagander 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 - we do that w

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

2010-09-28 Thread Euler Taveira de Oliveira
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++

2010-09-28 Thread Magnus Hagander
On Tue, Sep 28, 2010 at 09:26, Itagaki Takahiro wrote: > On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane 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 t

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

2010-09-28 Thread Craig Ringer
On 28/09/10 11:09, Itagaki Takahiro wrote: > On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas 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.

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

2010-09-28 Thread Itagaki Takahiro
On Tue, Sep 28, 2010 at 3:53 PM, Tom Lane 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 of uglifica

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

2010-09-27 Thread Tom Lane
Itagaki Takahiro writes: > On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas 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 mentioned, we don't need the marks in our build

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

2010-09-27 Thread Robert Haas
On Mon, Sep 27, 2010 at 11:26 PM, Itagaki Takahiro wrote: > On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas 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

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

2010-09-27 Thread Itagaki Takahiro
On Tue, Sep 28, 2010 at 12:12 PM, Robert Haas 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 didn't otherwis

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

2010-09-27 Thread Robert Haas
On Mon, Sep 27, 2010 at 11:09 PM, Itagaki Takahiro wrote: > On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas 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 confus

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

2010-09-27 Thread Itagaki Takahiro
On Tue, Sep 28, 2010 at 9:51 AM, Robert Haas 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 few times lately

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

2010-09-27 Thread Robert Haas
On Mon, Sep 27, 2010 at 8:45 PM, Itagaki Takahiro wrote: > On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira > 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

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

2010-09-27 Thread Itagaki Takahiro
On Tue, Sep 28, 2010 at 5:13 AM, Euler Taveira de Oliveira 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? Since we have P

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

2010-09-27 Thread Euler Taveira de Oliveira
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 ma

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

2010-09-25 Thread Itagaki Takahiro
On Sun, Sep 26, 2010 at 12:56 AM, Esteban Zimanyi 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 how can I solve the pr

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

2010-09-25 Thread Esteban Zimanyi
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 ser

[HACKERS] Help with Join Performance Testing

2009-01-21 Thread Lawrence, Ramon
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.

2008-10-31 Thread Somasekhar Ramadurgam
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 i

Re: [HACKERS] HELP

2008-03-26 Thread Gurjeet Singh
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, whi

[HACKERS] HELP

2008-03-26 Thread Pedro Belmino
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 with release note items

2007-12-01 Thread Tom Lane
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

2007-11-27 Thread Bruce Momjian
I need help understanding the following two release note items (see XXX): Create a general mechanism that supports casts to and from the standard string types (TEXT, VARCHAR, CHAR) for every datatype, by invoking the datatype's I/O functions (Tom) XXX exam

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

2007-05-29 Thread Wang Haiyong
,$(subdir))) override CPPFLAGS+= -DBUILDING_DLL endif endif - Original Message - From: "Andrei Kovalevski" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 30, 2007 1:35 AM Subject: Re: [HACKERS] Help! DLL make faild under windows mingw. > Hi! >

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

2007-05-29 Thread Andrei Kovalevski
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 wi

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

2007-05-29 Thread Wang Haiyong
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

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

2007-05-24 Thread Tom Lane
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 NE

[HACKERS] Help Required regarding implementing operators in postgreSQL

2007-05-24 Thread Tasneem Memon
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 NUMBER

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

2007-02-26 Thread Andrew Hammond
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 K

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

2007-02-25 Thread Andrew Dunstan
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: http://www.

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

2007-02-25 Thread Phani Kishore
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 with Degree Work

2007-01-24 Thread Jim C. Nasby
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 with Degree Work

2007-01-24 Thread Werner Echezuria
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, becaus

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

2006-11-14 Thread Shane Ambler
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 I

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

2006-11-14 Thread du li
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   I don't know if ther

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

2006-09-11 Thread Gevik Babakhani
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 l

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

2006-09-11 Thread Abhijit Menon-Sen
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 (Da

[HACKERS] help wanted (fmgr.c)

2006-09-11 Thread Gevik Babakhani
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 = FunctionCallInvoke(&fcinf

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

2006-07-25 Thread Chris Browne
[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", an

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

2006-07-25 Thread Tom Lane
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

2006-07-25 Thread Chris Browne
[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_l

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

2006-07-24 Thread Tom Lane
Chris Browne <[EMAIL PROTECTED]> writes: > 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 This is a good idea why exactly? What are you even expecting it to

  1   2   3   >