ata.
The tables to be updated 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Wed, Mar 30, 2011 at 2:36 PM, John R Pierce 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
want. I added the other group by fields because psql refused to run
the query otherwise.
--
Mike Orr
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@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 o
On Fri, Apr 1, 2011 at 2:39 PM, Merlin Moncure wrote:
> On Wed, Mar 30, 2011 at 3:56 PM, Mike Orr 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 cop
se. I 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
--
Sent via pgsql-general mailing list (
when I ask on
the list, to see what's the simplest way to do it all in one query.
On Wed, Sep 7, 2011 at 1:39 AM, Albe Laurenz wrote:
> Mike Orr wrote:
>> I have a complex query question whose answer I think would help me to
>> understand subselects and aggregates bett
fficial PostgreSQL
document or supported by a vendor or organization.
Thanks in advance. I've been a happy PostgreSQL user for two or three years now.
--
Mike Orr
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ring the
> data, because it handles the issue also from management point view
>
> http://www.databasesecurity.com/dbsec/database-stig-v7r1.pdf
>
>
> Regards
>
>
> From: Mike Orr
> To: pgsql-general@postgresql.org
> Sent: Thursday,
