Re: accent error

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