I make 3 tables with this senario:
b (id) extends a (id)
and
c (id) references a (id)
i insert one record to table b (id = 1)
and then i try to insert a record in table C (id = 1)
but it is not possible, i get error
(look at the sql statements above)
NOTE
if the C (id) references the b (id) t
Kostas Maistrelis wrote:
> I make 3 tables with this senario:
> b (id) extends a (id)
> and
> c (id) references a (id)
>
> i insert one record to table b (id = 1)
> and then i try to insert a record in table C (id = 1)
> but it is not possible, i get error
> (look at the sql statements above)
T
On July 22, 7:46 pm "Jasbinder Bali" <[EMAIL PROTECTED]> wrote:
> I have a C program and have some ECPG code in it.
>
> How do i display the data that i retrieve from the postgres database
> using a simple select statment or calling a stored procedure.
>
> Is it mandatory to use cursor or there's
Hi, could anybody tell me which variation of B-tree PostgreSQL uses, that
it can handle more than one column?
Some link would be great.
Thanks,
David Hoksza
---(end of broadcast)---
TIP 6: explain analyze is your friend
David Hoksza <[EMAIL PROTECTED]> writes:
> Hi, could anybody tell me which variation of B-tree PostgreSQL uses, that
> it can handle more than one column?
Plain old b+ tree ... we just treat the keys as compound, ie the
"compare" operation compares columns until finding a difference.
> Some link
Hi,
We have a database with Postgis extensions installed. When we do a
full dump of the database (using pg_dump -Ft), somehow the "geometry"
type does not get dumped, so the restore fails.
If I try to load the geometry type before restoring, then I have to
createlang 'plpgsql' because p
OK, thanks. And I would like have one more question about B-tree index
- how many records are usualy stored in one node (what's arity of the tree)?
Thanks,
David Hoksza
23. července 2006, 20:03:03, napsal jste:
TL> David Hoksza <[EMAIL PROTECTED]> writes:
On Sun, Jul 23, 2006 at 11:22:18AM -0700, Claire McLister wrote:
> We have a database with Postgis extensions installed. When we do a
> full dump of the database (using pg_dump -Ft), somehow the "geometry"
> type does not get dumped, so the restore fails.
What are the exact dump and restore c
On Sun, 2006-07-23 at 14:59 +0300, Kostas Maistrelis wrote:
> I make 3 tables with this senario:
> b (id) extends a (id)
> and
> c (id) references a (id)
>
> i insert one record to table b (id = 1)
> and then i try to insert a record in table C (id = 1)
> but it is not possible, i get error
> (l
