Thread: Nested transactions
Hi everyone, does postgres support nested transactions? If the answer is positive, can I use them thru ODBC from a windows client? Andrea
Hi, I am curently using MS Access and would like to convert my existing Access database to Postgresql database (maybe into Postgresql dump file first if neccessary). Is there any utility or program that can do that? Please advise. Thank you. Regards, Geok Leng
Unfortunately, Postgres doesn't support nested transactions. At least I'm 99% sure it doesn't. At 10:53 AM 6/26/00, Andrea Aime wrote: >Hi everyone, >does postgres support nested transactions? >If the answer is positive, can I use them >thru ODBC from a windows client? >Andrea
pgupt: http://ds.dial.pipex.com/boylesa/pgupt/pgupt.shtml "G.L.Lim" wrote: > Hi, > > I am curently using MS Access and would like to convert my existing Access > database to Postgresql database (maybe into Postgresql dump file first if > neccessary). Is there any utility or program that can do that? Please > advise. > > Thank you. > > Regards, > Geok Leng
Hey, I believe pgAdmin does that. Even if you don't use this part of it, you should still use it for general management of your postgresql databases. It rocks. http://www.vale-it.demon.co.uk/freeware/pgadmin/ Ole Gjerde ----- Original Message ----- From: "G.L.Lim" <limgl@grouplinks.com> To: <pgsql-general@postgresql.org> Sent: Monday, June 26, 2000 10:59 AM Subject: [GENERAL] Conversion from MS Access to Postgresql > Hi, > > I am curently using MS Access and would like to convert my existing Access > database to Postgresql database (maybe into Postgresql dump file first if > neccessary). Is there any utility or program that can do that? Please > advise.
"G.L.Lim" wrote:
>
> Hi,
>
> I am curently using MS Access and would like to convert my existing Access
> database to Postgresql database (maybe into Postgresql dump file first if
> neccessary). Is there any utility or program that can do that? Please
> advise.
I have a perl program which will load the .csv files you can dump from
Access. That will only move the data, of course. I generally find it
better to write a script to build the database by hand, but I think you
can export a script from Access that will work without too much editing.
Reply if you want my perl program.
Cheers,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
G'day. Having just done it, I can confirm that converting an Access database to PostgreSQL is very easy. All I did was as follows: 1. create an empty Postgresql database, 2. cretae an ODBC DSN on the Access machine pointing at the empty database, 3, fire up Access and Save/As/Export all tables to the ODBC target. Job done:-)) In fact, I had to do some massage to the results as the export process does not create indexes nor sequences and I decidesd to change some of the generated data types. This was also easy using the pgdump utility to dump the data and the definition for editing. Be aware that any column names that include upper case letters in Access will keep their capitalisation and require quotes in Postgresql. HTH, Stephen. "G.L.Lim" <limgl@grouplinks.com> wrote: > Hi, > > I am curently using MS Access and would like to convert my existing Access > database to Postgresql database (maybe into Postgresql dump file first if > neccessary). Is there any utility or program that can do that? Please > advise. > > Thank you. > > Regards, > Geok Leng ======================================================================== Stephen Davies Consulting scldad@sdc.com.au Adelaide, South Australia. Voice: 08-8177 1595 Computing & Network solutions. Fax: 08-8177 0133
On Mon, 26 Jun 2000, Andrea Aime wrote: > does postgres support nested transactions? No. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden