[GENERAL] A lock to fit a key..

2001-08-19 Thread David Ford
I need to figure out a way to allow users to only be able to update a certain column in a table. Does anyone have any ideas to start with? David ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] New RPMS ?

2001-08-19 Thread Trond Eivind Glomsrød
Fernando Lozano <[EMAIL PROTECTED]> writes: > Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using > the older glibc and rpm format? FWIW, while a version for RHL 6.2 makes sense because of glibc issues (and other libraries), the supported rpm format for RHL 6.2 is v4. Erratas

Re: [GENERAL] Serial not so unique?

2001-08-19 Thread Michael Samuel
I encountered the same problem. The machine it happenned on _may_ have had a power outage before I noticed the problem. (I know it had one a while back when on the workbench, but I can't remember if that was before or after I'd setup the tables) BTW, this was a debian box, running the 7.1release

[GENERAL] New RPMS ?

2001-08-19 Thread Fernando Lozano
Hi there! Are there plans for 7.1.3 RPMS for Red Hat 6.2 and other systems using the older glibc and rpm format? []s, Fernando Lozano ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Re: chr() in 7.0.3 !

2001-08-19 Thread Lee Harr
On Sun, 19 Aug 2001 20:59:35 + (UTC), omid omoomi <[EMAIL PROTECTED]>: > hi all, > I have pg 7.0.3 installed. I can use ascii() to get the ascii code of a > character but I can not use chr() to reverse the function... is it a matter > of the pg version I have? If so, is there any other way t

Re: [GENERAL] OT: Design Books

2001-08-19 Thread omid omoomi
Hi, The one I recommend is: Introduction to System Analysis and Design by Igor Hawryszkiewycz ISBN 013 896887 X Hope that helped Omid Omoomi >From: David Wheeler <[EMAIL PROTECTED]> >To: PostgreSQL-general <[EMAIL PROTECTED]> >Subject: [GENERAL] OT: Design Books >Date: Sun, 19 Aug 2001 11:48:57

[GENERAL] chr() in 7.0.3 !

2001-08-19 Thread omid omoomi
hi all, I have pg 7.0.3 installed. I can use ascii() to get the ascii code of a character but I can not use chr() to reverse the function... is it a matter of the pg version I have? If so, is there any other way to get the text from the ascii number? TIA Omid Omoomi __

Re: [GENERAL] OT: Design Books

2001-08-19 Thread Sam Tregar
On Sun, 19 Aug 2001, David Wheeler wrote: > I'm looking for a couple of solid books to help me broaden my knowledge of > database design so that I can improve my designs. So what do you like? > What stuff have you read and would recommend? I'm most interested in > fundamentals of both standard re

[GENERAL] OT: Design Books

2001-08-19 Thread David Wheeler
Hey All, I'm looking for a couple of solid books to help me broaden my knowledge of database design so that I can improve my designs. So what do you like? What stuff have you read and would recommend? I'm most interested in fundamentals of both standard relational database design and object datab

[GENERAL] is this possible? it should be!

2001-08-19 Thread newsreader
Hello I have statements (highly simplified just to get the point across) like select a,b,c from a where d=2 order by e limit 10; Now I think that because of "order by" the above query already "knows" the result of the below query select count(*) from a where d=2; The point is that I want to k

Re: [GENERAL] Serial not so unique?

2001-08-19 Thread Tom Lane
Stephen Robert Norris <[EMAIL PROTECTED]> writes: > ... The test case that > demonstrates it sometimes takes about 1.5 hours to run, If you have a reproducible test case, let's see it. Bulk isn't as important as being able to get the behavior under a microscope... regard

Re: [GENERAL] Overwriting Operator for numeric and float8 fails

2001-08-19 Thread Andrew Gould
I think you have a syntax error in the SELECT statement. What is RECHNUNG? The only table reference that I see is t6. If RECHNUNG is the database, connect to the database and try: Select * from t6 where bruttosum = 0034.70 order by nummer desc; Best of luck, Andrew Gould --- Johann Zusch

[GENERAL] Overwriting Operator for numeric and float8 fails

2001-08-19 Thread Johann Zuschlag
Hi, My application does queries like this: SELECT t6.* FROM RECHNUNG t6 WHERE t6.bruttosumm = 0034.70 ORDER BY t6.nummer DESC I get the following error: Unable to identify an operator '=' for types 'numeric' and 'float8'... and of course the same for the operator '<>'. Ok, ok quotes miss