Hello all
could you please tell me if there are any dataware housing tools for postgresql
Thanks in advance
vamsee
Joseph Shraibman writes:
> Does plpgsql not short circuit its logic?
We make no guarantees about evaluation order. In the particular
case at hand, you're losing because plpgsql has to evaluate all
the variables that it's going to pass into the SQL engine for
that expression. Break it into two
I'm trying to do this:
IF TG_OP = \'INSERT\' OR (TG_OP = \'UPDATE\' AND OLD.status <>
NEW.status) THEN
..but pg is complaining:
ERROR: record "old" is not assigned yet
DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.
CONTEXT: PL/pgSQL function "set_dir_count" lin
On 19/07/2006, at 4:24 AM, Christian Rengstl wrote:
now finally after a long time i have the query plan for the whole
filled table. I hope somebody can explain me why it takes so much
longer...
These explain analyze results don't appear to be from the queries you
posted previously. For
Tom Lane wrote:
> Eric Faulhaber <[EMAIL PROTECTED]> writes:
>> OK, but this particular issue is something quite new to the latest
>> version.
>
> Again, PG has never stored such data correctly.
>
Perhaps not, but it silently tolerated such data until this release, at
least at the encoding conve
Eric Faulhaber <[EMAIL PROTECTED]> writes:
> OK, but this particular issue is something quite new to the latest
> version.
Again, PG has never stored such data correctly.
> Am I stuck at 8.1.3 for the time being? I'd be happy to create a patch
> to resolve this for a future version, but if it is
Larry Rosenman wrote:
Reid Thompson wrote:
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will als
Greg, Florian, Joshua, Tom-
On Fri, 2006-07-14 at 17:02 -0700, Gregory S. Williamson wrote:
> You need to edit the postgresql.conf file and increase the
> max_fsm_pages and max_fsm_relations parameters and then restart
> postgres
I did this and vacuumed. I didn't need to up shmmax. The problem
Reid Thompson wrote:
> Using a legacy installation ( 7.2.3 ).
> Occasionally the system will reach a state where attempted psql
> connection attempts fail, with the following error in the postgresql
> log:
> postmaster: StreamConnection: accept: No such device or address
>
> Will also occasionally
Using a legacy installation ( 7.2.3 ).
Occasionally the system will reach a state where attempted psql
connection attempts fail, with the following error in the postgresql
log:
postmaster: StreamConnection: accept: No such device or address
Will also occasionally get "no connection to server" erro
On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote:
> i created a function and it takes a long time to run. I was testing it
> as a wrote it and to the first drop table it takes just short of a
> second. however when the rest of the code is added on, it takes
> upwards of 5 minutes. Not t
On 7/18/06, Christian Rengstl
<[EMAIL PROTECTED]> wrote:
now finally after a long time i have the query plan for the whole filled table.
I hope somebody can explain me why it takes so much longer...
QUERY PLAN
On Friday 14 July 2006 11:22, Tom Lane wrote:
> "Darren" <[EMAIL PROTECTED]> writes:
> > When I login to phppgadmin, the list of databases does not include any
> > databases that are owned by a 'group' (i.e. a role with NOLOGIN set).
>
> I'm betting that phppgadmin is using something like an inner
Hi, I just wanted to verify that there is nothing wrong with storing a Posgreql database on a DRDB partition. I read some old emails about there being problems, but the more recent ones seem to imply it should work fine.
I'm using two SUSE SLES 9 servers with Heartbeat to fail over some custom se
Tom Lane wrote:
> Eric Faulhaber <[EMAIL PROTECTED]> writes:
>> Can anyone help me understand why converting the NULL code point ()
>> from UTF8 to ISO8859_1 is no longer legal in v8.1.4?
>
> Embedded nulls in text strings have never behaved sanely in PG ... or
> hadn't you noticed? You'd hav
Thanks, Erik another possible solution would also be this.
Here it is in case you are interested.
On 7/18/06, Tony Wasson <[EMAIL PROTECTED]> wrote:
> On 7/18/06, Curtis Scheer <[EMAIL PROTECTED]> wrote:
> > Does anyone have any examples of how I would make a stored procedure
> > in plpgsql tha
Erik Jones wrote:
Curtis Scheer wrote:
Does anyone have any examples of how I would make a stored procedure in
plpgsql that would allow for passing a list or arrays of values to be
used
in an sql IN clause? Like so: select * from table where field1 in
(values).
Is this possible?
Well, a g
Curtis Scheer wrote:
Does anyone have any examples of how I would make a stored procedure in
plpgsql that would allow for passing a list or arrays of values to be used
in an sql IN clause? Like so: select * from table where field1 in (values).
Is this possible?
Well, a good thing to note he
now finally after a long time i have the query plan for the whole filled table.
I hope somebody can explain me why it takes so much longer...
QUERY PLAN
---
Ed L. wrote:
>
> We'd like to attempt some log replay to simulate real loads, but
> in 8.1.2, it appears the formal parameters are logged ('$')
> instead of the actuals for prepared queries, e.g.:
>
> EXECUTE [PREPARE: UPDATE sessions SET a_session = $1
> WHERE id = $2]
>
> Thoughts on mak
On Tuesday 18 July 2006 07:18, Terry Lee Tucker wrote:
> On Tuesday 18 July 2006 05:50 am, Adem HUR <[EMAIL PROTECTED]> thus
> communicated:
> --> Hi,
> -->
> --> I am sory for my bad English :)
> -->
> -->
> --> We try to use PostgreSQL on an Embeded System.
> -->
> --> Plan to use this PC/104 Mod
On 7/10/2006 9:49 AM, Martijn van Oosterhout wrote:
On Mon, Jul 10, 2006 at 02:56:48PM +0200, DANTE Alexandra wrote:
**
I would like to send charts to show you exactly what happens on the
server but, with the pictures, this e-mail is not posted on the mailing
li
In the output of gist_stat() in the gevel contrib module, is the number
of tuples the number of distinct values stored in the index? Is the
number (6M) so large because the positions are part of the values? I'm
guessing I can't determine the number of distinct lexemes from the
output of gist_
Kevin Flanders wrote:
I am looking for someone that might help us build a custom pgsql
installer for a project of ours. Anyone interested. I see this as a
small project, with other support to follow.
Kevin
I built a complete installer with Inno setup that you can use to embedd
your
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> 1) is the discrepancy by design (why?) or
Yes. I think we were mostly concerned about superuserness being too
dangerous to inherit.
regards, tom lane
---(end of broadcast)---
TIP
Does anyone have any examples of how I would make a stored procedure in
plpgsql that would allow for passing a list or arrays of values to be used
in an sql IN clause? Like so: select * from table where field1 in (values).
Is this possible?
Thanks,
Curtis
---(end of br
On 17 Jul 2006 at 6:08, [EMAIL PROTECTED] wrote:
> to get this effect for the above? What permissions do I need for the
> db, schema, and table? I have a user named "webuser" belonging to a
> group named "webgroup" and I am granting the above privileges to
> webgroup.
All you really need is the
On 17 Jul 2006 at 6:08, [EMAIL PROTECTED] wrote:
> I have a db named archive, a schema named library, and a table named
> book. I have granted USAGE on library to webuser and SELECT on book
> to webuser. When I try to do a select I get an error saying
> "permission denied for schema library". I
thanks martijn
I'l have a look in the documentation now as i know it is possible.
Martijn van Oosterhout schrieb:
> On Mon, Jul 17, 2006 at 02:25:20AM -0700, polder_udo wrote:
> > Hello
> >
> > i am planning to use postgreSQL in a new project and have some very
> > basic questions reguarding in
Hi,
I've been trying to do that same thing, and it works.
Still, one point in the process is not quite clear to me. When I have:
CREATE GROUP masters;
ALTER ROLE masters CREATEUSER;
CREATE USER user_one IN GROUP MASTERS;
CREATE TABLE test1 (stamp timestamp, thing
Postgresql will not completely un-install from my Windows XP computer! Yes use the wizard provided: Control Panel: Add/Remove programs: Remove. So UnInstall using the wizard. Delete the Postgres directory in Program Files. Re-boot. But the server that I had previously added was still visible.
I have a db named archive, a schema named library, and a table named
book. I have granted USAGE on library to webuser and SELECT on book to
webuser. When I try to do a select I get an error saying "permission
denied for schema library". I have tried every combination I can think
of, but none see
Rafal Pietrak wrote:
On Mon, 2006-07-17 at 07:54 -0400, John DeSoi wrote:
On Jul 17, 2006, at 2:56 AM, Timothy Smith wrote:
is it possible to give a non super user the ability to create
another user of a different group?
i'm looking for a way to assign a special group of admin's just
I am looking for
someone that might help us build a custom pgsql installer for a project of
ours. Anyone interested. I see this as a small project, with other
support to follow.
Kevin
On Tue, 2006-07-18 at 07:31 -0600, Michael Fuhr wrote:
> On Tue, Jul 18, 2006 at 01:45:01PM +0200, Rafal Pietrak wrote:
> > Any one knows, why do I have to explicitly SET ROLE, when I try to
> > exercise the group priviledge of role creation, while I don't need that
> > when accessing tables? Is th
PG tsearch2 users,
I notice there is an 8.1 backport of tsearch2 for 8.2
(http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch2WhatsNew).
Has anybody used this?
What are the performance differences between the new GIN index and GIST?
Thanks,
Kevin Murphy
---(end
Hi,
Anyone knows if there's a project to make FSQL querys in Postgre.
Thanks
On Tue, Jul 18, 2006 at 01:45:01PM +0200, Rafal Pietrak wrote:
> Any one knows, why do I have to explicitly SET ROLE, when I try to
> exercise the group priviledge of role creation, while I don't need that
> when accessing tables? Is this a feature, or a bug?
http://www.postgresql.org/docs/8.1/int
Hi all,
i created a function and it takes a long time to run. I was testing it
as a wrote it and to the first drop table it takes just short of a
second. however when the rest of the code is added on, it takes
upwards of 5 minutes. Not the most appropriate thing. Are there any
tips out there for
now finally after a long time i have the query plan for the whole filled
table. I hope somebody can explain me why it takes so much longer...
QUERY PLAN
-
On Tuesday 18 July 2006 05:50 am, Adem HUR <[EMAIL PROTECTED]> thus
communicated:
--> Hi,
-->
--> I am sory for my bad English :)
-->
-->
--> We try to use PostgreSQL on an Embeded System.
-->
--> Plan to use this PC/104 Module
--> http://www.icop.com.tw/products_detail.asp?ProductID=106
-->
-->
-
On Mon, 2006-07-17 at 07:54 -0400, John DeSoi wrote:
> On Jul 17, 2006, at 2:56 AM, Timothy Smith wrote:
>
> > is it possible to give a non super user the ability to create
> > another user of a different group?
> > i'm looking for a way to assign a special group of admin's just
> > enough rig
Hi,
I am sory for my bad English :)
We try to use PostgreSQL on an Embeded System.
Plan to use this PC/104 Module
http://www.icop.com.tw/products_detail.asp?ProductID=106
and this EmbedDisk
http://www.icop.com.tw/products_detail.asp?ProductID=185
There is a Linux version (X-Linux) for the P
Eric Faulhaber <[EMAIL PROTECTED]> writes:
> Can anyone help me understand why converting the NULL code point ()
> from UTF8 to ISO8859_1 is no longer legal in v8.1.4?
Embedded nulls in text strings have never behaved sanely in PG ... or
hadn't you noticed? You'd have been better off passing
44 matches
Mail list logo