RaphaÃl Enrici wrote:
Andreas Pflug wrote:
RaphaÃl Enrici wrote:
Ricardo just sent me an email where saying the problem also appears in psql:
xxx=# select * from non_existent;
ERROR: ERRORDATA_STACK_SIZE exceeded
xxx=#
So that's obviously a backend problem, and this stuff should go to pgsql-bugs. Maybe a corrupted es_ES translation file.
Thank you Andreas, we have found a workaround with Ricardo so that he can use his db correctly. We will move to the correct lists or Debian bug system to report this one.
Sorry to insist, but I'd like to come back on this...
To get the ERRORDATA_STACK_SIZE in psql it's mandatory to do one more thing than in pgAdmin III.
I mean pgAdmin gets in error in situation where psql does not... Maybe there is something else hidden far far far [(c) schrek2 ;)] ?
Here is where I am:
As root:
put lc_messages to es_ES in postgresql.conf
export LC_CTYPE=es_ES # LC_CTYPE, not LC_MESSAGES, or fr_FR, or something not C, not POSIX, not xxx.UTF-8
/etc/init.d/postgresql restart
then in another terminal with locales set to POSIX as a normal user: [EMAIL PROTECTED]:~$ pgadmin3 => DOES NOT WORK CORRECTLY [EMAIL PROTECTED]:~$ psql -d pipo2 Welcome to psql 7.4.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit
pipo2=# \encoding UNICODE pipo2=# select * from doesnotexist; ERROR: no existe la relaciïn "doesnotexist" ========> SO IT WORKS! pipo2=# \encoding LATIN9 # IS IT REALLY MEANINGFUL TO DO SUCH A THING ??? pipo2=# select * from doesnotexist; ERROR: ERRORDATA_STACK_SIZE exceeded ========> NOW IT DOES NOT WORK. pipo2=#
So, I have to change my encoding to LATIN9 so that psql does not work when pgadmin3 does not work at all.
As far as I've seen in pgadmin.log, the encoding selected by pga3 is UNICODE as expected...
Any idea ? Is it worth investigating more ?
Regards, RaphaÃl
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
