[GENERAL] Definitive list of new types in 6.5 needed

Is there a definitive list of types in 6.5 ? Not just the new ones, but all types? Or do I just wade through the documentation as usual - assuming that the latest docs are indeed the latest docs :-) cheers bc --- http://4qir.quantum-radio.net.au - Where Only The Dedicated Survive! 4QIR Quantum

[GENERAL] Someone was asking about MEMO fields and sizes?

This ability to use ODBC with access is pure magic! I created a database on the Access machine, and in that I created a table, with a memo field. I exported the table to the postgres database. I looked at the structure of the table in pgsql, and the memo filed is type TEXT of var length. As it sa

[GENERAL] RE: ODBC question on R+w and +r only. solved

Hmmm. Just gave all permisions to user, and created a NEW table database in Access, and it imported the new permissions. It seems that Access imports the permissions, and then doesn't let you chang them, even when they have been changed in the pgsql system. not a bad idea I usppose. Now to work

[GENERAL] What is happening here? ODBC. r+w on one, r only on other

I have two databases here, and I can read both with Access. However, I can only write to one with Access, the second one, although it appears to be set up the same - I think - I can't write to it to add records. Access shows the [Insert Record] field as greyd out? Any clues anyone? ta bob -- ht

Re: Was...[GENERAL] Checkboxes on MSAccess and PostgreSQL

Hi, I'm pretty new to postgresql, but am reasonably familiar with MSAccess, and I see here that Valerio can export tables from Access to pgsql. How is this done? And using forms from Access related to pgsql databases? This could be invaluable. While I'm at it, does anyone know where there might b

[GENERAL] Is there a script for cleanly shutting down

Just wondering if there is a script anywhere for cleanly shutting down the postmaster. thanks Bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au World Music Radio. phone:61-7-49440357 - fax:61-7-49512832 icq#11

[GENERAL] Found solution to reloading dumped 6.1 -> 6.4

The 6.1 db.out has a line in it that looks like this; CREATE TABLE categories (category varchar(30)) archive = none; If I remove the " archive = none" bit, then all works ok. Excellent. bob -- http://www.chalmers.com.au Chinese Language Studies. http://4qir.quantum-radio.net.au

[GENERAL] Is there something special to do to pull 6.1 db.out files into 6.4.1 ?

Hi, well, finally have it all running together, but can't get my old 6.1 data into 6.4.1 now. I did a pg_dumpall -z > db.out in 6.1 and its created the file with all the data in it, but the appropriate psql -e template1 < db.out falls over. Massive error messages, although it actually creates th