postgresql
How to migrate a Postgres database to heroku using NodeJS?
With Ruby, the migration only use a rake command, but in 开发者_如何学PythonNodeJS, i\'m not sure how i can do that. Any idea?This might help: https://github.com/visionmedia/node-migrateYou could copy[详细]
2023-04-11 02:30 分类:问答Heroku, cant push my db
I am trying to push my database to heroku, and get this error: Taps Server Error: PGError: ERROR:invalid byte sequence for encoding \"UTF8\": 0x89[详细]
2023-04-11 02:20 分类:问答How to drop DB indices before bulk loading in seeds.rb?
In my rails app I have a seeds.rb script which inserts lots of rec开发者_运维问答ords. In fact I\'m trying to load 16 million of them. It\'s taking a long time.[详细]
2023-04-11 02:15 分类:问答How to write alter column name migrations with sqlalchemy-migrate?
I\'m trying to alter a column name. First attempt was with this script: meta = MetaData() users = Table(\'users\', meta,[详细]
2023-04-11 01:48 分类:问答How can I compute a duration from two dates?
I have this query, that\'s been giving me some issues, it looks like this: UPDATE servicecontracts SET planned_duration = (to_char(due_date) - to_char(start_date) + 1)[详细]
2023-04-10 22:44 分类:问答ruby 1.9.2 does not support pg gem? cant heroku rake db:migrate (
i am using ruby 1.9.2 and rails 3.1.0 please help, cause i very need it to work for studying. It\'s my university project([详细]
2023-04-10 21:38 分类:问答Declare variable of composite type in PostgreSQL using %TYPE
Question: How can I declare a variable of the same type a parameter in a stored function? The simple answer is use %TYPE, this works:[详细]
2023-04-10 21:10 分类:问答Error Saving geodjango PointField
I have a geo model with a PointField property. Everything works perfectly locally, but when I try to save an instance on the server, I get the following error:[详细]
2023-04-10 18:54 分类:问答Set a default return value for a Postgres function
I have the following function in Postgres: CREATE OR REPLACE FUNCTION point_total(user_id integer, gametime date)[详细]
2023-04-10 16:19 分类:问答Destroying a Postgres DB on Heroku
I want to destroy the database but I\'m not sure what the command 开发者_高级运维would be. Does anyone know how to do this?You shouldn\'t use a postgres command to fully delete your database, as you w[详细]
2023-04-10 14:58 分类:问答