[ADMIN] Is there any eqvivalent or alternative to UPDATE(column) or COLUMNS_UPDATED() of SQLServer2000

2002-12-26 Thread shreedhar
Is there any eqvivalent or alternative to the following IF UPDATE(column) or IF(COLUMNS_UPDATED()) of SQLServer2000. IF UPDATE (column) Tests for an INSERT or UPDATE action to a specified column and is not used with DELETE operations. More than one column can be specified. Because the table name

[ADMIN] pgdb.py is still wrong in Postgres 7.3.1 rpm

2002-12-26 Thread Gaetano Mendola
I already post the fact that the file pgdb.py distribuited with Postgres 7.3 is wrong but was not already fixed in 7.3.1 The class pgdbTypeCache is not working with the version 7.3.1 the method getdescr try to do the following select: "SELECT typname, typprtlen, typlen FROM pg_type" and th

[ADMIN] Incremental backups?

2002-12-26 Thread Campano, Troy
Is there a way to do incremental backups or backups of the changes in PostgreSQL? It seems that if I do complete database backups with pg_dump that I'll be getting a lot of redundancy. What are your thoughts? thank you! ~ Troy Campano ~ ---(end of broadcast)---

Re: [ADMIN] [BUGS] pgdb.py is still wrong [not just] in Postgres 7.3.1 rpm

2002-12-26 Thread Lamar Owen
On Thursday 26 December 2002 07:15, Gaetano Mendola wrote: > I already post the fact that the file pgdb.py distribuited with > Postgres 7.3 is wrong but was not already fixed in 7.3.1 > why was not yet corrected ? It is not an RPM specific problem, but your subject implies that it is. Tom,

Re: [ADMIN] [BUGS] pgdb.py is still wrong [not just] in Postgres 7.3.1 rpm

2002-12-26 Thread Tom Lane
Lamar Owen <[EMAIL PROTECTED]> writes: > Tom, Bruce: who has the python interface these days? D'Arcy still is the lead guy on it, I think. Looking at the CVS logs, it seems this problem was fixed in CVS HEAD but not back-patched into the 7.3 branch: 2002-12-04 07:23 darcy * src/interfa

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)or COLUMNS_UPDATED() of SQLServer2000

2002-12-26 Thread shreedhar
Sorry, Because it is some problem in my system. So, it has shown Fri, 15 Mar 2002 17:27:30 +0530. Kindly any body give solution to my problem. Sreedhar. - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "shreedhar" <[EMAIL PROTECTED]> Sent: Thursday, December 26, 2002 11

Re: [ADMIN] Is there any eqvivalent or alternative to UPDATE(column)orCOLUMNS_UPDATED() of SQLServer2000

2002-12-26 Thread shreedhar
Dear Momjian, I need solution for the problem stated in subject. (i.e.) any method to know whether a record is Previously updated or not ? Sreedhar - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "shreedhar" <[EMAIL PROTECTED]> Sent: Friday, December 27, 2002 10:41 AM