Re: [GENERAL] Cambiando Postgresql 7.4.3 a 8.1.11 !!!

2009-02-22 Thread Mike Hall
Este podria ser un problema con SELinux? Prova: /usr/sbin/getsebool -a | grep httpd Busca: httpd_can_network_connect_db El valor de este directivo debe ser "on" Se puede cambiar permanentemente con: /usr/sbin/setsebool -P httpd_can_network_connect_db on Suerte //

[GENERAL] Serial/sequence problem

2008-11-24 Thread Mike Hall
I have just imported 3636 rows into a PG database table (PG 8.1 on CentOS 5.2 ... the default). The rows were imported using separate INSERT statements for each row. All OK so far. After having had a few attempts at inserting new test rows (which all inserted OK), I notice that the last_value c

[GENERAL] Date data type

2008-11-02 Thread Mike Hall
Gday, I'm currently converting an MS Access database to PostgreSQL (version 8.1 as it is the vesion that ships with CentOS 5). I'm having trouble with an INSERT statement attempting to insert an empty value ('') into a field with data type DATE. This produces the following error message: ERRO