[BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-10 Thread Tony Marston
The following bug has been logged online: Bug reference: 4465 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.4 Operating system: Windows XP Description:GROUP BY is not to SQL standard Details: The Postgresql implementation of GROUP

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-14 Thread Tony Marston
not follow the standards". As soon as I point out an SQL standard that you DON'T follow I get a barrage of weasel words and pathetic excuses. Tony Marston http://www.tonymarston.net http://www.radicore.org > -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTEC

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Tony Marston
something different? Tony Marston http://www.tonymarston.net http://www.radicore.org > -Original Message- > From: Greg Stark [mailto:[EMAIL PROTECTED] On > Behalf Of Gregory Stark > Sent: 15 October 2008 02:57 > To: Tony Marston > Cc: 'Peter Eisentraut'; pg

Re: [BUGS] BUG #4465: GROUP BY is not to SQL standard

2008-10-15 Thread Tony Marston
nctionally dependent on any other column in the GROUP BY clause. All you can do is point to paragraphs which are NOT contained in the definition of the GROUP BY clause and say "this is our get out". Now you wonder why I refer to your arguments as "weasel words". Tony Marston ht

[BUGS] BUG #2848: information_schema.key_column_usage does not work

2006-12-21 Thread Tony Marston
The following bug has been logged online: Bug reference: 2848 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:information_schema.key_column_usage does not work Details: I have the following

[BUGS] BUG #2850: Cannot select from information_schema.schemat

2006-12-21 Thread Tony Marston
The following bug has been logged online: Bug reference: 2850 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:Cannot select from information_schema.schemat Details: If I am logged on as a

[BUGS] BUG #1937: Parts of information_schema only accessible to owner

2005-10-04 Thread Tony Marston
The following bug has been logged online: Bug reference: 1937 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Description:Parts of information_schema only accessible to owner Details: I have been

[BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-08 Thread Tony Marston
The following bug has been logged online: Bug reference: 1947 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Windows XP Description:Enhancement Request - CONCAT() function Details: I would like the option to use

Re: [BUGS] BUG #1937: Parts of information_schema only accessible to owner

2005-10-08 Thread Tony Marston
> -Original Message- > From: Stephan Szabo [mailto:[EMAIL PROTECTED] > Sent: 08 October 2005 16:44 > To: Tony Marston > Subject: RE: [BUGS] BUG #1937: Parts of information_schema > only accessible to owner > > > On Sat, 8 Oct 2005, Tony Marston wrote: >

Re: [BUGS] BUG #1937: Parts of information_schema only accessible to owner

2005-10-08 Thread Tony Marston
> -Original Message- > From: Stephan Szabo [mailto:[EMAIL PROTECTED] > Sent: 08 October 2005 18:01 > To: Tony Marston > Cc: pgsql-bugs@postgresql.org > Subject: RE: [BUGS] BUG #1937: Parts of information_schema > only accessible to owner > > > > On Sa

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-08 Thread Tony Marston
> -Original Message- > From: David Fetter [mailto:[EMAIL PROTECTED] > Sent: 08 October 2005 22:16 > To: Tony Marston > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function > > > On Sat, Oct 08, 2005 at 12:

Re: [BUGS] BUG #1937: Parts of information_schema only accessible to owner

2005-10-09 Thread Tony Marston
> -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: 08 October 2005 14:09 > To: Tony Marston > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1937: Parts of information_schema > only accessible to owner > > > Plea

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-09 Thread Tony Marston
> -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 08 October 2005 22:30 > To: Jim C. Nasby > Cc: Tony Marston; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() > function > > > "Jim C

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-09 Thread Tony Marston
> -Original Message- > From: David Fetter [mailto:[EMAIL PROTECTED] > Sent: 09 October 2005 18:20 > To: Tony Marston > Cc: 'Tom Lane'; 'Jim C. Nasby'; pgsql-bugs@postgresql.org > Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

Re: [BUGS] BUG #1937: Parts of information_schema only accessible to owner

2005-10-09 Thread Tony Marston
> -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: 09 October 2005 17:42 > To: Tony Marston > Cc: pgsql-bugs@postgresql.org; 'Stephan Szabo' > Subject: Re: [BUGS] BUG #1937: Parts of information_schema > only accessible to o

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-10 Thread Tony Marston
No, but Oracle does, which is why I am trying to produce SQL statements that will run on MySQL, PostgreSQL and Oracle without the need for conversion. Tony Marston http://www.tonymarston.net > -Original Message- > From: Jim C. Nasby [mailto:[EMAIL PROTECTED] > Sent: 10 Oct

Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function

2005-10-10 Thread Tony Marston
(I found > one where there is no exception thrown for the additional > parameters; they are silently > discarded.) > > -Kevin > > P.S. A more professional and cooperative tone in any future > posts would be appreciated. I will try. Tony Marston http://www.t

[BUGS] BUG #2130: missing FROM-clause entry for table "mnu_task"

2005-12-26 Thread Tony Marston
The following bug has been logged online: Bug reference: 2130 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.1 Operating system: Windows XP Description:missing FROM-clause entry for table "mnu_task" Details: An SQL query

[BUGS] BUG #5690: pg_upgrade fails

2010-10-03 Thread Tony marston
The following bug has been logged online: Bug reference: 5690 Logged by: Tony marston Email address: t...@marston-home.demon.co.uk PostgreSQL version: 9.0 Operating system: Windows XP Description:pg_upgrade fails Details: I am trying to upgrade from version 8.4 to

[BUGS] BUG #5696: cannot upgrade to 9.0.1

2010-10-07 Thread Tony Marston
The following bug has been logged online: Bug reference: 5696 Logged by: Tony Marston Email address: t...@marston-home.demon.co.uk PostgreSQL version: 9.0 Operating system: Widows XP Description:cannot upgrade to 9.0.1 Details: I have just installed version 9.0