[ic] Postgresql problem (pg newbe)

[Rick Bragg]

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.