Re: [GENERAL] Checking Permissions with SQL

2001-02-10 Thread Christopher Sawtell
7; to select and read from the database. school=# select relacl from pg_class where relname = 'school'; relacl --- {"=","chris=arwR","nobody=r"} (1 row)

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

2001-02-12 Thread Christopher Sawtell
are looking to start re-developing our 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

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

2001-02-13 Thread Christopher Sawtell
x27;s the info. Please let me know if you need 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

[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
on column test_table.col1 is 'this is a column > comment'; > > COMMENT > > norman=# \dd test_table.col1 > > Object descriptions > Name | Object | Description > --++- > (0 rows) -- Sincerely etc., NAME Christopher Sawt

[GENERAL] Bug in my ( newbie ) mind?

2001-02-20 Thread Christopher Sawtell
utter just a tiny glimmer of a 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 UIN

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/po

[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

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

2001-02-24 Thread Christopher Sawtell
xxx VALUES(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 Saw

Re: [GENERAL] Addison-Wesley looking for authors

2001-02-28 Thread Christopher Sawtell
ou feel able to share 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/

Re: [GENERAL] Re: Under Mac OS X

2001-02-28 Thread Christopher Sawtell
n it? Has anybody 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 P

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

2001-03-01 Thread Christopher Sawtell
anyway, disjointed snippets of code are horrible. > 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 ;

Re: [GENERAL] Data types?

2001-03-07 Thread Christopher Sawtell
Look in the regression 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 o

[GENERAL] Backup and analyse

2001-03-12 Thread Christopher Sawtell
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 Saw

Re: [GENERAL] Fw: Missing Shared Libraries

2001-03-14 Thread Christopher Sawtell
; No such file or directory" > > The file 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? --