Thanks for clarifying. I've submitted a note on the interactive
version of the docs, and attached a small patch to make explicit that
a window function is followed _immediately_ by an OVER clause, as the
syntax[1] indicates.
Regards,
Jeff
[1]
http://www.postgresql.org/docs/current/stati
Yes meant the tables are not shown in the treeview.
Let me explain the sequence of operations.
While our application is running it will create the database , tables,
stored procedures, triggers etc. dynamically and it will be visible through
pgAdmin as well. The application is running 24 X 7 and
On Tue, Jan 18, 2011 at 2:27 PM, benoygopal wrote:
>
> Yes meant the tables are not shown in the treeview.
> Let me explain the sequence of operations.
> While our application is running it will create the database , tables,
> stored procedures, triggers etc. dynamically and it will be visible th
The following bug has been logged online:
Bug reference: 5842
Logged by: Daniel Popowich
Email address: danielpopow...@gmail.com
PostgreSQL version: 8.4.6
Operating system: x86_64-pc-linux-gnu (Ubuntu 10.04.1)
Description:Memory leak in PL/Python when taking slices of
Thanks, that is helpful. There was a separate reason it didn't appear
to be happening before the 8.4 upgrade.
I couldn't find this mentioned in the documentation anywhere. Should
it be included in the pg_restore section?
-Anthony
On Sun, Jan 16, 2011 at 11:06 AM, Denish Patel wrote:
> Anthony,
>
Hello
I can't to execure a prepared statement with one parameter via
SPI_execute_with_args function.
pavel=# select name, statement from pg_prepared_statements ;
name │ statement
──┼
xx │ PREPARE "xx" AS select 10 + $1
(1 row)
EXECUTE "xx"($1)
Dear Dave,
Tables will not visible even after refreshing the tree view and after
restarting the PC as well.
It not predictable when the table will start displaying again. Some time the
tables displayed in the next day as well.
However we could able to login to the database,views up to schema but in
