The postgresql-9.0 tag has no wiki summary.
1
vote
1answer
12 views
Is it possible to use a stable function in an index in Postgres?
I've been working on a project at work and have come to the realization that I must invoke a function in several of the queries' WHERE clauses. The performance isn't terrible exactly, but I would love ...
0
votes
1answer
35 views
how to generate fixtures for postgresql schema and tables using django
I am using django and postgresql db to develop my project, the db has 3 schemas. And I am writing raw quires using connection string to fetch data and insert data into tables.
Example:
from ...
1
vote
2answers
38 views
Is there any difference between integer and bit(n) data types for a bitmask?
I am working with a table in a PostgreSQL database that has several boolean columns that determine some state (e.g. published, visible, etc.). I want to make a single status column that will store all ...
0
votes
0answers
37 views
How to assign value of INSERT INTO … RETURNING to a variable? [closed]
Possible Duplicate:
Variable value assignment using RETURNING clause
The following code snippet inserts a row into a table and uses the primary key of the inserted row in a foreign key ...
3
votes
1answer
26 views
Returning distinct list of IDs existings in all subsets
I have two tables
Table "public.tags_to_entities"
Column | Type | Modifiers
--------+---------+-----------
tid | integer | not null
eid | integer | not null
Table "public.tag_tree"
...
1
vote
1answer
57 views
MacPorts: switching between postgresql90-server and postgresql91-server
Switching the postgresql client from postgresql90 to postgresql91 is simple enough, using MacPort's port select command like this:-
calvin$ sudo port select --set postgresql postgresql91
Selecting ...
1
vote
1answer
123 views
Anorm broken in PostgreSQL 9.0 Selects with Order By?
I'm trying to build a list page like the one in the "Computers" sample. My environment is Play 2.0 and PostrgreSQL 9.0
I have the following method in my User object:
def list(page: Int = 0, ...
0
votes
1answer
36 views
PostgreSQL using XID as unique entry in a table
I couldn't find how to set a xid (transaction ID type) column to be unique in a table. It complains about class method missing for btree and I have no clue how to get around it.
This is using ...
0
votes
1answer
34 views
How do I uninstall the uuid_ossp module in postgresql 9.0.4?
I used the following command to install the postgres UUID_OSSP module in version 9.0.4 :
$psql -d <database> -U <user> -f <path to>/uuid-ossp.sql
How do I uninstall this? I am ...
1
vote
1answer
78 views
Multiple ordering options
It is very common for a web page to have multiple ordering options for a table. Right now I have a case where there are 12 options (ordenable columns). The easiest (that I know of) way to do it is to ...
1
vote
1answer
68 views
How to get a list of words from a Full Text Search dictionary
Is there a way to query a dictionary using SQL in PostgreSQL, to get a list of words in that dictionary? I'm using Postgres 9.0.
0
votes
1answer
25 views
Within Table Subquery of Identical Combinations
I would like to select groups that have the exact same attributes from a table. For example, my table is like the following
facs_run_id | fcj_id
1 | 17
1 | 4
1 ...
1
vote
1answer
128 views
ERROR: function unnest(integer[]) does not exist in postgresql
SELECT UNNEST(ARRAY[1,2,3,4])
While executing the above query I got the error like this:
ERROR: function unnest(integer[]) does not exist in postgresql.
I am using PostgreSQL 8.3 and I have ...
0
votes
3answers
136 views
postgresql error PANIC: could not locate a valid checkpoint record
When I load up the postgres server (v9.0.1) i get a panic that prevents it from starting:
PANIC: could not locate a valid checkpoint record
How can I fix this?
2
votes
1answer
59 views
Can't drop GIN index in Postgres
I have a table which looks like this:
Column | Type |
----------------------+-------------------------+
...
thing | tsvector |
...
...
