Re: [SQL] Unicode problem inserting records - Invalid UNICODE character

2004-11-11 Thread David B
show client_encoding gives: UNICODE databases reads: DATABASE OWNER ENCODING mydb david UNICODE testdb david SQL_ASCII table columns are character varying(255) Tx, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Huxton Sent: Wedn

Re: [SQL] A transaction in transaction? Possible?

2004-11-11 Thread Stefan Weiss
On Thursday, 11 November 2004 09:23, Gaetano Mendola wrote: > Stefan Weiss wrote: > > These tables are connected by foreign keys, but without "on delete" > > triggers. > > Why "without" ? Are you looking to solve a problem introduced by > yourself ? There are numerous checks involved before a cust

Re: [SQL] A transaction in transaction? Possible?

2004-11-11 Thread Gaetano Mendola
Achilleus Mantzios wrote: O Michael Fuhr έγραψε στις Nov 10, 2004 : On Wed, Nov 10, 2004 at 12:45:19AM -0800, Riccardo G. Facchini wrote: Sorry, but I understand that your example is not really about nested transactions, but about sequential transactions. Here's a more elaborate example. If this

Re: [SQL] A transaction in transaction? Possible?

2004-11-11 Thread Gaetano Mendola
Stefan Weiss wrote: > On Wednesday, 10 November 2004 18:28, Tom Lane wrote: > >>Achilleus Mantzios <[EMAIL PROTECTED]> writes: >> >>>Just a very naive thought >>>Wouldn't make more sense to allow nested begin/commit/rollback blocks? >> >>We actually had it working that way initially, but change