1) Make sure the odbc data source you are using has the read only flag checked off.
2) Create a primary key index for the table. Access97 requires a primary key or it
will not allow you to edit or add any rows.
-Original Message-
From: Scott Teglasi [SMTP:[EMAIL PROTECTED]]
Sent:
Is there any documentation on what can be configured between PostgreSQL and Access?
-Original Message-
From: Jose Soares [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 3:59 AM
To: Siuda Pawe? DI Centrala
Cc: '[EMAIL PROTECTED]'
Subject:Re: Table msysconf
al functions that
already exist to convert numeric to text so that I don't have to write one?
I know that psql successfully does this.
Thanks, Michael Davis
Database Architect and Senior Software Engineer, Seva Inc.
Office: 303-460-7360Fax: 303-460-7362
Mobile: 720-320-6971
Email: [EMAIL PROTECTED]
Try:
--This shows all default values for columns
SELECT DISTINCT c.relname, a.attname, t.typname, pa.adsrc, a.atttypid
FROM pg_attribute a, pg_class c, pg_type t, pg_attrdef pa
WHERE a.attrelid = c.oid
AND a.atttypid = t.oid
AND c.oid = pa.adrelid
AND a.attnum =
ea how to
work around this other than using the -d/-D option in pg_dump? I like the
-d option in pg_dump, however, importing the data via pgsql is much slower
with this option.
Thanks in advance, Michael Davis
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis
From: dustin sallings on 05/05/99 01:57 AM
To: mtony @ iname.com@SMTP@EXCHANGE
cc: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis.
From: Mark Fleming on 05/04/99
02:23 PM
To: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
cc:
Subject:Re: [GENERAL
Your e-mail did not arrive at its intended destination. You need to
send it to Michael J. Davis, not Michael Davis.
From: Bruce Momjian on 05/04/99
12:39 PM
To: Chris Bitmead @SMTP@EXCHANGE
cc: pgsql-general @ postgreSQL.org@SMTP@EXCHANGE
The safest way is to select the nextval('seq_name') and then insert using
this value.
-Original Message-
From: Brian [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 14, 1999 2:59 PM
To: [EMAIL PROTECTED]
Subject:[GENERAL] How to get
Try vacuum. You could also try dropping and recreating your indexes.
-Original Message-
From: Stefano Zampieri [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, April 03, 1999 3:56 AM
To: [EMAIL PROTECTED]
Subject:[GENERAL] pg_dump error
:[EMAIL PROTECTED]]
Sent: Wednesday, March 31, 1999 12:30 AM
To: Michael Davis
Cc: PGSQL-General (E-mail)
Subject:RE: [GENERAL] limit select question
On Wed, 31 Mar 1999, Michael Davis wrote:
> Good point. I am running 6.5. So
Good point. I am running 6.5. So it has been fixed. I am not sure what
patch is needed to make this work on 6.4.2.
-Original Message-
From: Kevin Heflin [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, March 31, 1999 12:26 AM
To: Michael Davis
Select * From table_name limit 1;
-Original Message-
From: Kevin Heflin [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 30, 1999 10:00 PM
To: PGSQL-General (E-mail)
Subject:[GENERAL] limit select question
I've been asked if t
I use the following technique:
add sequence to the primary key of the table
look up the sequence the primary key
insert a record using (including) the primary key
re-query the newly inserted record using the primary key
Thanks, Michael
-Original Message-
From: David O'F
, Michael
-Original Message-
From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 12, 1999 11:31 AM
To: Michael Davis
Cc: [EMAIL PROTECTED]
Subject:Re: [GENERAL] Comments on columns?
> I did that and
I did that and it works great. I would like \dd tablename to show the table
comment and its column comments.
-Original Message-
From: Bruce Momjian [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 12, 1999 7:43 AM
To: Michael Davis
Cc
Are there any plans to have psql support comments on columns? For example,
I would like to be able to add a comment on a column of a table and have \dd
display the table comment in addition to any/all column comments.
Thanks, Michael
Yes, the "having" clause is supported in 6.4.2 with some restrictions as
outlined in the documentation on the web site.
-Original Message-
From: Matthew [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 09, 1999 10:46 PM
To: [EMAIL PROTECTED]
S
Does anyone have a query or function that will return the size (in bytes) of
a table?
1) When I run the function below I get an error at "select". If I put the
select statement in single quotes, I get an error at "loop". Any
suggestions how to fix this?
2) When I install the following function:
CREATE FUNCTION InstallPermissions(varchar, varchar) RETURNS int2 AS '
You could try select spaces(pointer::int4) || Number; Where spaces() is a
function that inserts "pointer" number of spaces (or dashes if you want to
create your own function). Not sure if spaces() exists in Postgres or not,
but it seems I read about it or a similar function somewhere.
How can I add a comment to a table, function, etc. that will should up in a
/dd comment in psql?
I wrote a function that takes a boolean parameter and returns int2.
-Original Message-
From: Valerio Santinelli [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 24, 1999 1:10 PM
To: Michael Davis
Cc: [EMAIL PROTECTED]
Subject
I defined my Access boolean fields as int2 in Postgres. This, in
combination with removing the "Bools as Char" flag in the ODBC driver
appears to work. However, I have not been able to much testing.
-Original Message-
From: Valerio Santinelli [SMTP:[EMAIL PROTECTED]]
I was thinking about creating a trigger on every table that would write an
insert, update, or delete statement into a log file. Each replicated
database would pro-actively read these and post them.
-Original Message-
From: Thomas Antepoth [SMTP:[EMAIL PROTECTED]]
25 matches
Mail list logo
