Thread: [Time-table-devl] SQL Commands instead of a dump
Status: Pre-Alpha
Brought to you by:
graeme_f
|
From: Anil M. <am...@me...> - 2006-03-23 12:41:14
|
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 |
|
From: graeme @ g. <fos...@gm...> - 2006-03-23 14:26:03
|
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?) 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 > _______________________________________________ > Time-table-devl mailing list > Tim...@li... > https://lists.sourceforge.net/lists/listinfo/time-table-devl > |
|
From: graeme @ g. <fos...@gm...> - 2006-03-23 16:17:38
|
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 >>> >>> _______________________________________________ >>> Time-table-devl mailing list >>> Tim...@li... >>> https://lists.sourceforge.net/lists/listinfo/time-table-devl >>> >> > > |
|
From: Anil M. <am...@me...> - 2006-03-23 16:25:37
|
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 >>>> >>>> _______________________________________________ >>>> Time-table-devl mailing list >>>> 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 > _______________________________________________ > Time-table-devl mailing list > Tim...@li... > https://lists.sourceforge.net/lists/listinfo/time-table-devl > |
|
From: graeme f. <fos...@gm...> - 2006-03-23 17:08:44
|
That's because (I think) it can't find the configuration file. The file tha= t 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. On 23/03/06, Anil Mamede <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 eas= y > > 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=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > >>>> > >>>> _______________________________________________ > >>>> Time-table-devl mailing list > >>>> 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=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > > _______________________________________________ > > Time-table-devl mailing list > > 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=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > _______________________________________________ > Time-table-devl mailing list > Tim...@li... > https://lists.sourceforge.net/lists/listinfo/time-table-devl > |
|
From: Anil M. <am...@me...> - 2006-03-23 17:14:38
|
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> > > |
|
From: graeme f. <fos...@gm...> - 2006-03-23 17:20:13
|
The command that I used to configure qt was (I think) Obviously you will need to check the pathson your system. ./configure -qt-sql-psql -I/usr/local/pgsql/include -L/usr/local/pgsql/lib |