Re: [GENERAL] Enforcing referential integrity against a HSTORE column

2016-01-02 Thread Adrian Klaver
On 01/01/2016 07:47 PM, Dane Foster wrote: Hello, I'm moving a MySQL database to PostgreSQL and redesigning parts of it to take advantage of PostgreSQL's richer type system and other advance features. Currently I am attempting to replace a table of name/value pair data w/ a hstore column. But no

[GENERAL] Ubuntu 15.04 Installing Oracle_fdw

2016-01-02 Thread Leonardo M . Ramé
Hi, I compiled oracle_fdw.so on Ubuntu 15.04 Server 64bits and I'm getting the "No such file or directory" error when I try to create the oracle_fdw extension. After doing make and make install on Oracle fdw source oracle_fdw.so is built and installed correctly (oracle_fdw.so is copied to my $

Re: [GENERAL] Enforcing referential integrity against a HSTORE column

2016-01-02 Thread Bill Moran
On Sat, 2 Jan 2016 07:30:38 -0800 Adrian Klaver wrote: > > So given: > > > > CREATE TABLE xtra_fields( > >xfk SERIAL PRIMARY KEY, > >xtk INTEGER NOT NULL REFERENCES xtra_types, > >... > > ); > > > > CREATE OR REPLACE FUNCTION foo_xtra_fk(HSTORE) RETURNS BOOLEAN AS $$ > > WITH keyz AS

Re: [GENERAL] Enforcing referential integrity against a HSTORE column

2016-01-02 Thread Dane Foster
On Sat, Jan 2, 2016 at 10:59 AM, Bill Moran wrote: > On Sat, 2 Jan 2016 07:30:38 -0800 > Adrian Klaver wrote: > > > > So given: > > > > > > CREATE TABLE xtra_fields( > > >xfk SERIAL PRIMARY KEY, > > >xtk INTEGER NOT NULL REFERENCES xtra_types, > > >... > > > ); > > > > > > CREATE OR

Re: [GENERAL] Ubuntu 15.04 Installing Oracle_fdw

2016-01-02 Thread Leonardo M . Ramé
El 02/01/16 a las 12:51, Leonardo M. Ramé escribió: Hi, I compiled oracle_fdw.so on Ubuntu 15.04 Server 64bits and I'm getting the "No such file or directory" error when I try to create the oracle_fdw extension. After doing make and make install on Oracle fdw source oracle_fdw.so is built and i

Re: [GENERAL] Enforcing referential integrity against a HSTORE column

2016-01-02 Thread Adrian Klaver
On 01/02/2016 08:13 AM, Dane Foster wrote: Ccing list. On Sat, Jan 2, 2016 at 10:30 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 01/01/2016 07:47 PM, Dane Foster wrote: Hello, I'm moving a MySQL database to PostgreSQL and redesigning parts of it t

Re: [GENERAL] Enforcing referential integrity against a HSTORE column

2016-01-02 Thread Dane Foster
On Sat, Jan 2, 2016 at 12:19 PM, Adrian Klaver wrote: > On 01/02/2016 08:13 AM, Dane Foster wrote: > > Ccing list. > >> On Sat, Jan 2, 2016 at 10:30 AM, Adrian Klaver >> mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 01/01/2016 07:47 PM, Dane Foster wrote: >> >> Hello, >> >>

Re: [GENERAL] Ubuntu 15.04 Installing Oracle_fdw

2016-01-02 Thread Adrian Klaver
On 01/02/2016 08:22 AM, Leonardo M. Ramé wrote: El 02/01/16 a las 12:51, Leonardo M. Ramé escribió: Hi, I compiled oracle_fdw.so on Ubuntu 15.04 Server 64bits and I'm getting the "No such file or directory" error when I try to create the oracle_fdw extension. After doing make and make install

Re: [GENERAL] How do I implement a .XSD in Postgres?

2016-01-02 Thread Brar Piening
ERR ORR schrieb: Hi everybody, I need to import some DB schemas which are defined in .XSD (a XML derivative) format. I've googled about this but have found no satisfactory answer. Perhaps I just don't know what exactly to ask Google. Perhaps you are talking about the xsd definition of strongly