[GENERAL] Plpgsql Multidimensional array

2006-06-06 Thread Rodrigo Carvalhaes
$; varr_tabela[2] :=$$'[[341','á'$$; varr_tabela[3] :=$$'[[341','á'$$; IF tipo_conversao IS TRUE THEN FOR i IN 1 .. 3 LOOP SELECT varr_tabela[i] INTO vstr_chave; new_string := replace(old_string,vstr_chave); END LOOP; ELSE FOR i IN 1 .. 3 LOOP

[GENERAL] pg_restore taking 4 hours!

2004-12-01 Thread Rodrigo Carvalhaes
arameters are the default) tcpip_socket = true max_connections = 30 shared_buffers = 3 sort_mem = 4096 vacuum_mem = 8192 max_fsm_pages = 2 max_fsm_relations = 1000 Regards, Rodrigo Carvalhaes ---(end of broadcast)--- TIP 6: Have you s

[GENERAL] IMPORT FROM CTREE to POSTGRESQL

2004-10-14 Thread Rodrigo Carvalhaes
Hi Guys! Anyone already made a importation from CTREE files ( files .dtc) to PostgreSQL ? I know that there is a "contrib" tool to import files from dbf to sql... Any tip ? -- Cheers , Rodrigo Miranda Carvalhaes ---(end of broadcast)--- TIP 6: Have

[GENERAL] FYRACLE better then PostgreSQL ?

2004-09-28 Thread Rodrigo Carvalhaes
Hi Guys! Someone already read this the documentation below? http://www.janus-software.com/fyracle.pdf They are saying that PostgreSQL is so robust as Firebird according to triggers ( I think that they are talking about their "universal triggers"), SQL functionality and transactions. wow! Someone