Re: [GENERAL] Can't Figure Out Where Rows Are Going

HH <[EMAIL PROTECTED]> writes: > Would it be possible to create a constraint that makes rows of a certain > table impossible to delete? REVOKE DELETE ON foo FROM ... This assumes you don't run your apps as database superuser of course. regards, tom lane -

Re: [GENERAL] Using the REPLACE command to replace all vowels

Magnus Hagander wrote: Is there a way to make seperate replacements in 1 field in one command in SQL? I need to remove all vowels (a,e,i,o,u) in a field. How would I go about that? Try something like SELECT regexp_replace(your_string,'[aeiou]','','g') ... (btw, if you want all vowels, don't

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Would it be possible to create a constraint that makes rows of a certain table impossible to delete? Perhaps by adding a constraint of that type, I would be able to get some more logging of the event that makes the rows disappear? When they were getting blown away, the constraint would prevent it

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Thanks for the suggestion. I will try to see if we can do this. One issue is that we don't know the minute this occurs (the rows disappear). We haven't been able to pinpoint it to any specific event or timing. We're stil trying to narrow that down. > From: Andrus <[EMAIL PROTECTED]> > Organizati

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Thanks. Actually, the Web app is a Ruby on Rails app and RoR doesn't use connection pooling in its current implementation. I'll do some more investigation here to double check but this is an area where Rails is pretty simple and straightforward. Yes, since I can see the rows outside of that tran

Re: [GENERAL] How to add plPHP to Postgresql

Hi, On Sun, 2006-05-07 at 15:33 -0300, Alejandro Michelin Salomon ( Adinet ) wrote: > How to add the plPHP to the postgresql server, without recompiling the > server? See the wiki for that information: http://projects.commandprompt.com/public/plphp/wiki http://projects.commandprompt.com/public/p

[GENERAL] How to add plPHP to Postgresql

Title: Mensagem Hi :   How to add the plPHP to the postgresql server, without recompiling the server?   Thanks in advance   Alejandro Michelin Salomon Porto Alegre Brasil   --No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.392 / Virus Database: 268.5.5/33

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Turn PITR on Restore database to the state immediately after transaction is commited and look for rows presence. Andrus. "HH" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > I am running 8.1.3, built from source, on RHEL4/x64. > > I have a Web application that uses thi

[GENERAL] recuperar el nro del registro actualizado utilizando Ado

Estoy programando en vb utilizo ado para conectarme  a la bd postgre, lo q necesito hacer es Grabar un registro y una vez grabado recuperar el autonumerico para grabarlo en otra tabla   Utilizando dao con mdb lo hacia asi:   Rs.update Rs.movelast Variable = Rs(“campo”)   Y ya estab

[GENERAL] can't reindex a couple of tables

Hi, We're having a problem with a couple of our tables. I have 2 tables, attribute and attribute_value: Table "public.attribute" Column | Type | Modifiers ---+---+--- attribute_id | intege

[GENERAL] Where I find examples of pqtrace ???

Hi, I Have some questions of use PQtrace in Windows' systens 1- The implementation of PQtrace, is possible ONLY with non bloking connections ??? 2- Please, I need same samples of implementation of PQtrace. Regards Marcelo Silveira OBS: text original in Portuguese, translate with google.

Re: [GENERAL] intarray internals

Hi, I've prepared a Quick & Dirty patch serie for some missing parts in intarray contrib module. Here they go with some explanation... On May 06 12:38, Volkan YAZICI wrote: > [4] > In the inner_int_contains() function of _int_tool.c, there's a while > loop like > > [Code assumes that arrays are

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Are the relevant COMMITs appearing in the log? If the commits fail for whatever reason does/can the application (and postgresql) log that? If the commits are successful then you shouldn't have to need to look for roll-backs. It might be a good idea for teh webapp to log unsuccessful commits

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Tom Lane wrote: Aside from the suggestion already made that the inserting transaction got rolled back instead of committed, I'd wonder about indirect deletions due to ON DELETE CASCADE foreign keys, or deletions executed by PL-language functions. Neither of those would produce obvious log entrie

Re: [GENERAL] Can't Figure Out Where Rows Are Going

If you're using a (java) web app with a connection pool is there a possibility that some connections are configured with auto-commit=false and that some future transaction issues a rollback which may include the insert of the order items? Perhaps some kind of persistance manager is doing this

Re: [GENERAL] Can't Figure Out Where Rows Are Going

Thanks Tom. I don't use any PL language functions in my app explicitly but perhaps something implicit when using one of the command line tools or something like that? I don't have anything pointing in that direction. I double checked the definition for the 'orders' table (header) and also the 'or