| 03:06:36 | arkygeek: | hi. :- ) |
| 03:07:07 | arkygeek: | I can't seem to figure out what I've done wrong with my install of PostGIS on my kubuntu box... |
| 03:07:28 | arkygeek: | one thing that might be plauging me is the fact that I have 8.2 and 8.3 installed... |
| 03:07:38 | arkygeek: | but I have specified the binary to use ( 8.3 ) |
| 03:08:06 | arkygeek: | this is the command I used: |
| 03:08:20 | arkygeek: | postgres@arkygeek-lab:/usr/share/postgresql-8.3-postgis$ /usr/lib/postgresql/8.3/bin/psql -f ./lwpostgis.sql -d template1 |
| 03:09:10 | arkygeek: | and this is an example of the errors i am getting.... |
| 03:09:18 | arkygeek: | psql:./lwpostgis.sql:6430: ERROR: current transaction is aborted, commands ignored until end of transaction block |
| 03:09:18 | arkygeek: | ROLLBACK |
| 06:00:51 | Gianfranco: | HI all |
| 06:16:54 | Gianfranco: | I am trying to connect Mapguide Studio with a PostGis db via fdo, but I have some problems... Can anyone helps me? |
| 07:50:55 | pewter: | mildly random question -- I'm trying to type up some documentation of my postgis stuff for other folks in my office to use, and I can't seem to find a tutorial that I followed... all I can remember is that by default it leads you to making a schema called 'gis_schema' and that the username they use in the tut is 'gis' |
| 07:51:01 | pewter: | anyone know the tutorial I'm thinking of? |
| 07:51:06 | pewter: | ( and yes, I've checked google ) |
| 08:09:21 | pewter: | found it! http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/ |
| 08:09:25 | sigq: | Title: Installing PostGIS on Ubuntu : Thinking in GIS ( at www.paolocorti.net ) |
| 08:09:26 | pewter: | thank you all for your hard work :-P |
| 09:07:47 | c0re: | anyone have a quick example of howto join two tables by wkb_geometry and pull values from both if they intersect? |
| 09:21:47 | bitner: | select * from a,b where st_intersects( a.geom,b.geom ) |
| 09:52:43 | c0re: | bitner: thanks, i just figured it out |
| 13:52:57 | mib_z448vylj: | . |