Re: feature requests (possibly interested in working on this): functional foreign keys

From: Geoff Winkless <pgsqlgeneral(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: feature requests (possibly interested in working on this): functional foreign keys
Date: 2013-02-07 16:57:15
Message-ID: CAEzk6ffbmpTCpCp-=mRCcjwQ3iFrns3XM_5bmWOVpd1y4iB04Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7 February 2013 16:26, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Hmm, interesting hack. I guess that would meet the part of the spec
> that says, eg, information_schema.constraint_column_usage.column_name
> must be an identifier --- at least if you also restricted which schema
> the function could be in.

Apologies if I'm misunderstanding your point; couldn't you give the index
name (since we've suggested you would have to have a unique index on the
function in order to use it as an FK anyway) as the identifier?

Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zach Seaman 2013-02-07 17:05:19 Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Previous Message Zach Seaman 2013-02-07 16:51:23 Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1