Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Kevin Hunter
At 10:18a -0400 on Tue, 27 May 2008, Mark Neely wrote: The brief requires a site that has sophisticated profiling capability, particularly with respect to the ability to 'personalise' the site; that is, recognise certain user preferences, and (where possible) target content to individual user

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Joshua D. Drake
It's not directly a CRM, but the Django web framework may be of interest to you. It's was developed at World Online (Lawrence, Kansas, USA), and is exceedingly stable. http://www.djangoproject.com/ For the list: it's community is ostensibly DB agnostic, but the big wigs seem to lean

Re: [GENERAL] active queries

2008-05-27 Thread Martijn van Oosterhout
On Tue, May 27, 2008 at 11:35:49AM +0200, Miklosi Attila wrote: Hi! Our company has a long last problem by using libpq in multi-threaded programs. The libpq usually closes the programs without any error message or rarely giving the 'Invalid frontend message type 87' error. When asked you

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Kevin Hunter
At 12:58p -0400 on Tue, 27 May 2008, Joshua D. Drake wrote: It's not directly a CRM, but the Django web framework may be of interest to you. It's was developed at World Online (Lawrence, Kansas, USA), and is exceedingly stable. http://www.djangoproject.com/ For the list: it's community is

Re: [GENERAL] active queries

2008-05-27 Thread Alban Hertroys
On May 27, 2008, at 3:08 PM, Miklosi Attila wrote: Hi! Our company has a long last problem by using libpq in multi-threaded programs. The libpq usually closes the programs without any error message or rarely giving the 'Invalid frontend message type 87' error. When asked you about this error

Re: [GENERAL] Permission Problem for DELETE

2008-05-27 Thread Volkan Yazıcı
Hi, I rarely use GRANT -- nearly once every 1-2 year -- and everytime I forget this small detail: DELETE/INSERT/UPDATE privileges require SELECT privilege also. On Tue, 27 May 2008, Tom Lane [EMAIL PROTECTED] writes: You don't have SELECT privilege, which is required to read any of the columns

Re: [GENERAL] array of composite types to refcusor

2008-05-27 Thread Merlin Moncure
On Tue, May 27, 2008 at 4:48 AM, aasat [EMAIL PROTECTED] wrote: hello It is posibile to get data from array of composite types to refcursor? In oracle like this open c_refcur for select * from TABLE(array_of_composite_types); sure. AIUI, there is nothing that arrays of composites does

Re: [GENERAL] Permission Problem for DELETE

2008-05-27 Thread Tom Lane
[EMAIL PROTECTED] (Volkan =?utf-8?B?WWF6xLFjxLE=?=) writes: On Tue, 27 May 2008, Tom Lane [EMAIL PROTECTED] writes: You don't have SELECT privilege, which is required to read any of the columns in the WHERE clause. As far as I tested, even DELETE FROM foo; UPDATE foo SET bar = NULL;

Re: [GENERAL] Permission Problem for DELETE

2008-05-27 Thread Volkan Yazıcı
On Tue, 27 May 2008, Tom Lane [EMAIL PROTECTED] writes: Well, you tested wrong then. It works as expected for me, which is that you need SELECT if the query involves fetching any existing column value: Pff... Sorry for the noise. (I created example table under a differrent schema than public

Re: [GENERAL] New MS patent: sounds like PG db rules

2008-05-27 Thread Justin
KaiGai Kohei wrote: Tom Lane wrote: Right --- if in fact PG's rules infringe, then the patent is invalid because we are prior art. After scanning the claims, though, most of this is about access-rights enforcement; which is something that rules *could* be used for but it's not their

Re: [GENERAL] XML Support related questions

2008-05-27 Thread Peter Eisentraut
Brijesh Shrivastav wrote: For #4 I was looking to be able to index some or all of the tags in the xml document. Most of our applications query very few tags in a Xml document and a smaller index on few tags will help with query performance. Expression indexes on xpath are probably what you

[GENERAL] Psql crashes with Segmentation fault on copy from

2008-05-27 Thread Francisco Reyes
I am setting up a new machine and preparing some standard benchmark tests. While trying to load some data using copy from psql is crashing. OS Red Hat Enterprise Linux ES release 4 (Nahant Update 6) Postgresql 8.2.7 installed from RPMs I ran strace on psql and got: read(5, DAIRY QUEEN

Re: [GENERAL] Psql crashes with Segmentation fault on copy from

2008-05-27 Thread Tom Lane
Francisco Reyes [EMAIL PROTECTED] writes: I am setting up a new machine and preparing some standard benchmark tests. While trying to load some data using copy from psql is crashing. Can you get us a stack trace from the crash? (You'd likely need to install the postgresql-debuginfo RPM to get a

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Andrej Ricnik-Bay
On 28/05/2008, Kevin Hunter [EMAIL PROTECTED] wrote: And its python :) That's actually a bigger plus than folks may realize because all three communities (Django, Postgres, Python) share the do-it-the-right-way,-not-just-the-quickest/easiest-way mentality. (At least in my experience.)

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Joshua D. Drake
On Wed, 2008-05-28 at 10:46 +1200, Andrej Ricnik-Bay wrote: On 28/05/2008, Kevin Hunter [EMAIL PROTECTED] wrote: And its python :) That's actually a bigger plus than folks may realize because all three communities (Django, Postgres, Python) share the

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Andrej Ricnik-Bay
On 28/05/2008, Joshua D. Drake [EMAIL PROTECTED] wrote: How does Zope/Plone fit in there as an alternative in your opinion? :) Do you really want the answer to that? :P Of course! I know a few people who swear by it (and I've never had to use it ...) -- Please don't top post, and don't

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Kevin Hunter
At 6:46p -0400 on Tue, 27 May 2008, Andrej Ricnik-Bay wrote: How does Zope/Plone fit in there as an alternative in your opinion? :) Heh, I can't honestly comment on Zope/Plone as I haven't used it from a developer or admin standpoint. The OP asked for a suggestion of a CRM or something similar

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Bob Pawley
I need to ask this question. What do you mean whan you say Don't top post??? I've seen this many times before and still don't understand. Bob - Original Message - From: Andrej Ricnik-Bay [EMAIL PROTECTED] To: Joshua D. Drake [EMAIL PROTECTED] Cc: Kevin Hunter [EMAIL PROTECTED];

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Stephen Denne
What do you mean whan you say Don't top post??? http://en.wikipedia.org/wiki/Posting_style At the Datamail Group we value teamwork, respect, achievement, client focus, and courage. This email with any attachments is confidential and may be subject to legal privilege. If it is not intended

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Gregory Williamson
What do you mean whan you say Don't top post??? http://en.wikipedia.org/wiki/Posting_style In-line comments are more readable, especially for longish emails. The PosgreSQL mail lists all prefer this method. Some related lists (the postGis list for instance) have a preponderance of

Re: [GENERAL] Permission Problem for DELETE

2008-05-27 Thread Tom Lane
[EMAIL PROTECTED] (Volkan =?utf-8?B?WWF6xLFjxLE=?=) writes: On Tue, 27 May 2008, Tom Lane [EMAIL PROTECTED] writes: Well, you tested wrong then. It works as expected for me, which is that you need SELECT if the query involves fetching any existing column value: Pff... Sorry for the noise.

Re: [GENERAL] Bottom Posting

2008-05-27 Thread Andy Anderson
What do you mean whan you say Don't top post??? http://en.wikipedia.org/wiki/Posting_style On May 27, 2008, at 7:41 PM, Gregory Williamson wrote: In-line comments are more readable, especially for longish emails. The PosgreSQL mail lists all prefer this method. Some related lists (the

Re: [GENERAL] Bottom Posting

2008-05-27 Thread Tom Lane
Andy Anderson [EMAIL PROTECTED] writes: On May 27, 2008, at 7:41 PM, Gregory Williamson wrote: In-line comments are more readable, especially for longish emails. But if you do bottom-post, please *do* edit the earlier content down to just the context of your comments. Otherwise readers

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Will LaShell
On Wed, 2008-05-28 at 10:46 +1200, Andrej Ricnik-Bay wrote: On 28/05/2008, Kevin Hunter [EMAIL PROTECTED] wrote: And its python :) That's actually a bigger plus than folks may realize because all three communities (Django, Postgres, Python) share the

[GENERAL]

2008-05-27 Thread Paweł Sobański
Co Isis Gee mówi po polsku? Zobacz http://klik.wp.pl/?adr=http%3A%2F%2Fcorto.www.wp.pl%2Fas%2Fisid.htmlsid=368 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] Open Source CRM - Options?

2008-05-27 Thread Joshua D. Drake
Will LaShell wrote: Time spent with Zope/Plone: 4 weeks Result: base plone installation has a new theme. website 15% complete. Eta completion: Infinity Time spent now with Django: 1 week 2 days. Result: Website 90% complete. Eta completion: 3 days. I have no desire for this to escalate

Re: [GENERAL] Permission Problem for DELETE

2008-05-27 Thread Volkan Yazıcı
On Tue, 27 May 2008, Tom Lane [EMAIL PROTECTED] writes: I applied a docs patch for this, though not exactly what you sent in. A lot better. Thanks for your interest. Let's see if I'll ask same question next year. Regards. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)