Mariusz Majer <mmajer(at)janmedia(dot)com> writes:
> I am using postgresql-8.2-504.jdbc3.jar driver.
> When I add one row from psql:
> - in net_source I got null value,
> while adding new order from application using JDBC
> - in net_source I got 'UL' value
> ...so in my opinion it might be issue with JDBC (maybe too old JDBC??).
Maybe. These dumps seem to be from a newer-than-8.2 server, so it'd be
a good idea to update to a matching JDBC version in any case.
> in dump.txt result of execution query you provided
>> select * from pg_attrdef where adrelid = 'ecom2_orders'::regclass;
> http://postgresql.1045698.n5.nabble.com/file/n2636403/descr.txt descr.txt
These results look perfectly normal to me. You're sure you got the data
for a malfunctioning table, not a correct table?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Josh Berkus||Date: 2010-08-16 17:26:58|
|Subject: Re: Unable to create serial column even with permissions|
|Previous:||From: Tom Lane||Date: 2010-08-16 14:59:47|
|Subject: Re: LINE COMMAND |