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
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 |