Re: [GENERAL] Foreign keys and permissions oddity

2010-08-07 Thread Richard Huxton
On 07/08/10 01:13, Joshua Tolley wrote: Is there some justification for this behavior that I should know already? It seemed awfully strange when some folkds here stumbled on it: [snip] The key point seems to be that the owner of the referenced table has no permissions on the table, although the

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread Alban Hertroys
On 7 Aug 2010, at 5:19, Sandeep Srinivasa wrote: > +1 on this. > This is very interesting from the point-of-view of transitioning MySQL > webapps to Postgres. The truth is that for a lot of people, MySQL is their > first DB (because of loads of pre-existing software. Refer to my thread > "Which

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread சிவகுமார் மா
2010/8/7 Alban Hertroys : > On 7 Aug 2010, at 5:19, Sandeep Srinivasa wrote: > >> +1 on this. >> This is very interesting from the point-of-view of transitioning MySQL >> webapps to Postgres. The truth is that for a lot of people, MySQL is their >> first DB (because of loads of pre-existing softw

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread David Boreham
On 8/7/2010 4:24 AM, சிவகுமார் மா wrote: 4. A pet name Is it possible to have a pet name which can be used in casual conversation easily? PG -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread Raymond O'Donnell
On 07/08/2010 11:24, சிவகுமார் மா wrote: 2010/8/7 Alban Hertroys: On 7 Aug 2010, at 5:19, Sandeep Srinivasa wrote: +1 on this. This is very interesting from the point-of-view of transitioning MySQL webapps to Postgres. The truth is that for a lot of people, MySQL is their first DB (because of

Re: [GENERAL] Foreign keys and permissions oddity

2010-08-07 Thread Joshua Tolley
On Sat, Aug 07, 2010 at 08:34:12AM +0100, Richard Huxton wrote: > On 07/08/10 01:13, Joshua Tolley wrote: >> Is there some justification for this behavior that I should know already? It >> seemed awfully strange when some folkds here stumbled on it: > [snip] >> The key point seems to be that the ow

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread Martin Gainty
Ray-- I would like to see in postgres: 1)Clustering 2)a more user-friendly interface to packages 3)eliminate the requirement to create a postgres user to execute the server binaries..I guess i never understood that requirement I would like to see in MySQL: A progression back to OpenSourc

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread Amitabh Kant
2010/8/7 சிவகுமார் மா > 3. The default configuration settings for PostgreSQL are not optimal > for performance. Can there be a recommended configuration file in the > installation (assuming certain amount of RAM and processor type) ? > > Ma Sivakumar > http://masivakumar.blogspot.com > > pgtune

Re: [GENERAL] MySQL versus Postgres

2010-08-07 Thread Pavel Stehule
Hello 2010/8/7 Martin Gainty : > Ray-- > > I would like to see in postgres: > 1)Clustering > 2)a more user-friendly interface to packages > 3)eliminate the requirement to create a postgres user to execute the server > binaries..I guess i never understood that requirement > it is simply - securi

[GENERAL] 2010 International Conference on Progress in Informatics and Computing(PIC-2010 )

2010-08-07 Thread PIC2010
Remind: PIC-2010 last Call for Papers - few days left-deadline August 10th! Please subimit your papers before August 10th. - 2010 International Conference on Progress in Informatics and Computing(PIC-2010 ) Impor

[GENERAL] Using AND in query

2010-08-07 Thread aravind chandu
Hello every one, I have encountered a problem while working .I have a sample table with the following data TID Date Item T100 8/1/2010 Laptop T100 8/1/2010 Desktop T101 8/1/2010 Laptop T102 8/1/2010 Desktop T103 8/2/2010 Laptop T103 8/2/2010 Desktop T104 8/2/2010 Laptop   need the data

Re: [GENERAL] Using AND in query

2010-08-07 Thread Raymond O'Donnell
On 07/08/2010 20:40, aravind chandu wrote: condition in where clause : table.date in date() to date() and table.item = "laptop" and table.item = "Desktop" I don't think this is correct - you need "BETWEEN". Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general

Re: [GENERAL] Using AND in query

2010-08-07 Thread Thomas Kellerer
aravind chandu wrote on 07.08.2010 21:40: Hello every one, I have encountered a problem while working .I have a sample table with the following data *TID* *Date* *Item* T1008/1/2010Laptop T1008/1/2010Desktop T1018/1/2010Laptop T1028/1/2010Desktop

Re: [GENERAL] Using AND in query

2010-08-07 Thread David Fetter
On Sat, Aug 07, 2010 at 12:40:41PM -0700, aravind chandu wrote: > Hello every one, > > I have encountered a problem while working .I have a sample table with the > following data > > > TID Date Item > T100 8/1/2010 Laptop > T100 8/1/2010 Desktop > T101 8/1/2010 Laptop > T102 8/1/2010 Deskt

[GENERAL] Accessing a database via AJAX scripts

2010-08-07 Thread Glen Eustace
I am not sure where my issue lies - apache, perl or postgresql, but as they say, one has to start somewhere. My goal is to have a perl cgi script (that is accessed using AJAX) perform some operations in a database using DBI. Some of the actions are likely to take a while so my intent was to h

[GENERAL] Howto only select secific lines from a result?

2010-08-07 Thread Clemens Eisserer
Hi, I am working on a graphical table display widget which should be able to display huge amounts of data, by lazy-loading database values. It already works well if the primary-key and line-number are equal. However I don't have any idea howto handle the case where the primary-key contains holes,

Re: [GENERAL] Howto only select secific lines from a result?

2010-08-07 Thread Thom Brown
On 8 August 2010 02:37, Clemens Eisserer wrote: > Hi, > > I am working on a graphical table display widget which should be able > to display huge amounts of data, by lazy-loading database values. It > already works well if the primary-key and line-number are equal. > However I don't have any idea