[SQL] question on rules

n i avoid this loop ? cu -- ----- Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] c

[SQL] unique keys on inherited classes

dex on the inode_id field of _inode. This doesn't seem to be inherited to the derived classes. The goal is to prevent double inode_id values in all _all_ derived classes. How could i achieve this ? cu -- ----- Enrico Weigelt

Re: [SQL] [ADMIN] Can the frontend get notifications from the postgres server?

h ... cu -- - Enrico Weigelt== metux ITS Webhosting ab 5 EUR/Monat. UUCP, rawIP und vieles mehr. phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email:

Re: [SQL] disabling triggers

nce it would produce an loop!). Currently this is done by the middleware, but I'd like to have it directly in the RDBMS. How could this be solved ? regards -- ----- Enrico Weigelt== metux IT services phone: +49

[SQL] Trigger functions w/o pgsql ?

cu -- - Enrico Weigelt== metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 174 70

Re: [SQL] [postgres] PostgreSQL-DB auf Web-Schnittstelle bringen

On Mon, Oct 20, 2003 at 12:36:01PM +0200, Volker G?bbels wrote: > Und DB-Modelle sollte man eh besser grafisch entwickeln ... Richtig. Zettel und Stift sind genauso unersetzlich wie awk+sed. cu -- - Enrico Weig

Re: [SQL] [postgres] Deutsche PostgreSQL-Mailingliste unter postgresql.org

On Mon, Oct 20, 2003 at 07:53:42PM +0200, Peter Eisentraut wrote: > Was haltet ihr also davon, die ganze Operation dorthin zu verlegen? Halte ich für sinnvoll. cu -- - Enrico Weigelt== metux IT services ph

[SQL] detaching triggers

r idea out these ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 1

[SQL] (non)zero function

-- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] cellphone: +49 174 7066481

[SQL] asynchrous triggers

hi folks, is it possible somehow to make (AFTER) triggers run in their own process/thread, so the calling session can return immediately and the trigger runs in background ? thx -- - Enrico Weigelt== metux IT service

Re: [SQL] Table PARTITION

with partitions, with a little bit more coding work, but then with better control and filtering out unneeded stuff. cu -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.

[SQL] checking pgsql functions

gle crashing trigger may cost a lot of money). So I'd like to checkin only syntactically correct (also with correct references). Is it possible somehow ? cu -- ----- Enrico Weigelt== metux IT service phone: +49

[SQL] RULE for mtime recording

SET bar = 'xyz' WHERE ... the mtime should be set to the current time, but on UPDATE foo SET bar = '123', mtime = '2001-09-11' WHERE ... we shall have 9/11 as mtime. Is this possible with rules ? thx -- ------

[SQL] trigger/rule question

yet. Any ideas ? thx -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] - Real

Re: [SQL] trigger/rule question

pdates within the application, but I wanna get away from that. It probably would be interesting, if a normal application couldn't touch the mtime at all. cu -- ----- Enrico Weigelt== metux IT service phone:

Re: [SQL] trigger/rule question

te (AFAIK), so we cannot intercept here. the only chance seems to leave out "INSTEAD" and live with duplicate data. Did I miss anyting ? cu -- --------- Enrico Weigelt== metux IT service phone: +49 36207 519931

Re: [SQL] pgtop, display PostgreSQL processes in `top' style

it - its just some keystrokes away for me) cu -- ----- Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] ---

[SQL] Mutex via database

ction dies ? thx -- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL

Re: [SQL] Converting from MS Access field aliases

n views, but is this always very performant ? cu -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Taskforce:

[SQL] Implementing an regex filter

the second query would be much faster (about 2mins vs. 18mins). But I really wonder, why is processing one huge regex so dramatically slow ? BTW: in some tables I'm using the username instead (or parallel to) the numerical id to skip joins against the user table. But I'm not sure if

[SQL] Performance on writable views

ive me some details about that issue ? cu -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Tas

Re: [SQL] Database synchronization

primary database. So time critical things are separated to own servers. It works quite fine :) cu -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ -

[SQL] Finding broken regex'es

the db ? thx -- ----- Enrico Weigelt== metux IT service - http://www.metux.de/ - Please visit the OpenSource QM Taskforce: http://wiki.