Skip to content

Instantly share code, notes, and snippets.

@gregglind
Created August 20, 2010 20:31
Show Gist options
  • Select an option

  • Save gregglind/541096 to your computer and use it in GitHub Desktop.

Select an option

Save gregglind/541096 to your computer and use it in GitHub Desktop.
create table t (f1 int);
create table t1 (CHECK (f1 < 100)) INHERITS (t);
select 1 into t1;
/* gives ERROR: relation "t1" already exists */
/* is this the expected solution? */
insert into t1 (select 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment