[GENERAL] what the problem with this query

Hi all,   When i try to run the following query it gives the following error what was wrong in the query.Query:SELECT o.orgunitname AS ouname, e.entrynumber AS value_field, centroid(c.the_geom) AS the_geom, c.ogc_fid AS ogc_fid FROM (ctrphc AS c INNER JOIN orgunit o ON c.dhs_ouname = o.orgunitname)

[GENERAL] How can i import .backup file into the database

Dear List,    I am trying to import tables from a file called choro.backup.I have created a db called dhis.Is this not possible to import data from a .backup file.If it is not possible then how can i import the data into my database.Can you please give me the steps how to import the data from a .ba

[GENERAL] what is this error

Dear List,    I have created a database called dhis13 and created a login role with user name venu and pwd gis now i have created an sql file using shp2pgsql command it worked successfully when i m importing the same to the dhis13 database i was giving with the following error all the database and

[GENERAL] getting failed while creating user accounts

Hi all, I m trying to install postgres8.1 on my system.I tried with account name postgres.I was getting an error of unable to create user account.user account already exists. If i try with any other user any of the following error is arising 1.unable to create user account.user account alre

[GENERAL] hi problem again with installing postgres8.1

d it to be installed to get worked with maps using PGIS. Can u give me the solution ASAP. Thanks and Regards, Venu. --- Tino Wildenhain <[EMAIL PROTECTED]> wrote: > venu gopal schrieb: > > Hi all, > > I am new to pgsql family.I had a problem with > > ins

[GENERAL] hi problem with installing postgresql8.1

Hi all, I am new to pgsql family.I had a problem with installing postgres8.1 i was getting the following error at the 4th step of installation the error is as follows: Data directory error: The specified data directory is not empty If you have an existing database with teh same major ver