Re: [GENERAL] Query planner question

2014-08-23 Thread Jeff Janes
On Wednesday, August 20, 2014, Soni M diptat...@gmail.com wrote: Hi Everyone, I have this query : select t.ticket_id , tb.transmission_id from ticket t, transmission_base tb where t.latest_transmission_id = tb.transmission_id and t.ticket_number = tb.ticket_number and tb.parse_date

Re: [GENERAL] Query planner question

2014-08-23 Thread Alban Hertroys
On 23 Aug 2014, at 4:34, Soni M diptat...@gmail.com wrote: On Fri, Aug 22, 2014 at 9:10 PM, Alban Hertroys haram...@gmail.com wrote: On 22 August 2014 14:26, Soni M diptat...@gmail.com wrote: Currently we have only latest_transmission_id as FK, described here : TABLE ticket CONSTRAINT

[GENERAL] AIX GCC

2014-08-23 Thread Anderson Valadares
Hello, we have a client with AIX version 7.1 what is using PostgreSQL 9.3.5 compiled with GCC 4.6.4 wonder if it's appropriate or would you rather use the XLC to obtain a better performance? Regards Anderson

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
How would that be done on a Mac? On Fri, Aug 22, 2014 at 5:51 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/22/2014 04:34 PM, Brodie S wrote: I have installed with the default data directory with success. Sadly, thats not an option for me Hmmm, so the installer is basically

[GENERAL] How to insert either a value or the column default?

2014-08-23 Thread W. Matthew Wilson
I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' ); In python, I have a function like this: def insert_task(title, status=None): and when status

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Adrian Klaver
On 08/23/2014 11:09 AM, Brodie S wrote: How would that be done on a Mac? Well that was stupid of me, forgetting you where using the Mac installer. Not sure how to do that on Mac or if it is even possible. Best I can do is point you here:

Re: [GENERAL] How to insert either a value or the column default?

2014-08-23 Thread John McKown
Would you mind a non-python solution? I think the following will work for you. It uses an INSERT trigger on the table tasks. The only minus is keeping the default value in both the table definition and the trigger. Of course, it is not really needed in the definition of the row value in the table

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
I'm using Unraid and SMB On Fri, Aug 22, 2014 at 5:07 PM, John R Pierce pie...@hogranch.com wrote: On 8/19/2014 11:03 AM, Brodie S wrote: I am installing the Data directory on a NAS server. what NAS file sharing protocol? (choices include SMB/CIFS, AFP, NFS, and probably others).

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread John R Pierce
On 8/23/2014 4:07 PM, Brodie S wrote: I'm using Unraid and SMB does the NAS box and your server support ISCSI so you can use your OS's native file system? that's a much better choice. -- john r pierce 37N 122W somewhere on the middle of the left

Re: [GENERAL] ERROR: Problem running post install step

2014-08-23 Thread Brodie S
As far as I can tell, It does not On Sat, Aug 23, 2014 at 5:15 PM, John R Pierce pie...@hogranch.com wrote: On 8/23/2014 4:07 PM, Brodie S wrote: I'm using Unraid and SMB does the NAS box and your server support ISCSI so you can use your OS's native file system? that's a much better