Re: [GENERAL] psql from Linux script

On Tue, Aug 30, 2005 at 09:25:07PM +1200, Bernard wrote: > The postgresql.org server is the only braindead list server I have > seen so far. http://www.unicom.com/pw/reply-to-harmful.html It is the rule on technical mailing lists. -- marko ---(end of bro

Re: [GENERAL] psql from Linux script

bit... -- marko ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] psql from Linux script

t; # su postgres > $ psql template1 > template1=# ALTER USER postgres WITH PASSWORD 'newpassword'; > ALTER USER > \q > $ exit > # -- marko ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Adding contrib modules

&> fts.out > > for testing of course > > the fts.out file has things like > > ERROR: type "tsvector" does not exist > ERROR: type "tsquery" does not exist > ERROR: function lexize("unknown", "unknown") does not exist &g

Re: [GENERAL] Using pgcrypto with AES-256 bits?

of the module, so the AES 256 functionality can be only provided by OpenSSL? Builtin AES supports 256-bit keys too. -- marko ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] kinda newbie - ish question

_id_seq') where id = currval('tbl_id_seq') This must be in the same TX as first insert. -- marko ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Function exists

s. Eg., for \df - 'show functions' it does: $ psql -E marko=# \df * QUERY * SELECT format_type(p.prorettype, NULL) as "Result", p.proname as "Function", oidvectortypes(p.proargtypes) as "Arguments" FROM pg_proc p WHERE p.prorettype <>

Re: [GENERAL] Encoding passwords

; > greatly appreciated. Look into contrib/pgcrypto in CVS, or http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz in meantime. Gives you crypt() function not unlike in UNIXes. Also gen_salt() for generating salts for it. -- marko ---(end of broadcast)-

Re: [GENERAL] how to get the md5 result of a string ?

On Mon, Sep 10, 2001 at 11:40:27PM +0200, Feite Brekeveld wrote: > Is there a function like: > > select md5() from digest(field, 'md5') If you want in hex: encode(digest(field, 'md5'), 'hex') Look into contrib/pg

Re: [GENERAL] JDBC and Accents

g is SQL_ASCII... > > Is there any temporary solutions, or may a convert the db in an other > encoding? Correct solutions is really dump database, create db with right encoding and restore. But for temporary solution ;) you could use PostgreSQL 7.0 JDBC driver, which does not support th

Re: [GENERAL] crypt(table.field) ?

t you are doing. In the next release they will be renamed to raw_encrypt()/raw_decrypt() and much better encrypt()/decrypt() will be provided based on OpenPGP (RFC2440) - I am still developing this. Also pgcrypto-0.3 should work with both 7.0 and 7.1. -- marko

Re: [GENERAL] crypt(table.field) ?

stgreSQL source for that. There is a patch in techdocs site which imports system crypt to SQL level and there is my pgcrypto package which does this and more... http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz -- marko ---(end of broadcast)

Re: [GENERAL] JDBC and Perl compiling problems w/ postgresql-7.1rc4

you dont have JAVA_HOME/lib/tools.jar in Ant's classpath. Next, if you have Ant 1.2 (especially Debian's) & jdk1.3 (well, you have this one) and have problems with: 1) undefined ${major} or 2) Zip* error: cannot create archive with no entries (from memory, cant remember exact message

Re: [GENERAL] fmgr, C , and character arguments

return 0; } This may work, but is more to give you idea what PostgreSQL vars are about. I would not use such code in my projects anyway :) I suggest you study the code in src/backend/utils/adt/varchar.c to see examples of char/text manipulation. -- marko ---(end of

[GENERAL] [Announce] pgcrypto 0.3 (long)

pgcrypto 0.3 / "why-dont-you-show-some-code" release http://www.l-t.ee/marko/pgsql/pgcrypto-0.3.tar.gz This release is give people something to play with. Parts of it need further thinking and lots of testing, but I am tired of sitting on it. Here follow parts from README

Re: [GENERAL] Re: DES in Postgres?

y format stable, then release, but if there is interest I can make a for-playing-only release. Btw, I have hmac() and crypt() too... -- marko

Re: [GENERAL] DES encryption in Postgres?

yself also does not need it. Maybe you are better off doing that in application level? If you have good use for it I guess it can be looked into... -- marko

Re: [GENERAL] using crypt authentication

rsion of the perl module. Any ideas? Use SSL. > p.s. remove the nospam from the return address to respond directly to > me Do not overdo it. -- marko

Re: [GENERAL] MySQL PASSWORD('x') function workalike

(Note that I > mean crypto hashes like MD5 and hopefully compatible with the hashes used > for pg_passwd). You can check out my implementation I just released ;) http://www.l-t.ee/marko/pgsql/pgcrypto-0.1.tar.gz And you can check out -hackers mail I sent. btw its 20k not 11k as the previous

[GENERAL] binary operators on integers

cation server, so different bits are for different capabilities. TIA. -- marko

<    1   2