| 01:08:10 | toby: | Do you know what's happened to the svn repo, it seems to have been unavailable for a few days now? |
| 01:11:06 | toby: | Do you know what's happened to the svn repo, it seems to have been unavailable for a few days now? |
| 01:38:26 | toby: | Does anyone know what's happened to the svn repo, it seems to have been unavailable for a few days now? |
| 05:19:33 | GeomatiLux: | Hello postgis Team, |
| 05:19:51 | GeomatiLux: | I need Help please ? |
| 05:24:05 | GeomatiLux: | I need to create a valid OpenGIS geometries and I have to create a valid SRID in the SPATIAL_REF_SYS table, and then update my geometries to reference the SRID with the following SQL : |
| 05:24:07 | GeomatiLux: | update "ZONE_HYDROGRAPHIQUE" set "ZONE_HYDROGRAPHIQUE"."the_geom" =setsrid( "ZONE_HYDROGRAPHIQUE"."the_geom",4326 ) from "datamart_dfpa"."ZONE_HYDROGRAPHIQUE"; |
| 05:24:43 | GeomatiLux: | It doesn't work |
| 05:34:50 | mloskot: | GeomatiLux: what error you're getting? |
| 05:36:12 | mloskot: | GeomatiLux: and better see postgresql doc about syntax of UPDATE command |
| 05:36:15 | GeomatiLux: | it's sql error but thank you mloskot it's solved : ) |
| 05:36:36 | GeomatiLux: | update "datamart_dfpa"."ZONE_HYDROGRAPHIQUE" set "the_geom" =setsrid( "the_geom",4326 ); |
| 05:37:09 | mloskot: | : ) |
| 07:11:12 | cgs_bob: | just wanted to report that the svn repos is down |
| 07:25:03 | bitner: | cgs_bob: try emailing the mailing list |
| 07:25:30 | bitner: | i'm not sure if any refractions folks are on irc |
| 07:26:15 | cgs_bob: | bitner: I'll do that |
| 07:26:58 | mloskot: | mleslie: seems to be offline |
| 07:27:11 | mloskot: | but refractions' server was down recently, so I'd suggest to wait |
| 07:53:17 | hbarrett: | Can someone help me move a postgis database? |
| 07:57:54 | hbarrett: | The problem Im having is the dumpfile I have was looking for an outdated postgis library and if I try to set it to the new library the names ar all different ie: lwhistogram2d_in in stead of histogram2d_in ) |
| 07:59:57 | hbarrett: | If I try to create an empty postgis database first, I get "type "wkb" is not yet defined" and "type wkb does not exist" |
| 08:01:01 | hbarrett: | What is the standard way of moving old postgis databases on to a new server? |
| 08:22:44 | darkblue_B: | pg_dump -Fc and the upgrade script, I believe hbarrett |
| 08:23:08 | darkblue_B: | though I have also done it by dumping only the data tables with -t tbl1 -t tbl2 etc |
| 08:23:26 | darkblue_B: | and leaving out all the postgis functions ... |
| 08:25:05 | hbarrett: | I have about 200 tables. |
| 08:25:15 | hbarrett: | Would I have to do them one at a time? |
| 08:26:28 | hbarrett: | Also I thought the upgrade script was run on databases. How do I run it on a file? |
| 08:26:34 | darkblue_B: | no.. you mean using the -t tablename form? |
| 08:26:42 | hbarrett: | yes |
| 08:26:45 | darkblue_B: | several questions there |
| 08:26:51 | hbarrett: | sorry |
| 08:26:56 | darkblue_B: | ok |
| 08:27:20 | darkblue_B: | what I did was .. write a script of some kind that gave me the names of the tables in some kind of text output |
| 08:27:38 | darkblue_B: | then search and replace and turn that into something useful |
| 08:28:10 | darkblue_B: | for example, a pg_dump command line with -t tblName1 -t tblName2 ... -t tblNameN |
| 08:28:38 | darkblue_B: | ( I have used the same technique with setting access GRANTs, because mass GRANT doesnt work that I know of ) |
| 08:28:57 | darkblue_B: | Q #2.. the upgrade script |
| 08:29:32 | darkblue_B: | I am not looking at it now.. but I found the drection in the manual for hard upgrade to be basically working |
| 08:29:52 | darkblue_B: | it tells you the order of events.. |
| 08:31:30 | hbarrett: | Ok Thanks, I will look at the manual for the upgrade script and give that a try. |
| 08:31:37 | darkblue_B: | ok, good luck |
| 08:31:43 | hbarrett: | Thanks |
| 11:43:20 | bcrosby: | ugh |
| 11:43:59 | bcrosby: | how can I explain this |
| 11:44:07 | bcrosby: | if you are returning rows from two tables |
| 11:44:25 | bcrosby: | how do you include null values for columns where rows dont exist in theo ther table? |
| 11:46:08 | bitner: | read up on full, left, right, and inner joins |
| 11:46:46 | bitner: | depending on the type of join and the order of the tables, you'll maintain the nulls |
| 11:47:09 | bcrosby: | ahh yup |
| 11:47:14 | bcrosby: | thanks |
| 12:53:42 | hbarrett: | OK, so I used the command "sh utils/postgis_restore.pl lwpostgis.sql newdbname olddbname -E=UNICODE > restore.log" and everyting seemed to work, but when I looked at the database the blk00_dd table was empty. |
| 12:53:57 | hbarrett: | I grepd for errors and found: |
| 12:54:04 | hbarrett: | ERROR: parse error - invalid geometry |
| 12:54:18 | hbarrett: | CONTEXT: COPY blk00_dd, line 131420, column the_geom: "SRID=4269;MULTIPOLYGON( EMPTY )" |
| 12:54:52 | hbarrett: | Can anyone help? |
| 14:07:01 | darkblue_B: | hbarrett: hello |
| 20:34:50 | CIA-7: | kneufeld * r2931 /trunk/doc/ ( reference.xml reference_new.xml ): moved ST_IsClosed to the new documentation template. |