[HACKERS] Bittorrent

2004-11-07 Thread Gaetano Mendola
Hi all, it seems that the tracker is down or at least not reachable. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
rsion 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 SIGN

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
e server, but for sure what is more 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)---

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

Re: [HACKERS] [PATCHES] CVS should die

2004-11-05 Thread Gaetano Mendola
subversion (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 ---(e

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 se

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

2004-11-05 Thread Gaetano Mendola
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. Of course this only if the effort to do it can justify the man power working on it. Rega

Re: [HACKERS] CVS should die

2004-11-04 Thread Gaetano Mendola
SVN and the only think we are going to miss is the UCM process. 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] 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] UPDATE is not allowed in a non-volatile function

2004-11-04 Thread Gaetano Mendola
a non-immutable function inside a "immutable" one and claim on this list that he lost data. I think a clean solution 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

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

2004-11-02 Thread Gaetano Mendola
ct that a function marked as IMMUTABLE can call a function 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]

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 ze

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

2004-11-01 Thread Gaetano Mendola
++ permit to declare some internal status as "mutable" in this way a non-const function is able to modify 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"

[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)

Re: [HACKERS] Suggestion: additional system views

2004-10-31 Thread Gaetano Mendola
st 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
saction numbers 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] plans for bitmap indexes?

2004-10-12 Thread Gaetano Mendola
from people where gender = 'male' intersect select * from people where city = Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

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 funct

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 irresponsib

[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?

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
y a fully reserved 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] SQL-Invoked Procedures for 8.1

2004-10-07 Thread Gaetano Mendola
function foo(i int, j int) ... > create function foo(j int, i int) ... As I see 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 ? Orri

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] 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] Checking for overflow of integer arithmetic

2004-10-03 Thread Gaetano Mendola
& ! (result/arg2 != arg1 || (arg2 == -1 && arg1 < 0 && result < 0))) ! 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 th

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

2004-10-03 Thread Gaetano Mendola
able called a --- (0 rows) and from this point of view immutable is not immutable enough: regression=# select sp_immutable() from test where sp_immutable() = 3; NOTICE: sp_immutable called NOTICE: sp_immutable called sp_immutable ------ (0 rows) Regards Gaetano Mendola -

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

2004-10-02 Thread Gaetano Mendola
the catalogs could be usefull. Regards 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
356]: [1268-5] LOCATION: vacuum_index, vacuum.c:2728 Oct 1 21:35:38 porto postgres[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 yo

Re: [HACKERS] Index locking considerations

2004-09-30 Thread Gaetano Mendola
x's parent 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

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

Re: [HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
at the race 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 run

[HACKERS] FlushRelationBuffers error

2004-09-30 Thread Gaetano Mendola
g me on IRC about this error. If you need further infos, please let 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 tha

[HACKERS] Postgres 8.0 with gcc 4.0 success

2004-09-22 Thread Gaetano Mendola
== createplan.c: In function `create_plan': createplan.c:1244: warning: 'opclass' may be used uninitialized in this function = 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
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.

Re: [HACKERS] CVS configure failure

2004-09-21 Thread Gaetano Mendola
Error 1 > > I 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 i

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

2004-09-20 Thread Gaetano Mendola
id($1)", and then using the results. 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] 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.or

[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] 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 publi

Re: [HACKERS] problem permission on view

2004-09-17 Thread Gaetano Mendola
big limitation. I'd like to fix 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

[HACKERS] problem permission on view

2004-09-16 Thread Gaetano Mendola
1) Select permission 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

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

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 2>&1 || (echo "You |> need distutils installed"; exit 1) |> | | Sorry for the delay -- things got busy around

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

2004-09-14 Thread Gaetano Mendola
an refer to NEW 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

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

2004-09-14 Thread Gaetano Mendola
x27;plpgsql'; CREATE TRIGGER check_foo BEFORE INSERT 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 ? Rega

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 agre

Re: [HACKERS] x86_64 configure problem

2004-09-12 Thread Gaetano Mendola
ils Traceback (innermost last): File "", line 1, in ? ImportError: No module named distutils /usr/ checking how to link an embedded Python application... no configure: error: Python Makefile not found error: Bad exit status from /var/tmp/rpm-tmp.56347 (%build) may be because the m

Re: [HACKERS] pgindent vs try/catch

2004-09-12 Thread Gaetano Mendola
{ int a; } // use the formal parameter } if the extra scope 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 debuggi

[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 Gaeta

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 Pytho

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.

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 t

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

2004-09-11 Thread Gaetano Mendola
e agree 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] psql questions: SQL, progname, copyright dates

2004-09-10 Thread Gaetano Mendola
keeps 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] x86_64 configure problem

2004-09-09 Thread Gaetano Mendola
7;)" /usr/lib64/python2.3/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

Re: [HACKERS] Clarification of action on Delete

2004-09-09 Thread Gaetano Mendola
d but Outlook or the new server had 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] 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

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

2004-09-08 Thread Gaetano Mendola
ults is also an open question. So far my thoughts are to classify by . Thoughts? This can be a good model to follow: http://boost.sourceforge.net/regression-logs/ Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe c

Re: [HACKERS] FYI: Fujitsu

2004-09-08 Thread Gaetano Mendola
u for giving me 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 choos

Re: [HACKERS] Why does pg_stat_activity Truncate Queries?

2004-09-07 Thread Gaetano Mendola
kilobyte 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 ---

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

2004-09-06 Thread Gaetano Mendola
useful way ... 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] Adding columns in the middle of tables

2004-09-05 Thread Gaetano Mendola
People don't want pay taxes for example... 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] 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 stat

Re: [HACKERS] Developers page is down

2004-09-05 Thread Gaetano Mendola
n our coding rule we have - 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 kqwKV

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 any

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)---

[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 P

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.

[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] Developers page is down

2004-09-04 Thread Gaetano Mendola
attributes 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?

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 [

[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 applic

Re: [HACKERS] version upgrade

2004-09-01 Thread Gaetano Mendola
no a singol failure 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 re

[HACKERS] iinvalid string enlargement PG 7.4.5

2004-09-01 Thread Gaetano Mendola
ave 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 -

[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 &#x

Re: [HACKERS] FYI: 8.0beta2 on Monday

2004-08-27 Thread Gaetano Mendola
nds in a plpgsql function ? 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= =/a

[HACKERS] DCO and postgresql

2004-08-27 Thread Gaetano Mendola
ss 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 iD8DBQFBL3tR7Upzw

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

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&#x

[HACKERS] rpm for RH AS 2.1 ?

2004-08-25 Thread Gaetano Mendola
plication... no configure: error: 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 subscrib

[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

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 t

Re: [HACKERS] debuging postgres

2004-08-24 Thread Gaetano Mendola
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 are going to debug it? Regards Gaetano Mendola ---(end of broadcast)--

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

2004-08-23 Thread Gaetano Mendola
resql.org/pgsql-hackers/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

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 upd

[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 --

[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: yo

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

[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

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
get messy. I 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] 7.4.5 on RH 2.1AS

2004-08-20 Thread Gaetano Mendola
mendola.no-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

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 num

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
tgres is not snmp capable and for windows administrators is a bit 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

Re: [HACKERS] postgres uptime

2004-08-20 Thread Gaetano Mendola
t returns an interval 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-

[HACKERS] postgres uptime

2004-08-19 Thread Gaetano Mendola
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

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

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

2004-08-18 Thread Gaetano Mendola
Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: BTW I have bitten recently on the attempt 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

<    1   2   3   4   5   >