Stack Overflow
Stack Overflow

Questions tagged [postgres-ext]

Postgres_ext is a gem for Rails 3.2 which provides support for PostgreSQL datatypes in ActiveRecord

9 questions
6
votes
2 answers

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 postgres_ext) has support for Postgres' arrays…
Nuck
  • 128
  • 5
5
votes
1 answer

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 converts UUID columns to text columns and arrays to text…
yonkeltron
  • 643
  • 5
  • 7
3
votes
2 answers

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 ordered – all in one query. Here's a simplified…
svoop
  • 3,318
  • 1
  • 23
  • 41
3
votes
1 answer

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, so anybody know the better way to do this? or…
mban94
  • 683
  • 1
  • 10
  • 18
2
votes
2 answers

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.9' gem 'pg' gem 'postgres_ext' gem…
paddle42380
  • 6,921
  • 7
  • 32
  • 40
0
votes
1 answer

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!
kreek
  • 8,774
  • 8
  • 44
  • 69
0
votes
1 answer

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 support array datatypes and GIN and GIST index…
Kyle C
  • 4,077
  • 2
  • 31
  • 34
0
votes
1 answer

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.string :pets, :array => true, :limit => 12 And…
Avishai
  • 4,512
  • 4
  • 41
  • 67
0
votes
1 answer

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 uppercase instead of lowercase. How do I patch…
thejaz
  • 2,763
  • 2
  • 26
  • 40