constraints regression fails

From: Patrick Robin <Patrick(dot)Robin(at)disney(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: constraints regression fails
Date: 1999-11-02 18:28:30
Message-ID: 381F2D4D.D0EDCFDE@fa.disney.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I compiled postgresql-6.5.2 on Solaris 2.6 without problems. When I run
regression tests, the
only one that fails is this create table line in constraints:

--------->

[352] % cat constraints.sql
--
-- Check constraints
-- Constraints can be specified with:
-- - DEFAULT clause
-- - CHECK clauses
-- - PRIMARY KEY clauses
-- - UNIQUE clauses
--
--
-- Primary keys
--

CREATE TABLE PRIMARY_TBL (i int PRIMARY KEY, t text);

DROP TABLE PRIMARY_TBL;

-------------------------------------------------------------

The debug output of postgres looks like this:

----------->

ProcessUtility: SET timezone = 'PST8PDT'
CommitTransactionCommand
StartTransactionCommand
query: CREATE TABLE PRIMARY_TBL (i int PRIMARY KEY, t text);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index
'primary_tbl_pkey' for table 'primary_tbl'
parser outputs:
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 19124 exited with
status 11
/usr/local/pgsql/bin/postmaster: CleanupProc: reinitializing shared
memory and semaphores
binding ShmemCreate(key=52e389, size=787456)

-------------

Any one know what to look for. The only thing I changed is the number
of processes when running postmaster (-N10)
because I didn't have enough shared mem by default. I will increase it
later.

Thanks

Patrick

--
________________________________________
Patrick Robin
patrickr(at)fa(dot)disney(dot)com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817

Browse pgsql-general by date

  From Date Subject
Next Message zris 1999-11-02 18:56:14 Re: PostgreSQL
Previous Message Bruce Momjian 1999-11-02 18:21:35 Re: [GENERAL] users in Postgresql