Hi
To follow up on this problem - the attached perl script still shows the same
error:
Cannot specify both sql_type and pg_type at /usr/lib/perl5/site_perl/5.8.1/
DBIx/Database.pm line 149.
with the attached sql. It is for PostgreSQL 7.3.4, but I think any recent
PostgreSQL gives the same answer.
DBD::Pg is 1.31 and Perl is 5.8.1
Hope this can give a clue.
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 12.00-18.00 Email: [EMAIL PROTECTED]
2000 Frederiksberg Lørdag 12.00-16.00 Web: www.suse.dk
#!/usr/bin/perl
use DBI;
use Data::Dumper;
use DBIx::Recordset;
my $dbname = 'dbitest';
my $host = 'localhost';
my $username = '';
my $password = '';
my $db = DBI->connect("dbi:Pg:dbname=$dbname;host=$host",
"$username",
"$password")
or die("Unable to connect to $dbname");
my %trans = (archived => 1);
my %search = ('!DataSource' => $db,
'!Table' => "transactions",
'$where' => 'archived = 0 AND deleted = 0'
);
$search{'$where'} .= " AND order_number IN (2288})";
DBIx::Recordset -> Update ({ %trans, %search });
$db->disconnect;
--
-- PostgreSQL database dump
--
\connect - kar
SET search_path = public, pg_catalog;
--
-- TOC entry 2 (OID 352832)
-- Name: transactions; Type: TABLE; Schema: public; Owner: kar
--
CREATE TABLE transactions (
code character varying(14) NOT NULL,
store_id character varying(9),
order_number character varying(14) NOT NULL,
"session" character varying(32) NOT NULL,
username character varying(20) DEFAULT '' NOT NULL,
shipmode character varying(32),
nitems character varying(9) NOT NULL,
subtotal character varying(12) NOT NULL,
shipping character varying(12) NOT NULL,
handling character varying(12),
salestax character varying(12),
total_cost character varying(16) NOT NULL,
fname character varying(30),
lname character varying(30),
company character varying(30),
address1 character varying(64),
address2 character varying(64),
city character varying(30) NOT NULL,
state character varying(10),
zip character varying(10),
country character varying(10),
phone_day character varying(20),
phone_night character varying(20),
fax character varying(20),
email character varying(42),
b_fname character varying(30),
b_lname character varying(30),
b_company character varying(30),
b_address1 character varying(64),
b_address2 character varying(64),
b_city character varying(30),
b_state character varying(10),
b_zip character varying(10),
b_country character varying(10),
b_phone character varying(20),
order_date character varying(32) NOT NULL,
order_ymd character(128),
order_wday character(128),
payment_method character varying(32),
po_number character(128),
payment_mode character(128),
avs character varying(32),
order_id character varying(32),
update_date timestamp with time zone,
status character varying(32),
affiliate character(128),
campaign character(128),
parent character varying(9),
archived character(1) DEFAULT '',
deleted character(1) DEFAULT '',
complete character(1) DEFAULT '',
comments text,
currency_locale character varying(32)
);
--
-- Data for TOC entry 7 (OID 352832)
-- Name: transactions; Type: TABLE DATA; Schema: public; Owner: kar
--
COPY transactions (code, store_id, order_number, "session", username, shipmode, nitems, subtotal, shipping, handling, salestax, total_cost, fname, lname, company, address1, address2, city, state, zip, country, phone_day, phone_night, fax, email, b_fname, b_lname, b_company, b_address1, b_address2, b_city, b_state, b_zip, b_country, b_phone, order_date, order_ymd, order_wday, payment_method, po_number, payment_mode, avs, order_id, update_date, status, affiliate, campaign, parent, archived, deleted, complete, comments, currency_locale) FROM stdin;
2288 2288 Hj2DHCH6 kaareR post (Postpakke) 1 720 42 0 0 762 Kaare Rasmussen Kaki Data Howitzvej 75 Frederiksberg 2000 DK 3816 2582 \N [EMAIL PROTECTED] 20030512 17:39:09 20030512 1 Forudbetaling \N \N order 1 0 0 \N
\.
--
-- TOC entry 3 (OID 354356)
-- Name: transactions_code; Type: INDEX; Schema: public; Owner: kar
--
CREATE INDEX transactions_code ON transactions USING btree (code);
--
-- TOC entry 6 (OID 354357)
-- Name: transactions_store_id; Type: INDEX; Schema: public; Owner: kar
--
CREATE INDEX transactions_store_id ON transactions USING btree (store_id);
--
-- TOC entry 4 (OID 354358)
-- Name: transactions_order_number; Type: INDEX; Schema: public; Owner: kar
--
CREATE INDEX transactions_order_number ON transactions USING btree (order_number);
--
-- TOC entry 5 (OID 354359)
-- Name: transactions_pkey; Type: CONSTRAINT; Schema: public; Owner: kar
--
ALTER TABLE ONLY transactions
ADD CONSTRAINT transactions_pkey PRIMARY KEY (code);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
