[GENERAL] function that resolves IP addresses

Hi all Does anybody know how I could create a database function that accepts an INET parameter and reverse-lookups the hostname via DNS PTR lookup? Something like the dnsname command line utility in the djbdns package. I need this function for analyzing firewall logs stored in the database with ul

[GENERAL] Problems with unique restrictions

Hi all I have a PL/PGSQL conversion procedure that reads a "source table" and then inserts tuples into several related tables. Recently I upgraded from 8.1 to 8.2.0, then to 8.2.1. With 8.1 everything worked fine. Now since I upgraded to 8.2 I have problems inserting data into tables that hav

Antw: Re: [GENERAL] Problems with unique restrictions

r for PL/PGSQL with breakpoints, single step, variable watching... Anyway, PostgreSQL is the best backend I ever have worked with. Regards --Marcel >>> Tom Lane <[EMAIL PROTECTED]> 13.01.2007 >>> "Marcel Gsteiger" <[EMAIL PROTECTED]> writes: > Now since

[GENERAL] trouble with rpmbuild on WBEL3.0/x86_64

Hi all, I wanted to install postgreSQL 7.4 on my ia32e box (x86_64 dual xeon PL370G4) running WBEL3.0. I looked for binary RPMs but did not find any. So I tried to rpmbuild --rebuild --define 'build9 1' postgresql-7.4.6-2PGDG.src.rpm but during configure I get the error checking for pyth

Antw: Re: [GENERAL] trouble with rpmbuild on WBEL3.0/x86_64

way to accomplish this? Seems that making x86_64 rpms for postgresql is somewhat tricky... regards --marcel >>> Devrim GUNDUZ <[EMAIL PROTECTED]> 09.11.2004 >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 1 Nov 2004, Marcel Gsteiger wrote: > I wanted t

[GENERAL] Problems with information_schema

Hi all I just copied a rather complex application database together with all tables and triggers to 8.0.0RC1 running under windows (the original 7.4 database still runs on linux). I migrated everyting using pg_dump and then executing the resulting scripts via pgsql. Most things work as expecte

[GENERAL] cleanup of pg_temp schemas

Hi all, My PostgreSQL app uses temporary tables. After some time, my database shows lots of pg_temp_xxx schemas with no data inside. I tried to do a vacuum full analyze to get rid of them, but they still persisted. Who takes care for removing these schemas? Can I safely ignore them, or do I ha

Antw: Re: [GENERAL] Why does the JDBC driver not supportprepareCall?

thanks for the response, with UltraDEV 4.0 the problem seems to be solved. >>> Joel Bernstein <[EMAIL PROTECTED]> 19.01.2001 16.49 Uhr >>> I have not tried prepareCall with postgreSQL but it makes sense that it would not be implemented. prepareCall is a JDBC method used to call stored procedur