[SQL] FastPath Protocol Error

2001-01-28 Thread Som
Helooo.. I have problem while retrieving image from postgres 7.0.0 through some front-end. I am getting Exception saying: FastPath protocol error : Z any idea? -- som

Re: [SQL] Multicolumn primary keys and multicolumn foreign keys

2001-01-28 Thread chard
On Sun, 28 Jan 2001, Ferruccio Zamuner wrote: > Hi, > > I've found a trouble and I've tried to avoid it without success: > > --- > create table companies ( >id serial not null primary key, >firm_name text not null, >activity text > ); > > create table customers ( >

[SQL] Multicolumn primary keys and multicolumn foreign keys

2001-01-28 Thread Ferruccio Zamuner
Hi, I've found a trouble and I've tried to avoid it without success: --- create table companies ( id serial not null primary key, firm_name text not null, activity text ); create table customers ( id int not null references companies, seller_id int not nul

Re: [SQL] Re: Problem with Dates

2001-01-28 Thread Christopher Sawtell
On Fri, 26 Jan 2001 12:46, Glen and Rosanne Eustace wrote: > template1=# select '31/12/2000'::date + '365 days'::timespan; > ?column? > > 2002-01-01 00:00:00+13<<< Wrong > (1 row) This appears to be fixed in the current sources by CVSup :- 23:16:03