[ic] Postgresql problem (pg newbe)

Davor Ocelic docelic at spinlocksolutions.com
Mon Aug 25 16:48:29 UTC 2008


On Mon, 25 Aug 2008 12:16:16 -0400
Rick Bragg <lists at gmnet.net> wrote:

> 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:
> 
....

Regarding the log files, did you look in both the global error.log
and catalog's error.log?

The best way for this is 

  tail -F /path/to/ic/error.log /path/to/cat/error.log


Also, try inserting the data manually, with something like

  [query sql="insert into ABC values (1,2,3,....)"]
  [/query]

(Of course, make sure ABC is an existing table and 1,2,3 are valid
values).

-doc



More information about the interchange-users mailing list