On Tue, Apr 29, 2008 at 06:31:30AM +0530, Gurjeet Singh wrote:
> On Mon, Apr 28, 2008 at 8:01 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
> > Postgres doesn't yet handle inheritance of constraints from parent to
> > child tables via inheritance.
> Was it done by design or was it a limitation we coul
On Apr 28, 2008, at 6:50 PM, [EMAIL PROTECTED] wrote:
I want to ask if there is something like nomount state or close
database state
in which I can acces postgresql to drop database or to do some other
stuff.
change the permissions on the DB so nobody can log in. you really
should find
<[EMAIL PROTECTED]> writes:
> For instance if I have the abbreviation "HLA", I would want it to be hit for
> a search on any of the terms "high", "level", or "architecture" or any
> combination thereof. Now from the documentation they have a sample synonym
> dictionary file that contains someth
Hello,
I have been trying to configure the 8.3 text search capabilities using the
documentation from the site from section 12 of 8.3 documentation. I understand
the basics but I am trying to set up a custom synonym dictionary so that I
could have abbreviations be returned as a hit for searches
On Apr 28, 2008, at 8:01 PM, Gurjeet Singh wrote:
On Mon, Apr 28, 2008 at 8:01 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
Postgres doesn't yet handle inheritance of constraints from parent
to child tables via inheritance.
Was it done by design or was it a limitation we couldn't get over?
On Mon, Apr 28, 2008 at 8:01 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> Postgres doesn't yet handle inheritance of constraints from parent to
> child tables via inheritance.
>
>
Was it done by design or was it a limitation we couldn't get over?
Best regards,
--
[EMAIL PROTECTED]
[EMAIL PROTEC
> -Original Message-
> From: Viktor Rosenfeld [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 28, 2008 4:52 PM
> To: Roberts, Jon
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] passing a temporary table with more than one
column
> to a stored procedure
>
> Hi Jon,
>
> Am 28.
Andrus wrote:
User interface need to show nulls as empty strings.
PostgreSQL sorts nulls after all data.
create temp table test ( testcol char(10) );
insert into test values ( null);
insert into test values ( 'test');
insert into test values ( '');
select * from test order by testcol;
This conf
Hello,
I want to ask if there is something like nomount state or close database state
in which I can acces postgresql to drop database or to do some other stuff.
Because when there are some connections, drop database is not
possible. Or is this done some other way?
Lukas Houf
--
Sent via pgsql
Hi Jon,
Am 28.04.2008 um 19:23 schrieb Roberts, Jon:
What does the signature of graphovertokens look like? Three
parmaters
and it doesn't return a setof?
This is my problem. The return type is setof something (doesn't
really matter), but I don't know what to put into the argument list.
On Sat, 2008-04-26 at 20:33 -0400, Robert Treat wrote:
> I think one of the best examples of this is the movie rating system (which I
> blogged about at
> http://people.planetpostgresql.org/xzilla/index.php?/archives/320-PostgreSQL-8.3-Features-Enum-Datatype.html
> )
>
> It's a good example of s
Hi,
Merlin Moncure wrote:
On Thu, Apr 24, 2008 at 3:01 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
Merlin Moncure wrote:
I think you're being a little too hard on enums here. I was actually
in the anti-enum camp until it was demonstrated to me (and in my own
testing) that using enum for na
Jeff escribió:
On Apr 26, 2008, at 8:40 AM, Martin Marques wrote:
Martin Marques escribió:
I'm re-writing documentation I have used in the past to give PG
courses, and at this moment I upgrading the information in my docs to
fit PG 8.3.
What I'm stuck with now is pgiomonitor, which seems to
Pascal Cohen a écrit :
I had a look in previous posts in the forum but could not find the
answer I was looking for.
My question is should I switch from varchar to text.
We have "discovered" although it seems to be SQL that adding something
like 'text ' to a varchar(50) just silent
> is there a way to pass a temporary result table with more than column
> to a stored procedure?
>
> Specifically, I would like to run a variation of this query:
>
> SELECT
> *
> FROM
> graphOverTokens(
> (
> SELECT 1 AS min, 10 AS max, 2 AS text_re
On Apr 26, 2008, at 5:11 PM, wstrzalka wrote:
I have some problem with setting up PITR recovery on the database.
I have archive_command set properly and logs are shipping OK. Archive
timeout is also set (5 min).
When performing pg_start_backup the WAL is lets say on position
000100010
Hi,
is there a way to pass a temporary result table with more than column
to a stored procedure?
Specifically, I would like to run a variation of this query:
SELECT
*
FROM
graphOverTokens(
(
SELECT 1 AS min, 10 AS max, 2 AS text_ref
On Apr 26, 2008, at 8:40 AM, Martin Marques wrote:
Martin Marques escribió:
I'm re-writing documentation I have used in the past to give PG
courses, and at this moment I upgrading the information in my docs
to fit PG 8.3.
What I'm stuck with now is pgiomonitor, which seems to not work due
Chris Browne wrote:
[EMAIL PROTECTED] (Robert Treat) writes:
I feel like some type of counter-argument is that this is probably longer
than one would expect thier database software to last. :-)
That has the counterargument that if the database software works, it's
likely to get used f
[EMAIL PROTECTED] (Robert Treat) writes:
> I feel like some type of counter-argument is that this is probably longer
> than one would expect thier database software to last. :-)
That has the counterargument that if the database software works, it's
likely to get used for longer than one would ex
Martin Marques escribió:
> Is the value measured in some scale, or does it depend on something
> internal? What does 1000 mean?
1000 histogram and MCV entries, and also a larger sample:
>> Increasing the target also increases the number of rows that ANALYZE
>> samples to prepare the stats, so
Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> writes:
How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe one with and index,
and heavily used in SELECT clauses)? If instead of 100 I set a column to
250, which extr
On Apr 27, 2008, at 8:23 PM, Tom Allison wrote:
create table master (
id serial,
mdn varchar(11),
meid varchar(18),
min varchar(11),
constraint mmm_master unique (mdn, meid, min)
);
insert into master(mdn, meid, min)
select mdn, meid, min from test_data where meid !=
'00' limi
On Sat, Apr 26, 2008 at 08:33:28PM -0400, Robert Treat wrote:
> enum types custom ordering. It also showcases the idea of data definitions
> that "should never change", but that do changes every half dozen years or so.
> Now you can argue that since it is expected that the ratings might change i
Martin Marques <[EMAIL PROTECTED]> writes:
> How much, and which extra statistics information will ANALYZE gather if
> I set a higher value for one specific column (maybe one with and index,
> and heavily used in SELECT clauses)? If instead of 100 I set a column to
> 250, which extra data will I
Albe Laurenz wrote:
Pascal Cohen wrote:
I am playing with security in Postgres
And I would like to have a database that can be managed by a given user
that could do almost anything but I would also have a user that can just
handle what is created.
I mean she could insert, update delete row
Hello
I had a look in previous posts in the forum but could not find the
answer I was looking for.
My question is should I switch from varchar to text.
We have "discovered" although it seems to be SQL that adding something
like 'text ' to a varchar(50) just silently cut the text
I'm trying to understand the implications of changing the value of the
STATISTICS of a column with ALTER TABLE, and there are somethings I'm
not understanding correctly.
How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe
28 matches
Mail list logo
