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
upda
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 mi
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 vcat_pgc
nt * F1 WHERE
l_store_hours.id = C.id;
END LOOP;
END LOOP;
-- CLEAN UP AFTER YOURSELF...
RAISE LOG 'LOOP COMPLETE! Dropping TEMPORARY TABLE tmphours...';
DROP TABLE tmphours;
-- AND RETURN...
RETURN TRUE;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Regards,
Gr
-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
"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
&
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: che
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
desc:Employee]","[id:5,
type_desc:User (standalone)]","[id:6, type_desc:Guest / Demo]"}
(1 row)
TIA
Regards,
Greg Patnude - Manager, Dynamic Applications Group
Data Mosaics, Inc.
2406 South Dishman-Mica Road / Suite # 6
Spokane Valley, WA 99206-6429
VO
64.83 rows=1000 width=211) (actual
time=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
VO
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,
-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
r
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,
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
"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 runni
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 c
client like MS Access
postgreSQL is NOT just 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
TH OIDS;
Using 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 gi
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
19 matches
Mail list logo
