The following bug has been logged online:
Bug reference: 5197
Logged by: Joseph Shraibman
Email address: j...@selectacast.net
PostgreSQL version: 8.2.14
Operating system: Linux
Description:JDBC: selecting oid results in Exception
Details:
query: "select oid
Craig Ringer wrote:
On Tue, 2009-09-15 at 19:26 +, Joseph Shraibman wrote:
The following bug has been logged online:
While the test case is appreciated, it's not really that clear what's
expected to happen vs what happens, at what point things go wrong and
under what circumst
The following bug has been logged online:
Bug reference: 5058
Logged by: Joseph Shraibman
Email address: j...@selectacast.net
PostgreSQL version: 8.2.14
Operating system: Linux
Description:[jdbc] Silent failure with executeUpdate()
Details:
I was trying to figure
Sam Mason wrote:
On Tue, Sep 01, 2009 at 04:36:25PM +, Joseph Shraibman wrote:
Description:CASE returns ELSE value always when type is "char"
I think it's just silently truncating the literal to a single character.
[local]:playpen=> select c.relkind, CASE c.rel
elkind
-+-
r | table
(1 row)
Time: 0.674 ms
[local]:playpen=> select c.relkind, CASE c.relkind WHEN 'r' THEN 'table'
WHEN 'v' THEN 'view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN
The following bug has been logged online:
Bug reference: 5028
Logged by: Joseph Shraibman
Email address: j...@selectacast.net
PostgreSQL version: 8.3.7
Operating system: Linux
Description:CASE returns ELSE value always when type is "char"
Details:
[loca
Kevin Grittner wrote:
"Joseph Shraibman" wrote:
The pg_relation_size(text) method cannot determine the size of a
relation that has capital letters.
Did you try putting quotes inside the apostrophes?:
No, I didn't. I didn't know I could do that.
SEL
The following bug has been logged online:
Bug reference: 5023
Logged by: Joseph Shraibman
Email address: j...@selectacast.net
PostgreSQL version: 8.3.7
Operating system: Linux
Description:pg_relation_size() is not case sensitive
Details:
The pg_relation_size(text
Tom Lane wrote:
Joseph Shraibman writes:
See example below. At the very least the documentation needs to tell
users that savepoints use shared memory, and the cofusing HINT string
needs to be changed to something more useful.
Which part of "You may need to inc
See example below. At the very least the documentation needs to tell
users that savepoints use shared memory, and the cofusing HINT string
needs to be changed to something more useful.
When run on a machine running 8.2b3
version: PostgreSQL 8.2beta3 on i686-pc-linux-gnu, compiled by GCC gcc
This works:
ALTER TABLE segment ADD CONSTRAINT name unique(textfield, reseller);
This doesn't:
ALTER TABLE segment ADD CONSTRAINT name unique(lower(textfield),
reseller);
I had to create a unique index.
---(end of broadcast)---
TIP 7: don't
The output of the vacuum command on
http://developer.postgresql.org/docs/postgres/sql-vacuum.html
shows the output of the 7.3.x version. I noticed while browsing the cvs that the output
has changed.
---(end of broadcast)---
TIP 7: don't forget to
t; 460,461d459
> < case Types.BIT:
> < set(parameterIndex,
> ((Boolean)x).booleanValue() ? "true" : "false");
Why not set(parameterIndex,x.toString())?
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
JDBC driver to pgsql-interfaces to do just that
> some time ago. Don't know what happened to it, though ..
>
> /Anders
> ________
> A n d e r s B e n g t s s o n[EMAIL PROTECTED]
> http://www.lecando.com
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
version(). Comments, Java folks?
>
I remember someone posting a patch saying that he changed the code to do
that. Or saying he was going to post a patch, I forget.
Anyway, I just checked and it isn't in the cvs.
--
Joseph Shraibman
[EMAIL PROTECTED]
Increase signal to noise ratio. http://www.targabot.com
15 matches
Mail list logo