[GENERAL] Cannot install postgres 9.2, less than 32 MB of memory

2013-01-19 Thread Alexander Reichstadt
Hi, I never had any problems to install postgres 9.1, now I do with 9.2. This is the enterprise installer for Mac OS X. I tried to install and am getting the dreaded error message regarding shared memory, which is not very helpful because it does not seem to actually look at the file it complai

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Rich Shepard
On Fri, 18 Jan 2013, Adrian Klaver wrote: test=> SELECT ('2012-10-29 '||'10:19')::timestamp; timestamp - 2012-10-29 10:19:00 Thanks, Adrian. I suspected it was simple but I could not find a reference to the syntax. Much appreciated, Rich -- Sent via pgsql-genera

Re: [GENERAL] Cannot install postgres 9.2, less than 32 MB of memory

2013-01-19 Thread Adrian Klaver
On 01/19/2013 05:10 AM, Alexander Reichstadt wrote: Hi, I never had any problems to install postgres 9.1, now I do with 9.2. This is the enterprise installer for Mac OS X. I tried to install and am getting the dreaded error message regarding shared memory, which is not very helpful because it

Re: [GENERAL] Cannot install postgres 9.2, less than 32 MB of memory

2013-01-19 Thread Raghavendra
On Sat, Jan 19, 2013 at 6:40 PM, Alexander Reichstadt wrote: > Hi, > > I never had any problems to install postgres 9.1, now I do with 9.2. This > is the enterprise installer for Mac OS X. I tried to install and am getting > the dreaded error message regarding shared memory, which is not very > h

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Kevin Grittner
Rich Shepard wrote: > On Fri, 18 Jan 2013, Adrian Klaver wrote: > >> test=> SELECT ('2012-10-29 '||'10:19')::timestamp; >> timestamp >> - >> 2012-10-29 10:19:00 > >  Thanks, Adrian. I suspected it was simple but I could not find a reference > to the syntax. Of course, since y

Re: [GENERAL] Cannot install postgres 9.2, less than 32 MB of memory

2013-01-19 Thread Tom Lane
Alexander Reichstadt writes: > I never had any problems to install postgres 9.1, now I do with 9.2. This is > the enterprise installer for Mac OS X. I tried to install and am getting the > dreaded error message regarding shared memory, which is not very helpful > because it does not seem to act

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Gavin Flower
On 20/01/13 04:40, Kevin Grittner wrote: Rich Shepard wrote: On Fri, 18 Jan 2013, Adrian Klaver wrote: test=> SELECT ('2012-10-29 '||'10:19')::timestamp; timestamp - 2012-10-29 10:19:00 Thanks, Adrian. I suspected it was simple but I could not find a reference to the syn

Re: [GENERAL] Libpq and multithreading

2013-01-19 Thread Ashesh Vashi
A back-trace would definitely be helpful to analyze the issue. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Fri, Jan 18, 2013 at 7:35 PM, A