[GENERAL] Database takes up MUCH more disk space than it should

2012-01-21 Thread Dan Charrois
Hi everyone. I'm currently in the situation of administering a rather large PostgreSQL database which for some reason seems to be even much larger than it should be. I'm currently running version 8.4.5 - not the latest and greatest, I know - but this is a live database that would problematic t

Re: [GENERAL] PGbouncer for Windows 2008

2012-01-21 Thread tuanhoanganh
http://winpg.jp/~saito/pgbouncer/ On Fri, Jan 20, 2012 at 11:01 PM, Edison So wrote: > Hello, > > Can anyone please tell me where I can find the PGbouncer executable and > tutorial for Windows 2008? I found one but need to recompile on Windows. I > also need intuitive instructions to configure i

[GENERAL] grouping of query data in xml

2012-01-21 Thread c k
Hi friends, I am working with some xml exporting functionality of our application. I am testing query_to_xml function supported in PostgreSQL 9.1. XML output should be 1 COMPANY ACCOUNT 638168 1. 0. 638168 0. 1. but the output is as follows: a

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of c k Sent: Saturday, January 21, 2012 10:23 AM To: pgsql-admin; pgsql-general@postgresql.org Subject: [GENERAL] grouping of query data in xml Hi friends, I am working with some xml exporting funct

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread c k
Sorry for double list posting. The query is follows. I have included a where clause to limit the rows. select query_to_xml($$select 'acc group' as accgroup, accgroups.accgroupid, accgroups.accgroupname, 'docs' as doc, act.refaccdocid, sum(act.debit) as d, sum(act.credit) as c from accgroups inner

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread Pavel Stehule
Hello there are others SQL/XML functions - with this function, you can create xml like you need http://www.postgresql.org/docs/9.1/static/functions-xml.html Regards Pavel Stehule 2012/1/21 c k : > Hi friends, > > I am working with some xml exporting functionality of our application. I am > te

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread c k
I have written a query as follows select xmlelement(name accgroup, xmlforest(accgroupid, accgroupname, xmlforest(refaccdocid,d, c) as doc))::xml AS xmldata from (select 'acc group' as accgroup, accgroups.accgroupid, accgroups.accgroupname, 'docs' as doc, act.refaccdocid, sum(act.debit) as d, sum

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread Pavel Stehule
2012/1/21 c k : > I have written a query as follows > > select xmlelement(name accgroup, xmlforest(accgroupid, accgroupname, > xmlforest(refaccdocid,d, c) as doc))::xml AS xmldata >  from (select 'acc group' as accgroup, accgroups.accgroupid, > accgroups.accgroupname,  'docs' as doc, act.refaccdoci

Re: [GENERAL] grouping of query data in xml

2012-01-21 Thread c k
It was not intentionally made, but was remaining due to copy-paste from other queries. It is only one occurrence of unnecessary casting. I got the idea about such a query from an oracle pl/sql book. C P Kulkarni On Sat, Jan 21, 2012 at 11:03 PM, Pavel Stehule wrote: > 2012/1/21 c k : > > I have

[GENERAL] log_statement variable does not admit all value

2012-01-21 Thread Jose Carlos Martinez Llario
Hi List, This variable admit according to docs: mod, ddl, all values. the all value is not accepted. I have postgres 9.1. s1=# set log_statement = all; ERROR: syntax error at or near "all" LINE 1: set log_statement = all; cheers, Jose -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Database takes up MUCH more disk space than it should

2012-01-21 Thread Adrian Klaver
On Saturday, January 21, 2012 12:37:17 am Dan Charrois wrote: > Hi everyone. I'm currently in the situation of administering a rather > large PostgreSQL database which for some reason seems to be even much > larger than it should be. > > I'm currently running version 8.4.5 - not the latest and gr

Re: [GENERAL] log_statement variable does not admit all value

2012-01-21 Thread Adrian Klaver
On Saturday, January 21, 2012 1:11:32 pm Jose Carlos Martinez Llario wrote: > Hi List, > > This variable admit according to docs: mod, ddl, all values. the all > value is not accepted. > I have postgres 9.1. > > s1=# set log_statement = all; set log_statement = 'all'; > ERROR: syntax error at

Re: [GENERAL] log_statement variable does not admit all value

2012-01-21 Thread Szymon Guz
On 21 January 2012 22:11, Jose Carlos Martinez Llario wrote: > Hi List, > > This variable admit according to docs: mod, ddl, all values. the all value > is not accepted. > I have postgres 9.1. > > s1=# set log_statement = all; > ERROR: syntax error at or near "all" > LINE 1: set log_statement = a

Re: [GENERAL] Database takes up MUCH more disk space than it should

2012-01-21 Thread Scott Marlowe
On Sat, Jan 21, 2012 at 1:37 AM, Dan Charrois wrote: > Hi everyone.  I'm currently in the situation of administering a rather large > PostgreSQL database which for some reason seems to be even much larger than > it should be. > > I'm currently running version 8.4.5 - not the latest and greatest,

Re: [GENERAL] Does Stackbuilder need username/pwd for the proxy?

2012-01-21 Thread Sachin Srivastava
On Jan 20, 2012, at 6:56 PM, maripa...@tiscali.it wrote: > I am a new user, and, as some people already highlighted before me, > after having installed Postgres 9.1, the stackbuider is not able to > connect to the URL www.postgresql.org/applications-v2.xml. I can reach > that page by the brows