Re: [BUGS] 7.3 GROUP BY differs from 7.2

2003-02-21 Thread Tom Lane
Dan Langille <[EMAIL PROTECTED]> writes: > This is the query in question: > SELECT element_id as wle_element_id, COUNT(watch_list_id) > FROM watch_list JOIN watch_list_element >ON watch_list.id = watch_list_element.watch_list_id > WHERE watch_list.user_id = 1 > GROUP BY watch_list_el

[BUGS] 7.3 GROUP BY differs from 7.2

2003-02-21 Thread Dan Langille
I notice this today when migrating an application from 7.2 to 7.3. The column name is not being recognized. See also: http://archives.postgresql.org/pgsql-sql/2003-02/msg00480.php This is the query in question: SELECT element_id as wle_element_id, COUNT(watch_list_id) FROM watch_list JOIN wat

[BUGS] Bug #900: Win32 Postgres ODBC driver does not allow 2 connections to a database at the same time

2003-02-21 Thread pgsql-bugs
Jim Kardias ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Win32 Postgres ODBC driver does not allow 2 connections to a database at the same time Long Description You cant connect to two data sources with the postgres 7.02.0005

Re: [BUGS] [ADMIN] PANIC: unable to locate a valid checkpoint record

2003-02-21 Thread Ganesan R
On Thu, Feb 20, 2003 at 11:07:55PM -0500, Tom Lane wrote: > Ganesan R <[EMAIL PROTECTED]> writes: > > I am using 7.3.2. postmaster prints this on starting up: > > > LOG: ReadRecord: bad resource manager data checksum in record at 0/E42144 > > > pg_resetxlog is able to recover from the problem; b

Re: [BUGS] [ADMIN] PANIC: unable to locate a valid checkpoint record

2003-02-21 Thread Ganesan R
On Thu, Feb 20, 2003 at 11:07:55PM -0500, Tom Lane wrote: > Ganesan R <[EMAIL PROTECTED]> writes: > > I am using 7.3.2. postmaster prints this on starting up: > > > LOG: ReadRecord: bad resource manager data checksum in record at 0/E42144 > > > pg_resetxlog is able to recover from the problem; b

[BUGS] Unable to download postgre program

2003-02-21 Thread [EMAIL PROTECTED]
Dear Postgre: I'm unable to download the postgre application. When given the page with all the flags to choose a download mirror, either MSIE hangs or I am given a message from the error site saying I don't have the right permissions. I'll appreciate any advice you may offer. Thanks! Bruce Sp