[GENERAL] Migrating from a DB2/400 to Postgres.

Hello, I have no experience of AS400 but I might be finding myself migrating a database from db2/400 to postgres/linux shortly. I suppose it is a question of making a dump on the db2 and then importing it to postgres. (The fact that I get more search hits on db2 *core* dumps than data dumps is no

Re: [GENERAL] Migrating from a DB2/400 to Postgres.

It may be possible to dump each table to a file on the AS/400 and FTP it to a PC I am not certain how this could be done but it should be possible. If the database is not too big I would be tempted to use an ODBC link to extract the data directly into postgres from a VB/Java program that has ODB

[GENERAL] fastpath error?

Hello. I am occasionally (seemingly randomly) seeing the following error when I try to load a large object. FastPath call returned ERROR: lo_close: invalid large obj descriptor (0) at org.postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141) at org.postgresql.fastpath.Fastpa

Re: [GENERAL] how to load a sql-file????

psql -U postgres -f loadfile.sql Should do what you want. Or if you are already in psql take a look at the \i command. Jason --- markus jais <[EMAIL PROTECTED]> wrote: > hi, > maybe this is somewhere in the docs but I couldn't > find > it. > I am a beginner to postgresql and do not know much

Re: [GENERAL] undefined symbol in create new function

Joel Dudley <[EMAIL PROTECTED]> writes: > Is PG_GETARG_CHAR valid? I thought it was. maybe I should re-do it all with > PG_GETARG_TEXT. Thanks for reading my post. Nope, neither one. See src/include/fmgr.h for the predefined GETARG macros. You would also do well to read src/backend/utils/fmgr/R

Re: [GENERAL] undefined symbol in create new function

Joel Dudley <[EMAIL PROTECTED]> writes: > Thanks for your help. I had to clarify though, are you saying that it is > impossible to do what I am trying to do? Thank you for your time. No, you just have to realize that Postgres string values are not null-terminated and so you can't manipulate them

[GENERAL] Tables grow in size when issuing UPDATEs! Why??

Hi, I have noticed a strange thing when dealing with postgreSQL. Foreword: this is all about postgres tables increasing in size extremely fast when doing updates. My sainness is decreasing in approximatly the same speed. Please look. When I do this: * create database foo * create table test C

Re: [GENERAL] how to load a sql-file????

Jason Earl wrote: > > psql -U postgres -f loadfile.sql > > Should do what you want. Or if you are already in > psql take a look at the \i command. Especially if you're just starting, you might like to start psql as 'psql -s'. This puts you in single step mode, so when you use \i, the SQL com

Re: [GENERAL] timestamp/function question

At 12:41 AM 3/29/2001 -0600, you wrote: >do. In the case of logfunc1(), the Postgres main parser knows >when preparing the plan for the INSERT, that the string 'now' >should be interpreted as datetime because the target field of >logtable is of that type. Thus, it will make a constant from it >at

Fwd: Re: [GENERAL] timestamp/function question

>blah blah blah > >...and that all meant what? The postgres manual is open to much >interpretation to anyone new trying to understand its contents. Combine >that with documentation that's still not written, or broken across several >different sections (programmer, user, admin, etc) and a sear

[GENERAL] Please Help Can not connect to any database

Hi, all! I have a problem with connection to any database on my server. $psql template1 psql: FATAL 1: Database 'template1', OID 17216, has disappeared from pg_database Any ideas? What's going wrong? Version of PostgreSQL is 7.0. The operation system is Red Hat 6.1. Any help would be appreci