[postgis-users] Installation problem

Dear Sir , I installed postgres Standard Server 8.4.After that when i want connect to database on localhost computer i get mesage "Could not connect to server:Invalid argument(0x2726/10022) Is the server running on host "127.0.0.1" and accepting TCP/ip connections on port 5433?" Please He

Re: [postgis-users] Search Engine

Hi! > one should try not to modify database structures just for something like > text searching. > Reality is that very often you cannot modify them (let alone being the db about GIS or not), because you have poorly documented legacy apps that rely on them. Or they are decently documented by you

Re: [postgis-users] Search Engine

Uli, we should not drift too far into a discussion about how you would do it with SQL Server. This was not Ricardos question. But I admit I have to specify some of my comments to get clearer. That's true. My main point is not that SQL Server is good (far from it), is that one should try not t

Re: [postgis-users] Search Engine

Uli, There are built in trigger functions for tsearch. We have some articles on the topic here - look at the cheat sheet for some examples of trigger use. http://www.postgresonline.com/journal/categories/30-tsearch There are a lot of ways to do this. You could get by with just a functional ind

Re: [postgis-users] PostGIS PHP setup on Windows 7

Are you sure you are suing PostGIS? PostGIS geometry type is just geometry. I believe ESRI PostgreSQL SDE calls their datatype sde.st_geometry which seems closer to what you are trying to do there. So your query for PostGIS should be just CREATE TABLE polygon_test (p1 geometry); We use Pos

Re: [postgis-users] postgres data tables package (ORACLE Formsreplacement?)

John, For the web solution I use WaveMaker with but haven't done anything too fancy with it yet. http://www.wavemaker.com/ SQL Workbench might be another option. http://www.sql-workbench.net/ Eric Eric Randall GIS DB Admin/Analyst County of Erie 140 W 6th St Room 111 Erie, PA 16501 ph. 8

[postgis-users] PostGIS PHP setup on Windows 7

I'm not configuring PHP to work with PostGIS. So, when I try in PHP: require_once 'postgresqlConnect.php'; //make a connection to the database pg_query("CREATE TABLE polygon_test (p1 st_geometry)"); I get: *Warning*: pg_query() [function.pg-query

Re: [postgis-users] how delete null value

On Thu, 2010-08-05 at 07:53 -0700, Akhilesh Gan wrote: > how to delete null values in table for geometry column Do you want to delete the complete record or just avoid the null? If the later, I think NOT NULL constraint will do just fine. If you want to delete the record its very easy. DELETE fr

[postgis-users] how delete null value

how to delete null values in table for geometry column ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] postgres data tables package (ORACLE Forms replacement?)

Hi John, OpenOffice is ok if you do not use views, you can create neat forms and there's also the option to edit data in tabular displays. Reports are also handy. But if you use views, OpenOffice simply don't deal with them. Best of luck, Luís On Thu, Aug 5, 2010 at 2:53 PM, John Callahan wro

Re: [postgis-users] postgres data tables package (ORACLE Forms replacement?)

Hi John, For the desktop, the best I've seen is MS Access, but it is certainly not FOSS. It is well used, documented, supported, easy form development, etc. A runner up is OpenOffice.org, but I haven't been able to develop too much on it, because I run into odd GUI behaviours that are deal-breaker

[postgis-users] postgres data tables package (ORACLE Forms replacement?)

Brief background: We're currently using Oracle for our main database. Nothing too big, 15 - 20 tables and the largest table has about 100K records. We use Oracle Forms as a web-based option for inserting and updating records. I am using Postgres/PostGIS for a couple of other projects. I would l

Re: [postgis-users] Search Engine

Simon, we should not drift too far into a discussion about how you would do it with SQL Server. This was not Ricardos question. But I admit I have to specify some of my comments to get clearer. > decision but it is foolish to suggest that "you should not do anything like > search tables one after

Re: [postgis-users] Backup and Restore of a PostGis database

Thanks for all the answers so far, the suggestion to export only the relevant schemas seems to me the most viable; I'll try that and report back. To Brent's question: the problem is that the restore fails once it encounters an error, no objects are created. Thank you, Luís On Wed, Aug 4, 2010 a

Re: [postgis-users] Search Engine

Uli, Clearly, if you want to search across different tables you need a way to combine data in a common place. You should not do anything like search the tables one after the other and combine the results. There may be a software limitation in PostgreSQL that supports this as a technical deci