Re: [GENERAL] Dreamweaver

2003-08-16 Thread Tino Wildenhain
Hi Glen, Glen Eustace wrote: This may have been better posted in the advocacy list but I am not a subscriber. We recently purchased Dreamweaver MX and I was a little surprised to find that one of its pre-defined scripting systems is PHP + MySQL. I haven't done much exploring of what is actually of

Re: [GENERAL] Dreamweaver

2003-08-16 Thread Nikola Milutinovic
> This may have been better posted in the advocacy list but I am not a > subscriber. > > We recently purchased Dreamweaver MX and I was a little surprised to > find that one of its pre-defined scripting systems is PHP + MySQL. I > haven't done much exploring of what is actually offered but wondered

Re: [GENERAL] summary and request - correction

2003-08-16 Thread Jason Godden
Just a note on that example: I didn't properly end the case commands on the last two fields in the insert and end should probably be quoted. No I haven't tested it. Should be: echo "insert into contact select id, case fm when null then 'xzxzxzxz' else fm end, case ls when null then 'xzxzxzxz'

Re: [GENERAL] Graphical Mapping a Database

2003-08-16 Thread Ron Johnson
On Sat, 2003-08-16 at 01:42, Jeffrey Melloy wrote: > If you don't mind spending a little money and are on Windows, you can > use Microsoft Visio Professional. The Force is strong in him, but he has strayed to the Dark Side. Very surprising, since he uses a Mac... > On Saturday, August 16, 2003,

Re: [GENERAL] Why the duplicate messages to pgsql-general?

2003-08-16 Thread Shridhar Daithankar
On 15 Aug 2003 at 10:36, Ron Johnson wrote: > In Evolution, I am able to do "Actions->Reply to List" Outlook 97 > doesn't have such a feature, but I'm sure that MozMail, Pine and Mutt > do. On the same topic, quite a few other lists I have sunscribed to rewrite reply to header to list. IMO it's

[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] Why the duplicate messages to pgsql-general?

2003-08-16 Thread The Hermit Hacker
On Sat, 16 Aug 2003, Shridhar Daithankar wrote: > On 15 Aug 2003 at 10:36, Ron Johnson wrote: > > > In Evolution, I am able to do "Actions->Reply to List" Outlook 97 > > doesn't have such a feature, but I'm sure that MozMail, Pine and Mutt > > do. > > On the same topic, quite a few other lists I

Re: [GENERAL] New to list, quick question.

2003-08-16 Thread Tom Lane
Rich Parker <[EMAIL PROTECTED]> writes: >> @results = `print \'\\d\' |/usr/local/pgsql/bin/psql travis`; Think you want "echo" not "print". regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [GENERAL] Copy From with "null" data

2003-08-16 Thread Tom Lane
"James Moe" <[EMAIL PROTECTED]> writes: > this bizarre error message is produced in psql: > ": can't parse "ne 1, pg_atoi: error in "1 That's unrelated to your NULL issue. It looks like you have Windows-style newlines (\r\n) in your data. COPY only likes Unix-style newlines (\n). It thinks the

Re: [osdldbt-general] Re: [GENERAL] getting execution plans with multiple database connections

2003-08-16 Thread Tom Lane
Jenny Zhang <[EMAIL PROTECTED]> writes: > And I still have the same problem. Since PG should fail if no more > files can be opened, my test should fail. But I got all the other > results back at the end of the run. No, you miss my point. Usually PG will *not* fail when it hits ENFILE. The code

Re: [GENERAL] summary and request

2003-08-16 Thread Murthy Kambhampaty
I like the COALESCE() function for the "insert into ..." statement below. See: http://www.postgresql.org/docs/7.3/interactive/functions-conditional.html#AE N9753 Cheers, Murthy -Original Message- From: Jason Godden To: [EMAIL PROTECTED] Sent: 8/15/2003 7:33 PM Subject: Re: [GENERAL] sum

Re: [GENERAL] summary and request

2003-08-16 Thread Jason Godden
Yes! Very true. I always forget about that one... On Sat, 16 Aug 2003 11:43 pm, Murthy Kambhampaty wrote: > I like the COALESCE() function for the "insert into ..." statement below. > See: > http://www.postgresql.org/docs/7.3/interactive/functions-conditional.html#A >E N9753 > > Cheers, > Murt

Re: [GENERAL] Resolved: PostGreSQL - Accessing It

2003-08-16 Thread Bruce Momjian
Karsten Hilbert wrote: > > > test=# CREATE USER mel CREATEDB > > > test-# \q > > > bash-2.05b$ exit > > > exit > > > [EMAIL PROTECTED] mel]$ psql test > > > psql: FATAL 1: user "mel" does not exist > > > > > > >

Re: [GENERAL] Resolved: PostGreSQL - Accessing It

2003-08-16 Thread Jim Rosenberg
--On Saturday, August 16, 2003 11:40 AM -0400 Bruce Momjian <[EMAIL PROTECTED]> wrote: I wonder if we should have a "novice" mode for psql? Are there other things it could control? Change the prompt when output is redirected with \o. I don't know how many times I've redirected output with \o to

[GENERAL] Problems installing DBD::Pg on Tru64 Unix !!!!

2003-08-16 Thread Milton Yutaka Nishiyama Junior
Hello, > I wonder if someone could help me with this DBD::Pg installation problem. I > successfully installed both perl 5.8.0 and DBI-1.32, > but somehow the 'make test' always fails as follow below. Basically the problems > start when it can't load '.DBD-Pg-1.22/blib/arch/auto/DBD/Pg/Pg.so

Re: [GENERAL] Dreamweaver

2003-08-16 Thread Bruce Momjian
Nikola Milutinovic wrote: > > This may have been better posted in the advocacy list but I am not a > > subscriber. > > > > We recently purchased Dreamweaver MX and I was a little surprised to > > find that one of its pre-defined scripting systems is PHP + MySQL. I > > haven't done much exploring of

Re: [GENERAL] Why the duplicate messages to pgsql-general?

2003-08-16 Thread Bruce Momjian
Shridhar Daithankar wrote: > On 15 Aug 2003 at 10:36, Ron Johnson wrote: > > > In Evolution, I am able to do "Actions->Reply to List" Outlook 97 > > doesn't have such a feature, but I'm sure that MozMail, Pine and Mutt > > do. > > On the same topic, quite a few other lists I have sunscribed to r