Re: [BUGS] execute incorect query and get data

2006-12-15 Thread Marek Wróbel
Him, Tom Lane napisał(a): > =?ISO-8859-2?Q?Marek_Wr=F3bel?= <[EMAIL PROTECTED]> writes: >> create table a (a1 integer); >> create table b (b1 integer); >> insert into a (a1) values (1); >> insert into a (a1) values (2); >> select a1 from b; >> ERROR: column "a1" does not exist at character 8 >> b

[BUGS] execute incorect query and get data

2006-12-14 Thread Marek Wróbel
PostgreSQL : 8.2 Operating system: fedora RC4 create table a (a1 integer); create table b (b1 integer); insert into a (a1) values (1); insert into a (a1) values (2); select a1 from b; ERROR: column "a1" does not exist at character 8 but : select a1 from a where a1 not in (select a1

[BUGS] my schema + sql function

2003-02-18 Thread Wróbel
27; LANGUAGE 'sql'; table kont is in schema public. Everythink working ok, but when I try to restore backup system write : pg_restore: [archiver (db)] could not execute query: ERROR: Relation "kont" does not exist pg_restore: *** aborted because of error Marek Wróbel