Postgres Pro
Downloads
Home   >   mailing lists

Thread: relations in PostgreSQL 8.1

relations in PostgreSQL 8.1

From
"Omar Zevallos"
Date:
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.
 

Re: relations in PostgreSQL 8.1

From
Date:
--- 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

PostgreSQL 8.1

From
"Omar Zevallos"
Date:
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

Re: PostgreSQL 8.1

From
Michael Fuhr
Date:
[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

Re: PostgreSQL 8.1

From
"Omar Zevallos"
Date:
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

Re: PostgreSQL 8.1

From
Michael Fuhr
Date:
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