This seems to be the best solution. At first I was a bit skeptical about the perfomance using execute versus using pre-planned queries. However, I found that this model actually executes faster than the paramterized queries that I was trying (even using the if-then-endif model).
Thanks for this
On Thu, Aug 17, 2006 at 11:25:30PM +0200, Chris Mair wrote:
> > Thanks Micheal I dont have dblink installed, I need to find a good
> > documentation which will help me do this and also the place where i
> > can download this module.
>
> dblink is a contrib module, that means it is part of the post
> Thanks Micheal I dont have dblink installed, I need to find a good
> documentation which will help me do this and also the place where i
> can download this module.
dblink is a contrib module, that means it is part of the postgresql
source code distribution.
you can read README.dblink online a
Thanks Micheal I dont have dblink installed, I need to find a good documentation which will help me do this and also the place where i can download this module.Thanks,Sumeet.
On 8/17/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Aug 17, 2006 at 04:37:03PM -0400, Sumeet wrote:> Im trying to fi
On Thu, Aug 17, 2006 at 04:37:03PM -0400, Sumeet wrote:
> Im trying to find out documentation for postgres module names "dblink", can
> anyone point me out to it. What i want to do is join multiple databases
> instead of multiple tables.
If you've installed dblink then somewhere on your system sho
Hi All,Im trying to find out documentation for postgres module names "dblink", can anyone point me out to it. What i want to do is join multiple databases instead of multiple tables.Thanks,Sumeet.
Hi Julian u need to reset your sequence, i had run through the same problem. On 8/17/06, Julian Scarfe <[EMAIL PROTECTED]
> wrote:A surrogate key has been introduced on a table with modifiers:
Column|Type |Modifiers-+-+-
A surrogate key has been introduced on a table with modifiers:
Column|Type |
Modifiers
-+-+
new_id| integer | not null default
nextval(('som
Rob Tester wrote:
I have the need to have optional values for a query in a stored procedure
that I am building. (using postgres 8.1.4). This particular query
executes
against a huge table (several million rows) and has six optional
parameters
that can be sent to the function. If one of the para
On Wed, Aug 16, 2006 at 10:03:38PM +0200, Jesper K. Pedersen wrote:
> The opendatabase model actually offered a standard set of table
> definitions covering a wide range of data storage.
>
> Of course this means that the tables would often have stuff you dont
> need, and may not have the things
10 matches
Mail list logo
