Re: [GENERAL] How could I find the last modified procedure in the database?

2011-11-19 Thread Rob_pg
Correction, try this: select proname,oid, xmin from pg_catalog.pg_proc order by xmin::text::int desc; regards Robert Bernier > Andreas Kretschmer writes: > > Dhimant Patel wrote: > >> I also created several procedures/functions and now I don't remember the last > >> procedure I worked on!

Re: [GENERAL] How could I find the last modified procedure in the database?

2011-11-19 Thread Rob_pg
Try this: select proname,oid, xmin from pg_catalog.pg_proc order by xmin::text desc; regards Robert Bernier > Andreas Kretschmer writes: > > Dhimant Patel wrote: > >> I also created several procedures/functions and now I don't remember the > >> last > >> procedure I worked on! - I thought I

Re: [GENERAL] writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect

2011-10-25 Thread Rob_pg
3866000) libdl.so.2 => /lib/libdl.so.2 (0x7f44e3662000) libpthread.so.0 => /lib/libpthread.so.0 (0x7f44e3445000) /lib64/ld-linux-x86-64.so.2 (0x7f44e4b66000) libm.so.6 => /lib/libm.so.6 (0x7f44e31c1000) > "Rob_pg" writes: > &g

[GENERAL] writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect

2011-10-25 Thread Rob_pg
I've been working on creating a foreign data wrapper for hdfs on using version 9.1.0. This is my first time creating C functions against postgres, so hopefully this falls under the 'newbie' category and is easy to solve. The source code code does compile resulting in a shared library: file myli