Skip site navigation (1) Skip section navigation (2)

regression test: triggers fial:

From: Terry Mackintosh <terry(at)terrym(dot)com>
To: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: regression test: triggers fial:
Date: 1998-12-27 17:35:02
Message-ID: Pine.LNX.3.95.981227122924.5666A-100000@terry1.acun.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all

The following is a snippet from the expected trigger.out file, the only
differance between this and what I got is that the following 'NOTICE:'
lines are missing in mine.
Is this a problem?
This was the only failure.

QUERY: delete from pkeys where pkey1 = 30 and pkey2 = '3';
NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
ERROR:  check_fkeys2_fkey_restrict: tuple referenced in fkeys
QUERY: delete from pkeys where pkey1 = 40 and pkey2 = '4';
NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
QUERY: update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 50 and pkey2
= '5'NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
ERROR:  check_fkeys2_fkey_restrict: tuple referenced in fkeys
QUERY: update pkeys set pkey1 = 7, pkey2 = '70' where pkey1 = 10 and pkey2
= '1'NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys are deleted
NOTICE:  check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted

Thanks, and have a great day
Terry Mackintosh <terry(at)terrym(dot)com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.4.1
---------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!


pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-12-27 18:10:51
Subject: Re: [HACKERS] psql \d does not work
Previous:From: Bruce MomjianDate: 1998-12-27 16:00:54
Subject: Re: [HACKERS] space usage of NULL fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group