Access violation on nested table
Posted: Wed 06 Jul 2016 08:37
Hi,
Performing a query on nested table fails with:
Access violation at address 00000000. Read of address 00000000
Use this:
and simply a select * from nested_tablename will do the trick.
I'm using the PgDAC 4.7.23, RAD Studio 2009, on PostgreSQL 9.4
Hope this helps.
With regards,
Martijn Tonies
Performing a query on nested table fails with:
Access violation at address 00000000. Read of address 00000000
Use this:
Code: Select all
CREATE TABLE IF NOT EXISTS public.nested_tablename2 (
colname2 Serial NOT NULL ,
vc30 VarChar(30)
);
CREATE TABLE IF NOT EXISTS public.nested_tablename (
colname Serial NOT NULL,
field01 Integer,
field02 public.nested_tablename2
);
commit;
insert into nested_tablename(field01)
values (1)
commit;
I'm using the PgDAC 4.7.23, RAD Studio 2009, on PostgreSQL 9.4
Hope this helps.
With regards,
Martijn Tonies