On 11/21/07, Richard Huxton [EMAIL PROTECTED] wrote:
Kathy Lo wrote:
Hi,
I am using Postgresql 8.0.3 in Fedora Core 4.
In my database, it contains a sequence. And, I need to alter the range
of this sequence and restart it to the start of the new range at
00:00:00 on 1st January
column's datatypes do not
match
Thanks for your reply.
But, the owner of the sequence originally is postgres. Does it work?
--
Kathy Lo
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire
on how to write this kind of function?
--
Kathy Lo
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
and Postgresql does not
support to lock a sequence.
How can I prevent others from accessing the sequence, like locking a
table? That means, when others want to access the sequence between
31-Dec 23:59:55 and 1-Jan 00:00:05, they are waiting instead of
getting an error.
Thank
--
Kathy Lo
On 12/8/05, Martijn van Oosterhout kleptog@svana.org wrote:
On Thu, Dec 08, 2005 at 12:29:11PM +0800, Kathy Lo wrote:
But this shouldn't be an issue here. If you set the IPC_RMID flag then
the kernel should remove the segment when all users go away. This is
standard IPC behaviour
On 12/8/05, Scott Marlowe [EMAIL PROTECTED] wrote:
Please keep replies on list, this may help others in the future, and
also, don't top post (i.e. put your responses after my responses...
Thanks)
On Tue, 2005-12-06 at 20:16, Kathy Lo wrote:
For a back-end database server running Postgresql
But this shouldn't be an issue here. If you set the IPC_RMID flag then
the kernel should remove the segment when all users go away. This is
standard IPC behaviour and is documentated in the manpage...
Would you please tell me where to find the manpage and how to set IPC_RMID flag?
--
Kathy