Thread

  1. postgreSQL 6.3.2 and AIX

    Sebestyen Zoltan <szoli@netvisor.hu> — 1998-11-09T12:00:08Z

    Does anyone have exeperiences with AIX4.2/postgreSQL 6.3.2? 
    Now I'm unable to compile it I've got the following error message:
    bash-2.01$ gmake
    Making postgres.imp
    ./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/bin >
    postgres.imp
    nm: postgres: 0654-200 Cannot open the specified file.
    nm: A file or directory in the path name does not exist.
    xlc -bE:./backend/postgres.imp -o postgres  ../utils/version.o -lPW -lld
    -lnsl -ldl -lm -lcurses
    xlc: 1501-228 input file ../utils/version.o not found
    gmake: *** [postgres.imp] Error 252
    
    What's wrong?
    --------------------------------------------------------------------------------
    Sebestyén Zoltán AKA Memphisto		It all seems so stupid,
    					it makes me want to give up. 
    szoli@netvisor.hu			But why should I give up,
                                            when it all seems so stupid? 
    
    MAKE INSTALL NOT WAR			And please avoid Necrosoft Widows
    
    
    
    
    
  2. Re: [GENERAL] postgreSQL 6.3.2 and AIX

    David Hartwig <daveh@insightdist.com> — 1998-11-09T18:37:33Z

    I have 4.1.4.   My last compile was flawless other then a few tweaks necessary for
    plpgsq.  Your not that far yet.
    
    >From what I can see apparent  what your problem is.
        mkldexport.sh is a script calls nm.
        nm is a UNIX utility for extracting external symbols from executables and such.
    It looks like nm is complaining that is cannot open the executable "postgres".
    
    At this phase postgres should be located in src/backend.   Is it there and readable?
    
    "/usr/local/pgsql/bin".
    
    
    Memphisto wrote:
    
    > Does anyone have exeperiences with AIX4.2/postgreSQL 6.3.2?
    > Now I'm unable to compile it I've got the following error message:
    > bash-2.01$ gmake
    > Making postgres.imp
    > ./backend/port/aix/mkldexport.sh postgres /usr/local/pgsql/bin >
    > postgres.imp
    > nm: postgres: 0654-200 Cannot open the specified file.
    > nm: A file or directory in the path name does not exist.
    > xlc -bE:./backend/postgres.imp -o postgres  ../utils/version.o -lPW -lld
    > -lnsl -ldl -lm -lcurses
    > xlc: 1501-228 input file ../utils/version.o not found
    > gmake: *** [postgres.imp] Error 252
    >
    > What's wrong?
    > --------------------------------------------------------------------------------
    > Sebestyén Zoltán AKA Memphisto          It all seems so stupid,
    >                                         it makes me want to give up.
    > szoli@netvisor.hu                       But why should I give up,
    >                                         when it all seems so stupid?
    >
    > MAKE INSTALL NOT WAR                    And please avoid Necrosoft Widows
    
    
    
  3. Re: [GENERAL] postgreSQL 6.3.2 and AIX

    Sebestyen Zoltan <szoli@netvisor.hu> — 1998-11-10T11:29:11Z

    I've found what the problem was:
     I've had to call the 'all' target explicitly: gmake all
    > > Does anyone have exeperiences with AIX4.2/postgreSQL 6.3.2?
    > > Now I'm unable to compile it I've got the following error message:
    > > bash-2.01$ gmake
    > > Making postgres.imp
    
    --------------------------------------------------------------------------------
    Sebestyén Zoltán AKA Memphisto		It all seems so stupid,
    					it makes me want to give up. 
    szoli@netvisor.hu			But why should I give up,
                                            when it all seems so stupid? 
    
    MAKE INSTALL NOT WAR			And please avoid Necrosoft Widows
    
    
    
    
  4. Float

    Javier E Polo <jpolo@luna.uniandes.edu.co> — 1998-11-10T13:17:56Z

    I'm want to create a table with data types float or doubles. How can I declare them
    ?
    
    Create table rrrrrrr (
    tip1  ????(float)???,
    );
    
    Thanks
    
    
    
  5. Re: [GENERAL] Float

    Anatoly K. Lasareff <tolik@icomm.ru> — 1998-11-10T13:29:39Z

    >>>>> "JEP" == Javier E Polo <jpolo@luna.uniandes.edu.co> writes:
    
     JEP> I'm want to create a table with data types float or doubles. How can I declare them
     JEP> ?
    
     JEP> Create table rrrrrrr (
     JEP> tip1  ????(float)???,
     JEP> );
    
    Pehaps
    
    create table rrr (
      a	float
    );
    
    What is the problem?
    
    -- 
    Anatoly K. Lasareff              Email:       tolik@icomm.ru 
    Senior programmer
    
    
  6. Re: [GENERAL] Float

    George Kousi <george@albourne.com> — 1998-11-10T14:31:46Z

    "Anatoly K. Lasareff" wrote:
    
    > >>>>> "JEP" == Javier E Polo <jpolo@luna.uniandes.edu.co> writes:
    >
    >  JEP> I'm want to create a table with data types float or doubles. How can I declare them
    >  JEP> ?
    >
    >  JEP> Create table rrrrrrr (
    >  JEP> tip1  ????(float)???,
    >  JEP> );
    >
    > Pehaps
    >
    > create table rrr (
    >   a     float
    > );
    >
    > What is the problem?
    >
    > --
    > Anatoly K. Lasareff              Email:       tolik@icomm.ru
    > Senior programmer
    
    try:
    create table rrr (
    a float4
    );
    
    Regards,
    
    George Kousi