Re: [GENERAL] [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?

2011-07-23 Thread Enrico Weigelt
-- -- Enrico Weigelt, metux IT service -- http://www.metux.de/ phone: +49 36207 519931 email: weig...@metux.de mobile: +49 151 27565287 icq: 210169427 skype: nekrad666

Re: [GENERAL] rule as on insert to view with multiple fk referencing the same table

2005-06-29 Thread Enrico Weigelt
-- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED] - Realtime Forex

Re: [GENERAL] Foreign key to a view (UNION of two or more tables),

2005-06-29 Thread Enrico Weigelt
-- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED

[GENERAL] faking writable views as tables

2005-06-29 Thread Enrico Weigelt
-- - Enrico Weigelt== metux IT service phone: +49 36207 519931 www: http://www.metux.de/ fax: +49 36207 519932 email: [EMAIL PROTECTED

Re: [GENERAL] REFERENCES error message complaint, suggestion

2004-03-05 Thread Enrico Weigelt
since mysqldump's output does it exactly the wrong way: identifiers in '' and string constants in ... cu -- - Enrico Weigelt== metux IT services phone: +49 36207 519931 www: http://www.metux.de/ fax

Re: [GENERAL] How many fields in a table are too many

2003-06-28 Thread weigelt
? 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: [GENERAL] Foreign keys

2003-06-28 Thread weigelt
. I'd run an garbage collection over the db from time to time. It should be an easy test to select (or delete) all address rows which ID doesnt exist anywhere else. You can easily put this in an function. cu -- - Enrico Weigelt