hstore Questions
2
I am trying to implement the Hstore-Datatype and use it in JPA Entities. However, when I try to persist some testdata, I get several errors.
For implementing the Hstore-Datatype I used the followin...
2
I'm just modeling a PostgreSQL data base for a new project that needs localization-support. I wonder if hstore might be a good way to localize certain data-fields.
For example: let's take a simpli...
Breeding asked 3/11, 2015 at 18:20
4
Solved
I am using PostgreSQL 9.1.4 with hstore and the PostgreSQL JDBC driver (9.1-901.jdbc4).
I am trying to use the contains operators (?, ?&, ?|) in a PreparedStatement, however the ? character is...
Hardison asked 13/8, 2012 at 18:45
3
Solved
Is there a way to use PostgreSQL json/hstore with JdbcTemplate? esp query support.
for eg:
hstore:
INSERT INTO hstore_test (data) VALUES ('"key1"=>"value1", "key2"=>"value2", "key3"=>"...
Providential asked 27/1, 2014 at 14:30
6
I've installed the hstore extension successfully, and everything works when I syncdb. (I'm using djorm-ext-hstore)
However, nose creates a new temp database to run tests in, and hstore is not inst...
Pistareen asked 3/5, 2013 at 9:39
1
Is it possible to filter a queryset by casting an hstore value to int or float?
I've run into an issue where we need to add more robust queries to an existing data model. The data model uses the H...
Ohare asked 21/4, 2016 at 23:14
2
Solved
Recently I went into trouble trying to use hstore with Django. I installed hstore this way:
$ sudo -u postgres psql
postgres=# CREATE EXTENSION hstore;
WARNING: => is deprecated as an operator ...
Hammons asked 20/7, 2012 at 18:10
3
Solved
First of all, this may look like a duplicate of:
postgres hstore exists and doesn't exist at same time
but it is not. While I am getting the same error message in the circumstance. When chec...
Modesta asked 20/2, 2014 at 13:34
3
Solved
When I attempt to enable hstore on my database:
=> CREATE EXTENSION IF NOT EXISTS hstore;
ERROR: permission denied to create extension "hstore"
HINT: Must be superuser to create this extension....
Quinone asked 21/12, 2013 at 20:12
3
Solved
I'm playing around with Hstore for the first time in a rails4 app, and I am using javascript in a form to build out dynamic form fields for the hstore column (:schema)
In rails 4 I dont need to ad...
Difficulty asked 27/9, 2013 at 15:27
2
Solved
I've read the docs and it appears that there's no discernible way to perform an ALTER TABLE ... ALTER COLUMN ... USING statement to directly convert a json type column to an hstore type. There's no...
Protamine asked 4/2, 2015 at 7:39
2
Solved
I'm having some troubles deciding on which approach to use.
I have several entity "types", let's call them A,B and C, who share a certain number of attributes (about 10-15). I created a table call...
Tennes asked 4/2, 2014 at 18:31
2
Solved
I have table files which has hstore column details. In my sql statement I insert data to it:
UPDATE files SET details = 'new_users=>new_users_count'::hstore where id = v_file_id;
but I want ...
Antecede asked 20/10, 2015 at 7:29
3
Solved
I tried to use django-hstore using this nice tutorial. I added two classes to an existing app managed by South:
class Attribute(models.Model):
name = models.CharField(max_length=200, verbose_na...
2
Solved
I'm trying to write a Spark Dataset into an existent postgresql table (can't change the table metadata like column types). One of the columns of this table is of type HStore and it's causing troubl...
Outpatient asked 5/12, 2016 at 12:5
7
I have a Rails app that aggregates a lot of data from Google API's. I store the JSON responses in MongoDB currently (so my Rails app has both pg and mongo). However, today, I've came across Postgre...
Toot asked 17/9, 2013 at 23:50
2
Solved
I'm working on a project that needs to use hstore on multiple schemas.
The 'public' schema, where the hstore extension was being installed isn't available everywhere, because my scope doesn't looku...
Goodspeed asked 2/10, 2013 at 20:39
1
I'd like to store a simple map of key-value strings as a field in my PostgreSQL table. I intend to treat the map as a whole; i.e, always select the entire map, and never query by its keys nor value...
Miltonmilty asked 6/4, 2017 at 16:41
1
I am running PostgreSQL 9.5.3 Fedora Linux, and I tried to create the "hstore" extension:
CREATE EXTENSION IF NOT EXISTS hstore;
But I got this error:
could not open extension control ...
Acadia asked 29/8, 2016 at 11:22
1
Is there an equivalent of Postgresql's hstore within SQL Server? I'm running SQL Server 2008 with a web application that has an increasingly large need for sparse key/value pairing on the database....
Gynaecomastia asked 22/1, 2014 at 16:17
1
Solved
For hstore columns in PostgreSQL databases, I know I can use a "LIKE" query like so in Ruby on Rails to search for names that include a certain string:
Product.where("hstore_data -> 'author' L...
Lorenzoloresz asked 11/4, 2016 at 6:0
4
Solved
When using hstore in Postgresql 9.2 in a Rails 3.2 app, I got an error complaining as follows when raking my test database:
PG::Error: ERROR: type "hstore" does not exist
Since it built from sche...
Krenn asked 22/9, 2012 at 5:3
3
Solved
I currently have the following db schema:
create_table :user_actions do |t|
t.integer :emitter_id
t.string :emitter_type
t.integer :target_id
t.string :target_type
t.json :payload
t.timestam...
Rezzani asked 17/6, 2014 at 8:54
2
Solved
Assuming I have a Hibernate/JPA Entity like the following:
@Entity
public class FooEntity {
...
@Type(type = "hstore")
HashMap<String, String> tags;
}
... and the hstore Type is a sim...
Doings asked 1/7, 2014 at 18:36
1
Solved
I'm trying to write a migration to convert an existing hstore column to JSON (not JSONB).
I tried different solutions json USING cast(hstore_column as json), some functions found over github, but ...
Spleeny asked 16/11, 2015 at 9:55
1 Next >
© 2022 - 2024 — McMap. All rights reserved.