Re: [GENERAL] Graphical Mapping a Database

2003-08-16 Thread David Fetter
Tim Edwards [EMAIL PROTECTED] wrote: I have been request to create a relational database map that can be place on the wall in my office. Generally I done these in the past by just manually typing the information into Access and then printing a map from there. However the database they want

[GENERAL] [Fwd: Re: [PHP] PHP and COPY]

2003-08-16 Thread DeJuan Jackson
Forwarding my question over to here, got no answer on the pgsql-php list. Hope someone can help. ---BeginMessage--- such as? To answer your question. I have a order system on my local Postgres (for multiple clients 50+), and need to have an offsite independent database to drive orders for a

Re: [GENERAL] Graphical Mapping a Database

2003-08-16 Thread Ron Johnson
On Thu, 2003-08-14 at 23:17, David Fetter wrote: Tim Edwards [EMAIL PROTECTED] wrote: I have been request to create a relational database map that can be place on the wall in my office. Generally I done these in the past by just manually typing the information into Access and then

Re: [GENERAL] Graphical Mapping a Database

2003-08-16 Thread Jeffrey Melloy
If you don't mind spending a little money and are on Windows, you can use Microsoft Visio Professional. On Saturday, August 16, 2003, at 01:38 AM, Ron Johnson wrote: On Thu, 2003-08-14 at 23:17, David Fetter wrote: Tim Edwards [EMAIL PROTECTED] wrote: I have been request to create a

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

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):

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 have

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, please

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 \r is a

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 is

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]

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, Murthy

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 I just figured out my

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] 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 rewrite reply