Re: [GENERAL] Possible bug in postgresql-7.1.3-1PGDG

2001-10-19 Thread Rich Shepard
I'll keep current after that. Should I move configuration files (such as pg_hba.conf) to a safe area, then manually delete all references to postgres that locate and find reveal, before starting from scratch? Right now I'm looking to get a working installation of 7.1.3 so I can star

Re: [GENERAL] Possible bug in postgresql-7.1.3-1PGDG

2001-10-19 Thread Rich Shepard
onf, what files do I save? Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) 2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A. + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | [EMAIL PROTECTED] http:/

Re: [GENERAL] Possible bug in postgresql-7.1.3-1PGDG

2001-10-19 Thread Rich Shepard
details on > what config stuff is there and in what files. Excellent reminder! I forgot about that. Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) 2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A. + 1 503-667-4

Re: [GENERAL] A tool for making console/text data enrty/display

2001-10-10 Thread Rich Shepard
On Wed, 10 Oct 2001, David. E. Goble wrote: > I am lazy. I which to write some c console/text programs to interface > with postgresql. Are there any tools/utilities, to help make the data > entry/display screens...? David, ncurses-5.2. Rich Dr. Richard B. Shepard,

Re: [GENERAL] Foreign keys

2003-06-26 Thread Rich Shepard
is with the name record. If a customer, supplier or whatever had multiple addresses, then I'd put _all_ addresses in a single table and reference each one to the name record in the appropriate table. What have I missed here? Rich Dr. Richard B. Shepard, President

[GENERAL] New to list, quick question.

2003-08-15 Thread Rich Parker
Thanks for any info you can provide me. -- Rich Parker http://www.fssi-ca.com mailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] RHEL

2003-11-11 Thread Rich Shepard
ch time and it has always worked for me, faster and with less hassle than trying to upgrade via the packages. That said, I also use checkinstall (rather than 'make install') and build the package (your choice of Slackware, Red Hat or Debian) from the source tarball. Consider trying

[GENERAL] Stored FUnctions

2003-12-05 Thread Rich Hall
Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but NOT the 300-odd functions I've created. Rick -- ---(end of broadcast)--- TIP 3: if posting/r

Re: [GENERAL] Stored FUnctions

2003-12-05 Thread Rich Hall
database so I could query them. Rick Martijn van Oosterhout wrote: On Fri, Dec 05, 2003 at 02:22:26PM -0500, Rich Hall wrote: Can somebody tell me how Stored Functions are kept in the database? I've gone through the catalog several times. I've found many interesting things but N

Re: [GENERAL] Stored FUnctions

2003-12-08 Thread Rich Hall
_catalog.pg_user u ON u.usesysid = p.proowner WHERE p.prorettype <> 'pg_catalog.cstring'::pg_catalog.regtype AND p.proargtypes[0] <> 'pg_catalog.cstring'::pg_catalog.regtype AND NOT p.proisagg AND pg_catalog.pg_function_is_visible(p.oid) ORDER BY 2, 3,

[GENERAL] Strange problem upgrading to 7.0.3x

2000-11-14 Thread Rich Shepard
the --force switch with rpm. Something's screwy here. Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) Making environmentally-responsible mining happen. (SM)

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-15 Thread Rich Shepard
w me is that this is a Red Hat installation, and the compiler does some from a package. As I wrote, this is quite strange. But, ... I'll just go install it now. Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosys

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-17 Thread Rich Shepard
herwise make sure that the program was installed successfully. Thanks, everyone. Getting closer here to a working postgres-7.0.3! Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) Makin

Re: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-17 Thread Rich Shepard
g into app development now. Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) Making environmentally-responsible mining happen. (SM) 2404 SW 22nd Street | Tro

RE: [GENERAL] Strange problem upgrading to 7.0.3x

2000-11-17 Thread Rich Shepard
running so it wouldn't start another instance. Many thanks, all! Now I'll get back to using the tool. Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) Making

[GENERAL] Missing pg_hba.conf

2000-11-17 Thread Rich Shepard
g_hba.conf by hand. What's the procedure, please? Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) Making environmentally-responsible mining happen. (SM)

[GENERAL] Alternate data locations

2001-03-27 Thread Rich Shepard
t I'd like to do is store attribute data in each project directory, along with the spatial object files. I do want postgres to find the proper data files, so I'll need to specify the proper path. But, the question is whether or not postgres will now respond properly. TIA, Rich Dr. Ric

Re: [GENERAL] tables, where

2001-03-29 Thread Rich Shepard
the process of registering PGDATA2 with postgres (supposedly), but I could not use this directory. Could I now do this and have it work? Thanks, Rich Dr. Richard B. Shepard, President Applied Ecosystem Services, Inc. (TM) 2404 SW 22nd Street | Troutdale, OR 970

[GENERAL] Problem importing auto-increment fields in MS Access to Postgresql

2001-04-26 Thread Rich Handler
ages on screen : none. the commlog file : see attached file (psqlodbc.log) Suggestions, workarounds and prayers would be appreciated ! love rich handler The following section of this message contains a file attachment prepared for transmission using the Internet MIME message format. If you are usin

[GENERAL] Problem importing auto-increment fields in MS Access to PostgreSQL

2001-04-26 Thread Rich Handler
Suggestions, workarounds and prayers would be appreciated ! love rich handler --- End of forwarded message --- Rich Handler OgilvyInteractive 18 Roeland St, Gardens, 8001, Cape Town Fon 021 467 1402 Fax 021 467 1401 http://www.oi.co.za/ The following section of this message c

<    3   4   5   6   7   8