Joey K. wrote:
On Mon, Mar 17, 2008 at 6:58 AM, hogcia [EMAIL PROTECTED] wrote:
Hi,
I have to find a Postgres database process pid (or other
identification) for a given client process pid. Or client processes
for a database process. How are they connected? I was suggested maybe
netstat could
On Mar 18, 2008, at 3:58 AM, Tyler, Mark wrote:
I suggest rethinking your dislike of NOTIFY.
I have thought very hard about using NOTIFY for this but it has two
large problems (from my point of view). The first is that it forces me
to put far more smarts and state into the subscriber
On Mon, Mar 17, 2008 at 8:28 PM, hogcia [EMAIL PROTECTED] wrote:
Hi,
I have to find a Postgres database process pid (or other
identification) for a given client process pid. Or client processes
for a database process. How are they connected? I was suggested maybe
netstat could give me the
Hi
Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
are very usefull but it would be great to have such a feature on the
mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
the template schema relations, etc...
What do you think about it ? Would it be hard
On Tue, Mar 18, 2008 at 3:20 PM, Filip Rembiałkowski
[EMAIL PROTECTED] wrote:
yes.
select setting from pg_settings where name = 'autovacuum';
Ah ha, thankyou! I assumed there must have been a view for the
settings, I guess I missed it when I looked at the various pg_* views.
Cheers,
-Blair
AlannY wrote:
I need a method of extracting information about indexes of any table
from information_schema.
Have you any suggestions?
I am afraid that indexes are not covered by information_schema.
You'd have to dig into pg_catalog.pg_index for this.
Yours,
Laurenz Albe
--
Sent via
wstrzalka wrote:
Hi
Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
are very usefull but it would be great to have such a feature on the
mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
the template schema relations, etc...
What do you think about it ?
On Tue, Mar 18, 2008 at 01:28:36PM +1030, Tyler, Mark wrote:
This
is because I cannot pass any information with the NOTIFY apart from the
fact that something happened.
Oh, you can, you can calculate the name of the NOTIFY
dynamically in the trigger sending the notify, for example
embedding a
Hi Chaps,
We're setting up 3 servers replicating using slony. I was wondering if it'd be
possible for me to create a set of triggers that fire whenever a user is
created/dropped/modified on one of the servers that goes and performs the same
action the other two servers.
Does that sound
On Mar 17, 2008, at 11:25 PM, Blair Bethwaite wrote:
On Tue, Mar 18, 2008 at 3:20 PM, Filip Rembiałkowski
[EMAIL PROTECTED] wrote:
yes.
select setting from pg_settings where name = 'autovacuum';
Ah ha, thankyou! I assumed there must have been a view for the
settings, I guess I missed it
On Mar 17, 2008, at 10:58 PM, Tyler, Mark wrote:
I suggest rethinking your dislike of NOTIFY.
I have thought very hard about using NOTIFY for this but it has two
large problems (from my point of view). The first is that it forces me
Wait a while and you will learn to detest Spread, too.
Joris Dobbelsteen wrote:
wstrzalka wrote:
Hi
Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
are very usefull but it would be great to have such a feature on the
mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
the template schema relations,
Hi,
On Mon, 2008-03-17 at 21:26 -0500, Adam Rich wrote:
Next, one of my apps failed because of a dependency on libpq.so.4.
During previous upgrades, I remedied that by installing this package:
compat-postgresql-libs-4-2PGDG.rhel4
But it seems under the 8.3.0 binary downloads, this
On Tue, Mar 18, 2008 at 9:00 AM, Dan Searle [EMAIL PROTECTED] wrote:
I've racked my brain about this but can't think of a simple solution,
even though this appears to be a simple problem, any suggestions much
appreciated.
Your fact is split across more than one row.
I recommend that you
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Albe Laurenz
Sent: Tuesday, March 18, 2008 1:24 AM
To: AlannY *EXTERN*; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Get index information from information_schema?
AlannY wrote:
On Mon, Mar 17, 2008 at 9:01 PM, wstrzalka [EMAIL PROTECTED] wrote:
Hi
Features like CREATE DATABASE WITH TEMPLATE or CREATE TABLE LIKE
are very usefull but it would be great to have such a feature on the
mid-level too. I mean something CREATE SCHEMA LIKE that would copy all
the
On Mar 18, 2008, at 1:28 PM, Dann Corbit wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Albe Laurenz
Sent: Tuesday, March 18, 2008 1:24 AM
To: AlannY *EXTERN*; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Get index
Hello,
I'm currently camping with a bit of a problem -- i have a common
requests table, and based on an entry's type, I need to join a
specific other table. Consider this database layout:
###
-- table where all common request data is stored
CREATE TABLE log.requests (
id
On Mar 18, 2008, at 8:06 PM, Leon Mergen wrote:
Hello,
Now, based on a previous post on the PostgreSQL mailing list
[http://archives.postgresql.org/pgsql-general/2007-11/msg00723.php] I
came up with this solution:
###
-- table where all common request data is stored
Hello Alban,
On 3/18/08, Alban Hertroys [EMAIL PROTECTED] wrote:
Now, in my theory, you would say that if postgresql encounters ref1 =
NULL, it will not attempt to JOIN the log.requests1 table. However,
I've been told that because the PostgreSQL planner doesn't know that
ref1 (or any
Hello!
My filesystem (UFS-FreeBSD) was crashed and I have lost files from
PGSQL DATA DIR FOLDER after fsck-utility.
I have lost files from directory pg_xlog
I reset my pg_xlog.
And now have such error by starting pgsql-server:
LOG: database system was interrupted at 2008-03-18 22:29:48 EET
On Mar 18, 2008, at 3:06 PM, Leon Mergen wrote:
Hello Alban,
On 3/18/08, Alban Hertroys [EMAIL PROTECTED]
wrote:
Now, in my theory, you would say that if postgresql encounters
ref1 =
NULL, it will not attempt to JOIN the log.requests1 table. However,
I've been told that because the
Hello Erik,
On 3/18/08, Erik Jones [EMAIL PROTECTED] wrote:
Table partitioning is normally implemented via table inheritance and
you are free to add more, and different, columns to the child tables.
Observe:
CREATE SEQUENCE part_seq;
CREATE TABLE parent (
id integer PRIMARY
On Mar 18, 2008, at 3:50 PM, Leon Mergen wrote:
Ah, silly that I failed to understand that.
Nah, we all do that stuff.
Thanks a lot for your response (Alban too) -- I can see table
partitioning solving my problem.
You're welcome!
Erik Jones
DBA | Emma®
[EMAIL PROTECTED]
800.595.4401 or
On Wed, Mar 19, 2008 at 1:29 AM, Erik Jones [EMAIL PROTECTED] wrote:
SHOW autovacuum;
That's even better, thanks Erik.
Cheers,
-Blair
--
In science one tries to tell people, in such a way
as to be understood by everyone, something that
no one ever knew before. But in poetry, it's the
exact
-Original Message-
From: Erik Jones [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 11:51 AM
To: Dann Corbit
Cc: Albe Laurenz; AlannY *EXTERN*; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Get index information from information_schema?
On Mar 18, 2008, at 1:28 PM,
On Mar 18, 2008, at 5:42 PM, Dann Corbit wrote:
correct results for this query:
create table t1 (c1 int not null, c2 int not null, c3 char(5), c4 int,
c5 int, constraint pk_t1 PRIMARY KEY (c5,c4));
create table t2 (tc1 int not null, c1 int not null, c2 int not null,
c5
char(5),
Vivek Khera wrote:
Wait a while and you will learn to detest Spread, too.
I know this is probably off-topic for this group but why do you say
this? I guess I don't want to go too far down a particular route if
there are big traps waiting so I am interested in the basis for your
comment.
Mark
Alban Hertroys wrote:
On Mar 18, 2008, at 3:58 AM, Tyler, Mark wrote:
I suggest rethinking your dislike of NOTIFY.
I have thought very hard about using NOTIFY for this but it has two
large problems (from my point of view). The first is that it forces
me
to put far more smarts and state into
Karsten Hilbert wrote:
On Tue, Mar 18, 2008 at 01:28:36PM +1030, Tyler, Mark wrote:
This
is because I cannot pass any information with the NOTIFY apart from
the fact that something happened.
Oh, you can, you can calculate the name of the NOTIFY dynamically
in the trigger sending the
hi,
i have an issue with tseach2, i just installed postgresql 8.3.1 on windows
using UTF8 server encoding / client encoding and LOCALE Canada / French.
CREATE DATABASE mydbWITH OWNER = me ENCODING = 'UTF8';
CREATE TABLE product
(
product_id SERIAL NOT NULL,
name
On Mar 19, 2008, at 2:35 AM, Tyler, Mark wrote:
Alban Hertroys wrote:
On Mar 18, 2008, at 3:58 AM, Tyler, Mark wrote:
I suggest rethinking your dislike of NOTIFY.
I have thought very hard about using NOTIFY for this but it has two
large problems (from my point of view). The first is that it
32 matches
Mail list logo