[BUGS] BUG #2500: subscribing for digest

2006-06-28 Thread
The following bug has been logged online: Bug reference: 2500 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 0.0 Operating system: Unix Description:subscribing for digest Details: subscribe-digest pgsql-general The subscribe command did n

[BUGS] BUG #2501: JOIN and capitial letters in Table Row

2006-06-28 Thread ALL
The following bug has been logged online: Bug reference: 2501 Logged by: ALL Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:JOIN and capitial letters in Table Row Details: I had a table as like the following named prod

Re: [BUGS] BUG #2496: Troubles with fixed-point types (NUMERIC, DECIMAL,...)

2006-06-28 Thread William ZHANG
Can you set "log_statement" in postgresql.conf and post the logged statements? -- With regards, William ZHANG - Original Message - From: ""Heinz-Peter Heidinger"" <[EMAIL PROTECTED]> Newsgroups: pgsql.bugs Sent: Saturday, June 24, 2006 3:44 PM Subject: BUG #2496: Troubles with fixed-poin

Re: RE : [BUGS] BUG #2497: bug initdb

2006-06-28 Thread Alvaro Herrera
bruno corbin wrote: > All my system is ok but my file systeme is reiserfs > > Is-it possible that it don't works with reiserfs ? Not at all! It certainly works with Reiserfs and a ton other FSes. How do you know your system is OK? > -Message d'origine- > De : Alvaro Herrera [mailto:[

Re: [BUGS] BUG #2494: SCROLL CURSOR does not worl

2006-06-28 Thread Jim C. Nasby
There's no such thing as a 'SCROLL CURSOR' in plpgsql: http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html I'm pretty sure that the default behavior would be scrollable. We should probably add a TODO to bring the plpgsql cursor syntax inline with what the backend supports. On Fri,

Re: [BUGS] BUG #2500: subscribing for digest

2006-06-28 Thread Jim C. Nasby
Moving to -www On Tue, Jun 27, 2006 at 06:24:34PM +, [EMAIL PROTECTED] wrote: > > The following bug has been logged online: > > Bug reference: 2500 > Logged by: > Email address: [EMAIL PROTECTED] > PostgreSQL version: 0.0 > Operating system: Unix > Description:s

Re: [BUGS] BUG #2501: JOIN and capitial letters in Table Row

2006-06-28 Thread Jim C. Nasby
If you define an object using quotes to preserve case, you must always refer to that object with quotes, ie: productoptions."ProductID". My recommendation: use underscores in the database (product_options.product_id). Personally, I wouldn't pluralize the table names either, but that's just me...

Re: [BUGS] BUG #2494: SCROLL CURSOR does not worl

2006-06-28 Thread Bruce Momjian
Added to TODO: > o Add support for WITH HOLD and SCROLL cursors > > PL/pgSQL cursors should support the same syntax as > backend cursors. --- Jim C. Nasby wrote: > There's no s