[BUGS] Fw: CD

2002-11-28 Thread Lee Kindness
itle... For general PostgreSQL help in getting started there is the [EMAIL PROTECTED] mailing list, which may be of use to you in the future. Regards, Lee Kindness. > Hi, > I bought the SQL Weekend Crash Course book with a CD. The problem was, = > I could not find the folder named &q

Re: [BUGS] postmaster will not start with stale lockfile but not report why

2002-10-07 Thread Lee Kindness
... Lamar, would this be easy to do for the RPMs? If you could point me in the right direction I could take a look... Thanks, Lee Kindness. Tom Lane writes: > Rudolf Potucek <[EMAIL PROTECTED]> writes: > > Oct 4 14:05:45 antimony3 postgresql: Starting postgresql service: > &

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Lee Kindness
I received the announcement today, seems it was stuck somewhere: From [EMAIL PROTECTED] Thu Aug 29 13:48:26 2002 Return-Path: <[EMAIL PROTECTED]> Received: from internet.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4) id NAA11884; Thu, 29 Aug 2002 13:48:25 +0100 (BST) Received:

Re: [BUGS] PostgreSQL security release 7.2.2 hasn't been announced on pgsql-announce

2002-08-29 Thread Lee Kindness
I received the announcement today, seems it was stuck somewhere: >From [EMAIL PROTECTED] Thu Aug 29 13:48:26 2002 Return-Path: <[EMAIL PROTECTED]> Received: from internet.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4) id NAA11884; Thu, 29 Aug 2002 13:48:25 +0100 (BST) Received: fr

[BUGS] ECPG: CREATE TABLE ... FOREIGN KEY(col) REFERENCES table(col)

2002-06-18 Thread Lee Kindness
but this would not work if the desired column was not the primary key... BRegards, Lee Kindness. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [BUGS] Bug #640: ECPG: inserting float numbers

2002-06-11 Thread Lee Kindness
roblem on my machine: > > #$ ./a.out floattest > col1: -0.06 > *!*!* Error -220: No such connection NULL in line 21. > > Wow, how did that "A" get into the query string: > > insert into tab1 ( col1 ) values ( -6.002122251e-

Re: [BUGS] Bug #640: ECPG: inserting float numbers

2002-06-11 Thread Lee Kindness
RROR: parser: parse error at or near "a" [29189]: raising sqlcode -400 in line 21, ''ERROR: parser: parse error at or near "a"' in line 21.'. Regards, Lee Kindness. Bruce Momjian writes: > Has this been addressed? Can you supply a reproducable

[BUGS] ecpg did not precompile declare cursor

2002-02-20 Thread Lee Kindness
This is expected behaviour, the 'real' code gets emitted when you OPEN the cursor, i.e. you should be doing something like: EXEC SQL DECLARE demo_cur CURSOR FOR SELECT field1, field2 FROM test; EXEC SQL OPEN demo_cur; if( sqlca.sqlcode != 0 ) { some_error(); return; } while( 1 )

[BUGS] ECPG bug in --help

2002-01-04 Thread Lee Kindness
Michael, hope you've had a good Christmas & all the best for the New Year... When you run 'ecpg --help' you get the following: -t turn on autocommit of transactions amongst the other options... Shouldn't this be OFF as per the documentation? Best regards,

[BUGS] Btree index ignored on SELECT until VACUUM ANALYZE

2001-10-11 Thread Lee Kindness
When adding an index to a (quite large, ~2 million rows) table PostgreSQL continues to do sequential lookups until VACUUM ANALYZE is run. Naturally performance is poor. The CREATE INDEX statement takes considerable time. Seen with 7.1.3 on Intel Linux (RedHat 7.0 & 7.1 and Solaris 2.6. In the e

[BUGS] ESQL/C TRUNCATE TABLE results in DROP TABLE

2001-10-01 Thread Lee Kindness
Your name : Lee Kindness Your email address : [EMAIL PROTECTED] System Configuration - Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.16-22, RedHat 7.0 PostgreSQL version