Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table msysconf

Table msysconf

From
Siuda Paweł DI Centrala
Date:
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.

Additional info:
    Postgres 6.4 on Redhat 6.0
    postmaster -i -B 60 -o '-S 4096'
    Intel Celeron 433, 64MB RAM, HDD 10,2GB

PostgreSQL is used as some kind of Data Mart (one of the table have over
4,000,000 tuples)
Max. 20 users (but max. 10 in one time).

2) ODBC driver on Win95 (I know what You say -:))

I have problems when using ODBC drivers to PostgreSQL on Win95 (VisualBasic
6.0 application).
When I make SELECT everyfing works fine, bat I can't make any UPDATES or
INSERTS.

There is a flag Read-only in Options of a ODBC driver but it doesn't matter
if it is on or off.
I always have error info.

Any help is welcome.
Pawel.

Re: Table msysconf

From
Jose Soares
Date:

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'

RE: Table msysconf

From
Michael Davis
Date:
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'

Test for existence of Table

From
Soma Interesting
Date:
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

RE: Table msysconf

From
P.Siuda@gbg.com.pl
Date:
Thanks for Your help.
After creating table msysconf (with attribiutes: Config,nValue) everyfing
seems to be ok.
After creating table without attribute Config, there was still error info,
that attribiute 'config' not exists.

Do You exactly know what for is table msysconf used or where can I find
information about it?

Pawel.