When I try to run something with PostrgreSQL (libpq) in Borland C++
Builder, it does not run and write errors like "[Linker Error]
Unresolved external '_PQconnectdb' referenced from C:\PROGRAM
FILES\BORLAND\CBUILDER6\PROJECTS\UNIT1.OBJ". Does anybody know how to
fix it?
Thanks
Hello,
I have a query using Greatest that hangs and never returns when called with two
tables.
Postgres Version: 9.6
Tables
t1{ id bigint }
t2 { id bigint }
they are sharing a sequence
the query
select greatest(max(t1.id), max(t2.id)) from t1, t2;
The purpose was to call setval on t
ows=56027 width=8)
-> Seq Scan on t2 (cost=0.00..808.27 rows=56027 width=8)
It seems it has to do a loop on 14 billion rows? Can someone explain why this
would happen?
Thanks,
Teddy
____
From: Teddy Schmitz
Sent: Thursday, February 16, 2017 12:32:41 PM
To: p
Thanks for the link Pavel, that makes perfect sense now.
Teddy
From: David G. Johnston
Sent: Thursday, February 16, 2017 12:42:36 PM
To: Teddy Schmitz
Cc: pgsql-general@postgresql.org
Subject: [GENERAL] Problems with Greatest
On Wednesday, February 15, 2017
visible from the public schema only
not from the schema I`m using. So my question is how can I make lo type to
be visible from all schemas
by visible I mean accesible: not need to use for example public.lo to define
a field of type lo
thanks in advanced
--
Teddy L.
application will find the lo type.
thanks
2010/5/20 Tom Lane
> Teddy Limousin writes:
> > I guess this is because when executing the sql command to install lo, it
> > makes it visible from the public schema only
> > not from the schema I`m using. So my question is how ca
