[GENERAL] Privileges question

2005-02-14 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, ~ I created a schema, database, tables, users and a user group. create user sma_user password 'x'; create group sma_user_group; alter group sma_user_group add user sma_user; create table sma_apps.ordr_dat ( ... ); grant select,delete,insert

Re: [GENERAL] Quad Xeon vs. Dual Itanium

2004-02-09 Thread James Moe
John Gibson wrote: Assuming similar memory and disk sub-systems, I am considering a Quad Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the PostgreSQL code is written for 32 bit and not optimized for the 64 bit Itanium cpu. That makes me think that the Xeon system would be a bet

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-15 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 15 Dec 2003 09:13:49 +, Tony wrote: >excel it's previous incantation. > The spelling is "its", not "it's". "Its" is a possessive pronoun. "It's" is a contraction for "it is". - -- jimoe at sohnen-moe dot com pgp/gpg public key: ht

Re: [GENERAL] Recomended FS

2003-10-25 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 26 Oct 2003 16:24:17 +1300, Mark Kirkwood wrote: >I would conclude that it not *always* the case that power failure >renders the database unuseable. > >I have just noticed a similar posting from Scott were he finds the cache >enabled case ha

Re: [GENERAL] Recomended FS

2003-10-21 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 21 Oct 2003 18:56:52 +1300, Mark Kirkwood wrote: > >Note that even including the card, this is a very cheap setup. > Yes, this is the single advantage of IDE vs SCSI. If the price of the storage system is the *only* consideration, IDE is the

Re: [GENERAL] OT: HEADS-UP: viral storm out there

2003-09-22 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 22 Sep 2003 20:06:56 +0530, Shridhar Daithankar wrote: >I had excess of 300 spam >mails to delete between friday night 9PM and monday morning 11AM. Usually that >is limited to 10-15 over week end. > Is that all? Lucky you. - -- jimoe at

[GENERAL] Copy From with "null" data

2003-08-16 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I am attempting to import data from a text file (tab-delimited) that has NULL fields of the form "(NULL)". (The source dbms does not have DUMP command.) According to the v7.3 docs (http://www.postgresql.org/docs/7.3/static/sql-copy.html): n

Re: [GENERAL] Importing data

2003-08-14 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 14 Aug 2003 18:48:43 -0500, Andrew L. Gould wrote: >> >> What you're looking for is COPY: >> >> http://www.postgresql.org/docs/7.3/static/sql-copy.html >> Thanks! That was it. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www