Hi,
I am using Postgre SQL 8.3, where I want to backup my entire database. For the
same I am using pg_dump.exe. I am able to take the backup of my database in to
my local machine. If I want to take the backup into network folder, how to pass
"-f" parameter to pg_dump.exe. I am using SMB to impl
Deepak, Tom thanks for answering.
Tom, we have psql 8.1.18. So you are right, this weird message is because of
the old version. I will check with my colleague about the possible reasons.
What can I do if there is a messed up table?
Regards,
Deniz
On Sat, Jul 30, 2011 at 11:45 PM, Tom Lane wrote
On Mon, Aug 1, 2011 at 3:00 AM, Aakash Goel wrote:
> Hi,
>
> I am having some trouble installing the db on my Windows 7 machine.
>
> Whenever I try to install from postgresql-9.0.4-1-windows_x64.exe, I get
> these errors:
> http://i.imgur.com/gNCrR.png
> http://i.imgur.com/yEVxT.png
>
> Any help i
>When the filesystem containing my database fills up, the server repeats
>the following log message about as fast as it can log:
>
> Jun 29 23:00:55 src@giraffe postgres: LOG: could not write temporary
> statistics file "pg_stat_tmp/pgstat.tmp": No space left on device
In case anyone finds thi
Hi,
I am having some trouble installing the db on my Windows 7 machine.
Whenever I try to install from postgresql-9.0.4-1-windows_x64.exe, I get
these errors:
http://i.imgur.com/gNCrR.png
http://i.imgur.com/yEVxT.png
Any help is appreciated. Thanks,
Aakash
Le dimanche 31 juillet 2011 à 18:43 +0200, saeed ahmed a écrit :
> i am new to postgresql and not very good in english language.i need
> help to understand,how i can make,(by using postgresql)something like
> microsofts access.i remebre you see a lot of buttons and
> functions.when you finish inser
You really need to tell people what knowledge and skills you already possess if
you expect to get a meaningful answer. If you have never written a program in
your life you have a lot to cover compared to mostly not knowing how to
interface your chosen language with a database. And have you ever
2011/7/31 John R Pierce :
> On 07/31/11 11:06 AM, Pavel Stehule wrote:
>>
>> 2011/7/31 saeed ahmed:
>>
>>> my english is limited and find it difficult to learn new things.only
>>> by askiing ,i can learn.
>>> i would like to know
>>> if i want to make a website where user can insert data and after
On 07/31/11 11:06 AM, Pavel Stehule wrote:
2011/7/31 saeed ahmed:
my english is limited and find it difficult to learn new things.only
by askiing ,i can learn.
i would like to know
if i want to make a website where user can insert data and after i
use query to get results.how should i begin?fr
Hello
look on this site, please, http://sqlzoo.net/
Regards
Pavel Stehule
2011/7/31 saeed ahmed :
> my english is limited and find it difficult to learn new things.only
> by askiing ,i can learn.
> i would like to know
> if i want to make a website where user can insert data and after i
> use
my english is limited and find it difficult to learn new things.only
by askiing ,i can learn.
i would like to know
if i want to make a website where user can insert data and after i
use query to get results.how should i begin?from where to start?
--
Sent via pgsql-general mailing list (pgsql-gen
On Thu, Jul 28, 2011 at 12:03 PM, Samba wrote:
> I think one year is sufficient time for any product/feature to be thoroughly
> tested for all its strengths and weaknesses; so would it be too much to ask
> the vast postgres customer base about their experiences with streaming
> replication, the g
On 31/07/11 21:36, Alban Hertroys wrote:
On 30 Jul 2011, at 13:49, Gavin Flower wrote:
On 30/07/11 10:45, bricklen wrote:
[...]
CREATE OR REPLACE VIEW table_dependencies AS (
WITH RECURSIVE t AS (
SELECT
c.oid AS origin_id,
c.oid::regclass::text AS origin_table,
On 31/07/11 21:42, Alban Hertroys wrote:
On 30 Jul 2011, at 12:17, Gavin Flower wrote:
CREATE OR REPLACE VIEW table_dependencies AS (
WITH RECURSIVE t AS (
SELECT
c.oid AS origin_id,
c.oid::regclass::text AS origin_table,
c.oid AS referencing_id,
c.oid::
On 07/31/11 9:43 AM, saeed ahmed wrote:
i am new to postgresql and not very good in english language.i need
help to understand,how i can make,(by using postgresql)something like
microsofts access.i remebre you see a lot of buttons and
functions.when you finish inserting some data,you have somethi
i am new to postgresql and not very good in english language.i need
help to understand,how i can make,(by using postgresql)something like
microsofts access.i remebre you see a lot of buttons and
functions.when you finish inserting some data,you have something
permanent like a software that remains
> Any security definer function should be designed with security in mind. That
> is the responsibility of the dba. You can't limit the dba in what he can do
> just in case he doesn't know what he is doing. You can suggest, but if the
> dba thinks he knows what he is doing, give him all the tools to
On 30 Jul 2011, at 12:17, Gavin Flower wrote:
>> CREATE OR REPLACE VIEW table_dependencies AS (
>> WITH RECURSIVE t AS (
>> SELECT
>> c.oid AS origin_id,
>> c.oid::regclass::text AS origin_table,
>> c.oid AS referencing_id,
>> c.oid::regclass::text AS referencin
On 30 Jul 2011, at 13:49, Gavin Flower wrote:
> On 30/07/11 10:45, bricklen wrote:
>> [...]
>> CREATE OR REPLACE VIEW table_dependencies AS (
>> WITH RECURSIVE t AS (
>> SELECT
>> c.oid AS origin_id,
>> c.oid::regclass::text AS origin_table,
>> c.oid AS referencing_id,
On 07/31/2011 09:48 AM, Chris Travers wrote:
On Sat, Jul 30, 2011 at 9:50 PM, Sim Zacks wrote:
On one hand the hole can't be plugged because as you mentioned that is the
point of the function. On the other hand, if the function is not being run
as security definer, the account running it would
20 matches
Mail list logo
