Re: Problem in modification

Posted by verussolutions on Dec 06, 2010; 4:34am
URL: http://ngl.70.s1.nabble.com/Problem-in-modification-tp5794836p5806703.html

Please run this SQL Query using your pgadmin3 to solve the problem
On your server (assuming its windows)
1. Start -> Programs -> Postgresql 8.0 -> padmin3
2. Select your database (newgenlib) on the left hand side of the screen
3. On the top there is a SQL button (With a pencil icon). Click on it you will now see a new window
4. Enter the below SQL query or paste it

update library_holdings set sublocation_id=1;

5. You will see a execute button (Green arrow button). Click on it. You will a message like this
Query returned successfully: ---- rows affected, ---- ms execution time.