Re: [SQL] Altering pg_conndefaults

macky writes: > how do i alter values of pg_conndefaults? What exactly do you mean by pg_conndefaults? > example user=user1 to user=user2 The default user is normally the user with the same name as the current Unix user, or the PGUSER environment variable if set, but the details may vary from

Re: [SQL] How to execute a system file in procedure?

On Mon, Aug 20, 2001 at 10:08:36AM -0400, Raymond Chui wrote: > I would like execute a system command or my program or my shell > script in procedure. How do I do that? use . Albert. ---(end of broadcast)---

[SQL] just checking

At times things seem just too easy, so I want to confirm that this is the correct syntax. I am looking for the interval (aging) for these invoices. I guess I am concerned because I guessed at the syntax. Is there a better way to do this? billdate is type 'date' SELECT ('now'-billdate) FROM f

[SQL] protected ON DELETE CASCADE

here's my problem i have tables A, B, C, D A <- B A <- C <- D i want to maintain integrity so that if A is deleted from then so is anything referencing from B and C - no problem ON DELETE CASCADE but if there are any D's that point back to A (through composite key in C) i don't want the delet