Re: [GENERAL] Trigger on Postgres for tables syncronization

Dear Csaba... OK, I did some tests on my postgres around view trying to understand the view concept. Yes, you are absolutely correct. View is my problem solution. I only have to equip the "rule" of the view and that's it. Thank you very much for your kindness I really appreciate your genero

Re: [GENERAL] Trigger on Postgres for tables syncronization

On Tue, 2004-07-27 at 09:55, Prabu Subroto wrote: > PS>and if the view changes, does it also change the > related record in table "appointment0" and "appointment1"? Yes, because a view is pretty much just a stored query (Pg does't have materialised views). CREATE VIEW apointment0 AS

Re: [GENERAL] NNTP server

mail server was down for a few others today with a 'page fault panic' ... should start flowing again now ... On Tue, 27 Jul 2004, Mike Rylander wrote: I hope I'm not reporting a known problem, but it seems that the NNTP server is not getting new postings any more. Thanks in advance! -- Mike Rylan

[GENERAL] NNTP server

I hope I'm not reporting a known problem, but it seems that the NNTP server is not getting new postings any more. Thanks in advance! -- Mike Rylander [EMAIL PROTECTED] Indentation is a wonderful form of commentary from programmer to programmer, but its symbology is largely wasted on the c

Re: [GENERAL] Trigger on Postgres for tables syncronization

Prabu, You should use views for appointment0 and appointment1. That way when you insert/modify in appointment, the modifications will automatically show up in the views too. See also http://www.postgresql.org/docs/7.4/static/sql-createview.html on how to create a view. Cheers, Csaba. On Tue, 20

Re: [GENERAL] Trigger on Postgres for tables syncronization

But I think, the modification of records to the table "appointment0" dan "appointment1" must be done automatically if my program modifies the "appointment". That's why I think I should use trigger and function. Please tell me more detail. --- Csaba Nagy <[EMAIL PROTECTED]> wrote: > Prabu, > > You

Re: [GENERAL] Trigger on Postgres for tables syncronization

> I want if my program inserted, updated, deleted the > record of "appointment" than the postgres does the > syncronization to the corresponded tables > (appointment0 or appointment1 or both). Is there a reason you aren't doing this with views? -- Mike Nolan ---(end of bro

[GENERAL] Trigger on Postgres for tables syncronization

Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of table "appointment" are as follows: noapp* (int4):ID Number of appointment (PK) custid (int4)

Re: [GENERAL] Data model for Postfix v2

I don't have any problem getting postfix to talk to postgres - I just have a problem getting postfix to do what i want! :) John Sidney-Woollett Devrim GUNDUZ wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 27 Jul 2004, Paul Thomas wrote: Just asking in case anyone has this info.

Re: [GENERAL] Data model for Postfix v2

On 27/07/2004 08:35 John Sidney-Woollett wrote: Just asking in case anyone has this info... Does anyone have a complete and working data model that allows Postfix v2 to lookup domain/user lookups (including virtual domains and users). Googling came up with http://www.high5.net/howto/ which explain

Re: [GENERAL] Data model for Postfix v2

Thanks for the link - I think I've have seen this before. I'm really trying to find a definitive covers all bases data model that will provide the functionality I need. My DB data model/postfix config is now so butchered that I wanted a "good" data model to start afresh with. I'll take a fresh l

Re: [GENERAL] Data model for Postfix v2

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 27 Jul 2004, Paul Thomas wrote: > > Just asking in case anyone has this info... > > > > Does anyone have a complete and working data model that allows Postfix > > v2 to lookup domain/user lookups (including virtual domains and users).

[GENERAL] open of /usr/lib/pgsql/data/pg_clog/0F3E failed

Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: pg_exec() query failed: server closed the connection unexpectedlyThis probably means the server terminated abnormally before or while processing the

[GENERAL] Data model for Postfix v2

Just asking in case anyone has this info... Does anyone have a complete and working data model that allows Postfix v2 to lookup domain/user lookups (including virtual domains and users). I've got mostly working data model cobbled together over a period of time, but I can't get my config/db model

[GENERAL] Sequences & rules

I created a table to hold some forum messages : table messages ( id serial primary key, parent_folder integer not null references folders(id), --in another table -- for replies, this stores the message which we reply