On 25 sep 2009, at 02.59, Tom Lane t...@sss.pgh.pa.us wrote:
Sam Mason s...@samason.me.uk writes:
+if (portnum 1 || portnum 65535)
BTW, it strikes me that we could tighten this even more by rejecting
target ports below 1024. This is guaranteed safe on all Unix systems
I know of,
On Thu, 2009-09-24 at 20:36 -0400, Tom Lane wrote:
BTW, are port numbers still limited to 16 bits in IPv6?
Port numbers are in TCP, not in IP.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 25/09/2009 12:45 AM, Grzegorz Jaśkiewicz wrote:
On Thu, Sep 24, 2009 at 5:34 PM, Ms swati chande swat...@yahoo.com
mailto:swat...@yahoo.com wrote:
SIGSEGV in micro$oft world.
Thanks for your response.
How can this be resolved?
Just like others said, upgrade to 8.4.1 first.
On 25 Sep 2009, at 07:22, InterRob rob.mar...@gmail.com wrote:
I guess it IS quite overengineered indeed...
What I'm trying to do is to facilitate different fieldwork
methodologies for archaeological research (on project basis); there
is no final agreement on data structure and semantics;
Le vendredi 25 septembre 2009, Selena Deckelmann a écrit :
On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain
cedric.villem...@dalibo.com wrote:
Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
Hi!
On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery mo...@english.net
wrote:
Hi List,
I tried already in the ODBC list, but without success...
I have to develop a client/server application, heavily transaction oriented,
that will serve around 100 users and database traffic will be intense (lot's of
reads, updates, inserts).
Development environment is Delphi 2007.
ok thanks Magnus from saving my time in googling
-Arvind S
Many of lifes failure are people who did not realize how close they were to
success when they gave up.
-Thomas Edison
On Fri, Sep 25, 2009 at 12:39 AM, Magnus Hagander mag...@hagander.netwrote:
On Thu, Sep 24, 2009 at 21:06,
Hi all,
I get invalid input syntax when UPDATEing my radacct table:
freedsl=# \d radacct
Table public.radacct
Column| Type |
Modifiers
On Fri, Sep 25, 2009 at 11:49 AM, Rakotomandimby Mihamina
miham...@gulfsat.mg wrote:
I cannot find the problem
Any hints?
and what's the error message ?
--
GJ
09/25/2009 01:55 PM, Grzegorz Jaśkiewicz:
and what's the error message ?
ERROR: invalid input syntax for integer:
(I put it in the email subject, not very clever from me)
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche Developpement
In response to Rakotomandimby Mihamina :
Hi all,
I get invalid input syntax when UPDATEing my radacct table:
freedsl=# \d radacct
Table public.radacct
Column| Type |
Modifiers
Hi Rob,
In a database I wish to implement a GENERIC datamodel, thus on a
meta-level. All RELATIONS (part of a MODEL) will be a view on some base
(being a table) JOINed with (an) extra column(s). Thus, this view
consists of a number of FIELDS. I whish to make this view editable
(INSERT,
Alvaro Herrera píše v Čt 24. 09. 2009 v 14:41 -0400:
Jaromír Talíř wrote:
we are facing strange situation with exclusively locked table during
normal lazy vacuum. There is one big table (66GB) that is heavily
inserted and updated in our database. Suddenly (after backup and delete
of
Hello,
I am developing a system, using the ZeosLib, which maintains a permanent connection to the database.
When the client loses the connection, the server does
not recognize this and keeps the connection as if it were active. When
the client attempts to reconnect, the server creates a new
Hello,
I am developing a system, using the ZeosLib, which maintains a
permanent connection to the database.
When the client loses the connection, the server does not recognize
this and keeps the connection as if it were active. When the client
attempts to reconnect, the server
Rakotomandimby Mihamina miham...@gulfsat.mg writes:
I get invalid input syntax when UPDATEing my radacct table:
It's the ELSE '' here:
AcctSessionTime = CASE WHEN '' = '' THEN (EXTRACT(EPOCH FROM
('2009-09-25 10:35:44'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP
WITH TIME
On Thu, Sep 24, 2009 at 10:31 AM, Michael Molz
michael.m...@iwm-software.de wrote:
one of our systems on a PG 8.2 database crashes nearly daily; others are
running fine. Host OS of this system is Windows, if the db crashes nothing is
written in the OS event logs. The database log show every
Devrim GÜNDÜZ wrote:
On Thu, 2009-09-24 at 15:43 -0500, Justin Pasher wrote:
I'm having trouble finding the source RPMs for PostgreSQL 8.1.18 on
RHEL4. I've tried looking in the following places with no luck (I can
only find the regular RPMs).
I've ran an update statement like this (obviously wrong, I know!):
update my_table
set boolean_field = true AND
my_notes = 'something'
where id in
(select id from my_table order by random() limit 4000);
in my psql client and I had a UPDATE 4000 result but, correctly, anything
was changed
Nico Callewaert wrote:
Hi List,
I tried already in the ODBC list, but without success...
I have to develop a client/server application, heavily transaction
oriented, that will serve around 100 users and database traffic will be
intense (lot's of reads, updates, inserts).
Development
Mirko Pace wrote:
I've ran an update statement like this (obviously wrong, I know!):
update my_table
set boolean_field = true AND
my_notes = 'something'
where id in
(select id from my_table order by random() limit 4000);
in my psql client and I had a UPDATE 4000 result but, correctly,
Mirko Pace mirko...@gmail.com wrote:
I've ran an update statement like this (obviously wrong, I know!):
update my_table
set boolean_field = true AND
my_notes = 'something'
where id in
(select id from my_table order by random() limit 4000);
in my psql client and I had a UPDATE 4000
On Fri, 25 Sep 2009 17:05:13 +0200, Mirko Pace wrote about [GENERAL]
UPDATE statement with syntax error doesn't raise a warning?:
I've ran an update statement like this (obviously wrong, I know!):
Not so obvious.
update my_table
set boolean_field = true AND
my_notes = 'something'
where id
Hi,
I'm coming from Sybase ASE and Transact SQL.
Apart from long time desire to see true stored procedures in pl/pgsql,
with integer status and many arbitrary resultsets, I have one specific question:
is it possible to rename columns in rowset returned from function declared
as "returns
Dear list,
I am trying to find out whether I can use the record type as a polymorphic
return type to return multiple columns, to be determined at runtime. In
fact, I'm trying to write a function that provides a generic implementation
of some deserialization of a certain field.
The prototype of
Nico Callewaert wrote:
Hi List,
I tried already in the ODBC list, but without success...
I have to develop a client/server application, heavily transaction
oriented, that will serve around 100 users and database traffic will
be intense (lot's of reads, updates, inserts).
Development
Hello
this isn't possible now. All what you want are limited by SELECT
statement in PostgreSQL. Simply PL knows only SELECT statement and
structure of result have to be strongly static - because it is based
on static execution plan - it is determined before query start.
Statement CALL isn't
Luiz Bernardi wrote:
I am developing a system, using the ZeosLib, which maintains a
permanent connection to the database.
When the client loses the connection, the server does not recognize
this and keeps the connection as if it were active. When the client
attempts to reconnect, the server
On Fri, Sep 25, 2009 at 6:26 AM, Luiz Bernardi l...@cplinformatica.com wrote:
Hello,
I am developing a system, using the ZeosLib, which maintains a permanent
connection to the database.
When the client loses the connection, the server does not recognize this and
keeps the connection as if
On Thu, Sep 24, 2009 at 11:07:31PM +0200, InterRob wrote:
What I'm trying to do is to facilitate different fieldwork methodologies for
archaeological research (on project basis); there is no final agreement on
data structure and semantics; however, on a meta-level all choices are
rational and
On Fri, Sep 25, 2009 at 5:16 AM, Nico Callewaert
callewaert.n...@telenet.be wrote:
Hi List,
I tried already in the ODBC list, but without success...
I have to develop a client/server application, heavily transaction
oriented, that will serve around 100 users and database traffic will be
On Fri, Sep 25, 2009 at 09:29:24AM +0300, Peter Eisentraut wrote:
On Thu, 2009-09-24 at 20:36 -0400, Tom Lane wrote:
BTW, are port numbers still limited to 16 bits in IPv6?
Port numbers are in TCP, not in IP.
I'd checked that it should work with IPv6, but I hadn't realized that
it was
On 25 Sep 2009, at 18:34, InterRob wrote:
Unfortunately, this results in ONE row, with ONE column. E.g.:
MYDB=# select * from (SELECT deserialize(kvp) FROM kvp) ss;
deserialize
---
(1,2)
(1 row)
I guess I am seeking to prototype the anonymous row layout in the
above SQL statement?
Sam Mason wrote:
It all depends on the problem domain of course, but this seems to work
OK for us! I really want to hack Samba around so that the users can
view the files directly from inside the database, but I'm not sure how
good an idea this really.
hack Samba? Wouldn't it be easier to
Thanks, Scott.
I change the setting and then find out why they were losing the
client connection.
--
Luiz Agnaldo Bernardi
Fone 41 36755756
41 99979849
On Fri, 25 Sep 2009 11:11:52 -0600
Scott Marlowe scott.marl...@gmail.com wrote:
On Fri, Sep 25, 2009 at 6:26 AM, Luiz Bernardi
hi John
I have no idea of what may be happening. The system opens a connection
and communicate normally. But after an idle time, it loses the
connection and new transactions return with error.
16/09/2009 13:39:14 - SQL Error: no connection to the server
16/09/2009 13:39:14 - SQL Error:
Are these machines communicating through a firewall? Often firewalls
timeout idle tcp/ip connections.
On Fri, Sep 25, 2009 at 12:56 PM, Luiz Bernardi l...@cplinformatica.com wrote:
hi John
I have no idea of what may be happening. The system opens a connection and
communicate normally. But
On Thu, Sep 24, 2009 at 1:09 PM, Magnus Hagander mag...@hagander.net wrote:
On Thu, Sep 24, 2009 at 21:06, arvindw...@gmail.com wrote:
Is it possible to log two different information to two different file.
Bascially i need to log all the mod statement in one log csv file and all
the queries
On Fri, Sep 25, 2009 at 11:01:02AM -0700, Ron Mayer wrote:
Sam Mason wrote:
It all depends on the problem domain of course, but this seems to work
OK for us! I really want to hack Samba around so that the users can
view the files directly from inside the database, but I'm not sure how
Dear list,
I wrote a function that takes one parameter of a certain 'table type':
CREATE FUNCTION deserialize(serTable table1) RETURNS record AS ...
I whish to use this function in a query such as:
SELECT deser.* FROM deserialize(table1) deser(col1 integer, col2 integer),
table1 WHERE
Jaromír Talíř wrote:
Alvaro Herrera píše v Čt 24. 09. 2009 v 14:41 -0400:
Jaromír Talíř wrote:
we are facing strange situation with exclusively locked table during
normal lazy vacuum. There is one big table (66GB) that is heavily
inserted and updated in our database. Suddenly (after
Hi,
We're facing performance problems in a Linux box running CentOS release 5
(Final) and PostgreSQL 8.2.4. I've done some basic checks in the
configuration but everything looks fine to me. One weird behaviour I've
found is the cached size showed by the
top and free Linux commands:
top -
Alvaro Herrera alvhe...@commandprompt.com writes:
An alternative solution would be to lower the vacuum delay settings before
starting the truncating phase, but this doesn't work very well in autovacuum
due to the autobalancing code (which can cause other processes to change our
cost delay
Still no luck... To clarify a bit, take this example:
CREATE OR REPLACE FUNCTION transpose()
RETURNS record AS
$BODY$ DECLARE
output RECORD;
BEGIN
SELECT * INTO output FROM (VALUES(1,2)) as tbl(first,second);
RETURN output;
END;$BODY$
LANGUAGE 'plpgsql' STABLE
COST 100;
Now, I
Background:
I am preparing to collapse two databases in a cluster into a single
database (current step in a roadmap preparing to update a system from
7.4.6 up to 8.4.1).
In testing, I have a step that dumps the schema of one of the databases,
creates an object list, removes the unwanted
Rob Marjot r...@marjot-multisoft.com writes:
Any thoughts on how to make sure multiple columns are returned; without
specifying this in the function's prototype return clause?
If you want SELECT * FROM to expand to multiple columns, the names
and types of those columns *must* be available at
Steve Crawford scrawf...@pinpointresearch.com writes:
I am preparing to collapse two databases in a cluster into a single
database (current step in a roadmap preparing to update a system from
7.4.6 up to 8.4.1).
In testing, I have a step that dumps the schema of one of the databases,
Tom Lane wrote:
Alvaro Herrera alvhe...@commandprompt.com writes:
An alternative solution would be to lower the vacuum delay settings before
starting the truncating phase, but this doesn't work very well in autovacuum
due to the autobalancing code (which can cause other processes to change
On Fri, Sep 25, 2009 at 3:28 PM, Carlos Henrique Reimer
carlos.rei...@opendb.com.br wrote:
Hi,
We're facing performance problems in a Linux box running CentOS release 5
(Final) and PostgreSQL 8.2.4. I've done some basic checks in the
configuration but everything looks fine to me. One weird
Drifting off topic so I'm no longer ccing the lists.
Sam Mason wrote:
The perl Fuse::DBI module's example sounds pretty similar to the
system you described where he file seems to be a column in a table.
http://www.rot13.org/~dpavlin/fuse_dbi.html
FUSE looks pretty easy to get going and I
Hi Scott,
The top and M option:
top - 20:37:52 up 8:19, 2 users, load average: 0.00, 0.00, 0.00
Tasks: 96 total, 1 running, 95 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.2%sy, 0.0%ni, 99.5%id, 0.3%wa, 0.0%hi, 0.0%si,
0.0%st
PID USER PR NI VIRT RES SHR S %CPU %MEM
On Fri, Sep 25, 2009 at 2:40 PM, Rob Marjot r...@marjot-multisoft.com wrote:
Still no luck... To clarify a bit, take this example:
CREATE OR REPLACE FUNCTION transpose()
RETURNS record AS
$BODY$ DECLARE
output RECORD;
BEGIN
SELECT * INTO output FROM (VALUES(1,2)) as
On Fri, 2009-09-25 at 09:40 -0500, Justin Pasher wrote:
Our of curiosity, how do you actually get to that links from the web
site? I always seem to have trouble finding the link to the SRPMs
tree.
Tom complained about this a few days, too -- There is not a direct link
from website.
I am unable to install postgresql on a Windows XP machine and am wondering if
anyone has struck this problem or might have an idea how to solve it.
This is a clean install, I've never installed postgresql on the is machine
before, I have successfully installed it on another machine which is a
On Sep 24, 2009, at 2:07 PM, InterRob wrote:
I guess it IS quite overengineered indeed...
What I'm trying to do is to facilitate different fieldwork
methodologies for archaeological research (on project basis); there
is no final agreement on data structure and semantics; however, on a
Hi friends,
Can anyone help me with this?
In what encoding the function PQgetvalue() return?
ASCII? UTF8?
Thank you very very much.
Rgds,
Ayen Yang
Sent from my AXIS Worry Free BlackBerry?0?3 smartphone
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
56 matches
Mail list logo