Re: [HACKERS] LZTEXT for rule plan stings

At 08:17 PM 2/25/00 -0500, Tom Lane wrote:

>Really? That's interesting. Could you send me a test case
>(create table and create view commands)?

Normally, I wouldn't post the test case to the whole group
but figured folks might find this interesting. It's not all
that complex a table and the view of course is very simple.

Now...this is running on a snapshot from last weekend, just
before you fixed the pg_dump/reload problem associated with
column alias and views. I tried downloading the latest sources
via CVS and got bit by the "it don't compile" problem others
have complained about earlier today (ecpg). Here's the test
case:

create table ec_products (
product_id integer not null primary key,
sku varchar(100),
product_name varchar(200),
creation_date datetime default current_timestamp not null,
one_line_description varchar(400),
detailed_description varchar(4000),
search_keywords varchar(4000),
price numeric,
shipping numeric,
shipping_additional numeric,
weight float4,
dirname varchar(200),
present_p char(1) check (present_p in ('f','t')) default 't',
active_p char(1) check (active_p in ('f','t')) default 't',
available_date datetime default current_timestamp not null,
announcements varchar(4000),
announcements_expire datetime,
url varchar(300),
template_id integer,
stock_status char(1) check (stock_status in ('o','q','m','s','i')),
last_modified datetime not null,
last_modifying_user integer not null,
modified_ip_address varchar(20) not null
);

create view ec_products_displayable
as
select * from ec_products e
where active_p='t';

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.