php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #40808 pg_insert problem
Submitted: 2007-03-14 20:21 UTC Modified: 2008-10-16 00:46 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:0 (0.0%)
From: pentropia at gmail dot com Assigned: yohgaki (profile)
Status: Closed Package: PostgreSQL related
PHP Version: 5.2.1 OS: Win32
Private report: No CVE-ID: None
 [2007-03-14 20:21 UTC] pentropia at gmail dot com
Description:
------------
Im referencing you to this bug:
http://bugs.php.net/bug.php?id=24679
Obviously he forgot to put the status back to 'open'.
pg_insert throws a couple of errors when you try to reference a table within i schema.
This is because the query isn't composed the right way.

Reproduce code:
---------------
sql
CREATE SCHEMA foo;
CREATE TABLE foo.bar (
  id int
);

php
pg_insert( $sqlres , "foo.bar" , array( "id" => 5 ) );

Expected result:
----------------
Expected new row to be added to table 'foo' within schema 'bar'.

Actual result:
--------------
Do not have the error atm. Could be brought up if requested.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-10-16 00:46 UTC] felipe@php.net
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri May 03 14:01:30 2024 UTC