By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist

P: 40
Hai,
Im getting this error.There is a column by name "nr_first_name" in the table
"gistl_new_request".
Yet im getting as that dose not exist.Would like to now what is the cause of it.

Thank You
Aug 3 '07 #1
Share this Question
Share on Google+
6 Replies


P: 40
Sorry,here is the complete error message,

org.postgresql.util.PSQLException: ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist
Aug 3 '07 #2

Expert 100+
P: 534
Can you provide some details on where you're getting this message?
A relevant code snippet may be helpful.
Also open the psql session and run these commands:
Expand|Select|Wrap|Line Numbers
  1. \l
  2. \d  gistl_new_request
  3.  
What was the output they produced?
Aug 7 '07 #3

gauravgmbhr
100+
P: 107
Sorry,here is the complete error message,

org.postgresql.util.PSQLException: ERROR: column "nr_first_name" of relation "gistl_new_request" does not exist




Your Table "gistl_new_request" does not have a column named "nr_first_name"

Regards Gaurav
Aug 7 '07 #4

P: 40
Geo=> \d GISTL_NEW_REQUEST
Did not find any relation named "GISTL_NEW_REQUEST".
Geo=> \d "GISTL_NEW_REQUEST"
Table "public.GISTL_NEW_REQUEST"
Column | Type | Modifiers
---------------+------+-----------
NR_FIRST_NAME | text | not null
NR_LAST_NAME | text |
NR_PHONENO | text | not null
NR_MOBILENO | text | not null
NR_EMAIL | text | not null
NR_CITY | text |
NR_PINCODE | text |
NR_ADDRESS | text |
NR_STATE | text |
NR_FLAG | text | not null
Indexes:
"gistl_new_request_pkey" PRIMARY KEY, btree ("NR_EMAIL")

Does double quotes " " ,matter so much.
I have created these tables using PG Amin iii,Yet i got the above error.
Aug 8 '07 #5

P: 40
I could resolve this...

Thx a lot..
Aug 8 '07 #6

gauravgmbhr
100+
P: 107
I could resolve this...
Thx a lot..
Yes double quotes matters


if you use double quoates " then the relations(table_name or columns_name or any other entity) becomes case sensitive


i hope that solve ur problem

Regards Gaurav
Aug 11 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.