On 27/10/2009, at 0:17, John R Pierce wrote:
Alvaro Herrera wrote:
I'm trying to implement the front-end protocol with TCP from
REALbasic to PostgreSQL.
That sounds the most difficult way to do it. Can't you just embed
libpq?
yah, seriously. the binary protocol is not considered stabl
Raimon Fernandez wrote:
REALbasic has plugin for PostgreSQL, but they are synchronous and
freeze the GUI when interacting with PG. This is not a problem
noramlly, as the SELECTS/UPDATES/... are fast enopugh, but sometimes
we need to fetch 1000, 5000 or more rows and the application stops to
r
On Tue, Oct 27, 2009 at 03:55:39PM +1100, ? wrote:
> How does PostgreSQL recognise "deleted" tuples by using xmax ?
xmax is the ID of the transaction that deleted the row. So if you are
in a transaction that sees that transaction as commited, it has been
deleted (from your point of view).
On 27/10/2009, at 8:29, John R Pierce wrote:
Raimon Fernandez wrote:
REALbasic has plugin for PostgreSQL, but they are synchronous and
freeze the GUI when interacting with PG. This is not a problem
noramlly, as the SELECTS/UPDATES/... are fast enopugh, but
sometimes we need to fetch 1000
John R Pierce wrote:
> yah, seriously. the binary protocol is not considered stable, it can
> change in subtle ways in each version. libpq handles the current
> version and all previous versions, and exposes all methods.
That's probably not the problem in the original message, but there
are t
Hi,
I've to generate unique password and associate them with emails.
Association with emails is just to mail the password, email +
password aren't "the password", just the password is.
So a bunch of emails may be associated with the same password.
So there are 2 kind of passwords:
- shared, mult
David Wall wrote:
> If I have various record types that are "one up" records that are
> structurally similar (same columns) and are mostly retrieved one at a
> time by its primary key, is there any performance or operational benefit
> to having millions of such records split across multiple tables
Ivan Sergio Borgonovo wrote:
> Hi,
>
> I've to generate unique password and associate them with emails.
> Association with emails is just to mail the password, email +
> password aren't "the password", just the password is.
>
> So a bunch of emails may be associated with the same password.
>
> S
On 27/10/2009 3:20 PM, Raimon Fernandez wrote:
> REALbasic has plugin for PostgreSQL, but they are synchronous and
> freeze the GUI when interacting with PG. This is not a problem noramlly,
> as the SELECTS/UPDATES/... are fast enopugh, but sometimes we need to
> fetch 1000, 5000 or more rows and
On Tue, 27 Oct 2009 09:17:59 +
Richard Huxton wrote:
> Ivan Sergio Borgonovo wrote:
> > Hi,
> > I've to generate unique password and associate them with emails.
> > Association with emails is just to mail the password, email +
> > password aren't "the password", just the password is.
> > So
Ivan Sergio Borgonovo wrote:
> On Tue, 27 Oct 2009 09:17:59 +
> Richard Huxton wrote:
>
>> Ivan Sergio Borgonovo wrote:
>>> Hi,
>
>>> I've to generate unique password and associate them with emails.
>>> Association with emails is just to mail the password, email +
>>> password aren't "the pa
On Mon, Oct 26, 2009 at 10:32:05AM -0500, Michael Gould wrote:
> In our system we have a hybrid security system.
[...]
> Trying to maintain the database
> to match the application security would become cumbersome for our customers.
Have you looked at using functions protected by "security definer"
Hello,
We had a server crash and when restarting postgres it works, except some
"Invalid Page Header Error" :
I already try VACUUM / FULL / ANALYSE but same error
Even when doing a pg_dumpall, we have this problem.
$ pg_dumpall >/dev/null
pg_dump: ERREUR: en-tête de page invalide dans le bloc
On Mon, Oct 26, 2009 at 2:48 PM, Ivan Sergio Borgonovo
wrote:
> On Mon, 26 Oct 2009 14:56:26 -0400
> Merlin Moncure wrote:
>
>> On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
>> wrote:
>> > To make it more concrete I came up with:
>> >
>> > select coalesce(u.mail,j.mail) from (
>> > se
2009/10/26 ChenXun :
> Hello,
>
> I'm starting to learn programming with libpq.
> In the main loop of my code, I will receive some data in the format of an
> array of a struct. The data will be inserted to the database, in different
> lines.
> I also need to update the last record in the table befo
Denis BUCHER wrote:
> Hello,
>
> We had a server crash and when restarting postgres it works, except some
> "Invalid Page Header Error" :
Data corrupted on disk. Either:
1. You have bad hardware
2. You have disks lying about fsync
3. You have fsync turned off.
> I already try VACUUM / FULL / ANA
On Oct 27, 2009, at 4:55 AM, Albe Laurenz wrote:
That's probably not the problem in the original message, but there
are things you can do with the frontend/backend protocol that libpq
does not expose: for example, with the extended query protocol you can
send a "Bind" call that requests that so
Sorry for not making the question clear.
The table is created like this,
create table prog (
id serial primary key,
pc_id integer,
start_time timestamp with time zone,
end_time timestamp with time zone,
...
);
A remote pc will send a bundle of data to my program after some time. The data
is
Raimon Fernandez wrote:
> REALbasic has plugin for PostgreSQL, but they are synchronous and
> freeze the GUI when interacting with PG. This is not a problem
> noramlly, as the SELECTS/UPDATES/... are fast enopugh, but sometimes
> we need to fetch 1000, 5000 or more rows and the application stops
On Oct 26, 2009, at 7:17 PM, John R Pierce wrote:
yah, seriously. the binary protocol is not considered stable, it
can change in subtle ways in each version. libpq handles the
current version and all previous versions, and exposes all methods.
I don't think the frontend/backend protocol
On 27/10/2009, at 14:00, Alvaro Herrera wrote:
Raimon Fernandez wrote:
REALbasic has plugin for PostgreSQL, but they are synchronous and
freeze the GUI when interacting with PG. This is not a problem
noramlly, as the SELECTS/UPDATES/... are fast enopugh, but sometimes
we need to fetch 1000,
Hello,
As this thread it's alive, I'm going to ask more specific questions:
After sending the satartup sequence, I receive the paramlist. I don't
need to send Authentication as I'm using a Trust user, for making
things easier.
I receive string data, I suppose it's text data.
I can parse
Raimon Fernandez wrote:
> After the S I found thre char(0) and later the size of the packet,
> and later the name + char(0) (separator between value and
> parameter), the parameter, and so on.
>
> Why I found those three char(0) after the S and before the packet
> length?
Because the length is a
Raimon Fernandez wrote:
> I receive string data, I suppose it's text data.
>
> I can parse the data received, search for a B.
You don't search for a B. You search for an S. The B in the
documentation you quote indicates that this message can be sent by the
backend only. You'll notice others h
I saw http://aws.amazon.com/rds/?ref_=pe_12300_13473310 on reddit today.
Faqs http://aws.amazon.com/rds/faqs/#14 here.
There's been talks of PostgreSQL in Amazon's EC & I know some of the
EnterpriseDB people were looking at it. So maybe the people here would be
interested in seeing how Amazon setu
Greetings,
It seems that in Postgresql 8.2 less casting was necessary to coax the
backend to execute queries.
For example:
* Comparing a varchar with a numeric
In 8.3, these will result in errors like this:
HINT: No operator matches the given name and argument type(s). You might
need to add expl
On 27/10/2009, at 14:41, Alvaro Herrera wrote:
Raimon Fernandez wrote:
After the S I found thre char(0) and later the size of the packet,
and later the name + char(0) (separator between value and
parameter), the parameter, and so on.
Why I found those three char(0) after the S and before the
Thank you all.
Thanks again!
Kynn
Raimon Fernandez wrote:
> how I know where the length ends ?
You count 4 bytes.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
On Mon, Oct 26, 2009 at 7:17 PM, John R Pierce wrote:
> Alvaro Herrera wrote:
>>>
>>> I'm trying to implement the front-end protocol with TCP from
>>> REALbasic to PostgreSQL.
>>>
>>
>> That sounds the most difficult way to do it. Can't you just embed
>> libpq?
>>
>
> yah, seriously. the binary
Hi all,
I've got a weird thing on one of my databases this night:
- I've a monthly partition for storing activity logs defined as this:
- mother log table
- one child partition for each month
- Last friday I dumped the last month partition, and tried to truncate it,
which locked lots of quer
I couldn't find the operator '@' for intervals and found this thread
from over six years ago:
http://archives.postgresql.org/pgsql-general/2003-09/msg00292.php
| "Claudio Lapidus" writes:
| > Bruce Momjian wrote:
| >> Why would you want an abolute value of a negative interval?
|
| > Because I'm t
On 27/10/2009, at 15:06, Alvaro Herrera wrote:
Raimon Fernandez wrote:
how I know where the length ends ?
You count 4 bytes.
thanks,
I'm parsing now the resulted string as a binarystring and all is
getting sense ...
thanks for your help,
raimon
--
Alvaro Herrera
On Tue, Oct 27, 2009 at 11:27:17AM -0300, Joshua Berry wrote:
> I couldn't find the operator '@' for intervals
A simple SQL implementation would look like:
CREATE FUNCTION absinterval(interval) RETURNS interval
IMMUTABLE LANGUAGE sql AS 'SELECT greatest($1,-$1)';
CREATE OPERATOR @ ( PROC
Sam Mason writes:
> On Tue, Oct 27, 2009 at 11:27:17AM -0300, Joshua Berry wrote:
>> I couldn't find the operator '@' for intervals
> A simple SQL implementation would look like:
> CREATE FUNCTION absinterval(interval) RETURNS interval
> IMMUTABLE LANGUAGE sql AS 'SELECT greatest($1,-$1)'
On Tue, Oct 27, 2009 at 10:55:31AM -0400, Tom Lane wrote:
> Sam Mason writes:
> > On Tue, Oct 27, 2009 at 11:27:17AM -0300, Joshua Berry wrote:
> >> I couldn't find the operator '@' for intervals
>
> > A simple SQL implementation would look like:
>
> > CREATE FUNCTION absinterval(interval) RE
On Tue, Oct 27, 2009 at 03:25:02PM +, Sam Mason wrote:
> If the absolute value of an interval was defined to strip out all the
> negation signs you'd get the "wrong" answers out.
Oops, forgot another reason! For maths to work (n) and (-(-n)) should
evaluate to the same value. Inverting all t
Joshua Berry wrote:
I couldn't find the operator '@' for intervals and found this thread
from over six years ago:
http://archives.postgresql.org/pgsql-general/2003-09/msg00292.php
| "Claudio Lapidus" writes:
| > Bruce Momjian wrote:
| >> Why would you want an abolute value of a negative interva
2009/10/27 Joshua Berry :
> Greetings,
>
> It seems that in Postgresql 8.2 less casting was necessary to coax the
> backend to execute queries.
> For example:
> * Comparing a varchar with a numeric
>
> In 8.3, these will result in errors like this:
> HINT: No operator matches the given name and ar
Sam Mason wrote:
> [...]
>> I would assume
>> that you just have to convert A, B and C to seconds (since
>> epoch) and then use a normal integer division.
> The problem is that the Gregorian calender is far too complicated. For
> example, think what would happen with an interval of "months". I
On Tue, Oct 27, 2009 at 05:01:00PM +, Tim Landscheidt wrote:
> Sam Mason wrote:
> > any definition of "division" I've ever been able to think of [is]
> > ill defined
>
> Yep, you would probably need some safety margin and add a
> "WHERE" clause. I should have thought about that earlier as
> I
JC Praud escribió:
> So my question are: can the autovacuum daemon perform vacuum full ? Or
> another internal postgres process ? Could it come from the TRUNCATE I run
> and canceled 4 days before ?
No. Autovacuum only issues commands that don't lock tables strongly. I
doubt this has anything t
On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule wrote:
|
| 2009/10/27 Joshua Berry :
| > Greetings,
| >
| > It seems that in Postgresql 8.2 less casting was necessary to coax the
| > backend to execute queries.
| > For example:
| > * Comparing a varchar with a numeric
| >
| > In 8.3, these will res
Sam Mason wrote:
>> > any definition of "division" I've ever been able to think of [is]
>> > ill defined
>> Yep, you would probably need some safety margin and add a
>> "WHERE" clause. I should have thought about that earlier as
>> I recently stumbled (again) over why "INTERVAL / INTERVAL"
>> wa
2009/10/27 Joshua Berry :
> On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule
> wrote:
> |
> | 2009/10/27 Joshua Berry :
> | > Greetings,
> | >
> | > It seems that in Postgresql 8.2 less casting was necessary to coax the
> | > backend to execute queries.
> | > For example:
> | > * Comparing a varcha
2009/10/27 Alvaro Herrera :
> JC Praud escribió:
>
>> So my question are: can the autovacuum daemon perform vacuum full ? Or
>> another internal postgres process ? Could it come from the TRUNCATE I run
>> and canceled 4 days before ?
>
> No. Autovacuum only issues commands that don't lock tables s
Hello,
I have a script which is written in PHP (5.2.8) + PDO (1.0.3). It's stable,
but actual version of PGSQL driver for PDO don't allow persistent
connections.
So we decided to use PGPOOL-II-2.2.5. It's configured to work in connection
pool mode with following settings:
# number of pre-forked
Pavel Stehule escribió:
> 2009/10/27 Alvaro Herrera :
> > JC Praud escribió:
> >
> >> So my question are: can the autovacuum daemon perform vacuum full ? Or
> >> another internal postgres process ? Could it come from the TRUNCATE I run
> >> and canceled 4 days before ?
> >
> > No. Autovacuum only
VladK wrote:
> Hello,
>
> I have a script which is written in PHP (5.2.8) + PDO (1.0.3). It's stable,
> but actual version of PGSQL driver for PDO don't allow persistent
> connections.
>
> So we decided to use PGPOOL-II-2.2.5. It's configured to work in connection
> pool mode with following setti
ginanjar wrote:
> I work on my thesis on spatial database indeksing using Btree n GiST.
> Can you help to explain how the GiST and btree indexing work in
> postgresql ( the algorithm ) ? Can somone show me how to write code to
> know the tree level and count the root and leaf ?
> thanks for the inf
On Tue, 27 Oct 2009, Alvaro Herrera wrote:
Now 40 mins walking those pages to figure out that they need to be
truncated, I concede that it's too much. Maybe we shouldn't be doing a
backwards scan; perhaps this breaks the OS readahead and make it even
slower.
I've watched that take hours befor
Kynn Jones wrote:
> How can I list the permissions of a given user/role for a specific
> relation/view/index, etc.?
>From psql use \dp
Using plain SQL, the closest I can think of are the has_xxx_privilege()
functions:
http://www.postgresql.org/docs/8.4/static/functions-info.html
There is also t
Greg Smith writes:
> On Tue, 27 Oct 2009, Alvaro Herrera wrote:
>> Now 40 mins walking those pages to figure out that they need to be
>> truncated, I concede that it's too much. Maybe we shouldn't be doing a
>> backwards scan; perhaps this breaks the OS readahead and make it even
>> slower.
> I'
On Tue, 27 Oct 2009, Tom Lane wrote:
The issue I can see is that we might never be able to complete any
truncation if there's a lot of potentially removable pages and a pretty
steady flow of conflicting lock attempts. But that would result in
failure to remove bloat, not stoppage of conflicti
Alvaro Herrera writes:
> Now 40 mins walking those pages to figure out that they need to be
> truncated, I concede that it's too much. Maybe we shouldn't be doing a
> backwards scan; perhaps this breaks the OS readahead and make it even
> slower.
That's very possible, since a backwards scan is g
Greg Smith writes:
> On Tue, 27 Oct 2009, Tom Lane wrote:
>> The issue I can see is that we might never be able to complete any
>> truncation if there's a lot of potentially removable pages and a pretty
>> steady flow of conflicting lock attempts. But that would result in
>> failure to remove
From: Little, Douglas
Sent: Tuesday, October 27, 2009 4:31 PM
To: 'pgsql-gene...@postgresql.org.'
Subject: Pgadmin support for writing files or psql \copy command
Hi,
I have a script I'd like to submit from pgadmin that needs to export query
results to a file.
Hey all,
I have the following table: data(pnum text, distance float8, route text).
I would like to remove the outliers in distance, i.e. lets say i get
the avg dist of pnum for each route and the std deviation of the
distance what is the best way to identify the outliers?
Rhys.
--
Sent via pgs
Hi,
I'm a new user...
First of all excuse me for the bad english... :confused:
I have a great problem!
I have to do some little query with views, but the views contain thousand
and thousand of records.
Searching online I have found somthing about view index, but I don't know
the right syntax for P
Im asking how to get the ones that dont fall near the avg so for
example lets say i have the following distances:
10,11,12,11,10,9,9,10,11,12,10,11,99
then 99 would be an outlier. the avg would be like 16 or 17 i reckon
with the 99. so i want a way to find aan outlier, remove it and then
recal
On Tuesday 27 October 2009, fox7 wrote:
> I have tries this:
> CREATE INDEX View1_index
> ON View1
> USING btree
> (term1);
>
> It isn't correct because this syntax is for tables, instead View1 is a
> view. Do you know the syntax to create view index?
> thanks a lot
You can't create indexes
Rhys A.D. Stewart escribió:
> i did some seraching about outliers and most of hits are about R or
> spss or some other statistical package.so looking for a way to do
> it wholly in pgsql.
Well, then, maybe PL/R?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
Rhys A.D. Stewart wrote:
Im asking how to get the ones that dont fall near the avg so for
example lets say i have the following distances:
10,11,12,11,10,9,9,10,11,12,10,11,99
then 99 would be an outlier. the avg would be like 16 or 17 i reckon
with the 99. so i want a way to find aan outlie
On Tue, Oct 27, 2009 at 5:11 PM, fox7 wrote:
>
> Hi,
> I'm a new user...
> First of all excuse me for the bad english... :confused:
> I have a great problem!
> I have to do some little query with views, but the views contain thousand
> and thousand of records.
> Searching online I have found somth
JC Praud escribió:
> - Last night the database locked. pg_log full of messages about insert into
> the mother table waiting for a lock.
This bit does not make much sense to me. A transaction waiting will not
show up in the log. Were they cancelled? Can you paste an extract from
the log?
> - A
Rhys A.D. Stewart wrote:
Hey all,
I have the following table: data(pnum text, distance float8, route text).
I would like to remove the outliers in distance, i.e. lets say i get
the avg dist of pnum for each route and the std deviation of the
distance what is the best way to identify the outliers
I assume you get segfault of pgpool.
Can you take a coredump and backtrace? That will be very helpfull to
inspect your problem.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Hello,
>
> I have a script which is written in PHP (5.2.8) + PDO (1.0.3). It's stable,
> but actual version of PGSQL driver for PDO
depends on how your PHP module is compiled for instance
taking a borland compiled module for Apache (mod_php) and forcing it to work on
Unix which has a different memory model would cause segfault
so we would need to know the specifics of
deployed platform
OS
Compiler version
to determine the cau
68 matches
Mail list logo
