Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Apr 26, 2009 at 11:54:55AM +0100, Sam Halliday wrote: > On 26 Apr 2009, at 07:05, to...@tuxteam.de wrote: >>> - a single psql server can autonomously start up and serve connection >>> requests (this cannot be done with encrypted disc) >> >> Sur

Re: [HACKERS] To know what a macro does

2009-04-26 Thread Martijn van Oosterhout
On Sun, Apr 26, 2009 at 08:33:42PM -0430, Werner Echezuria wrote: > Well, I do a query like this: "SELECT * FROM historial WHERE > id_grupo=grupo_hist ORDER BY grmemb LIMIT 10;", then in transformSortClause > I know it this way: Ok, this is way over my head. But really, it would be helpful to know

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Apr 26, 2009 at 04:40:33AM -0700, Sam Halliday wrote: > > > Tomas Zerolo wrote: > > > > Note that I'm not talking about stealing the hardware, but hijacking, > > trojanizing, whatever. That's the real threat, in this > > Javascript/Flash/Sil

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, Apr 26, 2009 at 03:13:16PM -0700, Sam Halliday wrote: > > TrueCrypt is exactly the "encrypted drive" solution. It has problems. They > are described in this thread. No. This is about *clients* (i.e. laptops which can be stolen). How some comp

Re: [HACKERS] To know what a macro does

2009-04-26 Thread Werner Echezuria
Well, I do a query like this: "SELECT * FROM historial WHERE id_grupo=grupo_hist ORDER BY grmemb LIMIT 10;", then in transformSortClause I know it this way: /* * transformSortClause - * transform an ORDER BY clause * * ORDER BY items will be added to the targetlist (as resjunk columns)

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Gurjeet Singh
On Mon, Apr 27, 2009 at 3:43 AM, Sam Halliday wrote: > > TrueCrypt is exactly the "encrypted drive" solution. It has problems. They > are described in this thread. If there were a way to prompt the user for the password to an encrypted >> drive on startup for all OS, with an equivalent for headl

[HACKERS] Open source and diagramming survey

2009-04-26 Thread chung
Dear open source contributors, I am Eunyoung Chung, a Masters student working with Dr. Jensen at Oregon State University. We are currently doing a research project in collaboration with Dr. Truong and Ph.D student Koji Yatani at University of Toronto. Our goal is to understand how contributors c

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Sam Halliday
TrueCrypt is exactly the "encrypted drive" solution. It has problems. They are described in this thread. Sam Mason wrote: > > There are various tools that allow you to do this without specialised > hardware, TrueCrypt[1] is one I've used in the past and is very easy for > naive users to get the

Re: [HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Tom Lane
Gevik Babakhani writes: > As I was working on my code generator app, I noticed that one is able to > create a function with multiple parameters with the same name. I'm pretty sure this has come up before and we concluded that prohibiting it in CREATE FUNCTION wasn't terribly exciting. For insta

Re: [HACKERS] To know what a macro does

2009-04-26 Thread Martijn van Oosterhout
On Sun, Apr 26, 2009 at 04:20:41PM -0430, Werner Echezuria wrote: > Hi, I've been trying to sort a column that performs some calculations, but > postgres says this: ERROR: invalid attnum: -12851. I was searching on the > source code, and I guess the error araises around this macro: I'm pretty sur

Re: [HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Gevik Babakhani
No. I meant: create function foo(PAR1 varchar, PAR1 int, PAR1 uuid). Note PAR1 Jaime Casanova wrote: On Sun, Apr 26, 2009 at 3:32 PM, Gevik Babakhani wrote: Hi, As I was working on my code generator app, I noticed that one is able to create a function with multiple parameters with the

Re: [HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Jaime Casanova
On Sun, Apr 26, 2009 at 3:32 PM, Gevik Babakhani wrote: > Hi, > > As I was working on my code generator app, I noticed that one is able to > create a function with multiple parameters with the same name. For example: > you mean this http://www.postgresql.org/docs/current/static/xfunc-overload.htm

[HACKERS] To know what a macro does

2009-04-26 Thread Werner Echezuria
Hi, I've been trying to sort a column that performs some calculations, but postgres says this: ERROR: invalid attnum: -12851. I was searching on the source code, and I guess the error araises around this macro: /* * Copy the given tuple into memory we control, and decrease availMem. * Th

[HACKERS] Multiple parameters with the same name for functions.

2009-04-26 Thread Gevik Babakhani
Hi, As I was working on my code generator app, I noticed that one is able to create a function with multiple parameters with the same name. For example: create or replace function func_test(id integer,id varchar, id timestamp) returns void as $$ begin raise notice '%',id; end; $$ language

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Sam Mason
On Mon, Apr 27, 2009 at 07:03:32AM +1200, Andrej wrote: > 2009/4/26 Sam Halliday : > > I'm still talking about theft of machines (particularly laptops) as that is > > a major threat. One need only read the British newspapers to discover story > > after story of articles where "sensitive information

[HACKERS] Restore deleted rows

2009-04-26 Thread Anton Egorov
Hi! I need to recover deleted rows from table. After I delete those rows I stopped postgres immediately and create tar archive of database. I found solution http://archives.postgresql.org/pgsql-hackers/2005-03/msg00965.php, but is there another (easyer) way to do it?

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Andrej
2009/4/26 Sam Halliday : > I'm still talking about theft of machines (particularly laptops) as that is > a major threat. One need only read the British newspapers to discover story > after story of articles where "sensitive information was on a laptop which > was stolen". As pointed out elsewhere,

[HACKERS] A couple of gripes about the gettext plurals patch

2009-04-26 Thread Tom Lane
I see that the recently committed changes typically use ngettext in this style: ereport(msglevel, /* translator: %d always has a value larger than 1 */ (errmsg(ngettext("drop cascades to %d other object", "drop cascades to %d

Re: [HACKERS] Patch to add support for text/int arrays for plpythonu

2009-04-26 Thread Valtonen, Hannu
On 4/26/09 6:23 PM, Tom Lane wrote: Why in the world would you confine the feature to just two data types? This seems like a fundamentally incorrect approach. The reason why I wrote it that way is because that's the way plpythonu's conversion to python and back is set up. Without my patch

Re: [HACKERS] GCC 4.4 compiler warnings

2009-04-26 Thread Grzegorz Jaskiewicz
On 26 Apr 2009, at 16:22, Tom Lane wrote: Grzegorz Jaskiewicz writes: tab-complete.c:666: warning: implicit declaration of function 'completion_matches' Are you sure you have a real installation of readline? OSX is notorious for providing a bogus one, particularly in older release series.

Re: [HACKERS] Patch to add support for text/int arrays for plpythonu

2009-04-26 Thread Tom Lane
"Valtonen, Hannu" writes: > Attached is a small patch for adding support for INT[] and TEXT[] to > plpythonu. Why in the world would you confine the feature to just two data types? This seems like a fundamentally incorrect approach. regards, tom lane -- Sent via pgsql-

Re: [HACKERS] GCC 4.4 compiler warnings

2009-04-26 Thread Tom Lane
Grzegorz Jaskiewicz writes: > tab-complete.c:666: warning: implicit declaration of function > 'completion_matches' Are you sure you have a real installation of readline? OSX is notorious for providing a bogus one, particularly in older release series. regards, tom lane

Re: [HACKERS] GCC 4.4 compiler warnings

2009-04-26 Thread Grzegorz Jaskiewicz
and a quick one on mac os x, which looks like it has something to do with COMPLETE_WITH_LIST() and macros like that, and maybe with completion_matches on mac os x. I don't get these on linux. This is from gcc4.4 with -O3 (which obviously causes gcc to find more potential warnings). tab-com

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Sam Halliday
Tomas Zerolo wrote: > > Note that I'm not talking about stealing the hardware, but hijacking, > trojanizing, whatever. That's the real threat, in this > Javascript/Flash/Silverlight infested world. > I'm still talking about theft of machines (particularly laptops) as that is a major threat. On

[HACKERS] Patch to add support for text/int arrays for plpythonu

2009-04-26 Thread Valtonen, Hannu
Hi, Attached is a small patch for adding support for INT[] and TEXT[] to plpythonu. There are also some small tests for this copypasted to the end of the mail. I'd like to get this into CVS but as it's probably a bit late for 8.4 I wouldn't mind it going into the first commitfest for 8.5. -

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-26 Thread Sam Halliday
On 26 Apr 2009, at 07:05, to...@tuxteam.de wrote: - a single psql server can autonomously start up and serve connection requests (this cannot be done with encrypted disc) Sure it can -- it will be strongly architecture dependent though. Look at [1] for an example of how this might be done for t