Re: [HACKERS] pg_get_serial_sequence is inconsistent

2004-11-26 Thread Bruce Momjian
Should we fix this or document it somewhere? It is the issue of pg_get_serial_sequence handling upper/lower case differently for its two arguments, if I remember correctly. --- Christopher Kings-Lynne wrote: > > Right. Fro

Re: [CYGWIN] [HACKERS] src/timezone/pgtz __imp__my_exec_path

2004-11-26 Thread Bruce Momjian
Is Cygwin now working properly in CVS and beta5? I assume so. --- Magnus Hagander wrote: > > >>beta4 - cygwin: > > >>postgres.exe fails to build, because __imp__my_exec_path from > > >>src/timezone/pgtz.o cannot be resolve

Re: [HACKERS] [BUGS] pg_autovacuum in 8beta-dev3 small bug

2004-11-26 Thread Bruce Momjian
Can someone comment on this? --- Leen Besselink wrote: > Hi folks, > > 8.0beta3 has pg_autovacuum included, when I want to run this as a Windows > service, it says you can use the -I and -R options. > > When I do that and

Re: [HACKERS] New member says hello

2004-11-26 Thread lsunley
In <[EMAIL PROTECTED]>, on 11/26/04 at 09:50 PM, Tom Lane <[EMAIL PROTECTED]> said: >[EMAIL PROTECTED] writes: >> How do I go about getting OS/2 specific changes for source code and >> makefiles merged with the regular release code? >Send a proposed patch to pgsql-patches for discussion. >If

Re: [HACKERS] New member says hello

2004-11-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > How do I go about getting OS/2 specific changes for source code and > makefiles merged with the regular release code? Send a proposed patch to pgsql-patches for discussion. If you're hoping to get this into 8.0, it had better arrive soon and be a very small patch ...

[HACKERS] New member says hello

2004-11-26 Thread lsunley
Hi All, I am doing a port of postgreSQL v8 to OS/2. I have successfully built a port (using the beta 4 code), and am starting testing. I will be updating my port with the beta 5 code in the next couple of days. How do I go about getting OS/2 specific changes for source code and makefiles merge

Re: [HACKERS] Error: column "nsptablespace" does not exist

2004-11-26 Thread Tom Lane
Roland Volkmann <[EMAIL PROTECTED]> writes: > with the new Beta5 you will receive an error ""column "nsptablespace" > does not exist"" on phpPgAdmin and EMS PostgreSQL-Manager. Yup. They need to be fixed. regards, tom lane ---(end of broadcast)--

Re: [HACKERS] Stopgap solution for table-size-estimate updating problem

2004-11-26 Thread Tom Lane
"Zeugswetter Andreas DAZ SD" <[EMAIL PROTECTED]> writes: >> rel->pages = RelationGetNumberOfBlocks(relation); > Is RelationGetNumberOfBlocks cheap enough that you can easily use it for the > optimizer ? It's basically going to cost one extra lseek() kernel call ... per query, per table referenced

[HACKERS] Error: column "nsptablespace" does not exist

2004-11-26 Thread Roland Volkmann
Hello All, with the new Beta5 you will receive an error ""column "nsptablespace" does not exist"" on phpPgAdmin and EMS PostgreSQL-Manager. Perhaps there will be some more applications around which are broken now. What is the future in this area? Back to schema of Beta4, or must all the utiliti

Re: [HACKERS] Stopgap solution for table-size-estimate updating problem

2004-11-26 Thread Zeugswetter Andreas DAZ SD
> rel->pages = RelationGetNumberOfBlocks(relation); Is RelationGetNumberOfBlocks cheap enough that you can easily use it for the optimizer ? I myself have always preferred more stable estimates that only change when told to. I never liked that vacuum (without analyze) and create index chan

[HACKERS] Stopgap solution for table-size-estimate updating problem

2004-11-26 Thread Tom Lane
There's been some previous discussion of getting rid of the pg_class columns relpages and reltuples, in favor of having the planner check the current relation block count directly (RelationGetNumberOfBlocks) and extrapolate the current tuple count based on the most recently measured tuples-per-page

Re: [HACKERS] problem installing 8.0.0beta5 on OS X 10.3

2004-11-26 Thread Tom Lane
Will Arp <[EMAIL PROTECTED]> writes: > removing my custom csh.cshrc file did the trick, > probably color syntax code I've found here: > http://www.macosxhints.com/article.php?story=20031027145026892 > Thank you! > Here is my csh.cshrc file, maybe you can spot the culprit, > and point me to some doc

Re: [HACKERS] Question to tea leaf readers

2004-11-26 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > I wonder if anybody here suspects that some problem under current > investigation might lead to another last-minute catalog change, > corrupting our 8.0 support again. There aren't any open problems that might require a catalog change, and I have my ow

Re: [HACKERS] Possible TODO item? VACUUM on empty table

2004-11-26 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > But not all of the stats are simple totals. I'm not sure this would make sense > for the histogram arrays. Yeah, I don't know how you "halve" a histogram. But the problem is not with the pg_statistic stats, I think. It is already true that ANALYZE punts w

[HACKERS] Question to tea leaf readers

2004-11-26 Thread Andreas Pflug
We (pgAdmin Development Team) want to release pgAdmin III V1.2 real soon now, we have the RC version out for a while. Very shortly after we tagged our RC1 version, the pgsql catalog changed mostly unnoticed by our core developers (including Dave Page and me), which rendered pgadmin3RC1 nonfunct

Re: [HACKERS] Beta5 now Available

2004-11-26 Thread Thomas Hallgren
Stephen Frost wrote: * Marc G. Fournier ([EMAIL PROTECTED]) wrote: we're not talking load issues this time ... the way I understand it, bittorrent has a 'tracker' process that only one can be running on the "BT Distributed Network" at once ... so, if the bt "central server" goes down, the who

Re: [HACKERS] Bitmap index

2004-11-26 Thread Yann Michel
Hi, On Fri, Nov 26, 2004 at 10:25:41AM -, Pawel Niewiadomski wrote: > > My promoter accepted the subject. I'm waiting for an official acceptance > of the subject. Until then I would want to get familiar with PostgreSQL > internals and bitmap index implementations. I will appreciate > any lin

Re: [HACKERS] Possible TODO item? VACUUM on empty table

2004-11-26 Thread Greg Stark
Richard Huxton <[EMAIL PROTECTED]> writes: > So - would it be worth, in the case of vacuum+analyse (but not analyse alone), > where the table is completely empty then just halve the existing stats. > > That way, if you're in the middle of a delete/replace cycle your stats will > still be in the

Re: [HACKERS] Bitmap index

2004-11-26 Thread Pawel Niewiadomski
On Wed, 24 Nov 2004 19:26:41 +1100, Neil Conway <[EMAIL PROTECTED]> wrote : > On Mon, 2004-11-22 at 07:57 +, PaweX Niewiadomski wrote: > > I saw discussion about bitmap indexes few weeks ago. I wonder if > > any of you is working on it (in secret)? > > For what it's worth, I don't know of an

Re: [HACKERS] Getting Unicode characters greater than or equal to

2004-11-26 Thread John Hansen
> In your case I'm guessing your Windows system isn't supplying > UTF-8 but some other character set. Certainly that is what > the error message implies. Note PG handles UTF-8 but not > UTF-16 or other encodings. Actually, Chinese is a problem on any pg version if the db encoding is unicode, si

[HACKERS] Possible TODO item? VACUUM on empty table

2004-11-26 Thread Richard Huxton
Over on the support lists we've seen a couple of examples this week of people doing a bulk import/delete/replace cycle with a vacuum analyse just after the delete. Instinctively, it's where you'd vacuum and I'm guessing the analyse just gets typed at the same time from habit (I know I've done s

Re: [HACKERS] Getting Unicode characters greater than or equal to

2004-11-26 Thread Richard Huxton
Venki wrote: Hi All, I am using Postgres 7.4.6 on Red hat linux 9.0. When I try insert a chinese character from my frontend(Asp.Net on win2k pro using ado.net, .Net framework 1.1) into a table in my postgres database I am getting the following error message "System.Data.Odbc.OdbcException: ERROR [H

[HACKERS] Getting Unicode characters greater than or equal to 0x10000 are not supported error

2004-11-26 Thread Venki
  Hi All, I am using Postgres 7.4.6 on Red hat linux 9.0. When I try to insert a chinese character from my frontend(Asp.Net on win2k pro using ado.net, .Net framework 1.1) into a table in my postgres database I am getting the following error message   "System.Data.Odbc.OdbcException: ER

[HACKERS] Getting Unicode characters greater than or equal to 0x10000 are not supported error

2004-11-26 Thread Venki
Hi All, I am using Postgres 7.4.6 on Red hat linux 9.0. When I try insert a chinese character from my frontend(Asp.Net on win2k pro using ado.net, .Net framework 1.1) into a table in my postgres database I am getting the following error message   "System.Data.Odbc.OdbcException: ERROR [HY000]