Tagged Questions
PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for many platforms including Linux, UNIX, MS Windows and Mac OS X. Please mention your PostgreSQL version when asking questions.
0
votes
0answers
13 views
saving an image from iphone to Django & postgres
my xcode code:
NSData *imageData = UIImageJPEGRepresentation(self.avatarImage, 1.0);
NSString *encodedImageString = [imageData base64Encoding];
parameters[@"avatarImage"] = encodedImageString;
then ...
-1
votes
0answers
14 views
How to install hstore in Postgresql on Mac OSX? [on hold]
So I'm trying to install hstore in Postgres on Mac OSX 10.9, but I'm having major troubles with it. First I had some trouble getting psql to work after installing postgresql using brew, so I finally ...
0
votes
1answer
12 views
Postgresql not installing with postgresql cookbook
I just started using Chef and I'm trying to get Postgresql installed on an EC2 instance. I'm using the knife-ec2 gem to help with this.
When I run knife ec2 server create -r "role[postgresql]" the ...
0
votes
0answers
9 views
clustering points in postgresql to create contour map
I have a postgresql / postgis table with a grid of weighted points, and I'd like to essentially create a contour map of those points. My goal is to get one or more polygon that surrounds points of a ...
0
votes
1answer
27 views
Using non-standard postgres operators with SQL Korma
Some complex features of Postgres utilize operators that are not part of the SQL standard. One simple example is the set of POSIX regular expression operators; I need them to include a where clause ...
0
votes
1answer
16 views
Postgres recovery.conf options
I am setting up Postgres binary replication.
In my slave's recovery.conf, I am suggested to have 2 options.
I am wondering if the directory specified in restore_command and archive_cleanup_commands ...
0
votes
2answers
20 views
Select rows in SQL that do not exist, given the existence of their references
Suppose that I have a table rating which is unique to the pair user and client.
The schema of rating would hold user_id and client_id along with some other information (like score and comment).
At ...
-3
votes
0answers
29 views
How could I revise postgresql source code to add extra token and methods? [on hold]
In my project, I need to customize Postgres by adding extra tokens and methods. For a common query in Postgres, it is processed as following:
client: query(SELECT ...)
server: ...
2
votes
2answers
27 views
how to create a Foreign-Key constraint to a subset of the rows of a table?
I have a reference table, say OrderType that collects different types of orders:
CREATE TABLE IF NOT EXISTS OrderType (name VARCHAR);
ALTER TABLE OrderType ADD PRIMARY KEY (name);
INSERT INTO ...
-1
votes
3answers
19 views
After Converting MySQL to PG, Getting Error : PG::NotNullViolation: ERROR: null value in column “id” violates not-null constraint
After Convert My database mysql to pg, I am getting error like
PG::NotNullViolation: ERROR: null value in column "id" violates not-null constraint
DETAIL: Failing row contains (null, ...
0
votes
0answers
31 views
PostgreSQL “DatabaseError: current transaction is aborted”
I installed OSQA and I synchronized (syncdb and migrate) the databases and I restarted Apache.
In the browser I got the HTTP Status 200 Error and in the project logs I got a lot of errors with this ...
0
votes
0answers
17 views
Indexing for efficient querying and pagination of financial data in PostgreSQL
I'm working in an API that needs to return a list of financial transactions. These records are held in 6 different tables, but all have 3 common fields:
transaction_id int NOT NULL,
account_id ...
0
votes
1answer
25 views
Is there a way in SQL to import ALL .csv contained in a directory to my postgres table? (window os)
Is there a way in SQL to import ALL csv contained in a directory to my postgres table ?
Thank you for your help.
0
votes
1answer
24 views
How to set DateTime.Now when inserting in postgresql table?
We ship images and the default culture setting for our image is MDY.
The customer server where the image is installed has a locale of DMY has been using our image for a few days and then noticed ...
0
votes
3answers
57 views
Execution time select * vs select count(*)
I'm trying to measure execution time of a query, but I have a feeling that my results are wrong.
Before every query I execute: sync; echo 3 > /proc/sys/vm/drop_caches
My server log file results ...
