"john lyssy" <[EMAIL PROTECTED]> writes:
> This cast returns:ERROR: invalid input syntax for type numeric: ""
> select string1 from adfields where
> (cast (string1 as decimal (6,2)) >= 0.0) and (string1 != '' )
Why do you find that surprising? There's nothing there to guarantee
that the string1
Tigran Mkrtchyan <[EMAIL PROTECTED]> writes:
> I got a incorrect or unexpected behavior in concurrent environment.
This is not a bug, nor even surprising. Since you haven't committed
the second transaction, there are a growing number of
dead-but-not-recyclable versions of the updated row. The ac
The following bug has been logged online:
Bug reference: 2865
Logged by: Leo
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows 2003
Description:Cannot save the data in pgAdmin
Details:
If there is only one record in a table, if I del
The following bug has been logged online:
Bug reference: 2866
Logged by: john lyssy
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Windows XP
Description:cast varchar to decimal failure
Details:
This cast returns:ERROR: invalid input synt
Dear PostgreSQL gurus,
I got a incorrect or unexpected behavior in concurrent environment.
Luckily, I was able to localize it and create an example:
My setup:
Postgres 8.2 ( with 8.1 the same effect )
Linux ( with Solaris the same effect )
java 1.5, JDBC driver 8.2-504.jdbc3 ( with earlier
On Dec 19, 2006, at 7:29 AM, Tom Lane wrote:
"Thomas Jahnsen" <[EMAIL PROTECTED]> writes:
I try to compile PostgreSQL 8.2, but it fails in the file "tab-
complete.c"
(src/bin/psql/tab-complete.c). It reports an undeclared function
call;
'rl_filename_completion_function'
Please be specific
The following bug has been logged online:
Bug reference: 2864
Logged by: max kuhar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: windows xp sp2
Description:can't instal postgresql
Details:
when installer gets to setting up the account it
So my problem is that the program EOModeler is forcing
the schema-qualified constraint. I will filed a bug
report with Apple Unfortunitily, I believe that
the product has been deprecated I have yet to get
eclipse with "entity modeler" working correctly to see
what it does the the name space
