Re: [GENERAL] Lifecycle of PostgreSQL releases

2007-03-24 Thread Joshua D. Drake
Jim Nasby wrote: On Mar 21, 2007, at 10:10 AM, Bruce Momjian wrote: As the owner of a 1986 Toyota Celica, I can accept the argument that a newer car with slightly brighter paint might not be worth the switch. Yup... that's why I drive a 1991 Acura. Of course, there's also the fact that the NS

Re: [GENERAL] Why can't I put a BEFORE EACH ROW trigger on a view?

2007-03-24 Thread Bruce Momjian
Added to TODO: * Allow BEFORE INSERT triggers on views http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php --- Tom Lane wrote: > "Karl O. Pinc" <[EMAIL PROTECTED]> writes: >

Re: [GENERAL] Configure can't find com_err on OpenBSD for --with-krb5

2007-03-24 Thread Bruce Momjian
Tom Lane wrote: > Jim Rosenberg <[EMAIL PROTECTED]> writes: > > Here's the problem: when configure tries to compile the code snippet to > > check for com_err, it needs to do this with -lcrypto added, but it's not > > using that. What's the "right" way to fix this? I could probably get it to > >

Re: [GENERAL] Tracking disk writes?

2007-03-24 Thread Jim Nasby
On Mar 10, 2007, at 4:33 AM, Erik Jones wrote: I've seen that I can get the total number of blocks read from disk over the lifetime of a database via the pg_stat_database view, and by taking successive readings I can track reads over time. How can I track disk writes? Hey Erik... That's

Re: [GENERAL] Limiting user connnections on 7.4

2007-03-24 Thread Jim Nasby
Dropping -hackers On Mar 22, 2007, at 4:23 AM, Saqib Awan wrote: is there an existing mechanism to do user based connection controls in Postgres 7.4? Other than max_connections? -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com

Re: [GENERAL] Bitmap AND multicolumn index used !

2007-03-24 Thread Jim Nasby
Have you timed it both with and without the separate btree? It could be that using the 2 indexes is actually faster. On Mar 10, 2007, at 4:19 AM, Arnaud Lesauvage wrote: Hi list ! I have a quite large table with a PostGIS-geometry field (~25M rows) representing road segments. The segments

Re: [GENERAL] Lifecycle of PostgreSQL releases

2007-03-24 Thread Jim Nasby
On Mar 21, 2007, at 10:10 AM, Bruce Momjian wrote: As the owner of a 1986 Toyota Celica, I can accept the argument that a newer car with slightly brighter paint might not be worth the switch. Yup... that's why I drive a 1991 Acura. Of course, there's also the fact that the NSX will do 180MPH..

Re: [GENERAL] automatic value conversion

2007-03-24 Thread Sebastian Boehm
Am 24.03.2007 um 19:08 schrieb Tom Lane: Sebastian Boehm <[EMAIL PROTECTED]> writes: the functions function_in and function_out should be called automatically on select or insert / update. How can I change the table definition to use function_in and function_out transparently for me (as if the

Re: [GENERAL] automatic value conversion

2007-03-24 Thread Tom Lane
Sebastian Boehm <[EMAIL PROTECTED]> writes: > the functions function_in and function_out should be called > automatically on select or insert / update. > How can I change the table definition to use function_in and > function_out transparently for me (as if the table had a text colum) You woul

[GENERAL] automatic value conversion

2007-03-24 Thread Sebastian Boehm
Hi, currently I do this: INSERT INTO table1 (row1) VALUES ( function_in('argument1','myvalue')) and select function_out('argument1',row1) from table1; (which gives 'myvalue' again) funtion_out(text,int) returns text funtion_in(text,text) returns int the table looks like this: create table

Re: [GENERAL] Lifecycle of PostgreSQL releases

2007-03-24 Thread Alvaro Herrera
Naz Gassiep escribió: > Tom Lane wrote: > > >This line of argument ignores the fact that newer versions often contain > >fixes for data-loss-grade bugs. Now admittedly that is usually an > >argument for updating to x.y.z+1 rather than x.y+1, but I think it > >destroys any reasoning on the basis of

Re: [GENERAL] question: knopixx and postgresql on flash drive

2007-03-24 Thread Raymond O'Donnell
On 24/03/2007 03:24, Stephen Liu wrote: The advantage of running thumb drive is convenient to carry. Its disadvantage is having life-time. I don't know how big will be your Not to mention the danger of losing the confounded thing :) . I've had a scare or two in the past with these devic