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
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
A surrogate key has been introduced on a table with modifiers:
Column|Type |
Modifiers
-+-+
new_id| integer | not null default
nextval(('som
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-+-+-
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.
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
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
> 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
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
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
10 matches
Mail list logo
