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
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
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
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:[
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,
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
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...
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