SQL Errors

[Perry Smith]

I'm checking out IBM's nl_langinfo code to see what it does (what does 
it look at... LANG? NLSPATH?)

I have only one langinfo.h on my system but I may have a library in the 
fink system somewhere that I'm linking to instead of Apple's.

Still exploring...

On Jul 15, 2004, at 3:49 PM, Derek Atkins wrote:

> I think we've crossed the line into gnucash-devel territory.
> All I can think is that CODESET is getting multiply-defined,
> or fink isn't pulling in the right langinfo.h, or...  I don't
> know.  I've not got a Mac to play with, nor have I ever
> built the existing sql backend.
>
> -derek
>
> Perry Smith <pedz at easesoftware.net> writes:
>
>> Small curious update:
>>
>> A seperate standalone program that calls nl_langinfo works.
>>
>> #include <langinfo.h>
>>
>> int main(int argc, char *argv[])
>> {
>>      char *temp = nl_langinfo(CODESET);
>>
>>      printf("CODESET = '%s'\n", temp);
>>      return 0;
>> }
>>
>> returns:
>>
>> CODESET = 'US-ASCII'
>>
>> The above snippet was compiled outside of fink, etc.  Just gcc on a
>> normal user command line.
>>
>> On Jul 15, 2004, at 3:18 PM, Perry Smith wrote:
>>
>>> The null encoding is coming from a call to nl_langinfo(CODESET)
>>> where CODESET appears to be #define to 0 but I"m not sure of that.
>>>
>>> This is new to me.  I found nl_langinfo doing a google search but,
>>> again, I thought if someone has tracked this down before, it would
>>> save me time.
>>>
>>> Thanks,
>>> Perry
>>> p.s. should we move this to gnucash-devel ?  I subscribed to it as
>>> well.
>>>
>>> On Jul 14, 2004, at 1:15 PM, Derek Atkins wrote:
>>>
>>>> Well, it looks like it's using an empty "encoding name", whatever
>>>> that is.  I've never compiled the pg backend, let alone used it,
>>>> so I have no clue.
>>>>
>>>> -derek
>>>>
>>>> Perry Smith <pedz at easesoftware.net> writes:
>>>>
>>>>> This is a run time error.  To recap, the README in the
>>>>> backend/postgres directory says to start gnucash with your data 
>>>>> file
>>>>> and then to do a "Save As" with a path of 
>>>>> postgres://localhost/tempdb
>>>>> and that will create the database and populate it.
>>>>>
>>>>> When I do this, I get the errors below.
>>>>>
>>>>> I'm been digging around and I see there is a set-log-level where 
>>>>> you
>>>>> can get the code to record the entry and exit of routines.  So 
>>>>> far, I
>>>>> haven't figured out how to call set-log-level.  Is it hooked up to 
>>>>> a
>>>>> GUI thingy?  I was just assuming it would be on the command line.
>>>>>
>>>>> As far as CVS and getting the latest, I'm figuring that the
>>>>> backend/postgres code hasn't changed much.  If I actually figure 
>>>>> out
>>>>> and fix something I'll ask about what to do at that point.
>>>>>
>>>>> Thanks
>>>>> Perry
>>>>>
>>>>> On Jul 14, 2004, at 11:30 AM, Derek Atkins wrote:
>>>>>
>>>>>> I dont know if we've ever tested with pg-7.4..
>>>>>>
>>>>>> Is this a configure-time, build-time, or run-time error?
>>>>>> What other errors do you get?
>>>>>>
>>>>>> -derek
>>>>>>
>>>>>> PS: If you're building gnucash, you should use 1.8.9 (if not the
>>>>>> 1-8-branch from CVS).
>>>>>>
>>>>>> Perry Smith <pedz at easesoftware.net> writes:
>>>>>>
>>>>>>> I'm going to start digging into this error but thought I would 
>>>>>>> post
>>>>>>> it. (Let me know if this might should be moved to the developers
>>>>>>> list).
>>>>>>>
>>>>>>> I got gnucash rebuilt with --enable-sql.  Now I get:
>>>>>>>
>>>>>>> ERROR:   is not a valid encoding name
>>>>>>>
>>>>>>> (plus other errors but I think that is the root cause of the
>>>>>>> errors)
>>>>>>> when I try to do the initial save as.
>>>>>>>
>>>>>>> If someone out there can say "Oh... thats XYZ" let me know.
>>>>>>> Otherwise, I plan to dig into the source and see what it is
>>>>>>> attempting
>>>>>>> to do.
>>>>>>>
>>>>>>> FYI: I have gnucash 1.8.8 and postpresql 7.4.1
>>>>>>>
>>>>>>> Thank you,
>>>>>>> Perry
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> gnucash-user mailing list
>>>>>>> gnucash-user at gnucash.org
>>>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> -- 
>>>>>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>>>>        Member, MIT Student Information Processing Board  (SIPB)
>>>>>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>>>>        warlord at MIT.EDU                        PGP key available
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> -- 
>>>>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>>        Member, MIT Student Information Processing Board  (SIPB)
>>>>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>>        warlord at MIT.EDU                        PGP key available
>>>>
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>
>>
>
> -- 
>        Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>        Member, MIT Student Information Processing Board  (SIPB)
>        URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>        warlord at MIT.EDU                        PGP key available
>