Oninit cdi / Archive
Talk to an expert →

Re: PK on superstores_demo.non_us_location

Posted in 2003

Topics: Security, Permissions & Auditing, Versions, Editions & End-of-Life

dom — — source: Usenet: comp.databases.informix

Hi John, dbschema.exe says: C:\\Informix\\bin>dbschema -t location_non_us -d superstores_demo DBSCHEMA Schema Utility INFORMIX-SQL Version 9.30.TC2E3 Copyright (C) Informix Software, Inc., 1984-1997 Software Serial Number ACP#A250443 { TABLE "dom".location_non_us row size = 2044 number of columns = 9 index size = 0 } create table "dom".location_non_us of type 'dom'.loc_non_us_t under 'dom'.location; revoke all on "dom".location_non_us from "public"; ... ALTER TABLE location_non_us ADD CONSTRAINT PRIMARY KEY ( location_id ) CONSTRAINT location_non_us_pk XIX000:-704: Primary key already exists on table. ... Mysterious. D. John Carlson <john_carlson@whsmithusa.com> wrote in message news:<sfkpcv45og0is22c0bid737bkd7ui6f1r4@4ax.com>... > On 22 May 2003 01:42:03 -0700, dominic.morris@eidosnet.co.uk (dom) > wrote: > > What does dbschema say? > > >Hi all, > > > >I'm trying to define a primary key on IDS 9.3/9.4 demo database > >superstores_demo on tables us_location and non_us_location on their > >SERIAL columns. > > > >The engine errors & reports that the tables already have a primary key > >defined, but I can't see it in the system tables, neither does > >ServerStudio report these keys' existence. > > > >Can anybody explain this, please? > > > >Many thanks, > >dm.

↪ replying to dom
Richard Harnden — — source: Usenet: comp.databases.informix

dom wrote in message ... >Hi John, dbschema.exe says: > >C:\\Informix\\bin>dbschema -t location_non_us -d superstores_demo > >DBSCHEMA Schema Utility INFORMIX-SQL Version 9.30.TC2E3 >Copyright (C) Informix Software, Inc., 1984-1997 >Software Serial Number ACP#A250443 >{ TABLE "dom".location_non_us row size = 2044 number of columns = 9 index size = > 0 } >create table "dom".location_non_us of type 'dom'.loc_non_us_t > under 'dom'.location; The keyword in the line above is UNDER; what you have is a hierarchy. Take a look at $INFORMIXDIR/demo/dbaccess/demo_ud/c_loc.sql >... > >ALTER TABLE > location_non_us >ADD CONSTRAINT PRIMARY KEY >( > location_id >) >CONSTRAINT > location_non_us_pk > >XIX000:-704: Primary key already exists on table. Which is true ... > >... > >Mysterious. > >D. > > >John Carlson <john_carlson@whsmithusa.com> wrote in message news:<sfkpcv45og0is22c0bid737bkd7ui6f1r4@4ax.com>... >> On 22 May 2003 01:42:03 -0700, dominic.morris@eidosnet.co.uk (dom) >> wrote: >> >> What does dbschema say? >> >> >Hi all, >> > >> >I'm trying to define a primary key on IDS 9.3/9.4 demo database >> >superstores_demo on tables us_location and non_us_location on their >> >SERIAL columns. >> > >> >The engine errors & reports that the tables already have a primary key >> >defined, but I can't see it in the system tables, neither does >> >ServerStudio report these keys' existence. >> > >> >Can anybody explain this, please? >> > >> >Many thanks, >> >dm.

Glossary