FUDforum: Bug Reports » pg_last_oid() and postgresql-8.1

Home » FUDforum Development » Bug Reports » pg_last_oid() and postgresql-8.1

Show: Today's Messages :: Polls :: Message Navigator

Re: pg_last_oid() and postgresql-8.1 [message #39481 is a reply to message #38992]

Fri, 26 October 2007 15:18

jacpad

Messages: 21
Registered: January 2006

Karma:

Junior Member

I had a similar problem with a combination of forum 2.7.7 and postgresql 8.0.
In this version of postgres the function lastval did not exist. So I tried to replace it with the 'currval()' function, but without success as this function has it's special behaviour :

Quote:

An error is reported if nextval has never been called for this sequence in this session
(http://www.postgresql.org/docs/8.0/static/functions-sequence.htm)

I modified the function that retrive the data and id - it's working now for me. I don't know if this is of interest for other people. So if it is just post it and I send my proposal to solve it.

anyway thx to Ilia for his great work

Report message to a moderator

[Message index]

		pg_last_oid() and postgresql-8.1 By: buck on Tue, 17 April 2007 17:34
		Re: pg_last_oid() and postgresql-8.1 By: Ilia on Tue, 17 April 2007 23:13
		Re: pg_last_oid() and postgresql-8.1 By: lawrencec on Wed, 12 September 2007 14:14
		Re: pg_last_oid() and postgresql-8.1 By: Ilia on Wed, 12 September 2007 18:35
		Re: pg_last_oid() and postgresql-8.1 By: jacpad on Fri, 26 October 2007 15:18

Previous Topic:	Bug on upgrading 2.7.6 => 2.7.7
Next Topic:	Modifying Moderator Permissions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 17:13:44 GMT 2024

Total time taken to generate the page: 0.04212 seconds