Re: [BUGS] Foreign keys don't work with inherited tables

2001-06-28 Thread Stephan Szabo
On Sat, 23 Jun 2001, Micah Yoder wrote: > Using PostgreSQL 7.1.2 compiled with Red Hat 7.1's gcc 2.96. > > I have a database that uses inherited tables. The top level table of the > hierarchy has a serial column, which is the primary key. Everything inserted > into any of its decendents and

Re: [BUGS] initdb fails on HP-UX 10.20 / PGSQL 7.1.2

2001-06-28 Thread Tom Lane
[EMAIL PROTECTED] writes: > initdb fails on HP-UX 10.20 / PGSQL 7.1.2 Hmm. What compiler are you using? HPUX 10.20 is my primary development platform, so I can assure you PG works on it ;-). I usually test with gcc (currently 2.95.3) and HP's cc (what /usr/bin/cc says HP92453-01 A.10.32.22 HP

Re: [BUGS] COPY TO looses on view

2001-06-28 Thread Tom Lane
Steve Pothier <[EMAIL PROTECTED]> writes: > I created a simple view from an existing table. I can select on the > view ok but COPY TO "does nothing" (no error, no output). It should raise an error. Thanks for pointing that out. regards, tom lane ---