Click here to Skip to main content
16,018,525 members
Home / Discussions / Database
   

Database

 
AnswerRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 22:50
mveRichard MacCutchan21-Sep-15 22:50 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:23
Member 1191972221-Sep-15 23:23 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:27
mveRichard MacCutchan21-Sep-15 23:27 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:31
Member 1191972221-Sep-15 23:31 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:34
Member 1191972221-Sep-15 23:34 
GeneralRe: postgresql database issues Pin
Richard MacCutchan21-Sep-15 23:52
mveRichard MacCutchan21-Sep-15 23:52 
GeneralRe: postgresql database issues Pin
Member 1191972221-Sep-15 23:56
Member 1191972221-Sep-15 23:56 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 0:00
mveRichard MacCutchan22-Sep-15 0:00 
Look at the error message you receive:
ERROR: null value in column "dt_open_date" violates not-null constraint
DETAIL: Failing row contains (VC2012030000303, VC20100300266, null, 11, 5, RBS, 1, 40, 40, 0, 14, 0, 1, 0, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0).

It clearly explains, and shows, that you have a record with a null value where one is not allowed. You need to use your database management tools to find that record and fix its content.
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:04
Member 1191972222-Sep-15 0:04 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 0:29
mveRichard MacCutchan22-Sep-15 0:29 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:49
Member 1191972222-Sep-15 0:49 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 20:57
mveRichard MacCutchan22-Sep-15 20:57 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 21:05
Member 1191972222-Sep-15 21:05 
GeneralRe: postgresql database issues Pin
Richard MacCutchan22-Sep-15 21:31
mveRichard MacCutchan22-Sep-15 21:31 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 21:35
Member 1191972222-Sep-15 21:35 
GeneralRe: postgresql database issues Pin
Richard MacCutchan23-Sep-15 2:23
mveRichard MacCutchan23-Sep-15 2:23 
GeneralRe: postgresql database issues Pin
Member 1191972223-Sep-15 19:34
Member 1191972223-Sep-15 19:34 
GeneralRe: postgresql database issues Pin
Richard Deeming24-Sep-15 1:55
mveRichard Deeming24-Sep-15 1:55 
GeneralRe: postgresql database issues Pin
Member 1191972225-Sep-15 1:01
Member 1191972225-Sep-15 1:01 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:08
Member 1191972222-Sep-15 0:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:20
Member 1191972222-Sep-15 0:20 
AnswerRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 2:31
Tim Carmichael22-Sep-15 2:31 
SuggestionRe: postgresql database issues Pin
Richard Deeming22-Sep-15 4:45
mveRichard Deeming22-Sep-15 4:45 
GeneralRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 5:08
Tim Carmichael22-Sep-15 5:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:52
Member 1191972222-Sep-15 19:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.