I think the code is somehow interrupt based, but I don't know. I've
asked the primary maintainer of the program to look into this with me.
We should have more insight by early next week.
Peter
Tom Lane wrote:
"Peter Koczan" <[EMAIL PROTECTED]> writes:
This app uses Perl/DBD::Pg, and the c
You may want to suggest to the devs to extend the "UPDATE" syntax with
"ORDER BY"? such that:
update rumple.directory
set right_visit_id = right_visit_id + 2
where right_visit_id >= parent_right
ORDER BY right_visit_id DESC;
...would work by enforcing a certain update order. And index scan is
CREATE OR REPLACE my_to_number(text,text) RETURNS number AS
$$
BEGIN
IF NOT textregexeq($1,'[0-9]{'||length($2)||'}') THEN
RAISE EXCEPTION 'TEXT % is not a valid NUMBER',$1;
END IF;
RETURNS to_number($1,$2);
END;
$$ LANGUAGE PLPGSQL IMMUTABLE;
OR something like ...
2007/8/3
Hi,
try this:
dump your db
create a db in sqlascii
import into new one
export from new one and then try to import in utf8.
i try somethng like this in 8.1.
good luck.
Казорез Александр Олегович wrote:
Hi to all,
I came across a problem while switching from 8.0 to 8.1.4 (or, now, to
8.2.4).
Ok. Now the function is OK
CREATE OR REPLACE FUNCTION my_to_number(text,text) RETURNS numeric AS
$$
BEGIN
IF NOT textregexeq($1,'^[0-9]+$') THEN
RAISE EXCEPTION 'TEXT % is not a valid NUMBER',$1;
END IF;
RETURN to_number($1,$2);
END;
$$ LANGUA
2007/8/3, William Leite Araújo <[EMAIL PROTECTED]>:
>
> CREATE OR REPLACE my_to_number(text,text) RETURNS number AS
OOOps... CREATE OR REPLACE FUNCTION ...
$$
> BEGIN
> IF NOT textregexeq($1,'[0-9]{'||length($2)||'}') THEN
> RAISE EXCEPTION 'TEXT % is not a valid NUMBER',$1;
> END
Bom, então provavelmente o problema é como JDBC que está usando, já
que no PGAdmin3 funciona corretamente.
Lembre-se que a versão TEM QUE SER do postgresql 8.2...
Veja http://jdbc.postgresql.org/download.html
2007/8/3, Raimundo Alves <[EMAIL PROTECTED]>:
>
>
> The following bug ha
Hi to all,
I came across a problem while switching from 8.0 to 8.1.4 (or, now, to 8.2.4).
Here it is:
QUOTE: Some users are having problems loading UTF-8 data into 8.1.X. This is
because previous versions allowed invalid UTF-8 byte sequences to be entered
into the database, and this rel
The following bug has been logged online:
Bug reference: 3509
Logged by: Raimundo Alves
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Windows
Description:bug with command from with two tables
Details:
i am using the postgres at an appl
Heikki Linnakangas a écrit :
Laurent Martelli wrote:
to_number('123.0','99') returns 1230, at least on version 7.4 and 8.1. I
think it should return 123 or raise an error.
to_number will silently ignore any character that doesn't match the
pattern. That can be confusing, and not generally
10 matches
Mail list logo
