Re: urgent: autocommit & pg 7.4.1

Got a mail from Oliver that helped.

The data were being written, but with id's starting from 0.
No sequence had their values set when restoring a pg_dump file.

My query was filtering with 'order by id desc'.

Now the problem is how to make sure that pg_dump will put all
the values correctly on all sequences...

Sorry for the rush....

> What do the postgres logs say?
>
> Dave
> On Thu, 2004-02-19 at 21:32, Marcus Andree S. Magalhaes wrote:
>> Guys,
>>
>> I know that this question has been answered dozen of times, but I have
>> less than 2 hours to solve this issue.
>>
>> We upgraded our server to a new machine. A java program is accessing
>> the database with autocommit set to true on JDBC Statements.
>>
>> I thought that we would need only to upgrade the jdbc drivers to a
>> recent version, but we're having only read access to the data. No
>> writes at all...
>>
>> Am I missing something? Do I need to put a commit() after writes?
>>
>> Any prompt help is appreciated.
>>
>> Thanks again.
>>
>> marcus.
>>
>>
>>
>>
>> ---------------------------(end of
>> broadcast)--------------------------- TIP 3: if posting/reading
>> through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that
>> your message can get through to the mailing list cleanly
>>
> --
> Dave Cramer
> 519 939 0336
> ICQ # 14675561
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend