[SQL] Concerns about the OID

[SQL] trigger question

I have created a trigger when updating/inserting into a table, the row is inserted into a log table. I get the following error when i tried to update the table: ERROR: Unable to locate type oid 0 in catalog what does this mean?

Re: [SQL] Something I'd like to try...

Can someone comment on this? > Hi, > > I just noticed that postgres doesn't totally support > column aliases on UPDATE statements, for example > > UPDATE EMPLOYEES SET > OFFICE_PHONE = UU.OFFICE_PHONE, > MOBILE_PHONE = UU.MOBILE_PHONE, >

Re: [SQL] Something I'd like to try...

It seems to me that aliases on updates are something totally superflous. Since updates always work on one table at a time, why bother especifying the table each field comes from? > Can someone comment on this? > > > Hi, > > > > I just noticed that postgres doesn't totally support > > column alias

[SQL] trigger examples

I need to write a trigger to create a new record in log table if it's a new record or if column A and B changes. Can someone give me an example how to do this. Are there any sites that gives trigger examples?? Thanks.

Re: [SQL] trigger examples

Carolyn Lu Wong wrote: > > I need to write a trigger to create a new record in log table if it's a > new record or if column A and B changes. Can someone give me an example > how to do this. > > Are there any sites that gives trigger examples?? > > Thanks. the fulltextindex in the contrib dir

[SQL] DB backup and connection questions

Can someone help me with the following? 1) Is there a command I can check which users are currently connecting to a particular database? Is it possible to disconnect certain users who are currently using the database? Can it also apply to connections to the database via ODBC? 2) When doing datab

Re: [SQL] Something I'd like to try...

Bruce Momjian <[EMAIL PROTECTED]> writes: > Can someone comment on this? >> >> I just noticed that postgres doesn't totally support >> column aliases on UPDATE statements, for example The SQL92 spec very clearly does not allow an alias on the target table: 13.10 ::=

Re: [SQL] trigger examples

[EMAIL PROTECTED] wrote: > > Carolyn Lu Wong wrote: > > > > I need to write a trigger to create a new record in log table if it's a > > new record or if column A and B changes. Can someone give me an example > > how to do this. > > > > Are there any sites that gives trigger examples?? > > > > Tha