pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
foreign keys
10+ messages / 9 participants
[nested] [flat]

* foreign keys
@ 1998-06-23 14:15  Dionisio Barrantes Blanco <BARRANTE@teleline.es>
  0 siblings, 1 reply; 10+ messages in thread

From: Dionisio Barrantes Blanco @ 1998-06-23 14:15 UTC (permalink / raw)
  To: pgsql-sql

Somebody can tell me how Postgres solves the referential integrity problem. I think I can't use 'constraints'  for foreign keys. ¿What's the easier way to declare and manage foreign keys? .

Thanks
Dionisio Barrantes

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: [SQL] foreign keys
@ 1998-06-24 14:51  Marin D <marin@cybernet.bg>
  parent: Dionisio Barrantes Blanco <BARRANTE@teleline.es>
  0 siblings, 0 replies; 10+ messages in thread

From: Marin D @ 1998-06-24 14:51 UTC (permalink / raw)
  To: Dionisio Barrantes Blanco <BARRANTE@teleline.es>; +Cc: pgsql-sql


Take a look at the contrib/spi/refint* under your PostgreSQL source
tree...

	Marin

          -= Why do we need gates in a world without fences? =-


On Tue, 23 Jun 1998, Dionisio Barrantes Blanco wrote:

->Somebody can tell me how Postgres solves the referential integrity problem. I think I can't use 'constraints'  for foreign keys. ¿What's the easier way to declare and manage foreign keys? .
->
->Thanks
->Dionisio Barrantes
->




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Foreign Keys
@ 1999-02-25 15:32  Michael Davis <michael.davis@prevuenet.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Michael Davis @ 1999-02-25 15:32 UTC (permalink / raw)
  To: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>; pgsql-sql; pgsql-hackers@postgreSQL.org

What is the possibility of recording foreign keys (a partial foreign key
implementation) in the database such that the ODBC interface can correctly
report them to client applications?  This would require an enhancement to
Postgres and to the ODBC driver for Postgres.  I have a problem with Access
97 not working properly with forms that contain sub forms representing
parent/child or master/detail tables.  For example: orders and orderlines.
I think this is caused by the lack of foreign key support.  I am basing this
conclusion on the SQL statement that Access sent through ODBC when looking
up records for the sub form.  The where clause of the SQL statement was
based on the primary key of the child or detail table.  The where clause
needs to be based on the column that is linked to the parent or master
table.  I already have indexes installed on both the primary key and the
field that links to the master/parent table.

I am willing to explore a work around and/or help with these enhancements.
This issue, at least for the moment,  appears to be a show stopper for me.
Any Suggestions?

Thanks, Michael



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: [INTERFACES] Foreign Keys
@ 1999-02-25 15:37  Byron Nikolaidis <byronn@insightdist.com>
  parent: Michael Davis <michael.davis@prevuenet.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Byron Nikolaidis @ 1999-02-25 15:37 UTC (permalink / raw)
  To: Michael Davis <michael.davis@prevuenet.com>; +Cc: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>; pgsql-sql; pgsql-hackers@postgreSQL.org



Michael Davis wrote:

> What is the possibility of recording foreign keys (a partial foreign key
> implementation) in the database such that the ODBC interface can correctly
> report them to client applications?  This would require an enhancement to
> Postgres and to the ODBC driver for Postgres.  I have a problem with Access
> 97 not working properly with forms that contain sub forms representing
> parent/child or master/detail tables.  For example: orders and orderlines.
> I think this is caused by the lack of foreign key support.  I am basing this
>

The driver does support SQLForeignKeys.  It does say it supports this function
in SQLFunctions.

However, the current implementation is based on the SPI/trigger stuff from the
pg_trigger table.  If you don't have any trigger info, then SQLForeignKeys will
not report anything.  This is most likely the problem.

Byron




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* RE: [INTERFACES] Foreign Keys
@ 1999-02-25 16:45  Michael Davis <michael.davis@prevuenet.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Michael Davis @ 1999-02-25 16:45 UTC (permalink / raw)
  To: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>; pgsql-sql; pgsql-hackers@postgreSQL.org

Excellent!  I will start working on it. 

	-----Original Message-----
	From:	Byron Nikolaidis [SMTP:byronn@insightdist.com]
	Sent:	Thursday, February 25, 1999 8:38 AM
	To:	Michael Davis
	Cc:	'pgsql-interfaces@postgreSQL.org'; pgsql postgres;
pgsql-hackers@postgreSQL.org
	Subject:	Re: [INTERFACES] Foreign Keys



	Michael Davis wrote:

	> What is the possibility of recording foreign keys (a partial
foreign key
	> implementation) in the database such that the ODBC interface can
correctly
	> report them to client applications?  This would require an
enhancement to
	> Postgres and to the ODBC driver for Postgres.  I have a problem
with Access
	> 97 not working properly with forms that contain sub forms
representing
	> parent/child or master/detail tables.  For example: orders and
orderlines.
	> I think this is caused by the lack of foreign key support.  I am
basing this
	>

	The driver does support SQLForeignKeys.  It does say it supports
this function
	in SQLFunctions.

	However, the current implementation is based on the SPI/trigger
stuff from the
	pg_trigger table.  If you don't have any trigger info, then
SQLForeignKeys will
	not report anything.  This is most likely the problem.

	Byron



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Foreign keys
@ 1999-07-15 17:14  Esteban Chiner Sanz <echiner@tissat.es>
  0 siblings, 0 replies; 10+ messages in thread

From: Esteban Chiner Sanz @ 1999-07-15 17:14 UTC (permalink / raw)
  To: pgsql-sql

I know there are no foreign keys in Postgres but, what could be the
best/most efficient way to simulate them?
Thank you,

            Esteban

------------------------------------------------------------
 Esteban Chiner Sanz        mailto (work): echiner@tissat.es
 TISSAT                     mailto (home): echiner@abonados.cplus.es
 Av. Aragon, 30, 5ª planta  Phone: 96 393 9950
 Valencia (SPAIN)





^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* RE: [SQL] Foreign keys
@ 1999-07-15 17:58  Jackson, DeJuan <djackson@cpsgroup.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Jackson, DeJuan @ 1999-07-15 17:58 UTC (permalink / raw)
  To: Esteban Chiner Sanz <echiner@tissat.es>; pgsql-sql

Triggers.  Check the contrib directory from the distribution for refint.

> -----Original Message-----
> From:	Esteban Chiner Sanz [SMTP:echiner@tissat.es]
> Sent:	Thursday, July 15, 1999 12:14 PM
> To:	pgsql-sql@postgreSQL.org
> Subject:	[SQL] Foreign keys
> 
> I know there are no foreign keys in Postgres but, what could be the
> best/most efficient way to simulate them?
> Thank you,
> 
>             Esteban
> 
> ------------------------------------------------------------
>  Esteban Chiner Sanz        mailto (work): echiner@tissat.es
>  TISSAT                     mailto (home): echiner@abonados.cplus.es
>  Av. Aragon, 30, 5ª planta  Phone: 96 393 9950
>  Valencia (SPAIN)
> 
> 



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Foreign keys
@ 2000-03-30 21:21  Aguinaldo Fagundes Junior <Aguinaldo.Fagundes@vantcom.net>
  0 siblings, 0 replies; 10+ messages in thread

From: Aguinaldo Fagundes Junior @ 2000-03-30 21:21 UTC (permalink / raw)
  To: pgsql-sql

Hi,

Can anybody help me with this:

-> Which is the best way to implement foreign keys constraints?


Thank you!



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Foreign Keys
@ 2001-02-02 00:59  <No Name> <bobmarley4u2c@yahoo.com>
  0 siblings, 1 reply; 10+ messages in thread

From: " @ 2001-02-02 00:59 UTC (permalink / raw)
  To: pgsql-sql

I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
be the problem?





^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Foreign Keys
@ 2001-02-06 05:25  Colin Faber <cfaber@fpsn.net>
  parent: <No Name> <bobmarley4u2c@yahoo.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Colin Faber @ 2001-02-06 05:25 UTC (permalink / raw)
  To: " <No Name>; " <bobmarley4u2c@yahoo.com>; +Cc: pgsql-sql

Foreign keys are not supported in that version :p see:
http://www.postgresql.org/devel-corner/docs/

"" wrote:

> I have PostgreSQL 6.5, and I can't get foreign keys to work! What seems to
> be the problem?




^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2001-02-06 05:25 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-23 14:15 foreign keys Dionisio Barrantes Blanco <BARRANTE@teleline.es>
1998-06-24 14:51 ` Marin D <marin@cybernet.bg>
1999-02-25 15:32 Foreign Keys Michael Davis <michael.davis@prevuenet.com>
1999-02-25 15:37 ` Re: [INTERFACES] Foreign Keys Byron Nikolaidis <byronn@insightdist.com>
1999-02-25 16:45 RE: [INTERFACES] Foreign Keys Michael Davis <michael.davis@prevuenet.com>
1999-07-15 17:14 Foreign keys Esteban Chiner Sanz <echiner@tissat.es>
1999-07-15 17:58 RE: [SQL] Foreign keys Jackson, DeJuan <djackson@cpsgroup.com>
2000-03-30 21:21 Foreign keys Aguinaldo Fagundes Junior <Aguinaldo.Fagundes@vantcom.net>
2001-02-02 00:59 Foreign Keys <No Name> <bobmarley4u2c@yahoo.com>
2001-02-06 05:25 ` Re: Foreign Keys Colin Faber <cfaber@fpsn.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox