As subject, i got a stored function that returns an int2
i successfully call it using a callable statement, exactly as it is written in
the manual, but when the getShort expression is executed, i receive a
"Exception in thread Exception in thread "Timer-1"
java.lang.ClassCastException: java.lang
i forgot :)
executing the function manually leads to no errors
> Da: "Federico Fissore" <[EMAIL PROTECTED]>
> Data: Sun, 07 Nov 2004 17:54:47 +
> A: [EMAIL PROTECTED]
> Oggetto: [BUGS] JDBC driver. Class Cast Exception when calling
> CallableStatement.getShort
>
> As subject, i got a stored
On Sun, 7 Nov 2004, Federico Fissore wrote:
> As subject, i got a stored function that returns an int2 i successfully
> call it using a callable statement, exactly as it is written in the
> manual, but when the getShort expression is executed, i receive a
> "Exception in thread Exception in thre
I agree with the suggestions to attach it to userids. However, setting the
statement_timeout in the conf file is good as it will enforce everyone to
have some timeout. This will be especially useful in web applications.
Anyway, I will use ALTER USER to do it and disable statement_timeout in the
co
The web page http://www.postgresql.org/news/235.html
says report any/all problems in 8.0 to this address, so…
The following java code works fine on 7.4:
Class.forName("org.postgresql.Driver");
Connection
conn = DriverManager.getConne
Hi,
thanks to everybody who has answered to my question. Indeed the documents
let the programmer hope that s/he gets what should be expected:
In postgresql-7.4.1/doc/html/rules-update.html it says:
For ON INSERT rules, the original query (if not suppressed by INSTEAD)
is done before any
The following statements work fine in 7.4
Connection
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/psdb","xxx","");
Statement
stmt = conn.createStatement();
Hey guys,
I'm a fairly new user to the postgresql world... so *perhaps* this is not a
bug. But I cannot get
the following entry to work in the pg_hba.conf file:
hostall all 0.0.0.0/0 md5 <-- doesn't work
hostall all 4.0.0.0/8 md5 <-- matches anything 4.x.x.x (wor
On Sun, 31 Oct 2004, Tom Lane wrote:
I don't have a problem with the make file changes.
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Mon, 2004-11-01 at 10:49, Martin Pitt wrote:
> >> 25contrib-dbmirror:
> >> - additionally install some useful scripts and data files
>
> > Makes sense to me,
On Mon, 1 Nov 2004, Laferriere, Al wrote:
> [can't call setBoolean on char or setString on boolean]
>
This is the expected behavior. The 8.0 release of the JDBC driver
includes strong typing. Previous versions of the driver did simple
string substitution, a = ? was transformed to a = '0'
Gostaria se possivel de uma ajuda o significa este erro ?
postgres[30994]: [40325] ERROR: pg_atoi: zero-length string
postgres[30558]: [57800] ERROR: pg_atoi: zero-length string
Obrigado.
---(end of broadcast)---
TIP 2: you can get off all lis
Greetings.
recently i downloaded the postgres version for windows, but after i installed
it
in my server, i get the following error:
"server closed the connection unexpectedly
this probably means the server terminated abnormally before or while processing
the request"
can you help me to solve t
Stephan Szabo wrote:
On Wed, 3 Nov 2004, PostgreSQL Bugs List wrote:
somedb=# alter table sometbl add column msisdn number(11);
ERROR: syntax error at or near "(" at character 43
you can use the type identifier 'decimal' instead:
somedb=# alter table sometbl add column msisdn decimal(11);
ALTER
On Mon, 1 Nov 2004, Laferriere, Al wrote:
> ResultSet rs =
> stmt.executeQuery("SELECT \"psdb \".\"public\".\"tt\".\"ans\" FROM
> \"psdb \".\"public\".\"tt\"");
>
> java.sql.SQLException: ERROR: syntax error at end of input
>
>
> Also, there is no problem
[EMAIL PROTECTED] writes:
> So I'm guessing there is something wrong with the way 0.0.0.0/0 is being
> recognized?
Hmm, I'm betting you are on a machine where shifting a 32-bit quantity
left 32 bits doesn't reliably give zero. This misbehavior is actually
allowed by the C standard :-( ... but it
Cast int to domaim based on bit(n) works quite strange.
CREATE DOMAIN kat bit(40) NOT NULL;
SELECT 7::bit(40), 7::kat;
--on Win (7.5devel) and Linux (8.0.0b4)
bit | kat
0111 |
1000
--on Linux (7.4.6)
bit | kat
000
On Fri, 5 Nov 2004, [ISO-8859-2] Martin Sládek wrote:
> Cast int to domaim based on bit(n) works quite strange.
>
> CREATE DOMAIN kat bit(40) NOT NULL;
> SELECT 7::bit(40), 7::kat;
I didn't realize you were going to report this (as this post got held for
moderator approval), so I reported it
Good morning, I’m from Brazil and I
trying install the postgre 8 beta and found this error: “filed to create
process for initdb”. Look that I use windows 2003 server. Maybe you help
me. To the service, I used ‘postgres’ and in cluster I used too ‘postgres’
but other password, or other user,
POSTGRESQL BUG REPORT TEMPLATE
Your name : Thomas Jacob
Your email address : [EMAIL PROTECTED]
Sys
Kris Jurka <[EMAIL PROTECTED]> writes:
> This did not work in 7.4 either, it even gives a much better error message
> than 8.0's "syntax error"
> jurka=# select * from catalog.schem.tab;
> ERROR: cross-database references are not implemented
I'm not sure why 8.0 wasn't handling this properly --
./configure --prefix=/usr/local
lets me run throu the entire test suite without an issue.
Tom Lane wrote:
David Dick <[EMAIL PROTECTED]> writes:
/home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
relocation error:
/home/dave/postgresql-8.0.0beta4/src/
*snip*
/bin/sh ./pg_regress --temp-install --top-builddir=../../..
--schedule=./parallel_schedule --multibyte=SQL_ASCII
== removing existing temp installation==
== creating temporary installation==
== initializing database sys
Hello,
I can't install the
beta 4 on my windows system because it is XP Home Edition.
The choices about
rights made for the installer seem to be a real problem because XP Home Edition
has seemlessly only two rights policies : quite full for the administrator
and quite none for the user
ipc-daemon2 &
[2] 1424
[1] Done ipc-daemon2
[EMAIL PROTECTED] ~
$ ps
PID PPID PGID WINPID TTY UID STIME COMMAND
1724 1 1724 1724 con 500 13:47:53 /usr/bin/bash
1424 1724 1424 1236 con 500 13:57:30
/usr/bin/ipc-d
Hi PG team ,
my database is in UNICODE
I try this (with Bulgarian chars):
SELECT 'ÐÐÑÑ ÐÑÐÐÐ' ~* 'ÑÐÑÑ' as result
returns FALSE
above query is same as:
SELECT 'Test exam' ~* 'test' as result
retuns TRUE
the only different is that strings are in English
Is there problem with cyrilic?
I
David Dick <[EMAIL PROTECTED]> writes:
> /home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
>
> relocation error:
> /home/dave/postgresql-8.0.0beta4/src/test/regress/./tmp_check/install//usr/local/pgsql/bin/psql:
>
> undefined symbol: PQserverVersi
"dev" <[EMAIL PROTECTED]> writes:
> my database is in UNICODE
> I try this (with Bulgarian chars):
> SELECT 'Тест проба' ~* 'тест' as result
> returns FALSE
> above query is same as:
> SELECT 'Test exam' ~* 'test' as result
> retuns TRUE
The regexp stuff is not currently capable of deal
You cannot use an "Administrator-account" to create postgresql
services. That is made impossible for security reasons.
The "Other User" MUST have "log on as service" privileges. Without
them it will not work.
Harald
On Fri, 5 Nov 2004 08:54:01 -0200, Estevan Rech <[EMAIL PROTECTED]> wrote:
>
28 matches
Mail list logo
