Re: [ADMIN] Table size growing for no reason

2006-07-13 Thread Rodrigo De Leon
On 7/13/06, Benjamin Krajmalnik <[EMAIL PROTECTED]> wrote: I am running PostgreSQL 8.1.4 on windows. I have a table with the following structure: CREATE TABLE "public"."tblksaura" ( "ksaurasysid" SERIAL, "testtime" TIMESTAMP WITHOUT TIME ZONE, "lasthouralive" DOUBLE PRECISION[], "last2

Re: [ADMIN] 8.1 Unique Index Issue/Bug???

2006-07-13 Thread Rodrigo De Leon
On 7/13/06, Chris Hoover <[EMAIL PROTECTED]> wrote: On this table, I have created a unique index on payer_trn03, payer_trn04, and expire_timestamp. However, since the expire_timestamp is normally null, the unique index does not appear to be working. I have been able to enter two identical rows

Re: [ADMIN] Wrap (obfuscate) code

2006-07-05 Thread Rodrigo De Leon
On 7/5/06, Scott Marlowe <[EMAIL PROTECTED]> wrote: Or, just hire a crusty old perl programmer and have him write them all as one line, super compact perl scripts and use plperl. ;^) ROFLMAO! The plpgsql_o idea sounds cool, but it seems I'm the only one that presented such a need :( Maybe no

Re: [ADMIN] Wrap (obfuscate) code

2006-07-04 Thread Rodrigo De Leon
On 7/4/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: I have more then once been in an environment where, "Oh we just "sampled" the function from *xyz*". That's precisely the reason I was asking, because my colleagues and I had that same experience with Oracle packages when doing consulting wor

Re: [ADMIN] Wrap (obfuscate) code

2006-07-04 Thread Rodrigo De Leon
On 7/4/06, Jonah H. Harris <[EMAIL PROTECTED]> wrote: No, there is no such utility for PostgreSQL. And, even if there were, it wouldn't actually stop someone from reverse engineering it quite easily as the source code to PL/pgSQL itself is readily available. I see. Thanks for the reply, both t

[ADMIN] Wrap (obfuscate) code

2006-07-04 Thread Rodrigo De Leon
Good afternoon. I'm not sure if this is the correct list, so please forgive me if it's not. I was wondering if there's a mechanism (or if not, a workaround) to obfuscate server code (PL/PgSQL), a la Oracle's PL/SQL Wrap Utility: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a9662