asfar khan wrote:
Hi Everyone
Please any one provide me the details of creating dblink ibetween two
server n postgress.
What problems are you currently seeing? What are you trying at the
moment and what error message(s) do you get?
--
Richard Huxton
Archonet Ltd
Ledina Hido wrote:
Hi,
I have just today installed the new version of PostgreSQL (8.1.0), and
my old code seems to have stopped working.
I am basically trying to delete a row from a table:
DELETE FROM "CON" WHERE "ref"='CON5';
I have checked and CON5 is definitively in the CON table. I trie
Hi community,
I would like to declare a function with IN and OUT
parameters as well as a refcursor as return value.
For example something like this:
This doesn’t work. It gives the compilation error
‘ERROR: function result type must be integer because of OUT parameters’
CREATE OR
On Thu, Nov 24, 2005 at 09:26:07AM +0100, Frank Motzkat/IC3S AG wrote:
> Hi community,
>
> I would like to declare a function with IN and OUT parameters as well as a
> refcursor as return value.
>
> For example something like this:
>
> This doesn???t work. It gives the compilation error ???ERRO
>> Trying to use same approach with Postgres fails. Postgres
>> requires special user account and is not capable to create
>> this account without user intervention.
>
> Sure, it's very much capable of diong that. See
> http://pginstaller.projects.postgresql.org/silent.html, specifically
> look for
Hi guys,
Thanks for you suggestions.
After a long night I found out what the problem was. I had a trigger
for deletes on table CON, and the trigger returned NEW at the end
instead of OLD.
Thanks again,
Ledina
PS I didn't really think 8.1 delete had stopped working. It was just
far too e
Hello everyone,
We encounter the following two strange errormessages when working
with temporary tables.
1) ERROR: duplicate key violates unique constraint
"pg_type_typname_nsp_index"
2) ERROR: tuple concurrently updated
This is how:
To cache large resultsets of searches we select them
am 24.11.2005, um 8:25:15 +0100 mailte Harald Armin Massa folgendes:
> Bruce,
> list,
>
> I translated that part to german, I know the source is strong in Germany -
> maybe it can be a helpfull addition - even if most speak English, they are
> even more happy to read sth. in German.
Nice Idea ;
Dear all,
I have written a function that returns a set. This set is of a type I
made, containing multiple attributes.
create type my_type as (col1 int, col2 int)
Something likes this works:
select col1 from my_pg_func('hello');
But how can I do something like this:
select my_pg_func(t
On 23/11/05 10:20 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Whats the best way to zero the bad block?
>
> Probably dd from /dev/zero, along the lines of
>
> dd bs=8k seek=597621 count=1 conv=notrunc if=/dev/zero of=relation
>
> (check this before you
Don't forget to CC: the list - that way everyone can help.
asfar khan wrote:
My problem is that I have two postgress server on window platform. I
would like to know how to communicate between them.
Ah - can't help you here. I don't run PG on Windows. Is there an option
on the installer?
1
Hi,
I'm new to postgresql and i have an easy question to ask. I have
installed postgresql 8.1 on windows 2000 and i want to use it with my
app developed with php 5 + apache 2.
All works well but i need to know if this is possible :
I use pgAdminIII as administration tool an i need to create a
rest
Adam Witney <[EMAIL PROTECTED]> writes:
> Just wanted to clarify, should this not be
> dd bs=8k seek=7 count=1 conv=notrunc if=/dev/zero of=134401991.4
Looks reasonable.
regards, tom lane
---(end of broadcast)---
TIP 4:
Alexander Presber <[EMAIL PROTECTED]> writes:
> We encounter the following two strange errormessages when working
> with temporary tables.
> 1) ERROR: duplicate key violates unique constraint
> "pg_type_typname_nsp_index"
> 2) ERROR: tuple concurrently updated
The first of these looks like
I know that within a trigger function the functin name can be referenced
by the special variable TG_NAME, so I could include raise an exception
that identified its source with a line like:
RAISE EXCEPTION ''ERROR IN %'', TG_NAME;
Is there a similar set of special variables defined for "no
On 24/11/05 2:48 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Just wanted to clarify, should this not be
>> dd bs=8k seek=7 count=1 conv=notrunc if=/dev/zero of=134401991.4
>
> Looks reasonable.
>
> regards, tom lane
Excellent thanks. I have run it
Adam Witney <[EMAIL PROTECTED]> writes:
> bugasbase2=# vacuum;
> WARNING: relation "mba_data_base" page 597621 is uninitialized --- fixing
This is the expected result of what you did.
> WARNING: relation "mba_data_base" page 640793 is uninitialized --- fixing
> WARNING: relation "mba_data_base
On 24/11/05 3:52 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> bugasbase2=# vacuum;
>> WARNING: relation "mba_data_base" page 597621 is uninitialized --- fixing
>
> This is the expected result of what you did.
>
>> WARNING: relation "mba_data_base" page
Hi. Where would I locate information on setting up postgres as a stand
alone db for a gui application. I am writing this in python and have
been using sqlite but would like to try my app with postgres backend.
Links to any specific open source example would be helpful. The only
user would be
On 11/24/05, David Pratt <[EMAIL PROTECTED]> wrote:
> Hi. Where would I locate information on setting up postgres as a stand
> alone db for a gui application. I am writing this in python and have
> been using sqlite but would like to try my app with postgres backend.
> Links to any specific open
Adam Witney <[EMAIL PROTECTED]> writes:
> If you mean by that, this:
> select * from mba_data_base where ctid = '(640792,12)';
> select * from mba_data_base where ctid = '(640799,1)';
> Then the data looks normal... Of course everything in between that is now
> blank.
The question is, can you te
Hi,
I'm curious as to what the general opinion is on these different
queries and their relative merits, especially in terms of speed:
-
select count(*) from zstore_temp where product_code not in (select
product_code from zstore)
QUERY PLAN
-
On 24/11/05 4:19 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> If you mean by that, this:
>
>> select * from mba_data_base where ctid = '(640792,12)';
>> select * from mba_data_base where ctid = '(640799,1)';
>
>> Then the data looks normal... Of course e
On Thu, Nov 24, 2005 at 08:25:15AM +0100, Harald Armin Massa wrote:
> I translated that part to german, I know the source is strong in Germany -
> maybe it can be a helpfull addition - even if most speak English, they are
> even more happy to read sth. in German.
I suggest the German translation b
Adam Witney <[EMAIL PROTECTED]> writes:
> On 24/11/05 4:19 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>> The question is, can you tell whether any data is actually missing?
> Well each of these datasets are about 20,000 rows each... So I can tell
> which one is in (640792,12) and in (640799,1), the
On 24/11/05 4:42 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> On 24/11/05 4:19 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
>>> The question is, can you tell whether any data is actually missing?
>
>> Well each of these datasets are about 20,000 rows each...
Hi Jaime. I currently work with psycopg with web apps. My question is
more a matter of whether postgres can be installed in a way that keeps
it contained to the program files for the app (as opposed to the
regular type of install where postgres becomes available as a server
available anywhere
David Pratt wrote:
> Hi. Where would I locate information on setting up postgres as a
> stand alone db for a gui application.
This is not possible.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 9: In ve
Adam Witney <[EMAIL PROTECTED]> writes:
> Does this help identifying what went wrong?
At this point I think there's no question that your filesystem is
dropping blocks :-(. Might want to check for available kernel updates,
or contemplate changing to a different filesystem.
On 24/11/05 5:28 pm, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Adam Witney <[EMAIL PROTECTED]> writes:
>> Does this help identifying what went wrong?
>
> At this point I think there's no question that your filesystem is
> dropping blocks :-(. Might want to check for available kernel updates,
> or
David Welton <[EMAIL PROTECTED]> writes:
> I'm curious as to what the general opinion is on these different
> queries and their relative merits, especially in terms of speed:
You really should do EXPLAIN ANALYZE rather than assuming that the
planner's estimates are reliable.
The NOT IN case, at l
I migrated one database from 8.0 to 8.1That I used to do add "without oids" to all tables.First step so:pg_dump --schema-only -U user databasethe file was edited, all tables to "withoud oids"; and reloaded in
8.1After that I pg_dump --data-only -U user databaseand tried to reload the data. But it
"Tom Lane" <[EMAIL PROTECTED]> wrote
>
> At this point I think there's no question that your filesystem is
> dropping blocks :-(.
It is very interesting to follow this thread. But at this point, can you
explain more why "there is no question" is file system's fault?
Thanks,
Qingqing
---
Harald Armin Massa wrote:
> [snipped text]
pg_dump --data-only -U user database
and tried to reload the data. But it fails on foreign keys: depending tables
are being dumped before the tables they depend on.
I solved it by manually dumping the relevant tables and reloading them,
Now I cannot f
Harald Armin Massa wrote:
I migrated one database from 8.0 to 8.1
That I used to do add "without oids" to all tables.
First step so:
pg_dump --schema-only -U user database
the file was edited, all tables to "withoud oids"; and reloaded in 8.1
After that I
pg_dump --data-only -U user databa
Please, suggest any free/opensource tool for DB design under Linux. I
need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
don't even dream about reverse transformation...) Quite good example
of such tool is Sybase PowerDesigner (which supports Postgres), but
AFAIK it runs only un
Am Freitag, den 25.11.2005, 02:25 +0300 schrieb Nikolay Samokhvalov:
> Please, suggest any free/opensource tool for DB design under Linux. I
> need following: ER (or UML)-diagram -> physical diagram -> SQL code (I
> don't even dream about reverse transformation...) Quite good example
> of such tool
using postgresql 8.1 on Ubuntu Breezy
I cannot connect to a database I created - checking \du the username is
listed. I also created a password with #ALTER ROLE WITH PASSWORD
'' I tried without password but it calls for a password. Any ideas?
Warning: pg_connect() [function.pg-co
John Taber <[EMAIL PROTECTED]> writes:
> using postgresql 8.1 on Ubuntu Breezy
> I cannot connect to a database I created - checking \du the username is
> listed. I also created a password with #ALTER ROLE WITH PASSWORD
> '' I tried without password but it calls for a password. Any i
I'm running PostgreSQL 8.0.3, the latest stable ebuild, on Gentoo linux.
1) Am I inviting any problems in linux by moving the directory
/var/lib/postgresql to /home/postgresql, and then symlinking
/home/postgresql back to /var/lib/postgresql? The reason for this is
to avoid having databases,
hello everyone,
in case i need to give a value which has apostrophe
as one of the characters i need to escape it.
and similary for the characters such as
backslash.
what other characters need to be escaped. Is there any list
published?
cant this be fixed in postgres?
thanks
regards
Sura
On Nov 25, 2005, at 13:12 , surabhi.ahuja wrote:
in case i need to give a value which has apostrophe as one of the
characters i need to escape it.
and similary for the characters such as backslash.
http://www.postgresql.org/docs/current/interactive/sql-
syntax.html#SQL-SYNTAX-STRINGS
Mic
i have a small query.
when i start postmaster the postmaster.pid file is created by default in
the PGDATA directory.
but in case that directory gets full if i try to restart postmaster ...
it fails because there is not enough space to create the postmaster.pid
file/
My question is that
wh
this is in continuation of the problem i was facing
some time back.
if i try to start postmaster ...it times out.
what can be the possible cause of it . I also have seen a core file being
generated.
in case such a thing happens ... what shuld i be doing?
how can i recover my database in suc
Title: Re: [GENERAL] regarding the apostrophe character
in which version will the use
of "Escape string syntax " be supported ..
thanks,
regards
From: Michael Glaesemann
[mailto:[EMAIL PROTECTED]Sent: Fri 11/25/2005 9:50 AMTo:
surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re:
"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> My question is that
> while starting postmaster is there an option to specify the location of =
> postmaster.pid file ..
> i was thinking if i can keep the postmaster.pid file in a separate =
> folder ..because that folder rarely gets full.
You do real
Walter Dnes wrote:
I'm running PostgreSQL 8.0.3, the latest stable ebuild, on Gentoo linux.
1) Am I inviting any problems in linux by moving the directory
/var/lib/postgresql to /home/postgresql, and then symlinking
/home/postgresql back to /var/lib/postgresql? The reason for this is
to avoi
I haven't seen anything to indicate that 8.x improves foreign key
refererence locking and fixes the foreign key 'deadlock detected' issue.
Has that been addressed in 8.1?
I sort my records before loading, but am still getting 'deadlock detected'
(still running 7.3.4).
I have
B references C
B
On 11/25/05, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
if i try to start postmaster ...it times out.
what can be the possible cause of it . I also have seen a core file being
generated.i ll again copy paste the script i am using for starting up and shutting
down postmasterPOSTGRES_LOG="$SDCHOME/nu
49 matches
Mail list logo
