[ADMIN] ODBC Driver

2003-09-29 Thread Rhaoni Chiu Pereira
Hi List, I finished the first step of the PostgreSQL's approval process ( We are gonig to use it to smalls databases instead of Oracle). Now I must make it work with other sotwares of our company as converting programs made in Delphi. I need a clue where can I find the ODBC driver for wind

[ADMIN] OT maybe/ X-Server ----Postgres 7.1.3

2003-09-29 Thread Gottfried F. Zojer
Hello to all, Maybe a OT question . I m using Postgres on my suse 7.3 box .Everything is working fine . Thanks to the books from Bruce Momjian and Ewald Geschwinde . But only on thing is a problem . When I logon as postgres user I have a different X-Server (window-manager ) as a root even i

Re: [ADMIN] ODBC Driver

2003-09-29 Thread Matej Puntar
If you go to http://odbc.postgresql.org it will redirect you to http://gborg.postgresql.org/project/psqlodbc/projdisplay.php There is the official PostgreSQL ODBC Driver. Rhaoni Chiu Pereira wrote: Hi List, I finished the first step of the PostgreSQL's approval process ( We are gonig to use

[ADMIN] Is there a concept of Redo log files in postgres.?

2003-09-29 Thread Somasekhar Bangalore
Hi, I wanted to know like in oracle there is a concept of redo log files meant for backup and recovery. Is the same concept present in postgres.I have gone thru the documentation .it says backup can be taken thru 2 approaches 1.SQL Dump 2.File System level backup. for SQL Dump c

[ADMIN] How to move BLOB partitions to a different tablespace?

2003-09-29 Thread sandeep G
I've a table which has a number & a blob column, both of which are NOT NULL type. This table is composite partitioned using range & hash on the same column. Each partition is sub partitioned into two. I'm using ORACLE VERSION 9.0.2. Now if I try to move the partitions to a different tablespace I g

[ADMIN] new script

2003-09-29 Thread Jodi Kanter
So I now have my new schema script that includes PK and FK constraints. It runs without a problem but I get too many NOTICES regarding implicit indexes that have been created. I am running this script from within psql using the \i command. Can I run this and suppress these NOTICES? I find it te

Re: [ADMIN] 7.3.4 - pg_relcheck

2003-09-29 Thread Tom Lane
Rudi Starcevic <[EMAIL PROTECTED]> writes: > So I thought I'd write just to double check that pg_relcheck has been > dropped and it's not just me. > Pg_relcheck is no longer in the system tables is it ? pg_relcheck has been replaced by a more general table, pg_constraint. Sounds like ColdFusion n

Re: [ADMIN] new script

2003-09-29 Thread Tom Lane
Jodi Kanter <[EMAIL PROTECTED]> writes: > So I now have my new schema script that includes PK and FK constraints. > It runs without a problem but I get too many NOTICES regarding implicit > indexes that have been created. I am running this script from within > psql using the \i command. Can I ru

[ADMIN] Automatic BackUp from VB

2003-09-29 Thread Marvin
Hello fellas, I made a VB application with PeerDirect-PostgreSQL 7.2 Under Win2K.   The application and the DB are working fine, however I would like to do an automatic BackUp process activated from my VB application.   Any Ideas, Thank you in advanced for any sugestion.   MAGO __

[ADMIN] Automatic BackUp Process

2003-09-29 Thread Marvin Gonzalez
[EMAIL PROTECTED] Hello fellas, I made a VB application with PeerDirect-PostgreSQL 7.2 Under Win2K. The application and the DB are working fine, however I would like to do an automatic BackUp process activated from my VB application. Any Ideas, Thank you in advanced for any sugestion. MAGO

[ADMIN] remove my email account, please

2003-09-29 Thread [EMAIL PROTECTED]
Dear pqsql-admin staff I don't want still recieving your emails. Please, remove me from your database registers. Thanks mail2web - Check your email from the web at http://mail2web.com/ . ---(end of b

Re: [ADMIN] [PERFORM] Plan-Reading

2003-09-29 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Where can I find a plan-readinf tutorial? This covers explain plans in depth: http://www.gtsm.com/oscon2003/explain.html - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200309291123 -BEGIN PGP SIGNATURE- Comment: http://