[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