Re: [GENERAL] Horizontal aggregation?

2012-04-14 Thread hamann . w
>> >> >> >> Hi, >> >> >> >> I am looking for a feature that would select from a table with >> >> >> >> If such an operator exists, would there be a "remove duplicates" option? >> >> >> >> Regards >> >> Wolfgang Hamann >> >> >> > >> > select k, array_agg(distinct val ) from t; >> > >> > See the do

Re: [GENERAL] Any information about the PostgreSQL Certified Engineer program?

2012-04-14 Thread Albretch Mueller
well, I have kept searching for it and found a somewhat funny message from the sraoss.co.jp guys [GENERAL] LPI-Japan to start PostgreSQL certfication and a long thread [GENERAL] PostgreSQL Certification which tellingly was quickly hijacked into other topics on pearsonvue.com/sra/ it says

Re: [GENERAL] Updating pg_attribute to change field's data type from integer to bigint on very large table

2012-04-14 Thread Alban Hertroys
On 13 Apr 2012, at 18:43, Jeff Adams wrote: > Thanks for the ideas Steve. I am actually working with a partitioned table > and the field I am modifying is the id field (I have reached the cap on the > integer data type and need to modify it to bigint - very poor planning on my > part!), but no

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread Clodoaldo Neto
Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu: > I had pgbouncer working somehow, but we have switched servers recently > and now I cannot for the life of me figure out again how to set it up. > > Online guides say things like "create a user ID". Well, where? Inside > PG the database? Or i

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread raghu ram
On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto < clodoaldo.pinto.n...@gmail.com> wrote: > Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu: > >> I had pgbouncer working somehow, but we have switched servers recently >> and now I cannot for the life of me figure out again how to set it up. >>

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread Clodoaldo Neto
Em 14 de abril de 2012 09:39, raghu ram escreveu: > > > On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto < > clodoaldo.pinto.n...@gmail.com> wrote: > >> Em 12 de abril de 2012 14:12, Phoenix Kiula >> escreveu: >> >>> I had pgbouncer working somehow, but we have switched servers recently >>> and n

Re: [GENERAL] [Pgbouncer-general] PGBouncer help (how to get it working)

2012-04-14 Thread raghu ram
On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto < clodoaldo.pinto.n...@gmail.com> wrote: > Em 14 de abril de 2012 09:39, raghu ram escreveu: > >> >> >> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto < >> clodoaldo.pinto.n...@gmail.com> wrote: >> >>> Em 12 de abril de 2012 14:12, Phoenix Kiula >>

Re: [GENERAL] Any information about the PostgreSQL Certified Engineer program?

2012-04-14 Thread Ray Stell
On Sat, Apr 14, 2012 at 09:01:10AM +, Albretch Mueller wrote: > > I wonder if anyone has ever gotten PostgreSQL Certified https://www.google.com/search?q=postgresql+certification&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a -- Sent via pgsql-general mailing list (

Re: [GENERAL] efficient trigger function selection?

2012-04-14 Thread Jasen Betts
On 2012-04-11, Kenneth Tilton wrote: > We are simulating a graph DB in Postgres and would have one RDF-like table > with columns as described above. If we want a trigger on what is > conventionally a column for "color", with pseudo-RDF we would have: > >create trigger ... when predicate = 'co

[GENERAL] Re: Updating pg_attribute to change field's data type from integer to bigint on very large table

2012-04-14 Thread Jasen Betts
On 2012-04-13, Jeff Adams wrote: > --e89a8ff1c1e8d37deb04bd922a84 > Content-Type: text/plain; charset=ISO-8859-1 > > Thanks for the ideas Steve. I am actually working with a partitioned table > and the field I am modifying is the id field (I have reached the cap on the > integer data type and need

Re: [GENERAL] Writing data to a text file based on a trigger event...

2012-04-14 Thread Jasen Betts
On 2012-04-12, raghupradeep wrote: > Hi , > > I am basically a MySQL DBA and have little idea on PostgreSQL. In our > environment we have an application which is using PostgreSQL as its back > end. The application logs the status of the jobs running in it to a table in > this database i.e when a j