[ic] Postgresql problem (pg newbe)

[Rick Bragg]

On Mon, 2008-08-25 at 09:03 -0600, Jon Jensen wrote:
> On Sun, 24 Aug 2008, Rick Bragg wrote:
> 
> > I am new to postgres, and I am having trouble inserting any data via 
> > Interchange, however it looks like it should work.  The IC and catalog 
> > error logs are empty, nothing at all; The postgres log looks like it 
> > inserted a row;  There is a sequence and it moves up perfect; However, 
> > there are no rows of data.
> 
> Rick,
> 
> Seems like it should be working.
> 
> Could you pass on some more details of your setup?
> 
> * OS
> * exact Postgres version and origin (RPM? .deb? source build?)
> * grep ^log ~postgres/data/postgresql.conf  # or wherever that file is
> 
> Maybe that will give us some clues.
> 
> Thanks,
> Jon
> 
> 
> -- 
> Jon Jensen
> End Point Corporation
> http://www.endpoint.com/


Thanks Jon, This is really puzzling to me... 

ubuntu hardy 64 bit server version
psql (PostgreSQL) 8.3.3 built from .deb
Interchange 5.6.0 built from source
Threaded perl built from .deb
  This is perl, v5.8.8 built for x86_64-linux-gnu-thread-multi
Nothing special in catalog.cfg
Also, when IC builds the table, it automatically builds the sequence
and also sets the following "default value" for the code primary key
field
nextval('testtable_code_seq'::regclass)
Again, the sequence works perfect, and even moves up each time I try to
import.

Here is the output of the grep command:

 #grep ^log /etc/postgresql/8.3/main/postgresql.conf 
log_error_verbosity = verbose		# terse, default, or verbose messages
log_connections = on
log_disconnections = on
log_duration = on
log_line_prefix = '%t '			# special values:
log_statement = 'all'			# none, ddl, mod, all


Should I change some configurations somewhere?
Another strange thing is that Interchange does write data if I delete
the products/.*.sql files and restart IC with pre-populated
products/*.txt files, it seems to rebuild and import data fine. 

It seems as though postgres is talking to IC saying, OK I will insert
that, ok, yup its done, (I tossed it away just like you wanted me to...)

Thanks again!
Rick




-- 
This message has been scanned for viruses and
dangerous content by Green Mountain Network, and is
believed to be clean.