Hi All,
I am creating a dll using MSVC 2005 and trying to call the dll from my
Postgres function but unfortunately PostgreSQL is throwing an error
message saying:
ERROR: could not load library C:/Program
Files/PostgreSQL/8.3/lib/watchlist.dll: The specified module could not
be found.
SQL
On Tue, 2009-10-27 at 02:19 -0400, a.bhattacha...@sungard.com wrote:
I am creating a dll using MSVC 2005 and trying to call the dll from my
Postgres function
OK, so you're creating a PostgreSQL module implementing one or more
SQL-callable functions in C. When you load it into the server with
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
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
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). If
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
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
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,
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 (say
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.
So there
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 d...@archonet.com 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.
Ivan Sergio Borgonovo wrote:
On Tue, 27 Oct 2009 09:17:59 +
Richard Huxton d...@archonet.com 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
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? I
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
m...@webthatworks.it wrote:
On Mon, 26 Oct 2009 14:56:26 -0400
Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Oct 26, 2009 at 11:05 AM, Ivan Sergio Borgonovo
m...@webthatworks.it wrote:
To make it more concrete I came up with:
2009/10/26 ChenXun p.smas...@hotmail.com:
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
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 / ANALYSE
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
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
to
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
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
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 an
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
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
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
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
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
On Mon, Oct 26, 2009 at 7:17 PM, John R Pierce pie...@hogranch.com 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
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 clapi...@hotmail.com writes:
| Bruce Momjian wrote:
| Why would you want an abolute value of a negative interval?
|
|
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 @ (
Sam Mason s...@samason.me.uk 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
On Tue, Oct 27, 2009 at 10:55:31AM -0400, Tom Lane wrote:
Sam Mason s...@samason.me.uk 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
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 the
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 clapi...@hotmail.com writes:
| Bruce Momjian wrote:
| Why would you want an abolute value of a
2009/10/27 Joshua Berry yob...@gmail.com:
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
Sam Mason s...@samason.me.uk 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
On Tue, Oct 27, 2009 at 05:01:00PM +, Tim Landscheidt wrote:
Sam Mason s...@samason.me.uk 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
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 to
On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule pavel.steh...@gmail.com wrote:
|
| 2009/10/27 Joshua Berry yob...@gmail.com:
| 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
Sam Mason s...@samason.me.uk 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
was
2009/10/27 Joshua Berry yob...@gmail.com:
On Tue, Oct 27, 2009 at 1:35 PM, Pavel Stehule pavel.steh...@gmail.com
wrote:
|
| 2009/10/27 Joshua Berry yob...@gmail.com:
| Greetings,
|
| It seems that in Postgresql 8.2 less casting was necessary to coax the
| backend to execute queries.
2009/10/27 Alvaro Herrera alvhe...@commandprompt.com:
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
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
Pavel Stehule escribió:
2009/10/27 Alvaro Herrera alvhe...@commandprompt.com:
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.
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 settings:
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
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
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 tablename
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
Greg Smith gsm...@gregsmith.com 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
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
Alvaro Herrera alvhe...@commandprompt.com 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,
Greg Smith gsm...@gregsmith.com 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
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
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
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
On Tuesday 27 October 2009, fox7 ale_sha...@yahoo.it 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
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
On Tue, Oct 27, 2009 at 5:11 PM, fox7 ale_sha...@yahoo.it 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
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?
-
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
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
70 matches
Mail list logo