Search results for query: *

TABLE: ameren_sbc_attachments TYPE: ameren_sbc_attachments INDEX: ameren_sbc_attachments_owner INDEX: ameren_sbc_attachments_pkey INDEX: ameren_sbc_attachments_type SEQUENCE: ameren_sbc_attachments_UID_seq Type: ameren_sbc_attachments_UID_seq TABLE: ameren_sbc TYPE: ameren_sbc INDEX...

Is this what you were referring to? FOREIGN KEY ("FID") REFERENCES "public"."ameren_sbc"("UID") ON DELETE CASCADE ON UPDATE CASCADE NOT DEFERRABLE

Here is my new error message: ERROR: column public.ameren_sbc.uid does not exist Sorry if I sound like a fool, but how could this be? That column ABSOLUTELY exists in my table?!?! LOL! Here is the code I was using to execute the UPDATE: update public.ameren_sbc_attachments set status =...

Thank you VERY much for your reply. Unfortunately, I now get this error message: ERROR: column "ABANDONED" does not exist I tried single quotes as well as double quotes... I will try fully qualifying by using server.table.column name

Good afternoon! I have been a SQL Server D.B.A. for the past 7 years and am just now getting my feet wet with Postgres. Could someone provide some help with this error? ERROR: table name "ameren_sbc_attachments" specified more than once ------------------- This is how I wrote the query: (and...