Обсуждение: Connection from Win machine
PostgreSQL 7.1 on RH 7.0; database mydata has a few files created. Access 95 on Win98 ODBC driver 6.50.00 Access connects to the database but "sees" no tables. Thanks for the help. Mihai Gheorghiu
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 > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Mihai > Gheorghiu > Sent: Thursday, May 24, 2001 3:59 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Connection from Win machine > > > PostgreSQL 7.1 on RH 7.0; database mydata has a few files created. > Access 95 on Win98 ODBC driver 6.50.00 > Access connects to the database but "sees" no tables. > Thanks for the help. > > Mihai Gheorghiu > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > majordomo@postgresql.org >
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!
>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 problem is from php, please do this
print $prod_id;
and see what it give you
in php you must have someting like.
$mumu = pg_exec ($conn, "insert into mumulica (mumu1,mumu2) values('" .
$mumu1 . "','" . $mumu2 . "')");
>Thanks!
Have fun
Diana
From: "Diana Cionoiu" <diana@softwaresolutions.ro>
> >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 problem is from php, please do this
> print $prod_id;
> and see what it give you
> in php you must have someting like.
> $mumu = pg_exec ($conn, "insert into mumulica (mumu1,mumu2) values('" .
> $mumu1 . "','" . $mumu2 . "')");
Absolutely correct for strings, although in your example you could use:
pg_exec($conn, "insert into mumulica (mumu1,mumu2) values
('$mumu1','$mumu2')")
bearing in mind the need to escape ' marks. But - Jason's using numbers so
he should be fine.
Jason - sounds like you're checking return values, so we can be reasonably
sure the insert occurred. You're not inside a transaction block that gets
rolled back are you?
Might be scripts failing half-way through because of connection problems
too.
I'd be tempted to print $sql to a log-file so you can see what you think you
inserted and compare it to Postgres. You can also turn the logging level up
in PG to see individual queries, but that can be a little overwhelming.
- Richard Huxton
"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 >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 > >> -----Original Message----- >> From: pgsql-general-owner@postgresql.org >> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Mihai >> Gheorghiu >> Sent: Thursday, May 24, 2001 3:59 AM >> To: pgsql-general@postgresql.org >> Subject: [GENERAL] Connection from Win machine >> >> >> PostgreSQL 7.1 on RH 7.0; database mydata has a few files created. >> Access 95 on Win98 ODBC driver 6.50.00 >> Access connects to the database but "sees" no tables. >> Thanks for the help. >> >> Mihai Gheorghiu >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 1: subscribe and unsubscribe commands go to >> majordomo@postgresql.org >> > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster