[BUGS] BUG #2467: Documentation
The following bug has been logged online: Bug reference: 2467 Logged by: Rae Stiening Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Linux Description:Documentation Details: Table 9-3. Mathematical Functions Description of the "width_bucket(...)" "return the bucket to which operand would be assigned in an equidepth histogram with count buckets, an upper bound of b1, and a lower bound of b2" I believe that the lower bound is b1 and upper b2. ---(end of broadcast)--- TIP 6: explain analyze is your friend
[BUGS] BUG #2470: Field DefVal And Description
The following bug has been logged online: Bug reference: 2470 Logged by: Serkan Eksi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows 2003 Server - Ent Description:Field DefVal And Description Details: Hi everyone excuse me for my english is not very well :( I use the asp, vb 6 (with sp6) and .net vb to development. And I use the postgres_odbc driver to connect the postgres server. I need to know a field description of a table. But I can not get the neither field description or field default value. to learn is the code wrong or right, I've tried it another db connection (ex. SQL2K, ORA, Foxpro). And there wasnt error. the code has run corectly. I wonder if the postgres doesnt provide these properties by the ADO. thanks in advance ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] BUG #2468: how to create auto-generate primary key
The following bug has been logged online: Bug reference: 2468 Logged by: vivekananda Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows-2000 Description:how to create auto-generate primary key Details: Hi, Good morning all.How to create automatic generated key while creating table like OID's.is there any posibility to create this one? for example create table emp(no numaric(3),name varchar(10)) here there is no primary key explicitly.But i want use primary key with adding 3rd column for generating querys. OID's are uniqe for all tables.but i want impliment this feature only for specified table.How? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[BUGS] BUG #2469: Error in connection to the server
The following bug has been logged online: Bug reference: 2469 Logged by: samir Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: windows 2000 Description:Error in connection to the server Details: I am trying to connect databse from a client machine having IP address 192.168.0.52. It returns an error "cannot conect to the server. Is the server running on port " The server IP address is 192.168.0.103 Please guide in this matter. Regards Samir ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] BUG #2466: lock issues...
""P.P.S. Narayan"" <[EMAIL PROTECTED]> wrote > > However, there are a bunch of http requests that come in after the hanging > request, which get deadlocked on the locks held by the hanging request. AS > far as I have read, there is a lock_timeout parameter in postgresql config > file to timeout after 1s. But none of the latter http requests timeout. > There is a deadlock_timeout parameter in the configure file, which is "the time in milliseconds to wait on lock before checking for deadlock." If a deadlock is resolved, you will see an error message like "deadlock detected" with some details. Also, you can see current lock status via pg_locks view to see "information about the locks held by open transactions within the database server". More details can be found in the docs. Regards, Qingqing ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [BUGS] BUG #2467: Documentation
"Rae Stiening" <[EMAIL PROTECTED]> writes: > Description of the "width_bucket(...)" > "return the bucket to which operand would be assigned in an equidepth > histogram with count buckets, an upper bound of b1, and a lower bound of > b2" > I believe that the lower bound is b1 and upper b2. I agree that this is a typo, but looking at the spec and the function code, the description seems misleading altogether. Apparently b1 > b2 is allowed and the computation is effectively negated then (the buckets are numbered in descending rather than ascending order). So ISTM that just switching "lower" and "upper" in the text doesn't really get us to the point of adequately documenting the function. But the description is already too long to fit comfortably in the table, so adding another sentence to cover the b1 > b2 case isn't attractive. Any ideas what to do? Would "starting bound" and "ending bound" work, or just confuse people more? regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[BUGS] stopping server does not remove external_pid_file
Hi PostgreSQL developers, I just played around with external_pid_file in 8.1.4. I noticed that the file is created and filled properly, but it is not removed again when the server is stopped. Thank you, Martin -- Martin Pitthttp://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates? signature.asc Description: Digital signature
