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

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 into

[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.html&sid=368 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

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 > > "do-it-the-right-way,-n

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 rea

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 (t

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

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 t

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 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 PROT

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 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 do

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 > > "do-it-the-right-way,

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 exper

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 t

[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] 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

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'

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 "pu

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 =

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 composit

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 > colu

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 me

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 commu

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 y

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 le

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 us