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 f
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 VAR
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 sendin
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
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
I
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), constraint
> -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
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
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
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
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 Post
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
L
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
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
CRE
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 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 informat
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
> -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
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 yo
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, th
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
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.
-
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 wh
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 doable?
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
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 ?
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 p
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,
-Blai
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 to
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
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 applicati
31 matches
Mail list logo