Re: I'm very confused.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alan Hodgson wrote:
> On Tuesday 16 January 2007 22:42, Brant Fitzsimmons
> <brant(at)bfcomputerconsulting(dot)com> wrote:
>> Records that are entered at the console show up when I do a
>> select with the script, but not the other way around. I have
>> tried to the RTFM as much as possible, but I'm still lost as to
>> why while accessing the same table I can't access the data
>> manipulated by the script. I don't know if it has anything to do
>> with tablespaces or what, but I'm really starting to get
>> frustrated.
>
> Is the script starting a transaction and not committing it? If so,
> the changes it makes will not be visible to other processes. psql
> by default operates in auto-commit mode, every statement is
> committed on completion.

No transactions; just simple inserts.
>
> If this is not the case, I would have to say you are not in fact
> working on the same table, somehow.

That's what i was thinking as well, but how is that possible?

If I insert a record at the console the data shows up in a select made
in the script. If I insert a record in the script I can not see that
data in a select from the console.

If I add a column at the console i am able to insert into that column
in my script. After that insert I am able to retrieve the newly
inserted data from the script, but not from the console.

It doesn't make any sense to me.

- --
Brant Fitzsimmons
brant(at)bfcomputerconsulting(dot)com
- -------------------------------------------------------------------
"Strange times are these in which we live when the old and the
young are taught falsehoods in the schools of learning. And the one
man that dares to tell the truth is called at once a lunatic and
a fool."
-Plato
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFrdkODpzwx2t8E5gRArfTAJ4zPndrqfbIR+f7PhA2CnV4S1pjnwCdGgCf
9vCfTAVLaDEZ/C9b6reflhI=
=A/vg
-----END PGP SIGNATURE-----