SQL Errors

[Perry Smith]

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
>