Re: [BUGS] horology regression test failure

2005-12-20 Thread Martin Pitt
Hi! Tom Lane [2005-12-20 16:39 -0500]: > Yeah, the chosen-at-random pathnames ;-). It's not that random, these are the paths that the FHS and Debian policy prescribe for this package's structure (multiple versions installable in parallel). :) > I quote from the comments for make_relative_path()

Re: [BUGS] horology regression test failure

2005-12-20 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > ./configure --libdir=3D/usr/lib/postgresql/8.1/lib --bindir=3D/usr/lib/pos= > tgresql/8.1/bin > is enough to reproduce the problem. With only --libdir, it works, and > with only --bindir the test suite does not run at all because the > postmaster cannot f

Re: [BUGS] horology regression test failure

2005-12-20 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > Maybe I did something wrong with the configure options. That bug is > reproducible with the pristine upstream 8.1.1 tarball and doing: > =2E/configure --prefix=/usr --mandir="\${prefix}/share/man" \ > --sysconfdir=/etc --libdir="\${prefix}/lib/postgre

Re: [BUGS] horology regression test failure

2005-12-20 Thread Martin Pitt
Hi! Martin Pitt [2005-12-20 21:23 +0100]: > Maybe I did something wrong with the configure options. That bug is > reproducible with the pristine upstream 8.1.1 tarball and doing: > > ./configure --prefix=/usr --mandir="\${prefix}/share/man" \ > --sysconfdir=/etc --libdir="\${prefix}/lib/post

Re: [BUGS] horology regression test failure

2005-12-20 Thread Martin Pitt
Hi Tom! Tom Lane [2005-12-20 12:49 -0500]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > So it seems that the test suite uses the timezone files from the > > installed system instead of the files in the temporary installation in > > the regression test directory. > > It's not supposed to, and AFA

Re: [BUGS] horology regression test failure

2005-12-20 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > So it seems that the test suite uses the timezone files from the > installed system instead of the files in the temporary installation in > the regression test directory. It's not supposed to, and AFAICT it works fine for me (not only on my personal machin

Re: [BUGS] horology regression test failure

2005-12-20 Thread Martin Pitt
Hi again! Martin Pitt [2005-09-29 23:08 +0200]: > Hi! > > On almost all Debian platforms the horology test for 8.0.3 fails. > Sometimes it works on a platform, sometimes not, I did not yet find a > pattern, but most often it fails with something like > [...] I now think I know what is wrong here

Re: [BUGS] BUG #2118: could not connect to server

2005-12-20 Thread Tom Lane
"zhuge xiao" <[EMAIL PROTECTED]> writes: > could not connect to server: Permission denied > Is the server running locally and accepting connections on Unix domain > socket "/tmp/.s.PGSQL.5432"? "Permission denied" indicates a file permissions problem. Check the permissions on /tmp and on the sock

Re: [BUGS] BUG #2119: FOREIGN KEY ON DELETE RESTRICT

2005-12-20 Thread Tom Lane
"Fred PerniÃ" <[EMAIL PROTECTED]> writes: > If I delete a dataset from p_kto then is also delete the referenced sets in > depot. > Normaly the RESTRICT should prevents deletion. Or? Works for me: regression=# delete from p_kto where kto_id = 101; ERROR: update or delete on "p_kto" violates foreig

Re: [BUGS] BUG #2118: could not connect to server

2005-12-20 Thread Devrim GUNDUZ
Hi, On Tue, 2005-12-20 at 08:44 +, zhuge xiao wrote: > PostgreSQL version: 8.0.3 > Operating system: Linux ( FC4 ) > Description:could not connect to server > Details: > I have edited the program testlibpq.c which is copied from the PostgreSQL > document to make it become a CGI pro

[BUGS] BUG #2118: could not connect to server

2005-12-20 Thread zhuge xiao
The following bug has been logged online: Bug reference: 2118 Logged by: zhuge xiao Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux ( FC4 ) Description:could not connect to server Details: Help me! I have edited the program testli

[BUGS] BUG #2119: FOREIGN KEY ON DELETE RESTRICT

2005-12-20 Thread Fred Perniß
The following bug has been logged online: Bug reference: 2119 Logged by: Fred Perniß Email address: [EMAIL PROTECTED] PostgreSQL version: 8.02 Operating system: Suse Linux 9.1 Description:FOREIGN KEY ON DELETE RESTRICT Details: I have 2 tables CREATE TABLE depot (