Thread

1. RE: Table msysconf

   Michael J Davis <mdavis@sevainc.com> — 2001-01-04T18:58:10Z

   Is there any documentation on what can be configured between PostgreSQL and Access?
   
   -----Original Message-----
   From:	Jose Soares [SMTP:jose@sferacarta.com]
   Sent:	Thursday, January 04, 2001 3:59 AM
   To:	Siuda Pawe? DI Centrala
   Cc:	'pgsql-general@postgresql.org'
   Subject:	Re: Table msysconf
   
   
   
   Siuda Pawe? DI Centrala wrote:
   
   > Hi !!!
   >
   > I am novice to Linux and PostgreSQL, so it is possible my question is
   > stupid.
   > Exactly I have 2 problems:
   >
   > 1) From time to time I have following info:
   >
   >         ERROR: Table msysconf does not exist
   >
   > Is it any system table?
   > Is it important?
   > My database seems to be OK.
   
   I supose you are using MS-Access -->ODBC-->PostgreSQL
   because M$-Access  checks for a table named msysconf
   you can optionally create this table on PostgreSQL
   to configure the connection between Access->PostgreSQL,
   if you don't have this table Access uses the default values.
   
   Jose'
   
   
   

2. Test for existence of Table

   Andy Koch <dfunct@telus.net> — 2001-01-04T19:39:56Z

   Can I test for an existing table before issuing the "CREATE TABLE" command?
   
   IF EXISTS employees{
            DROP TABLE employees
   }
   CREATE TABLE employees
   
   Can you provide an example of this. I couldn't find this in the manual or 
   Bruce's book - did I not look hard enough ? :)
   
   
   -          -          -          -          -          -          - 
     -          -          -          -
   WARNING: Some experts believe that use of any keyboard may cause
   serious injury. Consult Users Guide.
                                                                                          dfunct@telus.net