Connection from Win machine

you need the 7.1 version of the drivers. There is no installer available at
this time (so far as I am aware) so you will need to go to the postgresql
ftp site to download the odbc dll contained in a zip file called
psqlodbc-07_01_0005.zip

Hi,

I am using php. When executing a query I do not get an error. However, when
I look at the DB it hasn't added the row and all other rows in the series of
queries have been added.

I've echo'd the $sql statement and actually ran it through the command line
with no problems.

The odd thing is, when I do these queries they do not fail, yet they do not
insert. It still increases the serial primary key ("id") so when I do a
query through the command line the first record for example would start at
12 (becuase i have tried to insert from the php code 12 times prior to
adding it manually).

Any idea on what the prob is?

Here's my sql statement:
$sql = "insert into pricing (prod_id, size_id, price) values ($prod_id,
$size_id, 0.00)";

here's an example of what it generates before it inserts:
insert into pricing (prod_id, size_id, price) values (148, 48, 0.00)

the table pricing has the following columns:
id - primar key/serial
prod_id - int4
size_id - int4
price - float4

Any help would be very much appreciated!

Thanks!

"Jason" <jason@op480.com> writes:

The odd thing is, when I do these queries they do not fail, yet they do not
insert.

Perhaps the php code is running inside a transaction block? If so, the
added rows won't be visible to other connections until (and unless) the
transaction is committed. The rows *would* be visible to subsequent
commands issued by that same php connection, though --- have you tried
checking that way?

It still increases the serial primary key ("id")

This is consistent with my theory. Sequence-object bumps are
immediately visible regardless of transaction boundaries.

regards, tom lane

Thanks a lot,

Mihai

-----Original Message-----
From: Scott Gilbert <scott.gilbert@netregistry.au.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Thursday, May 24, 2001 2:38 AM
Subject: RE: [GENERAL] Connection from Win machine

you need the 7.1 version of the drivers. There is no installer available

at