Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using with Postgres #23

Closed
GoogleCodeExporter opened this issue May 13, 2015 · 2 comments
Closed

Using with Postgres #23

GoogleCodeExporter opened this issue May 13, 2015 · 2 comments

Comments

@GoogleCodeExporter
Copy link

This message is writen in Spanish, so if you have problems understanding the 
content, use a traductor.

Para usar esta aplicacion con postgres hice unos pequeños cambios. En primer 
lugar la función que se debe crear en la base de datos debe ser 

CREATE FUNCTION unix_timestamp(TIMESTAMP) RETURNS INTEGER AS '
SELECT date_part(''epoch'', $1)::INTEGER AS RESULT
' LANGUAGE sql;

Para alguien que no sepa, le puede parecer un dolor de cabeza meter la 
instrucción en el motor de base de datos y que no le funcione, porque le sobra 
el CREATE FUNCTION.

Otra cosa que hay que tener en cuenta es que en el config.inc.php en vez de la 
opción mysql, se debe usar pgsql (igual para el que no sabe, el que maneja PDO 
no tiene problema).

Y por ultimo para evitar problemas en la ejecución de las consultas a la base 
de datos, se debe quitar la variable $db_name de todas ellas.

Supongo que ya con eso es suficiente. No es un problema en si, sino la 
solución a lo que encontré.

Best Regards and THX for your effort. :D

Original issue reported on code.google.com by starex...@gmail.com on 2 Jul 2014 at 8:23

@GoogleCodeExporter
Copy link
Author

Thanks for your comments I will try to fix it.

Original comment by igor.oku...@gmail.com on 5 Jul 2014 at 4:07

@GoogleCodeExporter
Copy link
Author

fixed in 1.0.5

Original comment by igor.oku...@gmail.com on 23 Jul 2014 at 7:06

  • Changed state: Fixed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant