lamiastella

error in SELECT

Mar 12th, 2016
4,412
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE public.students (
  2.   id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('students_id_seq'::regclass),
  3.   first_name CHARACTER VARYING(20) NOT NULL,
  4.   last_name CHARACTER VARYING(20) NOT NULL,
  5.   major CHARACTER VARYING(20) NOT NULL
  6. );
  7. CREATE UNIQUE INDEX "Students_ID_uindex" ON students USING BTREE (id);
  8.  
  9. SELECT * FROM public.students;
  10.  
  11. ---------------------------
  12. [2016-03-12 22:16:54] Run postgres.public.students [PostgreSQL - postgres@localhost]
  13. [2016-03-12 22:16:54] Connecting to PostgreSQL - postgres@localhost...
  14. CREATE TABLE public.students (
  15.   id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('students_id_seq'::regclass),
  16.   first_name CHARACTER VARYING(20) NOT NULL,
  17.   last_name CHARACTER VARYING(20) NOT NULL,
  18.   major CHARACTER VARYING(20) NOT NULL
  19. )
  20. [2016-03-12 22:16:54] [42P07] ERROR: relation "students" already exists
  21. CREATE UNIQUE INDEX "Students_ID_uindex" ON students USING BTREE (id)
  22. [2016-03-12 22:16:54] [42P07] ERROR: relation "Students_ID_uindex" already exists
  23. SELECT * FROM public.students
  24. [2016-03-12 22:16:54] Executed in 14ms ms
  25.  
  26. [2016-03-12 22:16:54] Summary: 3 of 3 statements executed, 2 failed in 68ms (338 symbols in file)
Advertisement
Comments
  • User was banned
Add Comment
Please, Sign In to add comment