--- 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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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"



I supposed that the installers of this version of PostgreSQL came already with PostGIS because I get&nbsp;insert geographic data a table that I created.



Regards.











From:&nbsp;&nbsp;&lt;operationsengineer1@yahoo.com&gt;
To:&nbsp;&nbsp;Omar Zevallos &lt;omzeta@hotmail.com&gt;, pgsql-novice@postgresql.org
Subject:&nbsp;&nbsp;Re: [NOVICE] relations in PostgreSQL 8.1
Date:&nbsp;&nbsp;Wed, 7 Dec 2005 09:35:05 -0800 (PST)
&gt;--- Omar Zevallos &lt;omzeta@hotmail.com&gt; wrote:
&gt;
&gt;---------------------------------
&gt; &gt;&gt; Hi there, I am working with postgreSQL 8.1, postGIS
&gt;and pgAdmin
&gt; &gt;&gt; III. I am creating a geodatabase and I am novice in
&gt;this tools,
&gt; &gt;&gt; How I relationship my tables? there is some model?
&gt; &gt;&gt; Regards.
&gt;
&gt;one table has a primary (unique) key which is inserted
&gt;into the foreign key link in a related table.
&gt;
&gt;Omar, examples tend to be the easiest way to learn.
&gt;how about you give example tables that you want to
&gt;relate and then i, or someone else here, can show you
&gt;how to relate the table?
&gt;
&gt;
&gt;
&gt;__________________________________________
&gt;Yahoo! DSL – Something to write home about.
&gt;Just $16.99/mo. or less.
&gt;dsl.yahoo.com
&gt;
&gt;
&gt;---------------------------(end of broadcast)---------------------------
&gt;TIP 2: 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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:&nbsp;&nbsp;Michael Fuhr &lt;mike@fuhr.org&gt;
To:&nbsp;&nbsp;Omar Zevallos &lt;omzeta@hotmail.com&gt;
CC:&nbsp;&nbsp;pgsql-novice@postgresql.org
Subject:&nbsp;&nbsp;Re: [NOVICE] PostgreSQL 8.1
Date:&nbsp;&nbsp;Thu, 5 Jan 2006 20:52:33 -0700
&gt;[Please post in plain text, not HTML.]
&gt;
&gt;On Fri, Jan 06, 2006 at 02:12:51AM +0000, Omar Zevallos wrote:
&gt; &gt; Hi, I have installed PostgreSQL 8.1 for windows, this version comes
&gt; &gt; with PostGIS? becouse I have an application that uses a postgreSQL
&gt; &gt; database and when I execute it, it raises an exception:
&gt; &gt;
&gt; &gt; "function postgis_version() does not exist"
&gt;
&gt;Standard PostgreSQL installations don't come with PostGIS, although
&gt;somebody might have created a package that bundles them together.
&gt;Where did you get PostgreSQL?
&gt;
&gt; &gt; I supposed that the installers of this version of PostgreSQL came
&gt; &gt; already with PostGIS because I get insert geographic data a table that
&gt; &gt; I created.
&gt;
&gt;What exactly are you doing?&nbsp;&nbsp;PostgreSQL has its own geometric types
&gt;that are different than the PostGIS types -- are you sure you're
&gt;not confusing them?
&gt;
&gt;--
&gt;Michael Fuhr
&gt;
&gt;---------------------------(end of broadcast)---------------------------
&gt;TIP 4: Have you searched our list archives?
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;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/mailm.../postgis-users

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend