Re: [BUGS] small bug in op + between datetime and integer

2003-08-17 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Anyone have an idea on this one? There's a date + integer operator, but no integer + date operator. Yawn... Uh, Yawn means we don't need to fix it, or oh, here's another one? -- Bruce Momjian|

Re: [BUGS] small bug in op + between datetime and integer

2003-08-17 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Anyone have an idea on this one? There's a date + integer operator, but no integer + date operator. Yawn... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our

Re: [BUGS] ALTER SCHEMA problem

2003-08-17 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Can someone comment on this? This is unfixable as long as nextval() and friends depend on string parameters to represent table references. There are suggestions in our archives about how we might move to a more Oracle-like syntax (ie, table.nextval),

Re: [BUGS] small bug in op + between datetime and integer

2003-08-17 Thread Dennis Björklund
On Sun, 17 Aug 2003, Bruce Momjian wrote: Anyone have an idea on this one? It is maybe not bug, but I didn't find any warning about this behavior. select current_date + 1; -- ok select 1 + current_date; -- not ERROR: operator does not exist: integer + date HINT: No operator

Re: [BUGS] DBD::Pg 'lo_read' fails on = 32768 byte large objects

2003-08-17 Thread Tom Lane
Kevin Houle [EMAIL PROTECTED] writes: One more data point. The DBD::Pg 'lo_extract' function works fine across SSL. There is no issue with large objects = 32K using 'lo_extract'. So that casts doubt on it being an OpenSSL issue. No, it does not, because lo_export writes the data to a file on

Re: [BUGS] Bug #926: if old postgresql.jar in CLASSPATH, ant fails

2003-08-17 Thread Palle Girgensohn
It's been in use for the freebsd port for some months now, so I say yes. ;-) /Palle lördagen den 16 augusti 2003 kl 22.54 skrev Bruce Momjian: Is this patch valid for inclusion in jdbc? --- [EMAIL PROTECTED] wrote:

Re: [JDBC] [BUGS] Bug #926: if old postgresql.jar in CLASSPATH,

2003-08-17 Thread Dave Cramer
Yes, agreed Dave On Sun, 2003-08-17 at 09:57, Palle Girgensohn wrote: It's been in use for the freebsd port for some months now, so I say yes. ;-) /Palle lördagen den 16 augusti 2003 kl 22.54 skrev Bruce Momjian: Is this patch valid for inclusion in jdbc?

[BUGS] Database Grants Bug

2003-08-17 Thread Marcus England
=== POSTGRESQL BUG REPORT TEMPLATE Your name : Marcus England Your email address : [EMAIL PROTECTED] System Configuration

Re: [BUGS] Database Grants Bug

2003-08-17 Thread Joe Conway
Marcus England wrote: Grants do not work at the database level using the syntax mentioned in the documentation. i.e.: GRANT ALL ON DATABASE dbname TO GROUP groupname; Or GRANT ALL ON DATABASE dbname TO username; Works here: regression=# select version(); version