Re: [GENERAL] Does this table exist?

2000-11-02 Thread Ashley Clark
Well, I'll answer your questions and help you a little too, or at least try... * Alvaro Herrera in "[GENERAL] Does this table exist?" dated 2000/11/02 * 17:44 wrote: > Now, I'm building a database to hold customer data that needs to be > organized in a one-table-per-customer manner. No, I don't

[GENERAL] Can this be done?

2000-11-14 Thread Ashley Clark
n rgt + (droprgt - droplft + 1) when (rgt > droprgt) and (rgt < newpos) then rgt - (droprgt - droplft + 1) else rgt end; end; ' language 'plpgsql'; -- ashley clark PGP signature

Re: [GENERAL] Can this be done?

2000-11-14 Thread Ashley Clark
* Tom Lane in "Re: [GENERAL] Can this be done?" dated 2000/11/15 00:42 * wrote: > Ashley Clark <[EMAIL PROTECTED]> writes: > > Can I defer constraint checking on unique indexes? > > No, not at present. Consider restructuring your UPDATE into > sequential ste

Re: [GENERAL] newbie debugging pl/pgsql : better way?

2000-10-24 Thread Ashley Clark
* Frank Miles in "[GENERAL] newbie debugging pl/pgsql : better way?" * dated 2000/10/24 11:56 wrote: > I have a simple function that isn't working. I've enabled debugging, > but the error message is still mystifying. My function is as > follows: > > > CREATE FUNCTION proj_name

[GENERAL] deletion of records before commit doesn't work

2000-12-11 Thread Ashley Clark
I've come up with this example and I want to know why it does what it does. -- snip -- You are now connected to database template1. CREATE DATABASE You are now connected to database testing. psql:test2.sql:11: NOTICE: CREATE TABLE/UNIQUE will create implicit index 'subdivs_name_key' for table 's

[GENERAL] Re: SQL Where Like - Range it?!

2001-04-28 Thread Ashley Clark
ame from builders where name like 'A%' or name like 'B%'; NOTICE: QUERY PLAN: Index Scan using builders_name_key, builders_name_key on builders (cost=0.00..10.25 rows=16 width=12) EXPLAIN Does the similarity of these numbers to the first ones above have any significance or is it just c

[GENERAL] VACUUM is hanging

2001-05-04 Thread Ashley Clark
Maybe someone will know what's going on here. I'm running 7.1 and vacuuming the db regularly at 4am each day. But these last few days as it vacuums it hangs reaping dead processes. 2001-05-04 04:00:09 [27285] DEBUG: --Relation personnel-- 2001-05-04 04:00:09 [27285] DEBUG: Pages 0: Changed 0

[GENERAL] Re: VACUUM is hanging

2001-05-04 Thread Ashley Clark
* Tom Lane in "Re: VACUUM is hanging" dated 2001/05/04 22:05 wrote: > > I also seem to have found the culprit. I have Apache::DBI set up > > and it's holding something open. Restarting Apache let the vacuum > > finish normally. > > Try not to leave open transactions hanging around in your Apache

[GENERAL] Strange notices, should I worry?

2001-05-05 Thread Ashley Clark
Occasionally and without warning I get this from my daily vacuum cronjob: NOTICE: RegisterSharedInvalid: SI buffer overflow NOTICE: InvalidateSharedInvalid: cache state reset I don't understand what these mean. Should I be concerned about them and what do they signify? -- creaky halls PGP