Re: [GENERAL] Fw: Missing Shared Libraries

2001-03-14 Thread Christopher Sawtell
is located at libpq.so.2.1 so I don't understand. Any ideas? As the root user you have added the directory name /usr/local/pgsql/lib/ as a single line to the file /etc/ld.so.conf and then run the command ldconfig havn't you? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 445

[GENERAL] Backup and analyse

2001-03-12 Thread Christopher Sawtell
is alive and active and have the backup consistent to the state the database was in when the backup started? I'm 99.99% sure the answers are yes for all of these but I'd very much like to have it confirmed by somebody who _really knows_. -- Sincerely etc., NAME Christopher Sawtell CELL

Re: [GENERAL] Data types?

2001-03-07 Thread Christopher Sawtell
tests. Interesting stuff. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -- Please refrain from using HTML or WORD attachments in e

Re: AW: [GENERAL] Addison-Wesley looking for authors

2001-03-01 Thread Christopher Sawtell
. and it will contain a rather complex section about PL/pgSQL-programming and application development, also accompanied by many examples. At least I would like to thank Bruce for the offered help - I surely will remember ;-) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257

Re: [GENERAL] Addison-Wesley looking for authors

2001-02-28 Thread Christopher Sawtell
the special modifications to LyX you made? ( I thought the line numbers in the proof pdf files real neat ) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C

Re: [GENERAL] Re: Under Mac OS X

2001-02-28 Thread Christopher Sawtell
here actually used it / made it go? Not just a fyi type question. I'm in the middle of developing a school oriented PostgreSQL application and having an _easy_ way to get it to go on a Mac. would be very useful. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN

Re: [GENERAL] How to create a dynamic list?

2001-02-24 Thread Christopher Sawtell
UES(1,'aaa','{10,20,30}'); INSERT 137225 1 chris=# select * from xxx; num | nom | nb -+-+ 1 | aaa | {10,20,30} (1 row) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 445

Re: [GENERAL] problem while compiling user c functions in 7.1beta4

2001-02-22 Thread Christopher Sawtell
On Thu, 22 Feb 2001 22:39, hubert depesz lubaczewski wrote: On Thu, Feb 22, 2001 at 10:21:12PM +1300, Christopher Sawtell wrote: I did a cvsup update about 12 hours ago and look:- 22:05:23 chris@berty:/usr/src/cvs/pgsql $ find . -name postgres.h ./src/include/postgres.h 22:16:22 chris

[GENERAL] Column into array.

2001-02-22 Thread Christopher Sawtell
Greetings, I have a small table with serial numbers in it. I wish to get a selection ( approx 30 ) of those numbers into an array in another table. Is this possible in SQL? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell

[GENERAL] Bug in my ( newbie ) mind?

2001-02-20 Thread Christopher Sawtell
hint as to what it thinks one's mistake is instead of the rather enigmatic "ERROR: parser: parse error at or near". Is it possible for mere mortals to help? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co .

[GENERAL] Name list for testing / demo.

2001-02-15 Thread Christopher Sawtell
Greetings folks, I am setting up a db for test and demo. I need some names to populate the db. Anybody know where I can find a list of first ( Christian ) and some surnames on the net? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470

Re: [GENERAL] how to see column comments?

2001-02-15 Thread Christopher Sawtell
ons Name | Object | Description --++- (0 rows) -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell @ xtra . co . nz CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz -- Please re

Re: [GENERAL] Re: SELECT (sometimes) returning Zero Rows?

2001-02-13 Thread Christopher Sawtell
more information. This has the same smell about it as the one a couple of days ago where the CR characters in a file loaded into the database using COPY were upsetting things. So, How did you populate your database? -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ

Re: [GENERAL] PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?

2001-02-12 Thread Christopher Sawtell
accounts/order processing system using a major database (we currently use a 4GL). We would appreciate any constructive advise to help us make the decision on which database to use. -- Sincerely etc., NAME Christopher Sawtell CELL PHONE 021 257 4451 ICQ UIN45863470 EMAIL csawtell

Re: [GENERAL] Checking Permissions with SQL

2001-02-10 Thread Christopher Sawtell
. school=# select relacl from pg_class where relname = 'school'; relacl --- {"=","chris=arwR","nobody=r"} (1 row) -- Sincerely etc., NAME Christoph