[eluser]kea13[/eluser]
Hi yesov,
ok, let's gather the facts:
- on your development machine you usually do your queries through Active Record which works as intended
So this obviously rules out access problems on PostgreSQL's side (at least concerning pg_hba.conf)
- this time you're using hand-crafted SQL statements and your applications burns and implodes
This leaves me with two candidates: the first being a malformed SQL-query (maybe a typo somewhere? PostgreSQL is for example pretty picky when it comes to numbers not being enclosed in ticks) or a permission problem on the table or schema itself.
The thing that I still don't get is the issue with the hosters server ... do you imply that the application that crashes on your development machine just plain works as soon as it is stored on the hosters server?
Cheers,
Roman