Re: [Time-table-devl] SQL Commands instead of a dump
Status: Pre-Alpha
Brought to you by:
graeme_f
|
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 >>> >> > > |