9 questions
3
votes
2
answers
3k
views
Arel and CTE to Wrap Query
I have to update a search builder which builds a relation with CTE. This is necessary because a complex relation (which includes DISTINCT, JOINs etc) is first built and then it's results have to be ...
- 3,484
3
votes
1
answer
4k
views
How to install pgAudit extension?
I have postgreSQL 9.5 installed on Windows. I've cloned pgAudit repository and tried to install but there is no dll file in this repository and I could not build it.
I am new to postgreSQL extensions,...
- 764
0
votes
1
answer
32
views
How to perform a NOT query with postgres_ext
Is it possible to perform a NOT type query with chained methods using postgres_ext?
rules = Rule.where.overlap(:tags => ["foo"])
Basically want the inverse of the above. Thanks!
- 8,864
5
votes
1
answer
413
views
Rails 3.2 schema dump turns all UUID columns to text and mangles array declarations with postgres_ext gem
Using Ruby 2.0.0-p195 with Rails 3.2.13 and v0.3.1 of the postgres_ext gem.
It seems that I often have trouble with schema dumps (not SQL structure dumps) using Rails wherein the schema dumper ...
- 643
6
votes
2
answers
2k
views
Combining postgres_ext (or Rails 4) arrays with associations
I'm trying to develop a many-to-many relationship between tags (in the tags table) and items (in the items table) using a field of type integer[] on each item.
I know that Rails 4 (and Rails 3 via ...
- 128
0
votes
1
answer
707
views
PostgreSQL Complex indexing types and ordering
I have been doing some heavy reading the last couple days on indexing and I'm trying to figure out the right way to index a query I have with a lot of constraints. I am using the postgres_ext gem to ...
- 4,097
2
votes
2
answers
4k
views
Rails string array and PostgreSQL
I have a Rails model named Container with a column named products. It is a string array as supported by Postgres and the 'postgres_ext' gem.
The relevant portion of the GEMFILE is:
gem 'rails', '3.2....
- 7,081
0
votes
1
answer
500
views
Using postgres_ext with postgis adapter not working with array columns
I've successfully installed PostGIS and using the postgres_ext gem to add support Rails postgis ActiveRecord adapter, but when I try to use a Postgres array column type in my migration, it fails:
t....
- 4,800
0
votes
1
answer
374
views
Patch ActiveRecord/postgres_ext to return upper case UUID
I'm using postgres_ext with Rails/ActiveRecord to be able to store UUID as the PostreSQL UUID datatype. But in my app I'm comparing uuids and would like the UUIDs returned from the models to be in ...
- 2,783