| 00:43:01 | CIA-6: | mcayland * r2864 /trunk/lwgeom/lwgeom_estimate.c: Fix for segfault in ANALYZE due to incorrect use of legacy BOX type within compute_geometry_stats( ) ( Fixes GBT#43 ). Thanks to Landon Fuller for the bug report and fix. |
| 00:44:36 | CIA-6: | mcayland * r2865 /branches/1.3/lwgeom/lwgeom_estimate.c: Fix for segfault in ANALYZE due to incorrect use of legacy BOX type within compute_geometry_stats( ) ( Fixes GBT#43 ). Thanks to Landon Fuller for the bug report and fix. |
| 01:13:02 | arkygeek: | hi everyone |
| 01:13:03 | arkygeek: | :- ) |
| 01:15:29 | arkygeek: | http://rafb.net/p/KyPP4b44.html |
| 01:15:31 | sigq: | Title: Nopaste - why are there repeats? ( at rafb.net ) |
| 01:16:49 | arkygeek: | eep! I see why all of a sudden |
| 01:16:56 | : | * arkygeek runs off to hide. |
| 07:41:00 | cgs_bob: | hello all. I have a geology map that covers several quads. is there a way in postgis to cut out a particular quad and have the edge polygons closed by the quad boundary? |
| 22:00:20 | epifanio: | hi guys, i've a pgsql-8.2+postgis-1.2.1 dump , tring to restore it on pgsql-8.3 + postgis-1.3 i have a lot of error |
| 22:00:24 | epifanio: | please how can i restore the 8.2 dump on a machine that have 8.3 + 1.3 |
| 22:03:46 | epifanio: | when i try to restore the 8.2 dump into the 8.3 ... it search for a file located in the 8.2 directory ... that does not exist .. |
| 22:04:47 | darkblue_B: | did you use pg_dump -Fc ? |
| 22:05:19 | darkblue_B: | epifanio: |
| 22:05:38 | epifanio: | no, only pg_dump :-/ |
| 22:06:00 | darkblue_B: | pg_dump never works.. 8.2, 8.3 whatever |
| 22:06:15 | darkblue_B: | I used pg_dump -t Table1 -t Table2 ... |
| 22:06:43 | darkblue_B: | and got the data tables.. then created the PostGIS DB fresh and laoded the tables |
| 22:07:02 | darkblue_B: | spatial_ref_sys and geomtery_columns are pretty easy to make |
| 22:07:32 | epifanio: | so to extract the table "table1" from the db : "dbname" , what is the right sintax to use ? |
| 22:07:34 | darkblue_B: | .. just recently I actually followed the manual for hard upgrade and used the perl scrpt |
| 22:07:59 | darkblue_B: | I think its simple |
| 22:08:05 | : | * epifanio googling about hard upgrade |
| 22:08:16 | darkblue_B: | PostGIS manual section 2.2.2 |
| 22:09:44 | darkblue_B: | to extract just the data tables, pg_dump -t TableName DBName > out.sql |
| 22:09:47 | darkblue_B: | I think |
| 22:10:05 | darkblue_B: | -t t1 -t t2 -t t3 |
| 22:11:13 | epifanio: | ok ! i'll try both option , first the hard_upgrade if problems come out i'll try the table by table otion |
| 22:11:23 | epifanio: | *option |
| 22:11:40 | epifanio: | darkblue_B: thanks for these suggestion! |
| 22:11:53 | darkblue_B: | epifanio: you are welcome |