[BUGS] FATAL 1: btree

2000-11-03 Thread Chau, Artemis
> I am using postgressql 6.5.2. (Please don't tell me to upgrade to 7.0 > because we can't yet). > I wrote a function, the error I got is > FATAL 1: btree: cannot split if start (2) >= maxoff (1). > > It took me a while to isolate a section of the code. I suspected the line > was too lone, so

[BUGS] relation modified? (fwd)

2000-11-03 Thread Lennert Buytenhek
So.. I assume this isn't normal (postgresql 7.0.2 on linux 2.2.16)? ERROR: RelationClearRelation: relation 37799899 modified while in use

Re: [BUGS] FATAL 1: btree

2000-11-03 Thread Tom Lane
"Chau, Artemis" <[EMAIL PROTECTED]> writes: >> I wrote a function, the error I got is >> FATAL 1: btree: cannot split if start (2) >= maxoff (1). You are running into limits on the size of a function body. You can't safely make the body longer than about 2700 bytes in 6.5.*. The limit is abou

Re: [BUGS] relation modified? (fwd)

2000-11-03 Thread Tom Lane
Lennert Buytenhek <[EMAIL PROTECTED]> writes: > So.. I assume this isn't normal (postgresql 7.0.2 on linux 2.2.16)? > ERROR: RelationClearRelation: relation 37799899 modified while in use Nope... or at least it's not desirable... there's a thread about this in progress on pghackers.

[BUGS] Unable to compile enterprise version of jdbc-driver

2000-11-03 Thread pgsql-bugs
Grim Iversen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Unable to compile enterprise version of jdbc-driver Long Description I checked out all the source from cvs, and tried to compile the jdbc-driver with the class "Post

Re: [BUGS] waiting for lock?

2000-11-03 Thread Tom Lane
Lennert Buytenhek <[EMAIL PROTECTED]> writes: > If you send psql a SIGINT, it returns with: > NOTICE: Skipping "pg_rules" --- only table owner can VACUUM it > Cancel request sent > ERROR: Query cancel requested while waiting lock > ulsec=> > Restarting the server (postgresql 7.0.2) cured all.