on sunday, 23rd of march, tom lane commited another new-feature patch. this new patch was from brendan jurd, and adds quote_nullable() function:
Tag: postgresql
waiting for pg 8.4
yesterday, tom lane committed another great feature. actually it's so great, that i really wonder how could i live without it earlier.
patch came from itagaki takahiro, and was heavily modified by tom. what it does?
getting multiple values from sequences
there are this situations where you need (or you think you need) to get multiple values from sequence.
for example – you're importing lots of data: some objects, some objects which relate to base objects, and so on.
of course you can do it all with simple inserts, and currval, but it would be rather slow:
smtp + sql = more than it seems so (part 8)
last time, i showed how to add automatical filtering of mails. and i told you that i will show another way.
Continue reading smtp + sql = more than it seems so (part 8)
smtp + sql = more than it seems so (part 7)
in previous part of this howto we setup autoresponder/vacation system.
additionally i promised to show how to filter user mails.
Continue reading smtp + sql = more than it seems so (part 7)
waiting for pg 8.4
today (2008-03-10) magnus hagander commited patch which adds new, quite handy functionality: “enum type for guc parameters".
smtp + sql = more than it seems so (part 6)
in last part of this howto we did setup pop3/imap client access.
together with things set in all previous parts it makes a fully working mail system.
but, there are still things that might be added/modified. one of these is vacation support …
Continue reading smtp + sql = more than it seems so (part 6)
searching for longest prefix
couple of times is was brought to attention of #postgresql channel – how to find longest prefix.
case: you have phone number, and you want to find which carrier it is bound to.
there are at least 3 ways of finding it, and i decided to take a look at which is fastest.
smtp + sql = more than it seems so (part 5)
last time i finished with working smtp system, with accounts, aliases and quota. now, let's add ability to get th
e mails for client (imap/pop3) and some smtp-auth.
Continue reading smtp + sql = more than it seems so (part 5)
smtp + sql = more than it seems so (part 4)
at the end of previous part of this text, we got our system working, and accepting emails for local accounts. plus i promised to add quota now 🙂 so, let's do it.
Continue reading smtp + sql = more than it seems so (part 4)