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 an
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
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 rights to
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
--
--
-- and this
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
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
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?
Hi,
Anyone knows if there's a project to make FSQL querys in Postgre.
Thanks
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
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 this a
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
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 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 seem
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
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
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 installing
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 have
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
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
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 1:
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
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
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
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 Module
--
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 unnamed [PREPARE: UPDATE sessions SET a_session = $1
WHERE id = $2]
Thoughts on
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
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
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
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 that would
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 have been
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
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 join of
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 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 the
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
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 get
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's
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
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 not
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 conversion
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
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 line 4
Joseph Shraibman jks@selectacast.net 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.
Hello all
could you please tell me if there are any dataware housing tools for postgresql
Thanks in advance
vamsee
44 matches
Mail list logo