Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #3941: Insert Error


  • From: "gnp yadav" <gnperumal(at)gmail(dot)com>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: BUG #3941: Insert Error
  • Date: Fri, 8 Feb 2008 08:01:19 GMT
  • Message-id: <200802080801(dot)m1881JeA091085(at)wwwmaster(dot)postgresql(dot)org>

The following bug has been logged online:

Bug reference:      3941
Logged by:          gnp yadav
Email address:      gnperumal(at)gmail(dot)com
PostgreSQL version: 8.1
Operating system:   Ubuntu Linux
Description:        Insert Error
Details: 

CREATE TABLE sentence
(
  sentence_id serial NOT NULL,
  citation_id int8 NOT NULL,
  sen_offset int8 NOT NULL,
  sen_length int8 NOT NULL,
  sen_type varchar(10)[] NOT NULL,
  CONSTRAINT sentence_id PRIMARY KEY (sentence_id),
  CONSTRAINT citation_id FOREIGN KEY (sentence_id)
      REFERENCES citation (citation_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
) ;

INSERT INTO sentence (sentence_id, citation_id, sen_offset, sen_length,
sen_type) VALUES (NULL,1,2,3,asd");


As i Got This type error frequently

ERROR:  column "asd" does not exist

please guide me, Advance thanks to for my teacher.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group