Title: Message
I'm trying to copy a
database from mySql to postgres - I'd like to compare their performance in a
specific application.
I'm trying to use
the database migration wizard in pgadmin 1.6.0. (Is there a better way
to duplicate this database across?) Right after I click next aft
I got the error figured out this morning... The clients were having issues, because
the user that was removed was the owner of the tables. So, the tables effectively had
no owner, causing pgadmin do have different issues in different versions.
I was able to get it fixed (only with the new pgadm
I've managed to mess up the permissions on all of the tables in one of my
databases One way or another. I'm not sure of the actual sequence of events, but
I think that a user of the database got deleted, while it was set as having privileges
on these tables. Ever since then, things have be
Maybe some of you "unsubscribe" fools could take the time to actually use the web.
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=4
It took me all of 2 seconds to find the instructions for how to unsubscribe.
A direct link off the front page. Wow. That was hard.
Since you are apparently
, Daniel C. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:39 AM
To: [EMAIL PROTECTED]
Subject: [pgadmin-support] Add a user to a group of tables?
Is there a quick way to give a user permissions on multiple tables at once?
*
Daniel C. Armbrust
Medical
Is there a quick way to give a user permissions on multiple tables at once?
*
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*
---(end of broadcast)
Check out your logging:
Tools-> Options->Logging
The default level of Errors and SQL queries will probably be enough to sort out what
is going on, but if not, you can up it to Debug or Full Debug, rerun the export, and
then view the log file.
*
Daniel C. Armbrus
Thanks Dave! I checked my following previously reported errors against the new
current version:
* SELECT MAX(`OID_key`) AS RECCOUNT FROM `OID_root`CREATE SEQUENCE
"OID_root_OID_key_key" START 356
* Notice the back ticks (`) around OID_key. These promptly cause an error (illegal
syntax I thin
When attempting to migrate a set of tables from an access database using version
1.3.60 alpha, According to the log file, the following SQL was generated:
SELECT MAX(`OID_key`) AS RECCOUNT FROM `OID_root`CREATE SEQUENCE
"OID_root_OID_key_key" START 356
Notice the back ticks (`) around OID_key.
.
*
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 2:51 AM
To: Armbrust, Daniel C.; [EMAIL
The download for pgAdminII v1.3.60 (Alpha release) on
http://pgadmin.postgresql.org/downloads/ is broken.
The zip file gives a crc error when you try to unzip it.
*
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*
Database Migration Wizard Plugin for pgAdmin II 1.2.0 does not properly handle empty
strings from an MS Access Database.
When processing a column with a data type of Text, which is required but allows 0
length fields, and it encounters an empty string "", instead of passing the value as
"", it
The download for pgAdminII v1.3.60 (Alpha release) on
http://pgadmin.postgresql.org/downloads/ is broken.
The zip file gives a crc error when you try to unzip it.
*
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
***
13 matches
Mail list logo
