Re: [GENERAL] About PostgreSQL as developer

2012-11-04 Thread Craig Ringer
On 11/05/2012 12:33 PM, Scott Marlowe wrote: > On Fri, Nov 2, 2012 at 11:11 PM, Hernán Cano Martínez > wrote: >> Hi, boys. >> I am interested in the way of implement PostgreSQL in my apps --if >> possible-- in a native way. >> I am in a project that use C++ as the base programming-language. > If y

Re: [GENERAL] About PostgreSQL as developer

2012-11-04 Thread Scott Marlowe
On Fri, Nov 2, 2012 at 11:11 PM, Hernán Cano Martínez wrote: > > Hi, boys. > I am interested in the way of implement PostgreSQL in my apps --if > possible-- in a native way. > I am in a project that use C++ as the base programming-language. If you want an embedded db, you'd likely do better looki

Re: [GENERAL] About PostgreSQL as developer

2012-11-04 Thread John R Pierce
On 11/02/12 10:11 PM, Hernán Cano Martínez wrote: I am interested in the way of implement PostgreSQL in my apps --if possible-- in a native way. I am in a project that use C++ as the base programming-language. We want a guidance from you with this respect. the native API from C is libpq ...

[GENERAL] 9.1.3 AIX build issue

2012-11-04 Thread Keith Handlon
gcc -maix64 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv pg_ctl.o -L../../../src/port -lpgport -L../../../src/interfaces/libpq -lpq -L../../../src/port -Wl,-bbigtoc -Wl,-blibpath:'/users/kehand/pgsql_9.1.3/l

[GENERAL] About PostgreSQL as developer

2012-11-04 Thread Hernán Cano Martínez
Hi, boys. I am interested in the way of implement PostgreSQL in my apps --if possible-- in a native way. I am in a project that use C++ as the base programming-language. We want a guidance from you with this respect. Thanks. HERNAN CANO MARTINEZAnalista de Sistemas - programadorjhernanca...@

Re: [GENERAL] alter view foo set () -- fixed in 9.2 stable, but when will it be released?

2012-11-04 Thread Tom Lane
Chris Angelico writes: > Point of random curiosity: The commit mentioned adds the following line: > if (rinfo->reloptions && strlen(rinfo->reloptions) > 0) > Is there a reason this isn't done as: > if (rinfo->reloptions && *rinfo->reloptions) Just that the former is the general coding style in pg

Re: [GENERAL] alter view foo set () -- fixed in 9.2 stable, but when will it be released?

2012-11-04 Thread Chris Angelico
On Mon, Nov 5, 2012 at 8:48 AM, Ondrej Ivanič wrote: > On 5 November 2012 08:39, Chris Angelico wrote: >> Point of random curiosity: The commit mentioned adds the following line: >> >> if (rinfo->reloptions && strlen(rinfo->reloptions) > 0) >> >> Is there a reason this isn't done as: >> >> if (ri

[GENERAL] Recover from failed files

2012-11-04 Thread Nyamul Hassan
Hi, A small office customer of ours is in a bit of fix due to a HDD crash on their PGSQL machine. Their IT support staff on duty left around a week ago, without notice, and apparently, he was not good at keeping backups. Upon inspecting the hard drive, we were able to salvage the "data" folder,

Re: [GENERAL] alter view foo set () -- fixed in 9.2 stable, but when will it be released?

2012-11-04 Thread Ondrej Ivanič
Hi, On 5 November 2012 08:39, Chris Angelico wrote: > On Sat, Nov 3, 2012 at 9:15 AM, Joe Van Dyk wrote: > Point of random curiosity: The commit mentioned adds the following line: > > if (rinfo->reloptions && strlen(rinfo->reloptions) > 0) > > Is there a reason this isn't done as: > > if (rinfo-

Re: [GENERAL] alter view foo set () -- fixed in 9.2 stable, but when will it be released?

2012-11-04 Thread Chris Angelico
On Sat, Nov 3, 2012 at 9:15 AM, Joe Van Dyk wrote: > I'm running into this bug fixed a few days after 9.2.1 was released: > http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d2292f6405670e1fdac13998f87b4348c71fb9e6 > > Anyone know when 9.2.2 will go out? Point of random curiosity:

Re: [GENERAL] Server to run Postgresql

2012-11-04 Thread Scott Marlowe
On Sun, Nov 4, 2012 at 9:37 AM, Raymond O'Donnell wrote: > On 03/11/2012 23:08, Bob Pawley wrote: >> Hi >> >> I have an unused computer which I am considering turning into a server >> to run my Postgresql database. >> >> Is this even possible to do? > > Hi Bob, > > Of course. > >> If so, can someo

Re: [GENERAL] Server to run Postgresql

2012-11-04 Thread Raymond O'Donnell
On 03/11/2012 23:08, Bob Pawley wrote: > Hi > > I have an unused computer which I am considering turning into a server > to run my Postgresql database. > > Is this even possible to do? Hi Bob, Of course. > If so, can someone suggest an open source server that is relatively easy > to set up?

[GENERAL] C SRF question

2012-11-04 Thread Stephen Woodbridge
Hi all, I am writing a C set returning function to standardize address strings like: select * from standard_address( sql_for_lexicon, sql_for_gazeteer, sql_for_rules, sql_for_addresses); On the first call, the first 3 sql statements are executed with SPI to coll