Re: [HACKERS] MOVE strangeness
Tom Lane wrote: The cursor must be considered to be positioned on its current row, not between rows, or the SQL-defined operations UPDATE WHERE CURRENT OF and DELETE WHERE CURRENT OF don't make any sense. (We don't support those yet, but we should someday.) Okay. But then doesn't it make sense for FETCH to fetch the contents of the row (and subsequent requested rows) that the cursor is currently on *then* move, and not the other way around? Were that the model, then the only situation in which the cursor would not be on a row is if it's past the last one (or if it pointed to an empty set). And the initial declaration of the cursor would thus normally place the cursor on the first row fetched, just as you'd expect. Fetch 3 would fetch whatever row the cursor is currently on and the following 2 rows, then move the cursor down 3 rows (so that it's on the row that follows the last row fetched). Additionally, with that model, UPDATE WHERE CURRENT OF would work exactly as you'd expect in all situations: it would update the row the cursor is on or, if the cursor is beyond the last row, would fail. MOVE would also work exactly as you'd expect: MOVE -3 would move the cursor back 3 positions, or to the beginning of the set, whichever comes first, and would report how many positions it was able to move. My read of the spec indicates that cursors don't behave the way I describe above. If I'm right, then does anyone here know why the spec calls for something different? -- Kevin Brown [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Problems with 7.3.1
Tom, I'm puzzled! I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Could it be because the machine is slow (and disks too!) Regards, On Thu, 26 Dec 2002, Tom Lane wrote: Date: Thu, 26 Dec 2002 13:44:51 -0500 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] Problems with 7.3.1 Olivier PRENANT [EMAIL PROTECTED] writes: Compile works ok however make check fails wile creating pl/pgsql with : WARNING: bt_getroot[pg_proc_proname_nsp_index]: fixing root page ERROR: bt_fixroot: not valid old root page. Wow. Is the behavior reproducible? How about if you go ahead and install, and do a plain make installcheck (or even just try a manual createlang in a fresh database)? That code thinks it is dealing with a concurrent index root page split, but there couldn't be any concurrent operations happening during the create-plpgsql step of a regression test run. Can you step through _bt_getroot() (it's in src/backend/access/nbtree/nbtpage.c) and figure out exactly how it's getting confused? If the behavior is reproducible I'm inclined to suspect a compiler bug; it's hard to see how _bt_getroot could get so confused otherwise. regards, tom lane -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] PostgreSQL article
Here's another nice article about PostgreSQL in the enterprise: http://linuxworld.com.au/news.php3?nid=2095tid=1 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] please apply patch to CVS ( 7.3 and 7.4dev)
Applied to 7.3.X and CVS HEAD. Thanks. --- Oleg Bartunov wrote: Small fix in documentation and some examples of usage. Please, apply to 7.3 and current CVS Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 Content-Description: [ Attachment, skipping... ] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] PostgreSQL article
On 27 Dec 2002 at 8:37, Bruce Momjian wrote: Here's another nice article about PostgreSQL in the enterprise: http://linuxworld.com.au/news.php3?nid=2095tid=1 Those on the advocacy list saw this posted a few days ago: http://archives.postgresql.org/pgsql-advocacy/2002-12/msg00203.php -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Problems with 7.3.1
Olivier PRENANT [EMAIL PROTECTED] writes: I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Interesting. Would you try another test: now that you've completed the installation, does make check work? I am wondering if make check was picking up the wrong version of plpgsql.so, ie, the one from your pre-7.3 installation. (I'm not very clear on how a wrong version of plpgsql.so would result in the particular failure you observed, but this is the only theory I can think of right now...) regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Problems with 7.3.1
Hi Tom Here are some news and tests I did and am still doing: 1) there is no previous installation so that can't be a library problem (good thing!) 2) My tests and compiles are running on data disk ibm 18G uw and fail. I ended up intalling on the root disk and installcheck did work ok!! I just finish low reformating the 2 data disk , recreate file systems and reload. Make check stiil fails at the same point, driver shows no disk error... Anymore idea? Regards, On Fri, 27 Dec 2002, Tom Lane wrote: Date: Fri, 27 Dec 2002 11:34:01 -0500 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] Problems with 7.3.1 Olivier PRENANT [EMAIL PROTECTED] writes: I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Interesting. Would you try another test: now that you've completed the installation, does make check work? I am wondering if make check was picking up the wrong version of plpgsql.so, ie, the one from your pre-7.3 installation. (I'm not very clear on how a wrong version of plpgsql.so would result in the particular failure you observed, but this is the only theory I can think of right now...) regards, tom lane -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] Problems with 7.3.1
--On Friday, December 27, 2002 18:37:24 +0100 Olivier PRENANT [EMAIL PROTECTED] wrote: Hi Tom Here are some news and tests I did and am still doing: 1) there is no previous installation so that can't be a library problem (good thing!) 2) My tests and compiles are running on data disk ibm 18G uw and fail. I ended up intalling on the root disk and installcheck did work ok!! I just finish low reformating the 2 data disk , recreate file systems and reload. Make check stiil fails at the same point, driver shows no disk error... Anymore idea? Olivier, Mine works fine on the Beta (no media yet :-( for the real release). I can give you an account on my box if you want a reference point. LER Regards, On Fri, 27 Dec 2002, Tom Lane wrote: Date: Fri, 27 Dec 2002 11:34:01 -0500 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] Problems with 7.3.1 Olivier PRENANT [EMAIL PROTECTED] writes: I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Interesting. Would you try another test: now that you've completed the installation, does make check work? I am wondering if make check was picking up the wrong version of plpgsql.so, ie, the one from your pre-7.3 installation. (I'm not very clear on how a wrong version of plpgsql.so would result in the particular failure you observed, but this is the only theory I can think of right now...) regards, tom lane -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] - - Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Problems with 7.3.1
Tom, I've re-done all tests and I confirm that it works ok on the root disk but not on the others. Ok, this is an old machine but, should I send you a tgz of th pgsql directory if you want to analyse the files? Maybe my strange system triggers an unknown bug? Regards, On Fri, 27 Dec 2002, Tom Lane wrote: Date: Fri, 27 Dec 2002 11:34:01 -0500 From: Tom Lane [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] Problems with 7.3.1 Olivier PRENANT [EMAIL PROTECTED] writes: I tried postgresql 7.3 and 7.3.1 and they both fail regressin when creating plpgsql language. However, when installed, createlang plpgsql template1 work like a charm. Interesting. Would you try another test: now that you've completed the installation, does make check work? I am wondering if make check was picking up the wrong version of plpgsql.so, ie, the one from your pre-7.3 installation. (I'm not very clear on how a wrong version of plpgsql.so would result in the particular failure you observed, but this is the only theory I can think of right now...) regards, tom lane -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] -- Make your life a dream, make your dream a reality. (St Exupery) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html