by a vendor or organization.
Thanks in advance. I've been a happy PostgreSQL user for two or three years now.
--
Mike Orr sluggos...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
also from management point view
http://www.databasesecurity.com/dbsec/database-stig-v7r1.pdf
Regards
From: Mike Orr sluggos...@gmail.com
To: pgsql-general@postgresql.org
Sent: Thursday, August 30, 2012 9:18 PM
Subject: [GENERAL] Baseline configurations
Does
in one query.
On Wed, Sep 7, 2011 at 1:39 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote:
Mike Orr wrote:
I have a complex query question whose answer I think would help me to
understand subselects and aggregates better. I have a table with four
columns of interest:
id (int primary key
just need some
sample records to test my program against.
Is this something I should be able to do with a single query with a
subselect, or is it too much for one query? I tried a few ways and
none of them were syntactically valid.
--
Mike Orr sluggos...@gmail.com
--
Sent via pgsql-general
On Fri, Apr 1, 2011 at 2:39 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Mar 30, 2011 at 3:56 PM, Mike Orr sluggos...@gmail.com wrote:
I'm converting a MySQL webapp to PostgreSQL. I have a backup server
which is refreshed twice daily with mysqldump/mysql and has a
continuously-running
want. I added the other group by fields because psql refused to run
the query otherwise.
--
Mike Orr sluggos...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
...@postgresql.org] On Behalf Of Mike Orr
Sent: Thursday, March 31, 2011 2:49 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Counting records in a child table
I know how to do count(*)/group by on a single table, but how do I get a
count of related records in a child table? Some of the counts
do have 1:many relationships. How would I
restore all of them at once? List them all as '-t' args to the same
pg_restore command?
--
Mike Orr sluggos...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Wed, Mar 30, 2011 at 2:36 PM, John R Pierce pie...@hogranch.com wrote:
On 03/30/11 1:56 PM, Mike Orr wrote:
MySQL simply locks the tables, drops/recreates them, loads the data,
and unlocks the tables. Other connections have to wait but they don't
have to be closed/reopened. The PostgreSQL