Обсуждение: accent error

Поиск
Список
Период
Сортировка

accent error

От
Mateus
Дата:
log de erro pgAgent:
 $ pgagent -f host=127.0.0.1 dbname=bd user=scott -l 2 DEBUG: Creating primary connection DEBUG: Creating DB
connection:host=127.0.0.1 dbname=bd user=scott DEBUG: Database sanity check DEBUG: Clearing zombies DEBUG: Checking for
jobsto run DEBUG: Creating job thread for job 1 DEBUG: Creating DB connection: host=127.0.0.1 user=scott dbname=bd
DEBUG:Allocating new connection to database posveic DEBUG: Starting job: 1 DEBUG: Sleeping... DEBUG: Creating DB
connection:host=127.0.0.1 user=scott dbname=bd DEBUG: Allocating new connection to database bd DEBUG: Executing SQL
step1 (part of job 1)
 

WARNING: Query error: ERROR:  column cliente.descrição does not exist  character 8

Re: accent error

От
Dave Page
Дата:
Mateus wrote:
> log de erro pgAgent:
> 
>  $ pgagent -f host=127.0.0.1 dbname=bd user=scott -l 2
>  DEBUG: Creating primary connection
>  DEBUG: Creating DB connection: host=127.0.0.1 dbname=bd user=scott
>  DEBUG: Database sanity check
>  DEBUG: Clearing zombies
>  DEBUG: Checking for jobs to run
>  DEBUG: Creating job thread for job 1
>  DEBUG: Creating DB connection: host=127.0.0.1 user=scott dbname=bd
>  DEBUG: Allocating new connection to database posveic
>  DEBUG: Starting job: 1
>  DEBUG: Sleeping...
>  DEBUG: Creating DB connection: host=127.0.0.1 user=scott dbname=bd
>  DEBUG: Allocating new connection to database bd
>  DEBUG: Executing SQL step 1 (part of job 1)
> 
> WARNING: Query error: ERROR:  column cliente.descrição does not exist
>  character 8

What is the actual query? What encoding is your maintenance DB in?

Regards, Dave