Tagged Questions

-1
votes
0answers
43 views

upgrading postgres issue 9.1 to 9.2 [closed]

On going from postgres 9.1 to 9.2, it says that the data bases need to be upgraded so on giving the upgrade command I give and get the following $ sudo service postgresql upgrade Stopping postgresql ...
0
votes
1answer
63 views

How to call a function of postgis-1.5.dll in c code

I'm creating an Postgresql extension in c that use Postgis Point. when i try to call a function of postgis-1.5.dll after loading it, it fails and i get no error message Here is a small part of my ...
1
vote
2answers
40 views

How do I make a script that properly introduces hstore in both 9.0 and 9.1?

I am trying to introduce the hstore type into the database of a project I'm developing. But the problem is that I have a slightly newer version of the Postgres server installed on my development ...
1
vote
1answer
137 views

sec_to_time() function in PostgreSQL?

MySQL has a cool function sec_to_time() which converts your number of seconds to hh:mm:ss I've read through the mailing lists and am basically trying to implement the following: MySQL: select ...
1
vote
4answers
832 views

DATE_FORMAT in postgresql

Hi i'm working in postgresql i need to convert the date format in query itself, in mysql there is option called DATE_FORMAT using that we can convert Select DATE_FORMAT(date_time, '%b %e, %Y, %T') ...
1
vote
2answers
150 views

Exponential issue in postgresql

I'm facing an issue with the exponential function in postgresql. If I use this select statement select exp(5999), I'm getting: ERROR: value out of range: overflow SQL state: 22003 If I use this ...
1
vote
1answer
195 views

Replication of postgres database at table level

I am just wondering whether it would be possible to replicate only a table in a postgres database with another database instance. For example, lets say that I have a postgres instance running at hostA ...
1
vote
1answer
450 views

How to create a read-only user in PostgreSQL?

I want to create a read-only user in PostgreSQL. The intention is to have a publicly accessible data explorer, where users can write custom SQL queries. I do this to create the user: CREATE USER ...
1
vote
2answers
300 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 ...