Обсуждение: relations in PostgreSQL 8.1
Hi there, I am working with postgreSQL 8.1, postGIS and pgAdmin III. I am creating a geodatabase and I am novice in thistools, How I relationship my tables? there is some model? Regards.
--- Omar Zevallos <omzeta@hotmail.com> wrote: --------------------------------- >> Hi there, I am working with postgreSQL 8.1, postGIS and pgAdmin >> III. I am creating a geodatabase and I am novice in this tools, >> How I relationship my tables? there is some model? >> Regards. one table has a primary (unique) key which is inserted into the foreign key link in a related table. Omar, examples tend to be the easiest way to learn. how about you give example tables that you want to relate and then i, or someone else here, can show you how to relate the table? __________________________________________ Yahoo! DSL Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com
Hi, I have installed PostgreSQL 8.1 for windows, this version comes with PostGIS? becouse I have an application that usesa postgreSQL database and when I execute it, it raises an exception: "function postgis_version() does not exist" I supposed that the installers of this version of PostgreSQL came already with PostGIS because I get insert geographicdata a table that I created. Regards. From: <operationsengineer1@yahoo.com>To: Omar Zevallos <omzeta@hotmail.com>, pgsql-novice@postgresql.orgSubject: Re:[NOVICE] relations in PostgreSQL 8.1Date: Wed, 7 Dec 2005 09:35:05-0800 (PST)>--- Omar Zevallos <omzeta@hotmail.com> wrote:>>---------------------------------> >>Hi there, I am working with postgreSQL 8.1, postGIS>and pgAdmin> >> III. I am creating a geodatabaseand I am novice in>this tools,> >> How I relationship my tables? there is some model?> >>Regards.>>one table has a primary (unique) key which is inserted>into the foreign key link in a relatedtable.>>Omar, examples tend to be the easiest way to learn.>how about you give example tables that you want to>relate and then i, or someone else here, can show you>how to relate the table?>>>>__________________________________________>Yahoo!DSL Something to write home about.>Just $16.99/mo.or less.>dsl.yahoo.com>>>---------------------------(end of broadcast)--------------------------->TIP2: Don't 'kill -9' the postmaster
[Please post in plain text, not HTML.] On Fri, Jan 06, 2006 at 02:12:51AM +0000, Omar Zevallos wrote: > Hi, I have installed PostgreSQL 8.1 for windows, this version comes > with PostGIS? becouse I have an application that uses a postgreSQL > database and when I execute it, it raises an exception: > > "function postgis_version() does not exist" Standard PostgreSQL installations don't come with PostGIS, although somebody might have created a package that bundles them together. Where did you get PostgreSQL? > I supposed that the installers of this version of PostgreSQL came > already with PostGIS because I get insert geographic data a table that > I created. What exactly are you doing? PostgreSQL has its own geometric types that are different than the PostGIS types -- are you sure you're not confusing them? -- Michael Fuhr
hi, I see, I was confusing the data types. But, How I make to install PostGIS in Win2000 Pro? I was reading the aid to install PostGIS and it says that I must install CygWin, when installing it and to run ./configure,say: "no acceptable C compiler found in $PATH" help please... From: Michael Fuhr <mike@fuhr.org>To: Omar Zevallos <omzeta@hotmail.com>CC: pgsql-novice@postgresql.orgSubject: Re:[NOVICE] PostgreSQL 8.1Date: Thu,5 Jan 2006 20:52:33 -0700>[Please post in plain text, not HTML.]>>On Fri, Jan 06, 2006 at02:12:51AM +0000, Omar Zevallos wrote:> > Hi, I have installed PostgreSQL 8.1 for windows, this version comes>> with PostGIS? becouse I have an application that uses a postgreSQL> > database and when I execute it,it raises an exception:> >> > "function postgis_version() does not exist">>Standard PostgreSQL installationsdon't come with PostGIS, although>somebody might have created a package that bundles them together.>Where did you get PostgreSQL?>> > I supposed that the installers of this version of PostgreSQL came> > already withPostGIS because I get insert geographic data a table that> > I created.>>What exactly are you doing? PostgreSQLhas its own geometric types>that are different than the PostGIS types -- are you sure you're>notconfusing them?>>-->Michael Fuhr>>---------------------------(end of broadcast)--------------------------->TIP4: Have you searched our list archives?>> http://archives.postgresql.org
On Fri, Jan 06, 2006 at 04:05:57AM +0000, Omar Zevallos wrote: > hi, I see, I was confusing the data types. But, How I make to install > PostGIS in Win2000 Pro? I don't know; my background is on Unix-like systems. You might get more help from the PostGIS mailing list: http://postgis.refractions.net/mailman/listinfo/postgis-users -- Michael Fuhr