Re: [ADMIN] checking currval

2003-06-18 Thread Weiping He
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

Re: [ADMIN] problem with dumpall

2002-01-09 Thread Weiping He
> 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

Re: [ADMIN] psql error: file to large!

2001-07-27 Thread Weiping He
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.