[BUGS] Outer joins aren't working with views

Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Outer joins aren't working with views Long Description It seems outer joins are not working at all(they work as inner joins so far). For example, see below: (the re

[BUGS] grant oddity

POSTGRESQL BUG REPORT TEMPLATE Your name : Bruno Wolff III Your email address : [EMAIL

[BUGS] DON'T APPROVE PREVIOUS Re: Bug in CAST() with time data types

On Fri, 15 Dec 2000, Alvaro Herrera wrote: > Your name : Alvaro Herrera > Your email address: [EMAIL PROTECTED] [...] Moderator: Sorry, I tried 7.0.3 and the bug is fixed. Please don't approve the previous post. (Anyway, there's a bug in the FTP site, but I don't kno

[BUGS] Bug in CAST() with time data types

Your name : Alvaro Herrera Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : AMD Athlon Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.17 PostgreSQL version (example:

Re: [BUGS] Outer joins aren't working with views

It works for me: regression=# select t1.*, t2.* from t1 natural left outer join t2; id | id2 | id +-+ 1 | 1 | 1 2 | 2 | 2 3 | | (3 rows) What version are you using? regards, tom lane

Re: [BUGS] grant oddity

Bruno Wolff III <[EMAIL PROTECTED]> writes: > The problem is that when access is granted explicitly, the implicit access > by the owner of the object (at least for select) is lost. The work around > is to also give explicit access to the owner. Right. This is a known bug --- it's fixed in 7.1bet

Re: [BUGS] Bug report

I think this is fixed in the current snapshot. > > POSTGRESQL BUG REPORT TEMPLATE > > > > Your name :

Re: [BUGS] Outer joins aren't working with views

What version are you using? The sample code works for me on current sources, three rows with the last one as 3|null|null Stephan Szabo [EMAIL PROTECTED] On Fri, 15 Dec 2000 [EMAIL PROTECTED] wrote: > Grzegorz Mucha ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the numbe

[BUGS] JDBC Driver Authentication Bug

Cheeren Shieh ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC Driver Authentication Bug Long Description If the userid is valid, even though null password or wrong password is sent to server with JDBC Driver, the authent

Re: [BUGS] Outer joins aren't working with views

> It works for me: > regression=# select t1.*, t2.* from t1 natural left outer join t2; > id | id2 | id > +-+ > 1 | 1 | 1 My recollection is that SQL9x requires that the join result lose the link to the original table names. That is, select id, id2 from t1 natural left outer

Re: [BUGS] Bug in CAST() with time data types

> Compiler used (example: gcc 2.8.0) : RPM for Mandrake Linux ... > When inserting timestamps or interval types whose precision is one full > minute, Postgres substracts one minute from the data and add 60 seconds > (00:01:00 becomes 00:00:60). Later, when reading this data Postgres s