setting LC_NUMERIC

Hi,

unfortunately I did not set the locales correct, when I created my
database. The result is, that the numeric type expects an american
format like "12.34".

Since I'm from europe, where this number will be represented as "12,34"
I would like to change it without having to recreate the database,
because it already contains data.

I set the lc_numeric in the postgres.conf but that did not help. I also
used:

=# SET LC_NUMERIC TO "de_DE(at)euro" ;
SET

In the psql client, but after that inserts with the european number
format also failed. I also changed the enviornment variables and
restarted the database server. No luck either.

How do I change the numeric format? I read the postgresql manual but
it's fishy about this and they ways they described I tried and failed.

Any advice is appreciated!

Fritz