Re: [GENERAL] Still no way to install PostGres on os x Lion?

2012-08-13 Thread rickcasey
On Saturday, August 27, 2011 4:26:59 PM UTC-6, Darren Duncan wrote: > Kenneth McDonald wrote: > > Unfortunately, "initdb" has not been installed into a directory on the shell > > search path, and I can't find it by inspecting other likely places. I do > > like > > OS X, but sometimes its unique ap

[GENERAL] Regarding pc-lint on PostgreSQL code

2012-08-13 Thread Rajeev rastogi
Dear Sir, We are in process of evaluating the PostgreSQL static report. So wanted to know if there is any available result for pc-lint on latest source code of PostgreSQL (preferably on 9.2 Beta 3). Thanks and Regards, Kumar Rajeev Rastogi Cell No - +91 8971367787

[GENERAL] Retrieving the start and end hour queries correctly

2012-08-13 Thread dud
I have a CTE-based query in which I retrieve hourly intervals between two given timespans. My query works as following: Getting start and end datetimes (let's say 07-13-2011 00:21:09 and 07-31-2011 21:11:21) get the hourly total query values between the hourly intervals (in here it's from 00 to 21

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread Carey Tilden
On Mon, Aug 13, 2012 at 7:05 PM, David Johnston wrote: > On Aug 13, 2012, at 21:22, Carey Tilden wrote: > > On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote: > >> On Aug 13, 2012, at 20:28, Carey Tilden wrote: >> >> > Apologies for the awkward title. I haven't quite thought of the right

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread David Johnston
On Aug 13, 2012, at 21:22, Carey Tilden wrote: > > > On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote: > On Aug 13, 2012, at 20:28, Carey Tilden wrote: > > > Apologies for the awkward title. I haven't quite thought of the right way > > to describe my problem, which may be why I've had

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread Carey Tilden
On Mon, Aug 13, 2012 at 6:01 PM, David Johnston wrote: > On Aug 13, 2012, at 20:28, Carey Tilden wrote: > > > Apologies for the awkward title. I haven't quite thought of the right > way to describe my problem, which may be why I've had a hard time figuring > out how to solve it. I have a list

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread David Johnston
On Aug 13, 2012, at 20:28, Carey Tilden wrote: > Apologies for the awkward title. I haven't quite thought of the right way to > describe my problem, which may be why I've had a hard time figuring out how > to solve it. I have a list of program start/stop times, and I want to know > how long

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread Carey Tilden
On Mon, Aug 13, 2012 at 5:53 PM, Andrew Sullivan wrote: > On Mon, Aug 13, 2012 at 05:28:24PM -0700, Carey Tilden wrote: > > > how to solve it. I have a list of program start/stop times, and I want > to > > know how long each run takes to complete. The thing that's really > tripping > > me up is

Re: [GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread Andrew Sullivan
On Mon, Aug 13, 2012 at 05:28:24PM -0700, Carey Tilden wrote: > how to solve it. I have a list of program start/stop times, and I want to > know how long each run takes to complete. The thing that's really tripping > me up is there are gaps in the sequence. I've figured out how to collapse > th

[GENERAL] Summing activity intervals without any obvious column to group by

2012-08-13 Thread Carey Tilden
Apologies for the awkward title. I haven't quite thought of the right way to describe my problem, which may be why I've had a hard time figuring out how to solve it. I have a list of program start/stop times, and I want to know how long each run takes to complete. The thing that's really trippin

[GENERAL] Automatic checkpoints not running on streaming slave

2012-08-13 Thread Mike Roest
Hey Everyone, With my investigations into our streaming slave having a continuously growing pg_xlog directory ( http://archives.postgresql.org/pgsql-general/2012-08/msg00124.php) I think I've hit upon what's going on. Using pg_controldata I've found that our streaming slave hasn't run a check

Re: [GENERAL] json support for composites in upcoming 9.2

2012-08-13 Thread jan zimmek
big thanks, this is exactly what i was looking for. jan Am 13.08.2012 um 17:58 schrieb Merlin Moncure : > On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote: >> hi, >> >> i am looking into json support of the upcoming 9.2 release and have a >> question about the row_to_json function. is there

Re: [GENERAL] json support for composites in upcoming 9.2

2012-08-13 Thread Merlin Moncure
On Sat, Aug 11, 2012 at 7:05 AM, jan zimmek wrote: > hi, > > i am looking into json support of the upcoming 9.2 release and have a > question about the row_to_json function. is there a way to specify the column > aliases of a nested composite row without creating a custom type ? > > here is an e

Re: [GENERAL] Migrating Postgresql 8.0 to 8.3

2012-08-13 Thread Craig Ringer
On 08/13/2012 08:40 PM, quickinfo wrote: Hello Friends, I would like to migrate postgresql 8.0 to 8.3. Please suggest me the best way of restoring my backup. If at all possible, use the 8.3 version of pg_dump to make a new backup from your 8.0 server, rather than trying to restore a dump fro

Re: [GENERAL] Migrating Postgresql 8.0 to 8.3

2012-08-13 Thread Albe Laurenz
quickinfo wrote: > I would like to migrate postgresql 8.0 to 8.3. Please suggest me the best way of restoring my backup. > > In which format should I take the backup and how should I restore the data. Does it require to write > any sql script. will it create any problems in migrating 8.0 to 8.3. F

[GENERAL] postgresql.org.br site and email offline

2012-08-13 Thread Leonardo Carneiro
Hi everyone, Is there any admin here of the brazillian postgresql site and mailing list? Already have some days that is offline. Any news? tks in advance.

[GENERAL] Migrating Postgresql 8.0 to 8.3

2012-08-13 Thread quickinfo
Hello Friends, I would like to migrate postgresql 8.0 to 8.3. Please suggest me the best way of restoring my backup. In which format should I take the backup and how should I restore the data. Does it require to write any sql script. will it create any problems in migrating 8.0 to 8.3. Looking f

Re: [GENERAL] Expression alias not recognized in WHERE clause (ERROR: relation "p" does not exist)

2012-08-13 Thread Alban Hertroys
On 13 Aug 2012, at 1:15, Stefan Keller wrote: > 2012/8/9 Alban Hertroys wrote: >> You're referencing "p" as a table, not as a table-alias, because you >> select FROM p. > > That's true but sorry that I can see any difference between > referencing a table or a table alias. I don't think SQL allo