Re: [BUGS] BUG #1164: Informix compatibility ecpg

2004-06-21 Thread Michael Meskes
On Mon, Jun 14, 2004 at 08:08:37PM -0300, PostgreSQL Bugs List wrote: > In Informix ESQL/C, columns can be defined using the same string that's used > to describe the field when describing the table. Hence "integer" will work > in esql, but not in ecpg. I'm not sure I understand you correctly.

Re: [BUGS] BUG #1175: insert rule action with defaults

2004-06-21 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > [ double evaluation of serial-column default with ] > > create rule silly_insert_r as on insert to silly do > insert into action (item_id,whence) > values (new.id,'now'); The standard answer to this is "use a trigger, not a rule, to copy insert

[BUGS] BUG #1175: insert rule action with defaults

2004-06-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1175 Logged by: Joe Carlson Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: linux Description:insert rule action with defaults Details: I realize this was discussed 2 years ag

Re: [BUGS] ECPG doesn't return the correct length for an empty

2004-06-21 Thread Michael Meskes
On Mon, Jun 21, 2004 at 08:18:07AM +0100, Hebert, Caroline wrote: > Short Description : ECPG doesn't return the correct length for an empty > VARCHAR I'm sorry, but this is not a bug but an incorrectly used feature. > I compiled with : > * /usr/local/pgsql/bin/ecpg -r no_indicator pg_empty_var

[BUGS] ECPG doesn't return the correct length for an empty

2004-06-21 Thread Hebert, Caroline
=== POSTGRESQL BUG REPORT TEMPLATE Your name : Caroline Hebert Your email address : [EMAIL PROTECTE