[GENERAL] count(*) in binary mode returns 0

2016-12-04 Thread imagene...@gmail.com
I have an implementation of binary format communication that is working quite well but it is failing inexplicably on returning valid results for the aggregate function count. It returns a correct result for instance for the aggregate function max. Here is some debug information to illustrate that

[GENERAL] Use environment variables in postgresql.conf

2013-11-30 Thread imagene...@gmail.com
Is it possible to use environment variables in postgresql.conf and perhaps related configuration files? For example, I would like to use an env variable to specify the data directory.

Re: [GENERAL] Use environment variables in postgresql.conf

2013-11-30 Thread imagene...@gmail.com
dering the PGOPTIONS environment variable, I think it's initailization in a standardized way by the init scripts is the most relevant to this workflow. On Sat, Nov 30, 2013 at 8:06 PM, Andrew Sullivan wrote: > On Sat, Nov 30, 2013 at 06:54:31PM -0500, imagene...@gmail.com wrote: > > Is it p

[GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
I would like to build from source, however I would like to integrate with the scripts included in the ubuntu packages from https://wiki.postgresql.org/wiki/Apt. Where are the scripts that are used to build the various relevant packages from presumably these postgresql sources: http://www.postgresq

Re: [GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
Typo of course: $ver=9.3 $type=main ./configure --prefix=/usr/lib/postgresql/$ver/ --datarootdir=/usr/share/postgresql/$ver --sysconfdir=/etc/postgresql/$ver/$type On Mon, Dec 16, 2013 at 3:47 PM, imagene...@gmail.com wrote: > I would like to build from source, however I would like to integr

Re: [GENERAL] Scripts to build the various debian packages from postgresql source

2013-12-16 Thread imagene...@gmail.com
http://www.debian.org/doc/manuals/maint-guide/build.en.html Resolved. On Mon, Dec 16, 2013 at 3:53 PM, imagene...@gmail.com wrote: > Typo of course: > > $ver=9.3 > $type=main > ./configure --prefix=/usr/lib/postgresql/$ver/ > --datarootdir=/usr/share/postgresql/$ver &

[GENERAL] search_path reset on error (making it not reset)

2012-07-20 Thread imagene...@gmail.com
The search_path set for the connection is being reset if a query errors. Is there a setting to maintain the search_path despite errors.