Thanks so much for the link Paul! Everything upgraded with no problems. I'm very pleased.. Thanks again. George, to answer your question.. postgres is similar to Microsoft Access.. or Oracle..or mySQL.. or mssql server. its relational database management system (mysql is not..but thats a whole 'nother thread ;). I barely know anything about FileMaker pro, but I think its a db system that has its own language.. which is similar to sql based databases such as postgresql. the db engines differ.. but most are based around the same language --SQL.. and each adds its own flair to the language.. ----- Original Message ----- From: "George Simpson" <gasjr4wd@mac.com> To: "clemaire" <clemaire@netnerds.net> Sent: Monday, December 17, 2001 12:43 PM Subject: Re: [suse-ppc] Postgres on SuSE 7.0
Off topic... I'm new to SuSE. Really got for server. Question - I haven't used postgresql. Is it like filemaker pro? Just more robust?
-- Thank You, George
From: "clemaire" <clemaire@netnerds.net> Date: Mon, 17 Dec 2001 12:36:19 -0800 To: <suse-ppc@suse.com> Subject: [suse-ppc] Postgres on SuSE 7.0
Hello All, I've got SuSE PPC 7.0 running on a iMac SE.. After I installed Postgresql, I tried a few commands.. almost every command I issue it says the following:
ERROR: getattproperties: no attribute tuple 1247 -2
I found a support page that talks agbout it http://sdb.suse.de/en/sdb/html/poeml_ppc_postgresql.html
Seems that there is an optimization switch problem and it requires a recompile.. :/ And it states that there will be an update soon.. anyone know when?
Also, it mentions that i can recompile postgres and pg_serv on my own. I downloaded postgres.spm from suse's site ftp.suse.com/pub/suse/ppc/7.0/suse/zq1 <ftp://ftp.suse.com/pub/suse/ppc/7.0/suse/zq1> but cannot find the pg_serv there. Perhaps its included in the postgres.spm?
Suse does a great job of RPMing everything and having it all work perfectly. So I'm really wary of doing a manual recompile, but I'd like to get this going.. Is there a way i can tell how they compiled the packages that went into the RPMS? I'd love to know all the options they used for the postgres package so that I can also use all of them (except for -o0 of course).
Thanks much