[ic] Postgresql problem (pg newbe)
Rick Bragg
lists at gmnet.net
Mon Aug 25 16:59:38 UTC 2008
On Mon, 2008-08-25 at 18:48 +0200, Davor Ocelic wrote:
> 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
that's right, Nothing in both catalog and global log files.
the query tag does the same as the perl tag. It ticks the sequence, but
no row.
Rick
--
This message has been scanned for viruses and
dangerous content by Green Mountain Network, and is
believed to be clean.
More information about the interchange-users
mailing list