Re: [BUGS] could not find /usr/local/timezone

2004-11-06 Thread Tom Lane
I wrote: >> dropping symlinks to the pg binaries in /usr/bin or >> /usr/local/bin or /sbin/ is something I've done for ages, on PostgreSQL >> versions 7.1 -> 7.4. Is there a problem with this now? > This is fundamentally broken by the changes to support relocatable > installs: PG now attempts to

Re: [BUGS] domain on bit(N) type produces strange results

2004-11-06 Thread Tom Lane
I wrote: > Kris Jurka <[EMAIL PROTECTED]> writes: >> Creating a domain on bit(N) doesn't seem to work as expected when casting >> to the domain type. > What's going on here is that "7::bit4" is implemented as > "7::bit::bit(4)", and since 7::bit is taken to mean 7::bit(1), > the result follows.

Re: [BUGS] BUG #1307: Possible bug inheritance/referential integrity

2004-11-06 Thread Stephan Szabo
On Sat, 6 Nov 2004, PostgreSQL Bugs List wrote: > Rows inserted into a table "sub" inherited from a table > "super" do not seem to exist in the super-table from the point of > view of the foreign key constraint checker in references to the > "super"-table, even though a SELECT query displays the r

Re: [BUGS] BUG #1307: Possible bug inheritance/referential integrity

2004-11-06 Thread Michael Fuhr
On Sat, Nov 06, 2004 at 12:11:49PM +, PostgreSQL Bugs List wrote: > > Rows inserted into a table "sub" inherited from a table > "super" do not seem to exist in the super-table from the point of > view of the foreign key constraint checker in references to the > "super"-table, even though a SEL

[BUGS] BUG #1307: Possible bug inheritance/referential integrity

2004-11-06 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1307 Logged by: Thomas Jacob Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.5 Operating system: Gentoo Linux, Kernel 2.6.7 Description:Possible bug inheritance/referential integrity Details: Ro