Re: [BUGS] Rule execution bug

2003-09-25 Thread Tom Lane
Viacheslav N Tararin <[EMAIL PROTECTED]> writes: > For the next schema rule "d_analysis_plan" perform only first DELETE > statement, second statement not performed. You did not show us the definition of "analysis_plan", but I'll bet it's a view joining t_sub_plan and t_account_plan. If so, this

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-25 Thread Stephan Szabo
On Thu, 25 Sep 2003, Javier Carlos wrote: > Quoting Stephan Szabo <[EMAIL PROTECTED]>: > > > On Thu, 25 Sep 2003, Javier Carlos wrote: > > > > > > > > > > POSTGRESQL BUG REPORT TEMPLATE > > > > > =

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-25 Thread Stephan Szabo
On Thu, 25 Sep 2003, Javier Carlos wrote: > > POSTGRESQL BUG REPORT TEMPLATE > > > > Your name : Javie

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-25 Thread Andreas Pflug
Javier Carlos wrote: POSTGRESQL BUG REPORT TEMPLATE Your name : Javier Carlos Rivera Your email address

[BUGS] Rule execution bug

2003-09-25 Thread Viacheslav N Tararin
For the next schema rule "d_analysis_plan" perform only first DELETE statement, second statement not performed. Environment: - PostgreSQL 7.4beta4 CPU: 2PIII800 ASP Linux 7.2 2.4.19-13 smp gcc 2.96 SCHEMA: -- create table gl.

[BUGS] Postgresql 'eats' all mi data partition

2003-09-25 Thread Javier Carlos
POSTGRESQL BUG REPORT TEMPLATE Your name : Javier Carlos Rivera Your email address : fjc

[BUGS] Correction to 'translate' function in postgresql

2003-09-25 Thread Pedro Zorzenon Neto
Please send a carbon copy of replies to me, as I am not a subscriber of any postgresql mailing list. Hi folks, I noticed that I can use the string function "translate" to remove unwanted characters from strings, this way: translate(tablefield, '-_. ', ''); This will remove all hifens,

Re: [BUGS] Problem with domains

2003-09-25 Thread Robert Creager
Once upon a time (Thu, 25 Sep 2003 01:28:29 -0400) Tom Lane <[EMAIL PROTECTED]> uttered something amazingly similar to: > Robert Creager <[EMAIL PROTECTED]> writes: > >> Seems like the correct behavior to me. When CONSTRAINT is given, the > >> name is not optional AFAICS. > > > True, but the seco