[GENERAL] Looking for dependent object DROP and CREATE scripts

don't show up either. Does pg_depend not have records for dependent views? If not, how is it done? --- justin tocci Fort Wayne, IN

[GENERAL] INSERT RULE QUERY ORDER

When my RULE takes the form of: CREATE RULE name AS ON INSERT TO tableDO INSTEAD ( UPDATE query ;INSERT query); The INSERT query doesn't fire and there is no error. Putting the INSERT first allows them to both fire. Can anyone tell me why? I think it has something to do with *NEW* and

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

presently (lack of time). Finally got Bricolage installed on a system here at work to play around with. Reckon Josh'll be interested in that... :-) Regards and best wishes, Justin Clift Item #87 on Josh's ToDo list ... ---(end of broadcast

Re: [GENERAL] Performance question (stripped down the problem)

to get far better results by doing performance tuning of PostgreSQL and/or the server. What do you think? Regards and best wishes, Justin Clift Tille, Andreas wrote: On Thu, 20 Sep 2001, Herbert Liechti wrote: I tried it. See my actions below. The main performance boost is reached

Re: [GENERAL] Performance question (stripped down the problem)

is available at : http://techdocs.postgresql.org/techdocs/perftuningfigures.php Hope this is of assistance Andreas. Regards and best wishes, Justin Clift Tille, Andreas wrote: On Thu, 20 Sep 2001, Justin Clift wrote: Sorry, I haven't seen the history of this thread. One question which

Re: [GENERAL] Problem with database: FATAL 1: cannot find attribute 24

Hi Tauren, Have you found the solution for this yet? It really sounds like part of your customer's database has been deleted or gone missing. Which version of PostgreSQL are you using, and which operating system is it on? :-) Regards and best wishes, Justin Clift Tauren Mills wrote

Re: [GENERAL]

of those it might be ok. When you've figured out your compiler problem, you can follow the Solaris specific installation instructions for PostgreSQL at : http://techdocs.postgresql.org/installguides.php#solaris :-) Regards and best wishes, Justin Clift haifa touati wrote: Hi, I'm

[GENERAL] PostgreSQL jobs page updated (included Red Hat's search for Database Engineers)

and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast

Re: [GENERAL] Does Postgresql 7.1.x Still Have 8K Maximum Field Size?

this for production projects until it's finalised). You can download the latest RPM's of PostgreSQL for RedHat 7.1 from the PostgreSQL ftp sites (www.postgresql.org lists the mirrors). A direct URL is : ftp://postgresql.wavefire.com/pub/binary/v7.1.3/RPMS/redhat-7.1/ Regards and best wishes, Justin Clift

Re: [GENERAL] Ridicolus Postgresql review

Thanks Bruce, I'll check the Archives for more info about it then. Prob should have done that before asking. :-) Regards and best wishes, Justin Clift Bruce Momjian wrote: Hey guys, Does anyone know anything about this SQL*Net compatible thing which we are supposed

Re: [GENERAL] Idea: jobs.postgresql.org

we're doing this for the benefit of the PostgreSQL Community, they're cool with it. :-) Regards and best wishes, Justin Clift Vince Vielhaber wrote: On Sun, 9 Sep 2001, Justin Clift wrote: I definitely believe we should allow agencies to list their jobs at no charge. Just because

Re: [GENERAL] MacOS X Build Fails with 7.1.3

Hi, You could try either of : http://techdocs.postgresql.org/installguides.php#macosx or http://techdocs.postgresql.org/oresources.php#macosx :-) Regards and best wishes, Justin Clift Hunter Hillegas wrote: My postgres build on MacOS X is failing: cc -traditional-cpp -g -O2 -Wall

Re: [GENERAL] Idea: jobs.postgresql.org

Vince Vielhaber wrote: On Sat, 8 Sep 2001, Justin Clift wrote: Hi Guys, It is definitely something interesting, and there are a fair few PostgreSQL jobs out there. The address Joe mentioned is correct, I'm just so short of time now I haven't been able to do much in the way

Re: [GENERAL] Idea: jobs.postgresql.org

, and thereby benefits our community. :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi

Re: [GENERAL] RFC: PostgreSQL and MySQL comparison.

which will incite PostgreSQL-vs-MySQL warfare and not try and get people to choost the appropriate product(s). :) Regards and best wishes, Justin Clift Digital Wokan wrote: Knock yourself out. I got jumped by a MySQL user on AZPHP for asking another person why they had their Linux/PHP

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

or another. If anyone else can see things blatantly wrong on that page, email me about them and I'll ask Monty (the MySQL guy) to please change/remove/fix them. :-) Regards and best wishes, Justin Clift Sean Chittenden wrote: Has anyone seen this page on Mysql.org comparing PostgreSQL to MySQL

Re: [GENERAL] problems on solaris 7

Hi Peter, There's a Solaris specific installation guide for PostgreSQL at : http://techdocs.postgresql.org/installguides.php#solaris Have you taken a look at it yet? Regards and best wishes, Justin Clift Peter Lauko wrote: Hi! I've installed 7.1.2 on sparc solaris 7. configure, make

Re: [GENERAL] During dump: function not found

constructs from a target database by itself. You might just want to run that instead of doing it yourself/ :-) Regards and best wishes, Justin Clift Andrew Gould wrote: During a pg_dump, I got the following messages: Notice: function pgadmin_get_rows is not dumped. Reason: return type

Re: [GENERAL] Real newbie question.

) VALUES ('blah blah blah'); :-) Hope that's helpful, did it from memory, so the exact output may look slightly different. Regards and best wishes, Justin Clift William D. Tallman wrote: Just started fiddling with PostgreSQL, and know nothing of databases. I have the documentation

Re: [GENERAL] Is it possible to work with big databases (up to 10Gb) under Postgres?

Hi Ivan, I was running a database with ~27GB of info (admittedly in large, very simple tables) on PostgreSQL 7.0.3 a while ago for a few months. Didn't have any real problems with it, apart from having to accept that a lot of data takes time to process. :-/ Regards and best wishes, Justin

Re: [GENERAL] time interval question

Hi, You could do something along the lines of : SELECT foo, bar FROM baz WHERE date_part('hour', foo) 0 AND date_part('hour', foo) 8; Simple, but effective. Only works for whole hours like in your example though. :-) Regards and best wishes, Justin Clift Cefull Lo wrote: given

Re: [GENERAL] Serial not so unique?

)); That would explain the wrapping around behaviour, but not when the field is a SERIAL type. :( + Justin Clift Stephen Robert Norris wrote: On Sat, Aug 18, 2001 at 03:49:10PM -0700, Joe Conway wrote: Sometimes (about 20%, it seems) with several of the data sets, we get an error trying

[GENERAL] PostgreSQL buffer exploits

PostgreSQL in this regard yet. Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi

[GENERAL] PostgreSQL Article on tucows

Hi all, Branden has written an Introduction to PostgreSQL article for the Tucows network (another high profile group of sites): http://news.tucows.com/ http://news.tucows.com/linux/40605.html :-) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds

Re: [GENERAL] An unfair comparision....

can be found at the PostgreSQL Commercial Support page : http://www.ca.postgresql.org/users-lounge/commercial-support.html Hope this is helpful. Regards and best wishes, Justin Clift Tony Hoyt wrote: I'm curious how PostgreSQL compares to Oracle in terms of stability and speed. My company

[GENERAL] [Fwd: MySQL Benchmark page - Problem with vacuum() in PostgreSQL]

. If someone can take a look at the description of the problem which Monty is having (he's the lead MySQL developer) we'll be able to have accurate benchmark for PostgreSQL on their benchmark page. So, anyone want to lend a hand? :-) Regards and best wishes, Justin Clift Original

Re: [GENERAL] Hardware Recommendations

(and effective) with SCSI. :) Regards and best wishes, Justin Clift Steve Wolfe wrote: I respectfully disagree with Steve's disk speed isn't terribly important -- it can be (and is totally dependent on what you're doing) and since you have the on-board U160 with all the dual Athlon

Re: [GENERAL] psql on red hat 7.1

Hi again, You're probably best to look through the mailing list archives for the best ways people have found for doing this. There have been a few people with similar problems over time. :-) If you don't find anything there, feel free to ask again. :-) Regards and best wishes, Justin Clift

Re: [GENERAL] simple linking question

? :-) Regards and best wishes, Justin Clift Jeremy Hansen wrote: I'm trying to do some more advanced things in sql to make my tables more efficient. I'd like to do a link, or perhaps it's a join, although everything I've looked at relating to a join makes me think that it's not what I'm looking

Re: [GENERAL] replication?

and best wishes, Justin Clift Fran Fabrizio wrote: Does postgres support replication? I think this is the feature I need. I have a table in one db that I need to use from another db on another machine. The first db is behind two firewalls (for a good reason =) and the second needs to be hung out

Re: [GENERAL] Program to convert from PostgreSQL to Access or view table relationships

files from what I remember. :-) Regards and best wishes, Justin Clift Steve Werby wrote: I am looking for a program to convert a PostgreSQL database to Access. I'm not migrating to Access, I simply want an easy way to load the schema into Access so I can get a graphical view of the table

Re: [GENERAL] Migration

/PostgreSQL_ODBC_Configuration.html Hope these prove to be useful. :-) Regards and best wishes, Justin Clift Todd LaClair wrote: I will be migrating a Tango app on Windows with a SQL Server backend over to Linux, Apache, and Postgresql. What do I need to be on the lookout for in regards to the odbc

Re: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?

Hi Adam, There are a few links to benchmark-type things you might find useful at : http://techdocs.postgresql.org/oresources.php#benchmark Hope they're useful. :-) Regards and best wishes, Justin Clift Adam Manock wrote: This is almost certainly a lousy idea. You do *not* want to chew

[GENERAL] QUERY - Including the new LDP PostgreSQL HOWTO in the main PostgreSQL distribution

relationship between the new PostgreSQL HOW-TO and the present version. It also means that no one person has total control of it, and it can be contributed to by anyone that has a suggestion and/or can generate a diff. So, what do people think? :-) Regards and best wishes, Justin Clift

Re: [GENERAL] PostgreSQL perl / libpq.so.2 problem - again :(

the appropriate image to a hard drive with Ghost. Works well for me. What do you guys think, good approach? :-) Regards and best wishes, Justin Clift Lamar Owen wrote: On Friday 06 July 2001 09:04, [EMAIL PROTECTED] wrote: This might sound like a flame, but it isn't meant to be. Uninstall

[GENERAL] CLISP ?

Hi all, Does anyone know what the heck CLISP is, and/or if there's a driver for using PostgreSQL with it? :-) I'll add it to the techdocs.postgresql.org website if there is too. :-) Regards and best wishes, Justin Clift Gunjan Varshney wrote: Dear, We are working on a project

Re: [GENERAL] Install with Apache/PHP (Was Stubborn Multibyte)

Hi Karen, It wouldn't hurt to update to at least PHP 4.0.5, as it fixes a bunch of bugs, and also knows about the changes in the PostgreSQL naming of include files, etc. :-) Apache 1.3.20 is also available last I checked too. :-) Regards and best wishes, Justin Clift Karen Ellrick wrote

Re: [GENERAL] Re: What's the best front end/client under MS Windows?

have access to the NOTICES which PostgreSQL generates, regardless of how I'm hitting it. Would this be useful to you? :-) Regards and best wishes, Justin Clift Gregory Wood wrote: I'm partial to the ZEOS Database Explorer myself. I don't have experience with a multitude of tools, so

Re: [GENERAL] Re: Database Recovery Help...

installed from a package (rpm, deb, etc). It's something to look into. :-) Regards and best wishes, Justin Clift John Clark L. Naldoza wrote: Hi, Chris Smith wrote: Hi, Did you try what it suggests? If you're sure PostgreSQL isn't already running, remove the /tmp/.s.PGSQL.5432

Re: [GENERAL] DB Getting Slower and Slower and Slower....

Hi Guys, I don't know if this has any bearing, but I remember someone recently saying that Sun's JDK 1.3 has a memory leak bug in one of it's releases, and our JDBC driver is affected by that. Not sure of it's present status though. Regards and best wishes, Justin Clift Doug McNaught wrote

[GENERAL] Daylight savings

. At present I'm considering running a mismash of zdump, perl, psql, etc, and I'm kind of hoping there's already something out there. Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 2: you can get off all lists at once

[GENERAL] When DST occurs

, Justin Clift ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Serial Type

() See http://odbc.postgresql.org/docs/index.php?sql-createsequence.html for more info. Regards and best wishes, Justin Clift Christian Marschalek wrote: The serial data type automaticaly takes the next higher value, but what if there's a drop and I want to assing 3 even if there are 20 records

Re: [GENERAL] JDBC speed question.

). Regards and best wishes, Justin Clift Clayton Vernon wrote: Thanks, but can I specify each port? I've only seen the one documented command option -p which I assume was for the TCP/IP port. Again, thanks for the help, Clayton - Original Message - From: Doug McNaught [EMAIL

[GENERAL] Report Writer for PostgreSQL

Hi guys, Does anyone have experience with report writers? It's not something I know much about yet. Regards and best wishes, Justin Clift Original Message Subject: Re: [ANNOUNCE] New PostgreSQL Review at epinions.com Date: Thu, 26 Apr 2001 21:19:08 -0400 (EDT) From: Patrick

Re: [GENERAL] replicating a postgres database

Hi Cheryl, Do you want a one-off copy (a duplicate), or replication which continuously keeps the databases synchronised? Regards and best wishes, Justin Clift Cheryl Ayres wrote: is there a way to replicate an existing Postgres database. We want to duplicate it with a new name and login

[GENERAL] HOWTO document

Hi all, Has anyone stepped up to review and re-work the present English HOWTO document, the one that has been removed due to the misinformation and inaccuracies in it? If not, I'm going to start on it, with a view to have it ready in the next month or two. Regards and best wishes, Justin

[GENERAL] Re: Success: PostgreSQL 7.1 on MacOS X (Darwin 1.3)

, and updating those notes, that will be a really great contribution. Thanks heaps for your time and effort Dieter. Regards and best wishes, Justin Clift [EMAIL PROTECTED] wrote: Dear, i have sucessfully configure, compile, check (make check), install, create database and dbuser without any

[GENERAL] New look for the techdocs website...

, Justin Clift P.S. - As a bonus, I've even figured out how to access my [EMAIL PROTECTED] email, so I can start using this again! :-) -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first

Re: [GENERAL] Re: ongoing holy grail thread - VICTORY!!!

would get a mention that PostgreSQL works with it in their monthly newsletter? Probably be quite a few people interested in hearing that. Regards and best wishes, Justin Clift Cheers Tony Grant -- RedHat Linux on Sony Vaio C1XD/S http://www.animaproductions.com/linux2.html ---

[GENERAL] Shared memory failure?

the troubleshooting guide, but it wasn't very helpful. Anyone know how to get around this? Thanks again. Sincerely, Justin Stayton CometFly Media, LLC. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

RE: [GENERAL] Shared memory failure?

Cobalt RaQ4i with version 6 of their operating system. Sincerely, Justin Stayton CometFly Media, LLC. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Wolfe Sent: Friday, April 13, 2001 1:13 PM To: [EMAIL PROTECTED] Subject: Re

RE: [GENERAL] Shared memory failure?

, Justin Stayton CometFly Media, LLC. [EMAIL PROTECTED] -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 2:59 PM To: [EMAIL PROTECTED] Cc: Steve Wolfe; [EMAIL PROTECTED] Subject: Re: [GENERAL] Shared memory failure? "Justin S." [EMAIL

[GENERAL] Address already in use?

: Address already in use Is another postmaster already running on that port? If not, remove socket node (/tmp/.s.PGSQL.5432) and retry. Anyone know how to fix this? Thanks. Sincerely, Justin Stayton CometFly Media, LLC. [EMAIL PROTECTED] ---(end of broadcast

[GENERAL] Non-english articles on the techdocs.postgresql.org website

there any people who can understand both english and non-english languages, who wouldn't mind translating an article or two on the techdocs.postgresql.org website to a different language? Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of p

Re: [GENERAL] linux/bsd

Hi Marc, No argument there. Solaris 8 is a LOT better then previous versions in regards to driver support, but still a long way behind *BSD, linux, Windows, etc. BUT, if you've got hardware it DOES work on... it's really nice. Regards and best wishes, Justin Clift The Hermit Hacker wrote

Re: [DOCS] Re: [GENERAL] Better Features document?

be really insightful work... :-) Regards and best wishes, Justin Clift Peter Eisentraut wrote: snip If you can make it a little less than 5 pages (like 2), we can put it into the preface of the documentation. I'd imagine it stuck somewhere near the following URL: snip -- "My grandfather

Re: [GENERAL] Postgres 7.1RC1 on Solaris 7

Hi, It doesn't seem to have been mentioned that the preferable way to compile PostgreSQL on Solaris is to unset your LD_LIBRARY_PATH and set an LD_RUN_PATH instead. That is right isn't it? Regards and best wishes, Justin Clift Ahmed Moustafa wrote: Hi Tom, I did the test by hand

[GENERAL] PostgreSQL non-FAQ documentation

/projects/pgdocs :-) Regards and best wishes, Justin Clift Database Administrator

[GENERAL] Re: Sizing of LARGE databases.

7. Regards and best wishes, Justin Clift Database Administrator Michael Miyabara-McCaskey wrote: Hello there, I have a DB that I am attempting to buy "the right hardware" for. This DB today is about 25GB total, with typical tables in the area of 3GB in size, and up to about

[GENERAL] Advice needed please

Hi all, As I not familiar with the linux newsgroups and mailing lists, can anyone give me some guidance as to where I should post details of a java development job? It's a Java GUI application which interfaces to a PostgreSQL database backend through JDBC. Regards and best wishes, Justin

Re: [GENERAL] Memory Leak

time (end); printf ("Inner Loop %d, started: %s: Elapsed time: %d\n", k, ctime (begin), (int) (end-start)); } PQfinish (conn); return 0; } Justin Foster wrote: I am using Postgres 7.0.2 :) Sorry about that. I promise to put done my crack pipe before I

[GENERAL] Memory Leak

maybe occurring? Thanks, -justin

Re: [GENERAL] How to remove a user ?

You can use the command DROP USER username; at the interactive sql prompt. Justin From: "Fred" [EMAIL PROTECTED] Reply-To: "Fred" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [GENERAL] How to remove a user ? Date: Tue, 11 Jul 2000 21:09:53 GMT Hi, How to remove

[GENERAL] Using the JDBC Driver in version 7.02

Hello. I am using Postgres 7.02 on my redhat linux box. I have installed the JDK and a JSP engine. I have also copied the JDBC level 4 Drivers that came with postgresql 7.02 onto my hard drive. When I try to interface with it in java, even after loading the driver with the line:

[GENERAL] Speed

. ___ Justin Long CIO / Site Editor 616 Station Square Ct Network for Strategic Missions Chesapeake, VA 23320 977 Centerville Trnpk CSB 317 [EMAIL PROTECTED] Va Beach, VA 23463 Check out our site

<    1   2   3   4