Re: [HACKERS] UPDATE is not allowed in a non-volatile function

2004-11-07 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: The fact that a non-volatile function can not perform update is a good improvement but on the other side will limit too much if I know what I'm doing. I've got zero sympathy for this argument. It's been documented right along

Re: [HACKERS] [pgsql-www] pg_autovacuum is nice ... but ...

2004-11-05 Thread Gaetano Mendola
, of course you have to create a memory manager that handle not ccntinuous segments. Of course this only if the effort to do it can justify the man power working on it. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase

Re: [HACKERS] [pgsql-www] pg_autovacuum is nice ... but ...

2004-11-05 Thread Gaetano Mendola
Neil Conway wrote: Gaetano Mendola wrote: Right but we can create a new segment and use it too. I don't know how these segments are used but I used to do it in the past, of course you have to create a memory manager that handle not ccntinuous segments. The TelegraphCQ folks have already

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
(and/or arch) for source control, so that some developer groups and also our system administrators could get some experience with it. I good very start point is see if cvs2svn can handle the postgresql CVS without errors. Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] [pgsql-www] pg_autovacuum is nice ... but ...

2004-11-05 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert Treat wrote: | On Friday 05 November 2004 07:48, Gaetano Mendola wrote: | |Neil Conway wrote: | Gaetano Mendola wrote: | Right but we can create a new segment and use it too. I don't know how | these segments are used but I used to do

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
important here is the client side and now that the win environment matter more then before, I have to say that TortoiseSVN ( tortoisesvn.tigris.org ) is much better then WinCVS. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
home page. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBi9bJ7UpzwH2SGd4RAgraAKCcNLaMJPPjVxfqRQ1yGG2+GssiAACeJFg3 zULofgK2ouUum3wNSjUmG3U= =Bq/a -END PGP SIGNATURE

Re: [HACKERS] UPDATE is not allowed in a non-volatile function

2004-11-04 Thread Gaetano Mendola
is enforce the check between functions call ( I prefer even only this one), and at the same time provide a mutable attribute for tables ( a mutable table can be updated even inside an immutable contest ). Regards Gaetano Mendola ---(end of broadcast

[HACKERS] Wrong on-line documentation version

2004-11-04 Thread Gaetano Mendola
Hi all, the on line doc still show the 7.4.5. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] CVS should die

2004-11-04 Thread Gaetano Mendola
. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] [pgsql-hackers] UPDATE is not allowed in a non-volatile function

2004-11-02 Thread Gaetano Mendola
marked as VOLATILE ( that IMHO is not so good... ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Design by contract

2004-11-01 Thread Gaetano Mendola
Hi all, I don't know how much is effective or if it's applicable to postgresql processe but it's an interesting article: http://www.onlamp.com/pub/a/onlamp/2004/10/28/design_by_contract_in_c.html Regards Gaetano Mendola ---(end of broadcast)--- TIP

[HACKERS] UPDATE is not allowed in a non-volatile function

2004-11-01 Thread Gaetano Mendola
status marked as mutable. ( For example you need to count how many time a const function was called ). I think a clean solution is be able to declare a table as mutable as well. Am I completely wrong or out of mind ? Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] UPDATE is not allowed in a non-volatile function

2004-11-01 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: The fact that a non-volatile function can not perform update is a good improvement but on the other side will limit too much if I know what I'm doing. I've got zero sympathy for this argument. It's been documented right along

Re: [HACKERS] Suggestion: additional system views

2004-10-31 Thread Gaetano Mendola
of dependencies with other objects. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Why we still see some reports of could not access transaction

2004-10-15 Thread Gaetano Mendola
as known-dead or known-good. I found one. Are you going to fix it for the 8.0 and/or back patch it ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-12 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gavin Sherry wrote: | On Fri, 8 Oct 2004, Gaetano Mendola wrote: | | |Gavin Sherry wrote: | On Wed, 6 Oct 2004, Josh Berkus wrote: | | [snip] | | | Of course, this is as true of functions as it will be of procedures. So half | the functionality

Re: [HACKERS] plans for bitmap indexes?

2004-10-12 Thread Gaetano Mendola
city = Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] postgres vulnerability

2004-10-09 Thread Gaetano Mendola
Here http://www.sans.org/top20/#u9 are listed postgres vulnerability it's sad see that almost all are related to third part components Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] postgres vulnerability

2004-10-09 Thread Gaetano Mendola
Stephan Szabo wrote: On Sat, 9 Oct 2004, Stephan Szabo wrote: On Sat, 9 Oct 2004, Gaetano Mendola wrote: Here http://www.sans.org/top20/#u9 are listed postgres vulnerability it's sad see that almost all are related to third part components I'd go further than sad and say irresponsible

Re: [HACKERS] more dirmod CYGWIN (was: APR 1.0 released)

2004-10-08 Thread Gaetano Mendola
Bruce Momjian wrote: I just made some major Win32 modifications in the past few days. Would you try Cygwin compile and see if the following warnings are removed and the rest of the system builds OK? Now that postgres 8.0 is win32 native is it still necessary support the cygwin ? Regards Gaetano

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-07 Thread Gaetano Mendola
the world ( it could be wrong ) these two functions above have the same signature, so the second declaration shall be not allowed, do you want put also the formal parameters names in the function signature ? Orrible. Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] SQL-Invoked Procedures for 8.1

2004-10-07 Thread Gaetano Mendola
word, but that suggestion seems not to have garnered any support. I'm too for use the AS instead of '='. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] ERROR: left link changed unexpectedly

2004-10-04 Thread Gaetano Mendola
Anyone interested ? Regards Gaetano Mendola Gaetano Mendola wrote: Hi all, in my development server running a 7.4.5 I can replicate continuously this error: ERROR: left link changed unexpectedly I obtain this with a vacuum full: test=# vacuum full verbose ua_user_data_exp; INFO: vacuuming

Re: [HACKERS] ERROR: left link changed unexpectedly

2004-10-04 Thread Gaetano Mendola
Alvaro Herrera wrote: On Tue, Oct 05, 2004 at 12:08:26AM +0200, Gaetano Mendola wrote: Anyone interested ? I saw the code involved, and I think the only way this can happen is if the index file itself was corrupted by previous operation. How could that happen elludes me; maybe a previous VACUUM

Re: [HACKERS] Checking for overflow of integer arithmetic

2004-10-03 Thread Gaetano Mendola
))) ! ereport(ERROR, ! (errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE), ! errmsg(integer out of range))); ! PG_RETURN_INT32(result); } May be is a good idea postpone the division as second OR argument in order to hope to avoid it. Regards Gaetano Mendola ---(end

Re: [HACKERS] Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd

2004-10-02 Thread Gaetano Mendola
Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] ERROR: left link changed unexpectedly

2004-10-01 Thread Gaetano Mendola
[31356]: [1269-1] ERROR: XX000: left link changed unexpectedly Oct 1 21:35:38 porto postgres[31356]: [1269-2] LOCATION: _bt_pagedel, nbtpage.c:888 I don't care to fix the problem immediatelly, so if you want dig on it let me know. Regards Gaetano Mendola -BEGIN PGP SIGNATURE

[HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
me know. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
condition is still there but with less chance to pops up. Is it so dangerous teach the postmaster to solve this kind of problems without a direct user intervention ? Regards Gaetano Mendola On 9/30/2004 6:16 AM, Gaetano Mendola wrote: Hi all, I'm running postgres 7.4.5 on a linux box

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: I'm running postgres 7.4.5 on a linux box, this morning I got this error on my logs: WARNING: FlushRelationBuffers(exp_provider, 1836): block 1460 is referenced (private 0, global 1) ERROR: FlushRelationBuffers returned -2 Info

Re: [HACKERS] Index locking considerations

2004-09-30 Thread Gaetano Mendola
is a table that implement a materialized view so is heavily updated by triggers. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[HACKERS] Postgres 8.0 with gcc 4.0 success

2004-09-22 Thread Gaetano Mendola
= Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Gaetano Mendola
(1.5.2?). This is the check that I suggest to add recently :-( See the thread x86_64 configure problem on hackers You need to install the distutils, and how I wrote in that thread, it's not clear that that module is installed by default when you install python. Regards Gaetano Mendola

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Gaetano Mendola
have python 1.5(1.5.2?). This is the check that I suggest to add recently :-( See the thread x86_64 configure problem on hackers You need to install the distutils, and how I wrote in that thread, it's not clear that that module is installed by default when you install python. Regards Gaetano

[HACKERS] RSS

2004-09-20 Thread Gaetano Mendola
Hi all, I'm using the RSS on Mozilla Thundebird and I'm noticing that all entries are with the date: 01/01/1970 other sites are not affected by this issue. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] RSS

2004-09-20 Thread Gaetano Mendola
Gaetano Mendola wrote: Hi all, I'm using the RSS on Mozilla Thundebird and I'm noticing that all entries are with the date: 01/01/1970 other sites are not affected by this issue. Of course I'm speaking about www.postgresql.org :-) Watching at the two RSS: http://www.postgresql.org/news.rss http

Re: [HACKERS] No parameters support in create user?

2004-09-20 Thread Gaetano Mendola
. Create your own plpgsql function and call it. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] problem permission on view

2004-09-17 Thread Gaetano Mendola
this by myself but for lack of time and lack of postgres code knowledge I'm stuck. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] problem permission on view

2004-09-17 Thread Gaetano Mendola
Andreas Pflug wrote: Gaetano Mendola wrote: I'd like to fix this by myself but for lack of time and lack of postgres code knowledge I'm stuck. What you want is CREATE VIEW foo AS SELECT p1, p2, bar('theValidParameter') as p3 FROM othertab; GRANT ALL ON TABLE foo TO public; and don't want

[HACKERS] problem permission on view

2004-09-16 Thread Gaetano Mendola
on V 2) Exceute permission + Security Definer attr on F. this last point give to the user the possibility to execute F with any aribitrary value, instead of only the values present on the view ( already filtered ). Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] x86_64 configure problem

2004-09-15 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joe Conway wrote: | Gaetano Mendola wrote: | | python -c from distutils import * /dev/null 21 || (echo You | need distutils installed; exit 1) | | | Sorry for the delay -- things got busy around here all of a sudden. | | Attached is a version

Re: [HACKERS] PostgreSQL Core Committee Welcomes New Member

2004-09-15 Thread Gaetano Mendola
Marc G. Fournier wrote: In recognition of his role as lead developer on the internationalization front, as well as his invaluble work in both the build and release processes, Peter Eisentraut has been invited, and has accepted, to join the Core Committee. Good work, Peter. Regards Gaetano

[HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Gaetano Mendola
ON foo FOR EACH ROW EXECUTE PROCEDURE trigger_foo('field1'); insert into foo values ( 3 ); I got the error in the subject, it's like the EXECUTE open another contest and forget that is inside a rule. Any idea someone ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4

Re: [HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Gaetano Mendola
in a command string given to EXECUTE. You probably need to set up an IF...ELSIF...ELSE...END IF structure to get the value to put into the command string. I can't because the combination are not a limited number. Regards Gaetano Mendola ---(end of broadcast

[HACKERS] security definer on views

2004-09-12 Thread Gaetano Mendola
Hi all, one year ago I did this post: http://archives.postgresql.org/pgsql-admin/2003-04/msg00137.php however I had no reply att all, do you know why there is not a concept of: security definer on views too ? If in that post I was not clear please let me know. Regards Gaetano Mendola

Re: [HACKERS] pgindent vs try/catch

2004-09-12 Thread Gaetano Mendola
is removed the local variable shadow the formal parameter. Some compilers do not warning you, IIRC the Digital had this funny omission, ( however you can miss the warning ) and hours of debugging are behind the corner. I hope that Bruce change his mind... Regards Gaetano Mendola

Re: [HACKERS] x86_64 configure problem

2004-09-12 Thread Gaetano Mendola
Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] pgindent vs try/catch

2004-09-12 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce Momjian wrote: | Gaetano Mendola wrote: | |I had that argument a while ago with Bruce and lost :-) . It does horrible |things to if/else constructs too. The workaround is to put a comment in the |block. On the whole I agree with you, though. If I

Re: [HACKERS] Adding columns in the middle (Was: Developers page is down)

2004-09-11 Thread Gaetano Mendola
on this, the only reason this feature is needed is to continue to have a well table structure, see my last post. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: # python -c from distutils.sysconfig import get_python_lib as f; import os; print os.path.join(f(plat_specific=1,standard_lib=1),'config') /usr/lib64/python2.3/config Any other proposals? If not, any objections to the attached patch

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: What version of python comes with RH2.1? 1.5.2 In any case, the online documentation for python suggests that it is reasonable to expect that distutils is already installed (by default for python = 1.6, and by the user for python 1.5.2

Re: [HACKERS] x86_64 configure problem

2004-09-11 Thread Gaetano Mendola
Joe Conway wrote: Gaetano Mendola wrote: Joe Conway wrote: I wasn't going to -- python's own docs say I shouldn't need to. From the link above: the Distutils work just fine with Python 1.5.2, and it is reasonable (and expected to become commonplace) to expect users of Python 1.5.2 to download

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-09-10 Thread Gaetano Mendola
with backward compatability. One thing is emerging from this thread: the \xyzk functionality is overloaded. Time to switch to something more human readable ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Supporting Encryption in Postgresql

2004-09-09 Thread Gaetano Mendola
your customers then this information shall be stored in an encrypted form. The bast way I found to accomplish this is using an encrypted file system. Google for cryptoloop or if you are brave enough look for StegFS. Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] x86_64 configure problem

2004-09-09 Thread Gaetano Mendola
/config Any other proposals? If not, any objections to the attached patch? No one, we have to check also for the presence of distutils package installation. It's not installed by default and I was bitten by it during the RPM building for RH AS 2.1 Regards Gaetano Mendola

Re: [HACKERS] Clarification of action on Delete

2004-09-09 Thread Gaetano Mendola
a glitch. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] FYI: Fujitsu

2004-09-08 Thread Gaetano Mendola
the opportunity to do this, and I look forward to doing what I can to improve PostgreSQL over the next year. -Neil Congratulation. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [HACKERS] Geometry regression test failure, CVS HEAD, Mac OS/X

2004-09-08 Thread Gaetano Mendola
. So far my thoughts are to classify by Architecture,OS+Version,Compiler+Version. Thoughts? This can be a good model to follow: http://boost.sourceforge.net/regression-logs/ Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Why does pg_stat_activity Truncate Queries?

2004-09-07 Thread Gaetano Mendola
or so. Feel free to bump up PGSTAT_ACTIVITY_SIZE to 1000 or so in src/include/pgstat.h (and yes, this is already done for 8.0). I didn't see this changement in the 8.0 release note, don't you think shall be added ? Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] huge execution time difference with almost same plan

2004-09-06 Thread Gaetano Mendola
... Isn't enough have the related costs for table spaces ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Developers page is down

2004-09-05 Thread Gaetano Mendola
- New fields must be added at the end. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBOt717UpzwH2SGd4RAuuZAJwKkDVpwgRNI0vQJ4TC7qllQjH5XgCgmrKv kqwKVVO3ha+FUsQHggyfyvU= =z9y4

Re: [HACKERS] invalid string enlargment PG 7.4.5 ( SOLVED )

2004-09-05 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes: | || ERROR: invalid string enlargement request size 1476395004 || DEBUG: AbortCurrentTransaction || WARNING: AbortTransaction and not in in-progress state || ERROR: could not send data

Re: [HACKERS] Adding columns in the middle of tables

2004-09-05 Thread Gaetano Mendola
... However I'm with Tom Lane, this feature have a big impact on the code and give a not so big improvement. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Developers page is down

2004-09-04 Thread Gaetano Mendola
. just curious. No IIRC. The core doesn't think this is a valid feature. I had in the past my reasons to ask for it too. If you have yours may be... Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [HACKERS] Developers page is down

2004-09-04 Thread Gaetano Mendola
that _don't_ forcibly have an order, because sets are unordered. Means the order that \d show the columns ( for example ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

[HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Hi all, now that Apache Portable Runtime was release why don't use it on Postgres? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: now that Apache Portable Runtime was release why don't use it on Postgres? The sense of the question is backwards. Why *should* we use it? In order to avoid all the annoyance that someone else had in write code portable. I mean, how much

[HACKERS] invalid string enlargment PG 7.4.5 ( SOLVED )

2004-09-04 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I don't see the last post about the issue I had and that was solved ( due I think to last days problems), I post it here again: Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
Christopher Browne wrote: ... And since APR isn't BSD licensed, that would probably cause a problem. They are changin license for APR and I'll be not surprised if they adopth the BSD one. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3

Re: [HACKERS] APR 1.0 released

2004-09-04 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes: |I don't know if APR provide a spin lock mechanism, | | | You don't even know that, but you're confident that we can throw away | our spinlock work and use APR anyway. You're wasting our time

[HACKERS] www.postgresql.org hacked ?

2004-09-03 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, what is that: myGeek balance authentication page ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBOG3A7UpzwH2SGd4RAkfDAJ95/Y

Re: [HACKERS] version upgrade

2004-09-02 Thread Gaetano Mendola
Jan Wieck wrote: On 9/1/2004 9:02 PM, Gaetano Mendola wrote: Jan Wieck wrote: Which is another point I was about to ask. How do these people, running those huge and horribly important databases, ever test a single application change? Or any schema changes for that matter. Do they really

[HACKERS] iinvalid string enlargement PG 7.4.5

2004-09-01 Thread Gaetano Mendola
any idea on what could be the reason ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBNlh77UpzwH2SGd4RAqfoAJ4zEPgG/0Yr8YTKN+PpbYQvbU7TigCggQ+3 ie8oxH9jFgFDDMlZfNnKj4w= =5epB -END

Re: [HACKERS] version upgrade

2004-09-01 Thread Gaetano Mendola
after an alter schema operation. Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] iinvalid string enlargement PG 7.4.5

2004-09-01 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: ERROR: invalid string enlargement request size 1476395004 DEBUG: AbortCurrentTransaction WARNING: AbortTransaction and not in in-progress state ERROR: could not send data to client: Broken pipe PANIC: error during error recovery

[HACKERS] compiling postgres 8.0 in 47 seconds

2004-08-29 Thread Gaetano Mendola
Hi all, today I tried this tool: http://www-106.ibm.com/developerworks/linux/library/l-ccache.html and the second full compilation, after a make clean took: 47 seconds. Amazing. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9

[HACKERS] DCO and postgresql

2004-08-27 Thread Gaetano Mendola
to postgresql development, having seen some proprietary database becoming Open Source who never know ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBL3tR7UpzwH2SGd4RAiF9AJ0U

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Gaetano Mendola
? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBL6Hk7UpzwH2SGd4RAtraAJ4gLV3InpVdgtjhyK1Xaoe0f9Et/gCffzDq WhQakLMGcB+in0H2qDV7qmY= =/aUP -END PGP SIGNATURE

Re: [HACKERS] Win32 release warning

2004-08-26 Thread Gaetano Mendola
with the same level of caution as you would a new product. What about: ... Unix like platforms ... Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] rpm for RH AS 2.1 ?

2004-08-25 Thread Gaetano Mendola
: Python Makefile not found error: Bad exit status from /var/tmp/rpm-tmp.56347 (%build) Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] rpm for RH AS 2.1 ?

2004-08-25 Thread Gaetano Mendola
Devrim GUNDUZ wrote: Hi, On Wed, 25 Aug 2004, Gaetano Mendola wrote: anyone succesfull create all the rpm for RH AS 2.1 ? I was able to do it using the srpms for RH9 but I did it with --define 'python 0'. Any idea on how to obtain also the postgresql-python.rpm ? Without 'pyhton 0

Re: [HACKERS] debuging postgres

2004-08-24 Thread Gaetano Mendola
? I'm seeing that with --enable-debug only the option -g is passed to the compiler and the option -O2 is still there, is it not better compile with -O0 if you are going to debug it? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you

Re: [HACKERS] debuging postgres

2004-08-24 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola [EMAIL PROTECTED] writes: Christopher Kings-Lynne wrote: ./configure --enable-debug Is this enough? I'm seeing that with --enable-debug only the option -g is passed to the compiler and the option -O2 is still there, is it not better compile with -O0 if you

[HACKERS] futex

2004-08-24 Thread Gaetano Mendola
Hi all, I knew there was an evaluation on the futex vs spinlock, and Josh Berkus on IRC told me that there was only a 20% performance increase, is this increase to throw away ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze

[HACKERS] Interactive docs

2004-08-23 Thread Gaetano Mendola
Hi all, I don't want be a pain in the but now that 7.4.5 is officially out I think is time to change the version doc on: http://www.postgresql.org/docs/7.4/interactive/index.html Regards Gaetano Mendola ---(end of broadcast)--- TIP 2: you can

[HACKERS] debuging postgres

2004-08-23 Thread Gaetano Mendola
Hi all, in order to debug step by step the postmaster, just to understand better the code, is it enough to compile it after having exported: CFLAGS='-O0 -g' ? do you have any hint and/or tips ? BTW what do you use for this task ? Regards Gaetano Mendola ---(end

Re: [HACKERS] Interactive docs

2004-08-23 Thread Gaetano Mendola
Bruce Momjian wrote: Gaetano Mendola wrote: Hi all, I don't want be a pain in the but now that 7.4.5 is officially out I think is time to change the version doc on: http://www.postgresql.org/docs/7.4/interactive/index.html I have updated the FAQ. ?? However I see now the right

Re: [HACKERS] PITR: XLog File compression on Archive

2004-08-23 Thread Gaetano Mendola
/2004-08/msg00704.php and my success: http://archives.postgresql.org/pgsql-hackers/2004-08/msg00852.php Am I right ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [HACKERS] postgres uptime

2004-08-21 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola [EMAIL PROTECTED] writes: | |I think we should just call gettimeofday() at postmaster start and store |it somewhere. | | |Isn't the shared memory a good place ? | | | Depends. Do you want to reset it during a backend

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
or something. | | However, adding a new function requires a re-initdb, so it's quite | unlikely this will be in for 8.0. Even if the re-initdb was not necessary we are in beta, and usualy the new features are not allowed. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
Tom Lane wrote: I'd like to see more than one person requesting this (and with solider rationales) before it gets added to TODO. If I wanted to be picky I would suggest that knowledge of the server start time might be useful information to an attacker. It would for instance narrow down the

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
more difficult retrieve this value. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[HACKERS] 7.4.5 on RH 2.1AS

2004-08-20 Thread Gaetano Mendola
-ip.com/rpm745.htm Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBJjZ17UpzwH2SGd4RAivQAJ9LNWsjYMxYG7dK29PYGVbUxheGOACgriVe mzWhNZxy6zRIdHfVArBJjAA= =rco3 -END PGP SIGNATURE

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
think we should just call gettimeofday() at postmaster start and store it somewhere. Isn't the shared memory a good place ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] devx article

2004-08-20 Thread Gaetano Mendola
Hi all, reading this article: http://www.devx.com/dbzone/Article/20743 I notice on page 2: New versions of PostgreSQL support standard row-level locking as an option, but MVCC is the preferred method What this does mean ? Regards Gaetano Mendola ---(end of broadcast

Re: [HACKERS] Tablespace and cpu costs

2004-08-19 Thread Gaetano Mendola
Gavin Sherry wrote: On Wed, 18 Aug 2004, Gaetano Mendola wrote: Gavin Sherry wrote: On Wed, 18 Aug 2004, Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, now that we have the tablespace support don't you think that each tablespace needs his own costs instead

[HACKERS] postgres uptime

2004-08-19 Thread Gaetano Mendola
that windows version is out I believe a platform indipendent way is required. Any objection to add it ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Tablespace and cpu costs

2004-08-18 Thread Gaetano Mendola
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, now that we have the tablespace support don't you think that each tablespace needs his own costs instead of a system wide one ? I searched in the archives and on the TODO list without success. Regards Gaetano Mendola -BEGIN PGP SIGNATURE

Re: [HACKERS] [ADMIN] SRPM for 8.0.0 beta?

2004-08-18 Thread Gaetano Mendola
of change the default port. I did it as usual changing it in postgresql.conf but that parameter is overriden by: PGPORT=5432 present on the start up script. There is any reason to still pass this parameter to postmaster ? Regards Gaetano Mendola ---(end of broadcast

<    1   2   3   4   5   >