[GENERAL] How to clone CURRENT_DATE to SYSDATE ?

Hi, I need to clone function CURRENT_DATE to SYSDATE in my PostgreSQL. Does anybody know how to do that it ? -- *Atenciosamente,Emanuel Araújo* *Linux Certified, DBA PostgreSQL*

Re: [GENERAL] How to clone CURRENT_DATE to SYSDATE ?

in my case, there are a lot of fields with "DEFAULT trunc(sysdate)". This situation break when I start the sincronization why the data type there isn't in PostgreSQL. 2014-09-24 16:43 GMT-03:00 Adrian Klaver : > On 09/24/2014 07:39 AM, Emanuel Araújo wrote: > >> Hi

[GENERAL] Extract especific text from a sql statement

TE order by 1 desc ; I need to return that: pc.cod pc.val pi.qtd pc.name pc.email status pc pi pc.startdate can you help me ? -- *Atenciosamente,Emanuel Araújo*

[GENERAL] Triggers Operations

not interested in the performance, as this take care later, but the question that there are random operations that do not complete for the final table. Thanks! -- *Atenciosamente,Emanuel Araújo* *Linux Certified, DBA PostgreSQL*

[GENERAL] Acess Oracle with dbi-link (PostgreSQL) Error Compile

ot;-fPIC" -I/usr/lib64/perl5/CORE " -Wall-Won-comment-DUTF8_SUPPORT-DORA_OCI_VERSION = \" 10.2.0.3 \ "- DORA_OCI_102 Oracle.c In file included from Oracle.xs: 1:0: Oracle.h: 37:17: fatal error: oci.h: File or directory not found compilation terminated. make: ** [Oracle.o

[GENERAL] Bucardo syncrun

Hi, Can I purge data on Postgrebucardo table syncrun ? If I will follow this steps: bucardo stop psql bucardo truncate bucardo.syncrun ; \q bucardo start The steps to purge all past data that table. Is correct? Is this Simple method? -- *Atenciosamente,Emanuel Araújo* *Linux Certified

[GENERAL] Oracle_FDW - Cache lookup failed

WHEN (SELECT s_valor FROM t_parametro_cliente WHERE s_campo = 'v_utiliza_grupo') = 'I' THEN f_produto.coddistrib::text END) ) WHERE grupos.s_tipogrupo = (SELECT s_valor FRO

[GENERAL] Pgpool outdated spec

Hi, I'm doing a rebuild to a rpm package postgresql-9.0 with pgpool but your spec is outdated, there is some spec updated or have to make my changes manually? -- * Emanuel Araújo* http://eacshm.wordpress.com/ * * *Linux Certified LPIC-1*

[GENERAL] Problem dbi_link with postgresql 9.04

http://translate.google.com.br/?tr=f&hl=pt-BR> Cancelar <http://translate.google.com.br/?tr=t&hl=pt-BR> Tradução do português para inglês -- *Atenciosamente, Emanuel Araújo* http://eacshm.wordpress.com/ * * *Linux Certified LPIC-1*

Re: [GENERAL] Problem dbi_link with postgresql 9.04

hi, news! found that the problem occurs when the dbi_link makes parsing of a field float / double to a text field, because when it creates the tables already created with this type of data. Another thing we see is that the problem is not with null fields or zero bytes but with a value of 1.5, no

[GENERAL] connection manager pgpool... help

all the time. I plan on using a connection pool (pgpool), thinking to improve performance and have better management of the connections. Based on my scenario, can anyone help me? I'm using postgresql version 9.0.5 thank you -- *Atenciosamente, Emanuel Araújo* http://eacshm.wordpres

[GENERAL] Problemas com client_encoding ?

e problema Todas as instalações que fazemos aqui, seguimos os pacotes oficiais do repositorio pgdg e o processo de instalação igual em qualquer situação. Alguém pode me dar um HELP ? -- *Atenciosamente, Emanuel Araújo* http://eacshm.wordpress.com/ * * *Linux Certified LPIC-1*