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.

learn more… | top users | synonyms (3)

0
votes
0answers
11 views

codeigniter/postgres throw errors when trying to insert timestamp

I'm trying to use this code, plus codeigniter to $data = array( // 'category' => $dbi['category'], 'transaction_timestamp' => time(), ); $this->db->insert('bitzon', $data); Error ...
0
votes
3answers
17 views

Can't deploy to heroku [heroku log included]

I'm having trouble deploying to Heroku, I've installed postgresql but I don't think I've configured it properly. This may or may not be the problem, but I have a hunch it has something to do with it. ...
0
votes
1answer
11 views

Rails, CKEditor, PostgreSQL, image upload with Carrierwave

When I try to insert an image into my blog I select the Upload tag and select my file and Send it to Server. Then at the URL tab I select Browse Server and I get the following error: ...
0
votes
1answer
13 views

How can I get a String from this Geometry Object with hibernate and PostGIS

I would like to return the output (Output is "0101000020E610000000000000000024400000000000002440" in geometry type) of this SQL Postgis query select ST_GeometryFromText('POINT(10 10)',4326) in Java ...
1
vote
0answers
19 views

Join two tables using id and descendants from tree like table

I have the following tables: CREATE TABLE element ( element_id serial NOT NULL, local_id integer, name varchar, CONSTRAINT pk_element_id PRIMARY KEY (element_id), CONSTRAINT fk_element_local_id ...
1
vote
1answer
21 views

Converting an logical model to a physical model. Trouble understanding ERD

I'm working with an ERD. It is supposedly a logical model and I am supposed to make a physical model from it. I should be formatting in UML and our DBMS is PostgreSQL. Some of my research ...
0
votes
0answers
13 views

org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host

I am writing a web application that uses Hibernate to connect to Heroku Postresql. Everything works fine when the application is deployed to Heroku but I get the following exception when I run the ...
1
vote
1answer
23 views

How can I seperate reads and writes with a multi-db setup with django & postgresql?

as some of you are aware Django has multi-db support. This can be achieved by writing a dbrouter to send writes to the master database and all the reads to the slave, but as stated on the Django Docs ...
0
votes
1answer
21 views

Run pgTAP with Perl prove instead of pg_prove

I have a test-suit as usual for Perl projects, containing a lib and a t directory. The tests in t are structured through subdirectories. So I run them using: prove -Ilib -r t/ So far nothing ...
1
vote
4answers
52 views

Calling PHP file from JQuery to check unique identifier

I'm trying to do this http://web.enavu.com/tutorials/checking-username-availability-with-ajax-using-jquery/ to check the avaliability of some id's while the user is filling some forms, but I'm using ...
0
votes
2answers
13 views

PG::Error: ERROR: new encoding (UTF8) is incompatible

I have installed postgresql-9.2.4 from the source, now in rails app when I execute: rake db:create command I get: $ bin/rake db:create RAILS_ENV="test" PG::Error: ERROR: new encoding (UTF8) is ...
0
votes
1answer
23 views

Creating a table with PSQL as clone of another table but excluding a column

Short Version: What psql command should I use to create temporary table, which is a clone of a given table, excluding a given column? create temp table bar_temp as <columns from foo.bar excluding ...
0
votes
1answer
39 views

UPDATE with ORDER BY

Need to "tie" UPDATE with ORDER BY. I'm trying to use cursors, but get the error: cursor "cursupd" doesn't specify a line, SQL state: 24000 Code: BEGIN; DECLARE cursUpd CURSOR FOR SELECT * ...
0
votes
2answers
25 views

PostqreSQL Duplicate Values WHERE NOT EXISTS

I made this code: INSERT into author(authorfirstname1, authorlastname1,authorfirstname2, authorlastname2) select ...
1
vote
0answers
15 views

Pgrouting - Shortest Path function dynamic parameter

I have a bicycle network, which contains mixed records with directed and undirected edge, with the following information: gid start_node end_node link cost bidirected (with value 'Y', 'N') ecc. My ...

1 2 3 4 5 … 1141
15 30 50 per page