On Thursday 31 May 2007 19:42:20 Alvaro Herrera wrote:
> It is. But why do you care? You either have the correctness that
> NUMERIC gives, or you don't.
Because FLOAT8 can be precise enough for some application and not
enough for other ones.
--
Vincenzo Romano
--
Maybe Computer will never beco
Hi All,
I want to create a user in Postgres Database. And I want to restrict that user
with some privileges. And also I want that user should be specific to
particular database.
He should not be able to do the following
1) Connect to any other database.
2) Connect to System da
Thanks for your reply!
I was run gdb and errfinish but didn't get much help because I write to
list.
Yes the first datas ( datums[0-2] ) are char* / VARCHAR types and if I
call SPI_modifytuple( ( trigdata->tg_relation, tmptuple, 3, &attnum[0],
&datums[0], &isNull[0] ) than everything is OK.
Jus
hello,
you have to initialise array before using. Like:
declare a int[] = '{0,0,0,0,0, .}';
begin
a[10] := 11;
..
reason: older postgresql versions unsuported nulls in array
regards
Pavel
2007/5/31, Anton <[EMAIL PROTECTED]>:
Hi.
I want to use array for store some values (b
Ian Harding wrote:
On 5/31/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Ian Harding wrote:
> tsearch indexes have to reside in the table where the data is, for the
> automagical functions that come with it to work. You can define a
> view that joins the tables, then search each of the index c
On 5/31/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Ian Harding wrote:
> tsearch indexes have to reside in the table where the data is, for the
> automagical functions that come with it to work. You can define a
> view that joins the tables, then search each of the index columns for
> the val
Tom Allison <[EMAIL PROTECTED]> writes:
> select v.history.idx, v.token_idx
> from (
> values ((3,1),(3,2))) as v(history_idx, token_idx)
> left outer join history_token ht on v.history_idx = ht.history_idx
> and v.token_idx = ht.token_idx
> where ht.history_idx is null;
> ERROR: operator does not
=?ISO-8859-2?Q?Dud=E1s_J=F3zsef?= <[EMAIL PROTECTED]> writes:
> I know that something doing wrong, but I can't find out what is it.
Getting a stack trace from the point of the errfinish call would
probably help narrow it down. One thing that's not clear is whether
SPI_modifytuple itself is failin
Ottavio Campana wrote:
Joshua D. Drake wrote:
Ottavio Campana wrote:
Bill Moran wrote:
Ottavio Campana <[EMAIL PROTECTED]> wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single
database.
Can I get the same
On Thu, 31 May 2007, Marco Colombo wrote:
archive_command = 'test ! -f /var/lib/pgsql/backup_lock Under normal condition (no backup running) this will trick PG into thinking
that segments get archived. If I'm not mistaken, PG should behave exactly as
if no archive_command is configured, and re
Joshua D. Drake wrote:
> Ottavio Campana wrote:
>> Bill Moran wrote:
>>> Ottavio Campana <[EMAIL PROTECTED]> wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single
database.
Can I get the
Ottavio Campana wrote:
Bill Moran wrote:
Ottavio Campana <[EMAIL PROTECTED]> wrote:
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one data
Hi,
is there a packet source for recent PostgreSQL binaries?
I just finished installing OpenSUSE 10.2 and like to add PostgreSQL
8.2.4 instead of the provided 8.1.5.
I'd rather go with something that is at least vaguely official.
PostgreSQL.org has only binaries for fedora+redhat and I found only
I did something like this with a single VALUES statment [eg: VALUES
((2),(3))]
and thought I could extend this to two columns
But I'm not having any luck.
BTW - history_idx is an integer and token_idx is a bigint.
select v.history.idx, v.token_idx
from (
values ((3,1),(3,2))) as v(history_
Bill Moran wrote:
> Ottavio Campana <[EMAIL PROTECTED]> wrote:
>> I have postgresql running several databases. I can stop them all by
>> stopping postgresql, but sometimes I'd like to shut down a single database.
>>
>> Can I get the same effect of stopping postgresql for only one database?
>
> You
Ottavio Campana <[EMAIL PROTECTED]> wrote:
>
> I have postgresql running several databases. I can stop them all by
> stopping postgresql, but sometimes I'd like to shut down a single database.
>
> Can I get the same effect of stopping postgresql for only one database?
You can tweak pg_hba.conf to
I have postgresql running several databases. I can stop them all by
stopping postgresql, but sometimes I'd like to shut down a single database.
Can I get the same effect of stopping postgresql for only one database?
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
D
Hello Everybody!
I know that something doing wrong, but I can't find out what is it. This
is a part from trigger function:
/
attnum[3] = SPI_fnumber( tupdesc, "arfolyam" );
datums[3] = _selectFunctionB( "SELECT ertek FROM foo WHERE
parameter='rate'" ); // this come back with Datum type from se
Greg Smith wrote:
[...]
-Find something harmless I can execute in a loop that will generate WAL
activity, run that until the segment gets archived. Haven't really
thought of something good to use for that purpose yet.
Some time ago I started a thread about taking on-the-fly backups at file
l
On Thu, 31 May 2007 23:36:32 +0200, PFC <[EMAIL PROTECTED]> wrote:
On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera <[EMAIL PROTECTED]> wrote:
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creat
On Thu, 31 May 2007 22:20:09 +0200, Vivek Khera <[EMAIL PROTECTED]> wrote:
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creation steps pretty effectively
--- and that's where all the time goes.
On Thu, May 31, 2007 at 04:07:25PM -0400, Tom Lane wrote:
> the kernel rejected the connection before looking for a listening process.
or a host-based firewall might produce the same result.
---(end of broadcast)---
TIP 3: Have you checked our exten
On May 31, 2007, at 14:53 , Hackenberg, Rick wrote:
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new
entry into a table I receive the following message:
ERROR: permission denied for sequnce contractid
Please
On 5/31/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
I understand that it is possible for tables from different databases that
have the exact same data
but different Encoding can sort rows in differet orders.
Could this allow affect the order that triggers and rules are fired?
This mi
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> I understand that it is possible for tables from different databases that
> have the exact same data
> but different Encoding can sort rows in differet orders.
> Could this allow affect the order that triggers and rules are fired?
AFAIK, no --- t
On May 25, 2007, at 5:28 PM, Tom Lane wrote:
That's true at the level of DDL operations, but AFAIK we could
parallelize table-loading and index-creation steps pretty effectively
--- and that's where all the time goes.
I would be happy with parallel builds of the indexes of a given
table. T
I understand that it is possible for tables from different databases that have
the exact same data
but different Encoding can sort rows in differet orders.
Could this allow affect the order that triggers and rules are fired?
Regards,
Richard Broersma Jr.
---(end of broad
I am currently having a problem with an application that has been
working fine for the past few months. Whenever I try to add a new entry
into a table I receive the following message:
ERROR: permission denied for sequnce contractid
I have checked the permission for this sequence as well as the ot
"Bhavana.Rakesh" <[EMAIL PROTECTED]> writes:
> Here's what happens when I specify the port number
> [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
> psql: could not connect to server: Connection refused
> Is the server running on host "127.0.0.1" and accepting
>
On May 23, 2007, at 1:12 PM, Donald Laurine wrote:
Now my question. The performance of each of these databases is
decreasing. I measure the average insert time to the database. This
metric has decreased by about 300 percent over the last year. I run
vacuum analyze and vacuum analyze full o
Hi.
I want to use array for store some values (bytes_in and bytes_out) and
use array index as "id". But I got an errors...
My example function extract traf_id, bytes_in, bytes_out and try to
fill an array, like this
CREATE OR REPLACE FUNCTION myf_test() RETURNS void
AS $$
DECLARE
p_tmp RECORD;
p
I found out that using 'simple' instead of 'default' when using
to_tsvector() does excactly that, but I don't know how to change my
triggers and indexes to keep doing the same (using 'simple').
Suppose, your database is initialized with C locale. So, just mark
simple configuration as default:
On Thu, 31 May 2007, Erwin Moller wrote:
Hi all,
I installed TSEARCH2 on Postgres8.1 (Debian).
It runs all fine.
I have 2 tables indexed, and created triggers to keep the vectorcolumns
up
to date.
However, the text I indexed is a mix of Dutch and English and German.
The default stemmingproces
Ian Harding wrote:
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
No they don't.
Joshua D. Drake
Vincenzo Romano escribió:
> Hi all.
> I'd like to know whether there is any "real world" evaluation (aka test) on
> performances of the NUMERIC data type when compared to FLOAT8 and FLOAT4.
> The documentation simply says that the former is "much slower" than the latter
> ones.
It is. But why do
tsearch indexes have to reside in the table where the data is, for the
automagical functions that come with it to work. You can define a
view that joins the tables, then search each of the index columns for
the values you are looking for.
In my experience, the LIKE searches are fast for relative
Hi all.
I'd like to know whether there is any "real world" evaluation (aka test) on
performances of the NUMERIC data type when compared to FLOAT8 and FLOAT4.
The documentation simply says that the former is "much slower" than the latter
ones.
I'd also be interested into data storage evaluations.
Bhavana.Rakesh escribió:
> Hi,
> Here's what happens when I specify the port number
>
> [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
> psql: could not connect to server: Connection refused
>Is the server running on host "127.0.0.1" and accepting
>TCP/IP
On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
> Hi,
> Here's what happens when I specify the port number
>
> [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
> psql: could not connect to server: Connection refused
> Is the server running on host "127.0.0.
Tom Lane schrieb:
> Are you sure the master is checkpointing?
Yes. I double checked using pg_controldata on the master.
On both servers checkpoint_segments is set to 16 and checkpoint_timeout
is 300 seconds default.
There were two messages in the logs of the master that checkpointing
happened too
Thiago Ventura escribió:
> The manual say:
> The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
> characters from the following list:
> + - * / < > = ~ ! @ # % ^ & | ` ?
>
> So, how I could create a operator with word ( i.e. LIKE ) ?
You can't. (Unless you hack Postgres' sour
Vincenzo Romano <[EMAIL PROTECTED]> writes:
>
>> STABLE indicates that the function cannot modify the database,
> They talk about table scans which should not involce the information schema
> tables, the only tables that get modified by a fubction whose sole effect it
> to create other functions.
Frank Wittig <[EMAIL PROTECTED]> writes:
> The problem is that the slave server stops checkpointing after some
> hours of working (about 24 to 48 hours of conitued log replay).
Hm ... look at RecoveryRestartPoint() in xlog.c. Could there be
something wrong with this logic?
/*
* Do nothi
W/out specifying a -h switch, postgres defaults to using a UNIX domain
socket, meaning AF_UNIX and not AF_INET. There is a big difference.
Using -h 127.0.0.1 is the localhost not necessarily 'local' from the
context of postgres. W/out looking into the details, I think 'local' is
referring to A
What does netstat -l tell us about that?
On Thu, May 31, 2007 at 02:50:50PM +0100, Oliver Elphick wrote:
> On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
> > Hi,
> > Here's what happens when I specify the port number
> >
> > [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -
The manual say:
The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
characters from the following list:
+ - * / < > = ~ ! @ # % ^ & | ` ?
So, how I could create a operator with word ( i.e. LIKE ) ?
---(end of broadcast)---
TIP 6:
Good points: I was struggling this very direction.
I think that the really good point to encode the dependencies
as comments into the SQL files themselves.
The hard parto is to let "make" follow the dependencies.
If I change a single SQL script I'd need to:
1. drop all objects that are in that fi
On Thu, 2007-05-31 at 09:01 +0200, Vincenzo Romano wrote:
> Scripts have been named so that the lexicographical order of filenames
> brings
> the information about dependencies.
>
> I've been playing with the GNU Make itself but it's quite hard to keep
> track
> of changes and to re-load a single
Hi,
Here's what happens when I specify the port number
[EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -d testing123
psql: could not connect to server: Connection refused
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5000?
I have the
What is listen_addresses set to in postgresql.conf?
'*' corresponds to all available IP interfaces. Maybe
you are not listening on localhost.
On Thu, May 31, 2007 at 08:57:41AM -0400, Bhavana.Rakesh wrote:
> Ok,
> I confirmed that I'm editing the right pg_hba.conf file. I made sure
> that th
On 5/31/07, Bhavana.Rakesh <[EMAIL PROTECTED]> wrote:
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made sure that
there are no other postmasters running. I made sure that there is a user
called 'brakesh'. I restart the postmaster everytime I make any changes to
pg_hba.conf
Ok,
I confirmed that I'm editing the right pg_hba.conf file. I made sure
that there are no other postmasters running. I made sure that there is
a user called 'brakesh'. I restart the postmaster everytime I make any
changes to pg_hba.conf file. But still same results!
[EMAIL PROTECTED] ~/d
2007/5/31, Vincenzo Romano <[EMAIL PROTECTED]>:
Nonetheless your remark makes a lot of sense and I'm still in dubt.
In my case the "creatorfunc" has no parameters and returns void as it reads
data from configuration tables.
And it should be OK if ti were run only once.
AFAIK, the only practica
On May 30, 6:48 am, Rodrigo De León <[EMAIL PROTECTED]> wrote:
> You might want to add:
>
> AND a.attnum >=1
>
> to remove "tableoid" and friends from the output.
Now I know why I did not get tableoid & friends: because I am querying
a view which does not yield these fields. But to be on the
On Thursday 31 May 2007 13:23:36 Filip Rembiałkowski wrote:
> 2007/5/31, Vincenzo Romano <[EMAIL PROTECTED]>:
> > Hi all.
> >
> > Can functions whose effect is to create functions (yep!)
> > be labelled as "stable"?
>
> According to the docs, no.
>
> "STABLE indicates that the function cannot modif
Hi all,
I installed TSEARCH2 on Postgres8.1 (Debian).
It runs all fine.
I have 2 tables indexed, and created triggers to keep the vectorcolumns
up
to date.
However, the text I indexed is a mix of Dutch and English and German.
The default stemmingprocess is an annoyance for me.
I would like
2007/5/31, Vincenzo Romano <[EMAIL PROTECTED]>:
Hi all.
Can functions whose effect is to create functions (yep!)
be labelled as "stable"?
According to the docs, no.
"STABLE indicates that the function cannot modify the database (...)
any function that has side-effects must be classified volat
Hello list,
I have a problem regarding running a warm standby server as described in
the postgresql 8.2 documentation.
I set up two servers. Both running PostgreSQL 8.2.3-1PGDG on Fedora Core
6 (x86_64). (Master driven by AMD Opteron / Slave running on Intel Xeon)
The master server copys its WAL
Hi all.
Can functions whose effect is to create functions (yep!)
be labelled as "stable"?
Thanks.
--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]
---(end of broadcast)-
Thank you, Michael! I'm looking some examples and doing tests to find the
best search solution.
Best,
On 5/30/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On May 30, 2007, at 13:59 , Gabriel Laet wrote:
> I'm developing an application where basically I need to store cars.
> Every car ha
On Thursday 31 May 2007 09:01, Vincenzo Romano wrote:
| As I need to maintain a rather large set of PgSQL scripts, I'd like to
| use something like "make" in order to track changes and apply the
| "proper" variations to the database.
|
| Scripts have been named so that the lexicographical order of
On 30.05.2007 23:31, Kevin Kempter wrote:
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight transactions but alos
un-sync'd buffer-pool dirty pages?
If so, how might I minimize this risk ?
If you have DRBD using pro
Hi all.
As I need to maintain a rather large set of PgSQL scripts, I'd like to
use something like "make" in order to track changes and apply the
"proper" variations to the database.
Scripts have been named so that the lexicographical order of filenames brings
the information about dependencies.
I
63 matches
Mail list logo
