Ah, I misread. Sorry for the noise. On Sep 24, 2017 4:59 PM, "Keith Medcalf" <kmedc...@dessus.com> wrote:
> > I don't think so. The question is about interpreting the schema, not > about executing anything at all. > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-----Original Message----- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Scott Robison > >Sent: Sunday, 24 September, 2017 16:47 > >To: SQLite mailing list > >Subject: Re: [sqlite] Support for named foreign keys? > > > >I think he's asking for FK constraint names to be reported in > >conflict > >messages which has been requested in the past, but not included up > >until > >now because of the approach taken. > > > >On Sep 24, 2017 4:16 PM, "Keith Medcalf" <kmedc...@dessus.com> wrote: > > > >> > >> Why do you think this? > >> > >> The syntax diagrams are quite clear that FOREIGN KEY constraints > >can be > >> named. > >> > >> sqlite> create table parent > >> ...> (id integer primary key); > >> sqlite> create table child > >> ...> (fk integer null, > >> ...> constraint dippydoo foreign key (fk) references > >parent(id)); > >> sqlite> > >> > >> > >> --- > >> The fact that there's a Highway to Hell but only a Stairway to > >Heaven says > >> a lot about anticipated traffic volume. > >> > >> > >> >-----Original Message----- > >> >From: sqlite-users [mailto:sqlite-users- > >> >boun...@mailinglists.sqlite.org] On Behalf Of Csányi Pál > >> >Sent: Sunday, 24 September, 2017 12:06 > >> >To: SQlite User > >> >Subject: [sqlite] Support for named foreign keys? > >> > > >> >Hi, > >> > > >> >when will SQLite support the named foreign keys? > >> > > >> >I am using SchemaCrawler to visualize my SQLite databases and > >because > >> >SQLite does not support it yet, foreign keys get automatically > >> >generated foreign key names in the diagram. > >> > > >> >So it would be nice if SQLite would support it one day. Is'n it? > >> > > >> >-- > >> >Best, Pali > >> >_______________________________________________ > >> >sqlite-users mailing list > >> >sqlite-users@mailinglists.sqlite.org > >> >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > >users > >> > >> > >> > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@mailinglists.sqlite.org > >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > >users > >> > >_______________________________________________ > >sqlite-users mailing list > >sqlite-users@mailinglists.sqlite.org > >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users