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@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
