Hi,
Aman: did you test your suggestion? If you create a view from
(nextval('myseq') as id, geom, attr1, attr2) then QGIS will complain
that a layer cannot be created from that view as geom, attr1 and attr2
are not of suitable for use as a unique key (but does not even mention
the view field
On 10/11/2010 01:52 PM, William Furnass wrote:
Hi,
Aman: did you test your suggestion? If you create a view from
(nextval('myseq') as id, geom, attr1, attr2) then QGIS will complain
that a layer cannot be created from that view as geom, attr1 and attr2
are not of suitable for use as a unique
hi all,
i have downloaded the binaries for windows 32bit : postgis-pg90-binaries-2.0svn
when i proceed to run the batch file, this error appears and the whole
process goes wrong:
SET
BEGIN
psql:share/contrib/postgis-2.0/postgis.sql:59: ERROR: could not
access file $libdir/postgis-2.0: No such
This may be a stupid question, so excuse me if it is :)
Do I have to install the 32 bit version of postgresql 9.0 to use the 32 bit
PostGIS 1.5.2? I would think yes, but just want to make sure.
I want to install the latest and greatest on a 64 bit windows machine, and just
installed the 64 bit
As far as I know, all versions of pgsql2shp work just fine on Win7,
and they should do exactly what they are documented to do for the
situation you describe. What exactly are your problems? If the command
had an error and didn't produce any files, what did you type?
-Mike
On 10 October 2010
hi all,
i have downloaded the binaries for windows 32bit : postgis-pg90-binaries-2.0svn
when i proceed to run the batch file, this error appears and the whole
process goes wrong:
SET
BEGIN
psql:share/contrib/postgis-2.0/postgis.sql:59: ERROR: could not
access file $libdir/postgis-2.0: No
The reason I asked is that I had tyo upgrade pgdump in order to get it to
work.
I'm using this (and variations of it)
pgsql2shp -f c:\user\bob\ShapeTest.shp -h localhost -u postgres -P
London2342 PDW
Select the_geom from p_id.image where p_id_id = '1534'
or
pgsql2shp -f myfile.shp
Charles,
Not a stupid question. Yes you have to install PostgreSQL 9.0 32-bit
version to use PostGIS 1.5.2 32-bit binaries
We are still working on the 64-bit PostGIS builds which we will post on
application stack builder when we are done. We are hoping to be done in the
next 2-3 weeks or so.
Bob,
You can ignore that notice. If you are getting no data, then it usually
means your tables are empty or there is some other problem which it should
notify you of.
The No proj file will be generated is just a warning that your data will
lack the meta data required to reproject it with common