=16726.014..16726.286 rows=1618 loops=1)
Sort Key: activity_group, display_order, week_code
Regards,
Greg Patnude - Manager, Dynamic Applications Group
Data Mosaics, Inc.
2406 South Dishman-Mica Road / Suite # 6
Spokane Valley, WA 99206-6429
VOICE: (866) 904-DMSF
FAX: (509) 928-4236
?
{[id:1, type_desc:System],[id:2, type_desc:Company],[id:3,
type_desc:Administrator],[id:4, type_desc:Employee],[id:5,
type_desc:User (standalone)],[id:6, type_desc:Guest / Demo]}
(1 row)
TIA
Regards,
Greg
and there are approximately
2 million rows in the inherited table structure...
Any ideas ? Suggestions ?
Regards,
Greg Patnude - Manager, Dynamic Applications Group
Data Mosaics, Inc.
2406 South Dishman-Mica Road / Suite # 6
Spokane Valley, WA 99206-6429
VOICE: (866) 904-DMSF
FAX: (509
LOG: checkpoints are occurring too frequently (19 seconds apart)
HINT: Consider increasing the configuration parameter
checkpoint_segments.
LOG: checkpoints are occurring too frequently (12 seconds apart)
HINT: Consider increasing the configuration parameter
checkpoint_segments.
LOG:
Scott Marlowe [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
LOG: checkpoints are occurring too frequently (19 seconds apart)
HINT: Consider increasing the configuration parameter
checkpoint_segments.
LOG: checkpoints
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 11:40 AM
To: Greg Patnude
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Checkpoints are occurring too frequently...
On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
Scott Marlowe
;
Regards,
Greg Patnude - Manager, Dynamic Applications Group
Data Mosaics, Inc.
2406 South Dishman-Mica Road / Suite # 6
Spokane Valley, WA 99206-6429
VOICE: (866) 904-DMSF
FAX: (509) 928-4236
Michael Fuhr [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, Jul 12
Here is the definition of a view I use to retrieve all of the tables and a
list of columns for tables that appear in the public schema ... I have
others that only retrieve a list of the table names and the views in the
public schema as well...
-- View: vcat_pgcolumns
-- DROP VIEW
The point of a data base is storing ASCII or
unicode not encypting the data... encrypting the data IN the database is a bad
idea what happens if you ever lose the key ??? you lose ALL your data...
Additionally -- encryption keys are usually machine-dependent so you lose the
ability to
After an application updates, deletes, or inserts rows, it can call
SQLRowCount to determine how many rows were affected. SQLRowCount returns
this value whether or not the rows were updated, deleted, or inserted by
executing an UPDATE, DELETE, or INSERT statement, by executing a positioned
Get a better computer to run it on in teh long-term -- that will be your
best investment
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On a 128MB RAM, 450 MHz pentium 3 server with linux gentoo and postgresql
7.4.6 on an office lan we can manage satisfactorily a db
Envbop [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi
I've just inherited a PostgreSQL database, for which I do not have any
details of, like database name or the users.
This used to be a library database which was managed via a web page
written
in php.
Its running on a
That particular error message is typically associated with a missing
pg_hba.conf entry that tells the postgreSQL server which remote machines to
allow connections FROM
# If you want to allow non-local connections, you need to add more
# host records. Also, remember TCP/IP connections are
I use a modified form of option 3 with an ON UPDATE RULE the update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KEY,
lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id),
dm_user_address INTEGER NOT NULL DEFAULT
-Original Message-
From: Berend Tober [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 8:47 AM
To: Greg Patnude
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] preserving data after updates
I use a modified form of option 3 with an ON UPDATE RULE the update
rule
I use a modified form of option 3 with an ON UPDATE RULE the update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KEY,
lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id),
dm_user_address INTEGER NOT NULL DEFAULT 0,
You might have better success with the form of HAVING and appropriate use of
OR IS NULL as opposed to strict JOIN and WHERE conditions...
Similar to...
SELECT A.a, B.b, C.c FROM A, B, C
HAVING (A.b = B.b OR B.b IS NULL)
GROUP BY A.b;
--
Greg Patnude / The Digital Demention
2916 East Upper
this type of table def will automatically create the sequence for
you -- and always ge thte next value when you do an insert -- ensuring that
you dont have duplicate...
so you would:
INSERT INTO test ('log', 'message');
then
SELECT * FROM test;
would give you
id, log and message.
--
Greg
a high-powered version of MS Access or mySQL -- there
are quite a few differences --
Not to be rude -- but the postgreSQL docs (the Preface, Tutorial, and SQL
Language sections) would be good for you to read...
--
Greg Patnude / The Digital Demention
2916 East Upper Hayden Lake Road
Hayden
19 matches
Mail list logo