[SQL] compiling plpython compilation error
Hi all. Im having a hard time trying to compile the plpython package. This is the error make gives me: [EMAIL PROTECTED]:/usr/local/src/postgresql-8.2.5/src/pl/plpython> make gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fpic -shared -Wl,-soname,libplpython.so.0 plpython.o -L/usr/lib/python2.5/config -L../../../src/port -lpython2.5 -lpthread -ldl -lutil -lm -Wl,-rpath,'/usr/lib/python2.5/config' -o libplpython.so.0.0 /usr/lib64/gcc/x86_64-suse-linux/4.2.1/../../../../x86_64-suse-linux/bin/ld: /usr/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used when making a shared object; recompile with -fPIC /usr/lib/python2.5/config/libpython2.5.a: could not read symbols: Bad value collect2: ld returned 1 exit status make: *** [libplpython.so.0.0] Error 1 This runs on OpenSuse 10.3. python 2.5 postgres 8.2.5 ( and 8.3.0) Any clues? Thanks! Gerardo -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your Subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-sql
Re: [SQL] compiling plpython compilation error
Gerardo Herzig <[EMAIL PROTECTED]> writes: > Hi all. Im having a hard time trying to compile the plpython package. > This is the error make gives me: > /usr/lib/python2.5/config/libpython2.5.a(abstract.o): relocation > R_X86_64_32 against `a local symbol' can not be used when making a > shared object; recompile with -fPIC Well, I'd try following the error message's advice: use -fPIC not -fpic. Note that it's not real clear whether this needs to be done for plpython, or libpython, or perhaps both; so you might well be in for making a custom libpython installation. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your Subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-sql
Re: [SQL] psql word wrapping to terminal width - testers?
Karsten Hilbert wrote: # \pset format aligned-wrapped # \pset border 2 # select * from distributors order by did; +--++-+---+ | did |name|descr| long_col_name | +--++-+---+ |1 | Food fish and wine | default | | |2 | Cat Food Heaven 2 | abcdefghijklmnopqrs ! | ^ Any chance you could put an indicator here to point out the field has been wrapped ? It is there but subtle. Note the ! instead of |. Did you consider - a maximum length up to which fields will indeed be wrapped ? (\pset format aligned-wrapped 50) this will prevent a really large text field being wrapped to hundreds of lines thereby scrolling off everything else Yes, but truncating the request with substr() seems to address this need. A large field restricted in height would just blow out the width otherwise. - ignoring wrapping bytea ? Why treat bytea specially? In many cases it's unlikely to make any sense to print on a console anyway. How would you want bytea represented? - allowing truncation of fields at a certain length before wrapping ? (well, this can be handled by truncating at the SQL level, too) Even without any of the above suggestions this will be a *very* appreciated improvement of the already excellent psql. Karsten
