RE: [ADMIN] how to use boolean types

1999-06-24 Thread Michael J Davis
select * from chargehistory where "new" = 't'; Boolean values are 't' and 'f'. -Original Message- From: Garry Dolley [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 24, 1999 7:01 AM To: [EMAIL PROTECTED] Subject:[ADMIN] how to use boo

RE: [ADMIN] Security and Backup Questions - New Trying

1999-05-14 Thread Michael J Davis
1) try using crypt instead of trust in the pg_hba.conf file. I am not sure of the details nor how this works, but this is worth trying. 2) Mirroring is not available. Your only choice is to run pg_dump, copy if dump file to the remove machine, and recreate the database on the remote ma

[ADMIN] RE: [INTERFACES] recordset not updateable

1999-04-23 Thread Michael J Davis
No, I don't think MsysConf is the problem. -Original Message- From: JT Kirkpatrick [SMTP:[EMAIL PROTECTED]] Sent: Friday, April 23, 1999 3:53 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject:[INTERFACES] recordset not updateab

RE: [ADMIN] recordset not updateable

1999-04-23 Thread Michael J Davis
1) The problem is likely the user name that Access97 is using to communicate with PostgreSQL. Turn on the logging in the PostgreSQL ODBC driver. Look at the PostgreSQL log file in your c:\ directory after opening Access97 and the table in question. Look in the log file and check user name that

RE: [ADMIN] Recovery from the transaction log?

1999-04-22 Thread Michael J Davis
Does this mean that if I performed a pg_dump at 8:00 AM, performed some updates, inserts and deletes at 10:00AM, destroyed and restored my database at 12:00 noon using the 8:00AM pg_dump that all of the insert, updates, and deletes that I did at 10:00 AM would still exist in the newly restored dat