select last_value from your_sequence;
Jodi Kanter wrote:
I cannot view the currval because it is not set in the session yet. Is
there a way to set it without having to increment the value?
Thanks
Jodi
---(end of broadcast)---
TIP 7: don't forge
> Hi !
> I have small problem
> amount size all databases ~5Gb
> I make dumpall >dumpfile
> when size dumpfile = 1024 dumpall print error and exit !
> Linux Slackware7.2 ext2 2.4.17 gcc2.95
^^^
I think ext2 can't support file larger then 2G,
and your DB may be
Roy Souther wrote:
> This is a follow up to my previous post "Upgrade problems"
> I compiled from source and have the same problem.
>
> -- My original post. --
> I have a large database. I had PG 7.0. I did the data dump and got a 2.5 GB
> file.