Re: [Time-table-devl] SQL Commands instead of a dump

[Anil M. <am...@me...>]

graeme foster wrote:
> That's because (I think) it can't find the configuration file. The file 
> that loads it is main.cpp function initDB(). If you place some 
> diagnostics there then it should verify what is being read.
> 
> Just thought the config file has the name of the user, you will probably 
> need to change that. Also check the database name.
> 
> graeme.

I discovered the problem. I only have sqlite driver compiled. I will 
compile psql too but i'm with probs compiling it. I dont know how i put 
on configure the postgresql directory.

Anil Mamede



> 
> On 23/03/06, *Anil Mamede* <am...@me... 
> <mailto:am...@me...>> wrote:
> 
>     I've created database and loaded the dump. I removed ALTER's OWNER. I've
>     put *.conf on ~/.config/time-table/ but i cant run the program.
> 
>     It gives me:
> 
>     Driver not loaded.
> 
>     Anil Mamede
> 
>     graeme @ gmail wrote:
>      > I don't have the sql separately but you could probable just use a
>      > replace to comment out the ALTER commands
>      > That probably also means that it is not compatible with earlier
>      > versions. We will need to decide if that is a problem and if so
>     how easy
>      > would it be to change the SQL to be compatible with an earlier
>     version.
>      >
>      > graeme.
>      >
>      > Anil Mamede wrote:
>      >
>      >> graeme @ gmail wrote:
>      >>
>      >>> The dump was (I thought) just all the SQL commands in one file.
>      >>> Anyway, which function is causing the problem? When is the problem
>      >>> happening (creation or executing?)
>      >>>
>      >>
>      >>
>      >> I was trying to restore the database on a postgresql 7.4.
>      >> The declaration:
>      >> >>> function(var integer) is not supported.
>      >>
>      >> On 7.* it is:
>      >> >>> function(integer) returns integer AS '
>      >> DECLARE
>      >>     var ALIAS $1
>      >> BEGIN
>      >>
>      >> ....
>      >>
>      >>
>      >> Now i'm building postgresql 8.1.3 but i prefer only the sql commands
>      >> instead of the dump and it's easy for people to install the
>     software
>      >> because there's no references to users.
>      >> If you dont have i'll separate it.
>      >>
>      >> Anil Mamede
>      >>
>      >>
>      >>> graeme.
>      >>>
>      >>> Anil Mamede wrote:
>      >>>
>      >>>> Hi. Do you have SQL commands instead of a dump?
>      >>>>
>      >>>> I'm with some probs with postgresql 7.4.1.
>      >>>>
>      >>>> I'm inserting a legal function according to PLPGSQL 7.4.1 but its
>      >>>> giving me error.
>      >>>>
>      >>>> Anil Mamede
>      >>>>
>      >>>>
>      >>>> -------------------------------------------------------
>      >>>> This SF.Net email is sponsored by xPML, a groundbreaking scripting
>      >>>> language
>      >>>> that extends applications into web and mobile media. Attend
>     the live
>      >>>> webcast
>      >>>> and join the prime developer group breaking into this new coding
>      >>>> territory!
>      >>>>
>     http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>     <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642>
>      >>>>
>      >>>> _______________________________________________
>      >>>> Time-table-devl mailing list
>      >>>> Tim...@li...
>     <mailto:Tim...@li...>
>      >>>> https://lists.sourceforge.net/lists/listinfo/time-table-devl
>     <https://lists.sourceforge.net/lists/listinfo/time-table-devl>
>      >>>>
>      >>>
>      >>
>      >>
>      >
>      >
>      > -------------------------------------------------------
>      > This SF.Net email is sponsored by xPML, a groundbreaking
>     scripting language
>      > that extends applications into web and mobile media. Attend the live
>      > webcast
>      > and join the prime developer group breaking into this new coding
>     territory!
>      >
>     http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>     <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642>
>      > _______________________________________________
>      > Time-table-devl mailing list
>      > Tim...@li...
>     <mailto:Tim...@li...>
>      > https://lists.sourceforge.net/lists/listinfo/time-table-devl
>      >
> 
> 
> 
>     -------------------------------------------------------
>     This SF.Net email is sponsored by xPML, a groundbreaking scripting
>     language
>     that extends applications into web and mobile media. Attend the live
>     webcast
>     and join the prime developer group breaking into this new coding
>     territory!
>     http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
>     <http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642>
>     _______________________________________________
>     Time-table-devl mailing list
>     Tim...@li...
>     <mailto:Tim...@li...>
>     https://lists.sourceforge.net/lists/listinfo/time-table-devl
>     <https://lists.sourceforge.net/lists/listinfo/time-table-devl>
> 
>