The following bug has been logged online:
Bug reference: 2251
Logged by: Sergei Dubov
Email address: sdubov ( at ) gmail ( dot ) com
PostgreSQL version: 8.1.2
Operating system: Windows XP
Description:NOT IN clause is not working correctly
Details:
I have two tables,
On Sun, 26 Feb 2006, Dhanaraj wrote:
> I have two tables, let's say A and B.
>
> B is a child of a in one to many relationship. A contains records that are
> not referenced by B.
>
> I am running a query:
>
> select * from A t1 where t1.id not in (select t2.A_id from B t2);
>
> It returns 0 rows.
On Sun, Feb 26, 2006 at 07:38:32PM +0530, Dhanaraj wrote:
> I am running a query:
>
> select * from A t1 where t1.id not in (select t2.A_id from B t2);
>
> It returns 0 rows.
>
> Now I run
> (select t1.id from A t1) except (select t2.A_id from B t2);
>
> And now Postgres correctly returns recor
On Sun, Feb 26, 2006 at 07:38:32PM +0530, Dhanaraj wrote:
> I tested this exampe. It works fine in Solaris platform (postgres 8.1.2
> released recently by sun)
> Try the same example in some other version. If this is true, the changes
> need to be done for a particular version of postgres..
Sorr
The following bug has been logged online:
Bug reference: 2282
Logged by: Kevin Marshall
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: FreeBSD/i386
Description:Warning: pg_cmdtuples(): Not supported under this build
Details:
Can you hel
"Kevin Marshall" <[EMAIL PROTECTED]> writes:
> Warning: pg_cmdtuples(): Not supported under this build in
> /home/hhm.trafika.co.uk/htdocs/phpgadmin/htdocs/libraries/adodb/drivers/adod
> b-postgres64.inc.php on line 108
You should try reporting this problem on a php bug list. pgsql-bugs
is for bu
""herianto"" <[EMAIL PROTECTED]> wrote
>
> Every I will query select * from namaTable , I get Error invalid page
> header. but if me use query select * from namaTable limit 1008. I get
Query
> is successfully.
>
> Total rows of tables is 1009. while if me query select * from namaTable
> limit 10
