Re: [HACKERS] pg_begintypend

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: which library I have to link in order to have the symbol pg_begintypsend ? I think you want pq_begintypsend. Consider paying more attention to unknown-function warnings from your compiler. I had no warning at all, I think I h

Re: [HACKERS] email built in type

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil Conway wrote: | On Sat, 2004-05-08 at 13:10, Gaetano Mendola wrote: | |>However an *add on* is an *add on* with not the same eligibility |>of the main project | | | I'd suggest implementing the custom datatype first and packaging it |

[HACKERS] invalid type internal size -1

IABLE. (Internally, this is represented by setting typlen to -1.) I'm doing this on Postgres 7.4.1 Am I missing something ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

Christopher Kings-Lynne wrote: Just a note for the hackers, Jonathan (I think :) ) talked to me about this on the irc channel - we couldn't figure this one out. Seems that Exist a postgres irc server? If yes may I know the server and port ? Regards Gaetano Me

[HACKERS] Constraint not shown on \d ?

ot;id_code_pool"); or ALTER TABLE activation_code ADD UNIQUE ( code, id_code_pool ); with \d command there is no difference but is different because the first command create an index deleteable with a "drop index". Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] COPY command - CSV files

developers :-o You should really get the CVS code if you want to hack on Postgres ... there are a lot of changes since 7.4.3. 7.4.3 is not out yet, even I don't find the TAG on CVS. Regards Gaetano Mendola ---(end of broadcast)---

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

pgsql is more close to postgres then plPython or plPerl, and after all is nearest SQL then plPtyhton or plPerl so a DBA find it more confortable then others languages. my two cents. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Hav

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib,

that programmers are not aware of ( see select max(id) from foo; optimized with a order by + limit 1 ). Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] write a new built in type

inserted in the file at point 1 and what else ? For example how may I define the name for my new type ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] email built in type

Hi all, about you is it ok for you if I write the email built in type ? I know of course that I can do it with a DOMAIN. Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Constraint not shown on \d ?

choose one ot other one, and basic all why drop index idx_my_index cascade; doesn't drop the constraint too? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-noma

Re: [HACKERS] email built in type

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: about you is it ok for you if I write the email built in type ? You're going to have to explain why it has to be a built-in type. Can't you do what you want as a local add-on? Is it likely that the functionality

Re: [HACKERS] email built in type

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: Tom Lane wrote: Can't you do what you want as a local add-on? I guess that for manage efficiently million of email addresses I need to have a built in type instead of a domain with a regex as validator, You probably

Re: [HACKERS] Postgres Optimization: IO and Data Organization

is not so expensive after all. Please, don't consider optimization that other DBMS are performing will be good also for postgres, I think Oracle made pre forking of a pool of process and this because a Oracle process when is forked do more work then a postmaster. Regards Gaetano Mendola -

[HACKERS] create type: recv and send function

Hi all, what is the purpose of two function send and receive when a new type is defined ? When these two functions are called ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] email data type first release

if you can, do a sort of code revision on it. Comments are welcomed. ============= 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])

[HACKERS] Email data type

x27;@' (it's an alpha version), I'd like to put it on pgfoundry but apparently my DNS are unable to resolve www.pgfoundry.org. I'll put this version as soon the address become available. This is the first time that I wrote code for postgresql so please, if you can, do a sort

Re: [HACKERS] Email data type

Gaetano Mendola wrote: Hi all, this is the alpha version for the new email data type, is not written as built in type but as plug in, Tome Lane and others drove me in this direction. The type is indexable and provide also conversion methods: text <--> email and the operator >>, is pos

Re: [HACKERS] The features I'm waiting for.

r, fault tollerance, load balancer, ... ) ? I'm looking forward to these tools indeed. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] ALTER TABLE TODO items

de a table definition could save us some pains. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Email data type

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Sun, May 16, 2004 at 04:36:55 +0200, | Gaetano Mendola <[EMAIL PROTECTED]> wrote: | |>The type is indexable and provide also conversion methods: |> |>text <--> email |>and the operator >>, is

Re: [HACKERS] email data type first release

Greg Stark wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: Comments are welcomed. Well as long as you're asking... Email domains are case insensitive, but the left hand side is case sensitive. That's the only part that's hard to handle using a text data type, it would b

Re: [HACKERS] Email data type

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave Page wrote: |>-Original Message- |>From: Gaetano Mendola [mailto:[EMAIL PROTECTED] |>Sent: 17 May 2004 16:02 |>To: Bruno Wolff III |>Cc: [EMAIL PROTECTED] |>Subject: Re: [HACKERS] Email data type |> |>About the dom

Re: [HACKERS] Call for 7.5 feature completion

Hans-Jürgen Schönig wrote: Somebody has posted sync multimaster replication (PgCluster) - nobody has commented on that. Maybe I am the only one who has ever tried it ... I didn't find it on pgFoundry, others place to look at it ? Regards Gaetano Mendola ---(e

[HACKERS] Why new features only in magior releases ?

ering some improvements in the 7.4.3 will permit to delay a month the 7.5 without the pain to wait too long for some enhancements. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Why new features only in magior releases ?

Neil Conway wrote: Gaetano Mendola wrote: I well understand the reason to wait a 7.5 in order to delivery BIG changes that are requiring a initdb, but I don't understand why little enhancement can not be delivered in a 7.4.3 ( may be with a short period with a 7.4.3beta ) like the "vacu

[HACKERS] emaildt_0.0.2

ot;[EMAIL PROTECTED]" true o false? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Call for 7.5 feature completion

duction", am I wrong ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Call for 7.5 feature completion

Win32 compared with other products? I really hope yes, you know: there is no a *second* possibility to do a *first* good impression. Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Optimizer bug??

icletbl; SELECT COUNT(*) AS c FROM articletbl WHERE mydate BETWEEN '2004-04-24' AND '2004-05-24'; SELECT COUNT(*) AS c FROM articletbl WHERE mydate = '2004-04-24'; Regards Gaetano Mendola ---(end of broadcast)--- TI

Re: [HACKERS] Big problem

ough in the initdb fase create the postgres user as undeleateable. I think this is resonable. 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] Optimizer bug??

alues that are good for a modern machine. Hackers, what about to decrease the default values for this quantities ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Optimizer bug??

om command line, what you have to do is decrease the cost of the index scan till is less of the sequential scan cost. Good luck. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if yo

Re: [HACKERS] Optimizer bug??

Josh Berkus wrote: Gaetano, Hackers, what about to decrease the default values for this quantities ? Oh, I don't think Ismail has a bug, I think he probably just needs to tune his database. I just only suggesting to decrease that values that are oversized for a modern hardware. Regards Ga

Re: [HACKERS] Optimizer bug??

elative CPU cost settings, and had mixed results. | That's why I have no particular recommmendation for them. | Usually yes, decreasing that values I'm able to decrease the index scan cost, so when I enable again the sequential scan the index one is choosed. Regards Gaetano Mendola ---

Re: [HACKERS] Optimizer bug??

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: I just only suggesting to decrease that values that are oversized for a modern hardware. I've seen no evidence saying that random_page_cost needs to be decreased for modern hardware. Disk seek speed versus bandwidth hasn

Re: [HACKERS] SELECT * FROM LIMIT 1; is really slow

the table so I "vacuum analysed" the database. It had no effect. I had a "vacuum full" going on the table for 17 hours before I killed it. Are you sure that the vacuum full was running or sitting there to wait an idle transaction ? Regards Gaetano Mendola --

Re: [HACKERS] tablespaces and DB administration

[EMAIL PROTECTED] wrote: A single postgresql process may not see much benefit, because it does not do background I/O, Not yet, I believe that in 7.5 there is a component that do it. Am I wrong ? Regards Gaetano Mendola ---(end of broadcast)--- TIP

[HACKERS] -Wall and Wmissing-prototype

Hi all, I compiled postgres7.5devel and I see that during compilation are used togheter: -Wall -Wmissing-proptotype -Wmissing-declaration there is any reason to specify after -Wall others warning ? Regards Gaetano Mendola ---(end of broadcast

[HACKERS] passing a whole record variable into a SQL command is not implemented

d variable into a SQL command is not implemented the problem is that the variable quota have the same column name for the table test, for us it's a minimum issue due the fact that is easily fixed changing the variable name, but I'm wondering if behind there is something w

[HACKERS] false infinite recursion detected

=# select * from v_v_test; ERROR: infinite recursion detected in rules for relation "v_test" Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] false infinite recursion detected

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: kalman=# select * from v_v_test; ERROR: infinite recursion detected in rules for relation "v_test" I think also my other message: "passing a whole record" is a bug that shall to be fixe

Re: [HACKERS] PageGetMaxOffsetNumber on uninitialized pages

Tom Lane wrote: I was just looking at this macro: /* * PageGetMaxOffsetNumber *Returns the maximum offset number used by the given page. *Since offset numbers are 1-based, this is also the number *of items on the page. * *NOTE: to ensure sane behavior if the pa

Re: [HACKERS] PageGetMaxOffsetNumber on uninitialized pages

Gaetano Mendola wrote: Tom Lane wrote: We could fix this by changing the declarations of the "maxoff" variables to int, but I think it's probably cleaner to recode PageGetMaxOffsetNumber like so: #define PageGetMaxOffsetNumber(page) \ (((PageHeader) (page))->pd_lower <=

Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

uently then other and you have enough RAM your OS will mantain that table on RAM, don't you think ? BTW if you trust on your UPS I'm sure you are able to create a RAM disk and place that table in RAM. Regards Gaetano Mendola ---(end of broadcast)--

Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL?

s: 1) copy the table from RAM to DISK Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAxDC07UpzwH2SGd4RAm3KAJ9HFgvTSqXSGCh3Xx2n6+Mfqb7AcQCgzWht CeFGnUTQrD9AWOTvwdkVr0A= =evpH --

Re: [HACKERS] Postres dilemma

tly shifting range of live index keys, which pre-7.4 btrees didn't handle well at all). This is just speculation though, without proof as yet. Another information to know is if there are connection in the "unfamous" state: "Idle in transaction". Is usefull if the OP show us

Re: [HACKERS] Improving postgresql.conf

reality. Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Improving postgresql.conf

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce Momjian wrote: | Gaetano Mendola wrote: | |>Bruce Momjian wrote: |> |> > I understand your points below. However, the group has weighed in the |> > direction of clearly showing non-default values and not duplicating |> >

Re: [HACKERS] File leak?

able files created by a transactions that were in-progress when the server crashed I don't think is a good idea put the words: "when the server crashed" in a TODO list, may be is better write: "when the server is killed abruptly". My 2 cents. Regards Gaetano Mendola -

Re: [HACKERS] Improving postgresql.conf

Scott Marlowe wrote: On Fri, 2004-06-11 at 11:02, Bruce Momjian wrote: Gaetano Mendola wrote: [ PGP not available, raw data follows ] -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce Momjian wrote: | Gaetano Mendola wrote: | |>Bruce Momjian wrote: |> |> > I understand your

Re: [HACKERS] Minor DROP TABLESPACE issue

Tom Lane wrote: Although DROP TABLESPACE can detect tables existing in the target tablespace, it doesn't have any way to detect schemas that reference that tablespace as their default tablespace. Thus you can get implementation-level failures like this one: $ mkdir /tmp/junk regression=# create ta

[HACKERS] warning missing

) don't you think a warning shall to be raised here ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] warning missing

Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: I think a warning is missing if I create a table without OIDS that inherits from a table with oids: don't you think a warning shall to be raised here ? Nope ... this is not different from the behavior for merging dupli

Re: [HACKERS] warning missing

t an user of D could not use foo() Having said that, I think a warning is motivated. The warning should state that attributes (columns) present in the generalisation (the parent table) cannot be hidden. Right. Regards Gaetano Mendola ---(end of broadcast)-

Re: [HACKERS] warning missing

I can not use the RAII Idiom, or at least without be a joggler 3) I miss the "const" modifier for methods, and I really can not be sure of what happen to my objects when are used around. Do you want now speak about the missing template feature? Don't say template are the same of G

Re: [HACKERS] warning missing

Gaetano Mendola wrote: Tom Lane wrote: Gaetano Mendola <[EMAIL PROTECTED]> writes: I think a warning is missing if I create a table without OIDS that inherits from a table with oids: don't you think a warning shall to be raised here ? Nope ... this is not different from the behavior

Re: [HACKERS] [BUGS] [CHECKER] 4 memory leaks in Postgresql 7.4.2

In that (as of yet unwritten) code, palloc would fit very well. But does palloc depend on some other part of the Postgres code? If you don't mind you can write your application in C++ and use a boost smartpointer: http://www.boost.org/libs/smart_ptr/smart_ptr.htm Regards Gaetano Mendola

Re: [HACKERS] SAN, clustering, MPI, Backplane Re: Postgresql on SAN

egment and the shared memory is managed "without kernel intervention". Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Release planning (was: Re: Status report)

2) Nested Transaction 3) WIN32 porting 4) ARC 5) Table Space 6) I'm sure I'm forgetting something was really too much. I hope that all will be fine. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to cho

Re: [HACKERS] Release planning

Christopher Browne wrote: > A long time ago, in a galaxy far, far away, Gaetano Mendola <[EMAIL PROTECTED]> wrote: > >>>I was thinking of something much simpler where Jan would create an >>>ARC patch against 7.4.X and have it either in /contrib for 7.4.X or >>&

[HACKERS] NT + deadlock intended behaviour ?

abort; Why that commit unblock the SESSION 1? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFA+bD+7UpzwH2SGd4RAq0VAJ9rZQ3aJmsJM6WSlLqIERJzDDS9iQCeL5rT rF7PkCaJ59PWNQw4C

[HACKERS] NT and aborted transaction

ransaction block I think the second begin shall fail instead of open an already invalid transaction. Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFA+bEz7UpzwH2SGd4RAujVAJ4wBx64

[HACKERS] unused variable

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm compiling the last postgres CVS version and I get: vacuum.c: In function `repair_frag': vacuum.c:1528: warning: unused variable `myXID' Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32)

Re: [HACKERS] NT + deadlock intended behaviour ?

Alvaro Herrera wrote: On Sun, Jul 18, 2004 at 01:06:39AM +0200, Gaetano Mendola wrote: I'm doing some experiments with NT, I din't expect this behaviuor: First of all, let me point that the behavior on deadlock has been agreed to change. Instead of only aborting the innermost trans

Re: [HACKERS] NT + deadlock intended behaviour ?

Alvaro Herrera wrote: Gaetano, please apply the latest savepoints patch (savepoint-5.patch) and let me know how it goes ... where is it ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] NT tab complete patch

oint are active ? Regards Gaetano Mendola --- pgsql_patched/src/bin/psql/tab-complete.c 2004-07-19 17:21:50.0 +0200 +++ pgsql/src/bin/psql/tab-complete.c 2004-05-26 15:56:55.0 +0200 @@ -463,8 +463,8 @@ "ABORT", "ALTER", "ANALYZE", "B

Re: [HACKERS] localhost redux

al to "on" in the configuration file but was shown as "off" with a SHOW stats_start_collector inside a psql section. That GUC variable is resetted to off is the collector doesn't start ? Regards Gaetano Mendola ---(end of broadcast)-

[HACKERS] check point segments leakage ?

Any ideas ? I'm attaching boot graphs ( HD space usage and load ). Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFA/Ydh7UpzwH2SGd4RAuhKAKCTftBGjBLSfR+OTy5vHlYpL46TXQCfc65/ VfepMM87

Re: [HACKERS] check point segments leakage ?

| mode | granted --+--+-+---+-+- 16759 |1 | | 15910 | AccessShareLock | t | | 7714652 | 15910 | ExclusiveLock | t Regards Gaetano Mendola ---(end of broadcast)--

Re: [HACKERS] check point segments leakage ?

ughts ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] no instruction after install

Hi all, why after compiling and install postgresql CVS tip there is no information on how to run it ? Also the file INSTALL is not there anymore. Do I miss something in these days ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the

[HACKERS] NT and aborted transaction

il instead of open an already invalid transaction. Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] NT + deadlock intended behaviour ?

t unblock the SESSION 1? 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])

[HACKERS] unused variable

Hi all, I'm compiling the last postgres CVS version and I get: vacuum.c: In function `repair_frag': vacuum.c:1528: warning: unused variable `myXID' Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] check point segments leakage ?

Bruce Momjian wrote: > Gaetano Mendola wrote: > >>Bruce Momjian wrote: >> >> >>>Scott Marlowe wrote: >>> >>> >>>>>>I use a checkpoint_segments = 16 but in my pg_xlog I have >>>>>>35 files. Why 35 files ? &g

Re: [HACKERS] check point segments leakage ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matthew T. O'Connor wrote: | Gaetano Mendola wrote: | |> Well, today I stop the pg_autovacuum and I did a vacuum full and I |> reindexed |> all big tables and other 500 MB were reclamed. Could be the pg_autovacuum |> running yesterda

Re: [HACKERS] check point segments leakage ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Matthew T. O'Connor wrote: | Gaetano Mendola wrote: | |> I'm pretty sure, see the attached graph. Each morning at 7 a script stop |> the autovacuum, vacuum full the database and reindex the eavy updated |> tables |> and restart of

Re: [HACKERS] Fixing PKs and Uniques in tablespaces

ing close to beta, can we have consensus on what I'm to do about this? We are already in a features freeze period, or not ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Wrong index choosen?

mpdb=# select count(*) from v_past_connections where login_time > '2004-07-21'; count --- 22441 (1 row) why then the planner choose to do an index scan using the filter that retrieve a bigger ammount of rows ? A bug ? Regards Gaetano Mendola ---(end of

Re: [HACKERS] 7.5 release notes

, even minor |ones. Either send in a patch or committers can modify the file |directly. Did you forget to insert the autovacuum integrated ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

Re: [HACKERS] storage engine , mysql syntax CREATE TABLE t (i INT)

ver miss this MySQL "feature". Another "mysql people" style answer. We have only one engine: the full transactional one. If the OP need to have for example the MEMORY one the he can easily create a RAM disk and with the tablespaces support he can create tables

Re: [HACKERS] Sketch of extending error handling for subtransactions

... ~END; and of course who trhow the exception: ~THROW 3::INTEGER; in this way who throw the exception can also transfer informations on what is going on. Am I may be not understanding what are you trying to do ? Regards Gaetano Mendola -BEGIN PGP SIGNATURE- V

Re: [HACKERS] 7.5 release notes

alman=# create table test1 ( d integer, e test ); CREATE TABLE kalman=# select * from test1; d | e ---+--- (0 rows) kalman=# select e from test1; e --- (0 rows) kalman=# select (e).a from test1; a --- (0 rows) Regards Gaetano Mendola ---(end of broa

[HACKERS] 7.5 backend crash

the back end kalman=# select * from test1; server closed the connection unexpectedly ~This probably means the server terminated abnormally ~before or while processing the request. The connection to the server was lost. Attempting reset: Failed. !> Regards Gaetano Mendola -BEG

Re: [HACKERS] 7.5 backend crash

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes: | |>kalman=# create table test ( a integer, b integer ); |>CREATE TABLE |>kalman=# create table test1 ( c integer , d test ); |>CREATE TABLE | | |>kalman=# alter tab

Re: [HACKERS] Sketch of extending error handling for subtransactions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Gaetano Mendola <[EMAIL PROTECTED]> writes: | |>Tom Lane wrote: |>| I was just looking around the net to see exactly what Oracle's PL/SQL |>| syntax is. It doesn't seem too unreasonable syntax-wise: |

Re: [HACKERS] 7.5 backend crash

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: | Greg Stark <[EMAIL PROTECTED]> writes: | |>Gaetano Mendola <[EMAIL PROTECTED]> writes: |> |>>kalman=# insert into test values (1 ,(2,(3,(4,(5,(6, null)); |>>INSERT 33639 1 |>>

Re: [HACKERS] No mail?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marc G. Fournier wrote: | | all fixed ... had a kernel panic this morning, and fsck took a while to | run ... Also news.fr.postgresql.org it seems down since yesterday. Regards Gaeatano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (Min

[HACKERS] extra info on autovaccum log

erforming: VACUUM ANALYZE "dbame"."public"."current_connection" or Performing: VACUUM ANALYZE "public"."current_connection"@"dbname" I know that I will know the database on the very next line, but sometimes is too late :-( Regards Gaetano Mend

Re: [HACKERS] extra info on autovaccum log

Matthew T. O'Connor wrote: Gaetano Mendola wrote: I don't have idea about the database involved, I suggest: Performing: VACUUM ANALYZE "dbame"."public"."current_connection" or Performing: VACUUM ANALYZE "public"."current_connection"@&q

Re: [HACKERS] Version Numbering -- The great debate

implementation is not a epoch change about you ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] missing link on ftp

Hi all, I'm seeing that a link is missing inside the src directory, the last version is 7.4.1 !! There is also something wrong with the doc directory. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your

Re: [HACKERS] Version Numbering -- The great debate

Christopher Browne wrote: After takin a swig o' Arrakan spice grog, Gaetano Mendola <[EMAIL PROTECTED]> belched out: Peter Eisentraut wrote: Alvaro Herrera wrote: What was the rule for increasing the first number after just before 7.0? That was just to avoid having to release a 6.6.6

Re: [HACKERS] missing link on ftp

Marc G. Fournier wrote: On Mon, 2 Aug 2004, Gaetano Mendola wrote: Hi all, I'm seeing that a link is missing inside the src directory, the last version is 7.4.1 !! There is also something wrong with the doc directory. Please provide an exact path for what you are seeing ... everything I

Re: [HACKERS] Open items

pshot and don't immediately see anything about PITR. Yep, PITR docs is an open item. And is really needed because we can not play/experiment/test it without instructions... Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through

[HACKERS] reindex force

After two series 7.3 and 7.4 that ignore the force argument, why don't remove it in the 8.0 ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail comma

[HACKERS] CVS comment

nably noncontroversial parts of Alvaro's recent mop-up patch, plus further work on large objects to minimize use of the TopTransactionResourceOwner. but the modification on that file have noting to see with this. Is it normal ? Regards Gaetano Mendola ---(end of

[HACKERS] cannot remove lock from HTAB

avepoint a; ~ update record 2; update record 2; ~ update record 1; ~ I hope that looking at the code is possible understand what the problem is ( if exists ). Regards Gaetano Mendola -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (MingW32) Comm

[HACKERS] cache lookup failed for type 0

umber of columns. regression=# \d test Table "public.test" Column | Type | Modifiers +-+--- b | test| c | integer | The two insert in (1) and (2) are the same ( change only the column order ), but the (1) works and the (2) not

<    1   2   3   4   5   >