Re: [SQL] Unable to get UPDATE ... FROM syntax correct

2010-02-19 Thread zkn
update audit set key = (select extension.number from extension where audit.record_id = extension_id) On 19.02.2010, at 11:25, Gordon Ross wrote: > I have two tables: > > Table "public.audit" > Column |Type | Modifiers > +--+-

Re: [SQL] Problem with batch insert

2010-02-18 Thread zkn
On 18.02.2010, at 17:32, Tom Lane wrote: > zkn writes: >> I have a weird problem with batch insert. It works fine on my development >> machine but when I upload to the server it fails. Here is the log: > >> DEBUG [http-8443-2] - {conn-100123} Preparin

[SQL] Problem with batch insert

2010-02-18 Thread zkn
Hi, First I'm sorry if this message shouldn't be posted in this mailing list but I wasn't sure if it should be here or in jdbc mailing list. I have a weird problem with batch insert. It works fine on my development machine but when I upload to the server it fails. Here is the log: DEBUG [http-