Title: Version Control Software for Database Objects
We maintain multiple versions of our application's database and we are looking for version control software to help us automate this. Specifically, we would like to have a program that automatically tracks all changes to the database (tabl
s
for INSERT, UPDATE, and DELETE), you must name the OID and CTID as
columns in the view. Again, we learned this the hard way. Mark Dexter
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 12:06 PM
To: Mark Dexter
Cc: [EMAIL PROTECTED];
Title: Re: disabling OIDs?
For what it's worth, OIDs are required if you ever want to use updateable cursors with the ODBC driver. We discovered this the hard way. Mark Dexter
Title: Re: [GENERAL] VACUUM and ANALYZE Follow-Up
Tom, I did read through the links you provided. Unfortunately, I don't feel qualified to judge the technical merits of the possible solutions. Since you appear to be well informed on this issue, can I ask you a couple of quick questions?
1.
Hmm... it seems that we're maybe not understanding one another here.
I'm going to try to be more clear. Below are the questions that were
raised and my attemp to answer them clearly.
1. Why run VACUUM on an empty table?
This is a good question, but perhaps there is a valid answer. Our
product
Title: VACUUM and ANALYZE Follow-Up
Several recent postings appear to confirm that there is an issue with the use of VACUUM or ANALYZE on empty tables. Specifically, if you
VACUUM or ANALYZE a table that is empty and then insert a large number of rows into this table, you will experience ve
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wed 11/24/2004 1:26 AM
To: Mark Dexter
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] VACUUM and ANALYZE With Empty Tables
Mark Dexter wrote:
> We use a development environment that works with Postgres via ODBC
Title: VACUUM and ANALYZE With Empty Tables
We use a development environment that works with Postgres via ODBC and uses cursors to insert and update rows in Postgres tables. I'm using Postgres version 7.4.5.
I have a test program that reads 34,000 rows from an external file and inserts them
Thank you. That works for the simple example I had.
However, I have an additional question about this. What if I need to do
a LEFT OUTER JOIN in the Fromlist. For example, this query works but it
requires the orders table to appear twice.
UPDATE orders set requireddate =
(case when c.city in
cond, it would be really nice if there was better documentation of the UPDATE statement in Postgres, including examples of this type.
Thanks.
Mark Dexter
Dexter + Chaney
9700 Lake City Way NE, Seattle, WA 98115-2347
Direct Phone: 206.777.6819 Fax: 206-367-9613
General Phone: 800-875-1400
Email: [EMAIL PROTECTED]
10 matches
Mail list logo
