Alexei Novakov <[EMAIL PROTECTED]> writes:
> Attaching the dumps of the tables. And here is the
> query:
> select T1.MAIN_ID, T6.LEVEL_IND, T12.MAIN_ID
> from TMP_1 T1, TMP_2 T2, TMP_2 T3, TMP_2 T4, TMP_2 T5,
> TMP_3 T6,
> TMP_2 T7, TMP_2 T8, TMP_2 T9, TMP_2 T10, TMP_2
> T11, TMP_1 T12
> wher
Mark Stosberg <[EMAIL PROTECTED]> writes:
> Why not make the translation on the fly, since using 'now' and
> timestamp() are not recommended practices anyway ?
Because we can't retroactively fix 7.1.
regards, tom lane
---(end of broadcast)-
Hello,
I'm in the process of migrating dozens of databases from 7.1 to 8.0.
It's been a great opportunity to become familiar with all the things
that have changed in the meantime.
Of of those things is the meaning 'now', as documented in the 7.4
release notes:
http://www.postgresql.org/docs/8.0/i
Added to TODO:
o Allow PL/PgSQL to support WITH HOLD cursors
---
Danilo Barbosa wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1850
> Logged by: Danilo Barbosa
> Email addre
> -Original Message-
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]
> Sent: 23 September 2005 20:56
> To: Dave Page
> Cc: Tom Lane; Magnus Hagander; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] CVS Head: Pg_ctl bug?
>
> Dave Page wrote:
> >
> >
> > > -Original Message-
>
Dave Page wrote:
>
>
> > -Original Message-
> > From: Tom Lane [mailto:[EMAIL PROTECTED]
> > Sent: 29 August 2005 21:32
> > To: Magnus Hagander
> > Cc: Dave Page; pgsql-bugs@postgresql.org
> > Subject: Re: [BUGS] CVS Head: Pg_ctl bug?
> >
> > "Magnus Hagander" <[EMAIL PROTECTED]> writ
"Trevor Tingey" <[EMAIL PROTECTED]> writes:
> I ran the following queries and got unexpected results:
> UPDATE Account
> SET "Password" = 'password1'
> WHERE "AccountName" = 'Trevor'
> SELECT *
> FROM Account
> WHERE "AccountName" = 'Trevor'
> AND "Password" = 'password2'
> (I ran them individua
The following bug has been logged online:
Bug reference: 1905
Logged by: Trevor Tingey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1 beta 2
Operating system: Windows XP Home Edition SP 2
Description:When a column with the chkpass datatype is used in a
where
