| 07:14:06 | sheats: | hello room, I am getting the following error quite frequently in my postgresql log file, and I was wondering if anyone could shed some light |
| 07:14:08 | sheats: | 2008-06-10 09:57:11.894 EDT,"byp","backyardpost",21324,"192.168.144.102:53611",484e8837.534c,2,"idle in transaction",2008-06-10 09:57:11 EDT,6/867832,0,WARNING,22P06,"nonstandard use of \\ in a string literal",,"Use the escape string syntax for backslashes, e.g., E'\\'.",,,,,, |
| 07:14:23 | sheats: | I believe it has something to do with the geometries |
| 07:16:03 | sheats: | I know it is a deprecated warnings about how the strings are being escaped, has this been fixed in a later version of postgis or this is not a postgis problem |
| 07:16:09 | sheats: | ? |
| 07:27:49 | bitner: | sheats: I generally run into that error when I am using regular expressions and the like |
| 07:29:13 | sheats: | Regular expressions in postgresql functions? |
| 07:29:31 | sheats: | or elsewhere |
| 07:31:55 | bitner: | http://www.postgresql.org/docs/8.2/static/functions-matching.html |
| 07:31:56 | sigq: | Title: PostgreSQL: Documentation: Manuals: PostgreSQL 8.2: Pattern Matching ( at www.postgresql.org ) |
| 07:32:02 | bitner: | section 9.7.3.3 |
| 07:40:59 | sheats: | thanks... I will check this out |
| 07:56:54 | murray: | have someone tried here postgis with pgrouting? |
| 07:58:51 | bitner: | I have gone through the workshop ( http://pgrouting.postlbs.org/wiki/WorkshopFOSS4G2007 ) |
| 07:58:55 | sigq: | Title: WorkshopFOSS4G2007 - pgRouting - Trac ( at pgrouting.postlbs.org ) |
| 07:59:05 | murray: | : ) |
| 07:59:24 | murray: | i am trying the A-Star function |
| 07:59:38 | murray: | but getting the error message: |
| 07:59:59 | murray: | server closed the connection unexpectedly. This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. |
| 08:01:26 | : | * bitner has no clue |
| 08:01:43 | murray: | http://nopaste.org/p/aQA8I9JrG |
| 08:01:44 | sigq: | Title: nopaste.com ( beta ) ( at nopaste.org ) |
| 08:02:24 | murray: | mh |
| 08:05:36 | bitner: | perhaps try the mailing list |
| 08:07:20 | murray: | ok |
| 09:55:25 | prakriti: | I need help dealing with MULTIPOLYGONS |
| 09:55:45 | prakriti: | I can't seem to do centoids or extents on them |
| 10:49:10 | jalmeida: | hi, i need to import a shapefile into postgres |
| 10:49:38 | jalmeida: | but i don't know, get a sintax error in line addGemetry( ) |
| 10:50:01 | bitner: | what are you doing? |
| 10:50:04 | jalmeida: | what do is this problem ?? |
| 10:50:55 | jalmeida: | shp2pgsql -D roads1 roads_table my_db > roads.sql |
| 10:50:55 | jalmeida: | psql -d my_db -f roads.sql |
| 10:52:51 | bitner: | you are using the postgresql dump format, not sql insert statements |
| 10:53:26 | bitner: | perhaps try either eliminating the -D option or psql my_db < roads.sql |
| 11:47:38 | pimpaa: | hello! |
| 11:57:01 | prakriti: | will using the -S option on shp2pgsql lose any infromation? |
| 11:58:00 | pimpaa: | no |
| 11:58:05 | pimpaa: | just keeps the geometry simple |
| 11:58:06 | pimpaa: | that is |
| 11:58:27 | pimpaa: | breaks down the geometry to |
| 11:58:38 | pimpaa: | simple. humn...not multi |
| 11:58:51 | prakriti: | so it will make all my MULTIPOLYGON woes go away? |
| 11:58:53 | prakriti: | like magic? |
| 11:59:07 | pimpaa: | yea |
| 11:59:09 | pimpaa: | shoudl |
| 11:59:11 | prakriti: | BRILLIANT! |
| 14:14:04 | doktoreas: | hello everybody |
| 14:14:08 | pimpaa: | hello |
| 14:14:23 | doktoreas: | is it possible using the envelope function to get a BB for a point feature? |
| 14:14:28 | doktoreas: | hi pimpaa! |
| 14:15:16 | pimpaa: | for points yes |
| 14:15:28 | pimpaa: | but individual points dont hve bb |
| 14:16:13 | pimpaa: | got it? |
| 14:18:19 | doktoreas: | ok |
| 14:19:03 | doktoreas: | pimpaa: what you think if I create it from the coint coordinates |
| 14:19:16 | doktoreas: | for example adding/removing a certain value? |
| 14:19:33 | doktoreas: | I need it to set the bound in OL |
| 14:19:39 | doktoreas: | for zooimng to feature |
| 14:19:42 | pimpaa: | humn |
| 14:19:46 | pimpaa: | set for the entire table |
| 14:19:53 | pimpaa: | you can zoom to one coordinate |
| 14:19:55 | pimpaa: | which would be |
| 14:20:02 | pimpaa: | the 1 point "bb" |
| 14:21:37 | doktoreas: | using OL? |
| 14:21:51 | pimpaa: | ol? |
| 14:22:00 | doktoreas: | Openlayers |
| 14:22:13 | pimpaa: | i dont know much about ol |
| 14:22:15 | pimpaa: | to tell you |
| 14:22:26 | pimpaa: | but you for sure can parse a bb or coordinate for it |
| 14:22:29 | pimpaa: | using pgis |
| 14:22:50 | doktoreas: | yep the idea is that |
| 14:23:22 | doktoreas: | writing a server application that get the feature name as input, and prompt out a BB as output |
| 14:23:36 | doktoreas: | the the BB is handled for the zoom to |
| 14:24:10 | pimpaa: | you could define a function in pg |
| 14:24:15 | pimpaa: | to return the bb |
| 14:24:20 | pimpaa: | from a query or from a table |
| 14:24:32 | pimpaa: | but the way to parse that result to OL i dont know |
| 14:24:51 | pimpaa: | actually there is a function to return the bb already |
| 14:24:55 | pimpaa: | look pgis docs |
| 14:25:06 | doktoreas: | pimpaa: envelope? |
| 14:25:13 | pimpaa: | let me look at the reference |
| 14:25:58 | doktoreas: | thanks |
| 14:29:03 | pimpaa: | check st_addbbox |
| 14:29:21 | pimpaa: | i need to go for a sec |
| 14:29:22 | pimpaa: | brb |
| 14:29:54 | doktoreas: | ok |