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 you
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
me
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 Wi
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. Ho
On Fri, Sep 25, 2009 at 2:40 PM, Rob Marjot 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 tbl(first,second);
> RETURN out
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
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 g
On Fri, Sep 25, 2009 at 3:28 PM, Carlos Henrique Reimer
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 behaviour I've
> found is
Tom Lane wrote:
> Alvaro Herrera 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 s
Steve Crawford 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,
> creates an object list, remove
Rob Marjot 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 parse time. You
can eit
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 objec
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 e
Alvaro Herrera 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 settings). This case could
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 - 08:
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. Su
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 table1.fie
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 ho
On Thu, Sep 24, 2009 at 1:09 PM, Magnus Hagander wrote:
> On Thu, Sep 24, 2009 at 21:06, 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 running more then 2mins in another
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 wrote:
> hi John
>
>
> I have no idea of what may be happening. The system opens a connection and
> communicate normally. But after an idle time,
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: conn
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 wrote:
On Fri, Sep 25, 2009 at 6:26 AM, Luiz Bernardi
wrote:
Hello,
I am devel
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 easie
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?
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 b
On Fri, Sep 25, 2009 at 5:16 AM, 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
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 a
On Fri, Sep 25, 2009 at 6:26 AM, Luiz Bernardi 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 it were active. Wh
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 c
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 impl
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 env
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 t
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 table(..
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
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 bu
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,
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 env
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
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).
http://yum.pgsqlrpms.org/8.1/redhat/rhel-4-i38
On Thu, Sep 24, 2009 at 10:31 AM, Michael Molz
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 time the following
> mess
Rakotomandimby Mihamina 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 ZONE - '0'::INTER
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
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 c
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
>
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, UPDATE
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 |
> Mo
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
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
Hi all,
I get invalid input syntax when UPDATEing my radacct table:
freedsl=# \d radacct
Table "public.radacct"
Column| Type |
Modifiers
--+--+
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 wrote:
> On Thu, Sep 24, 2009 at 21:06, wrote:
> > Is it po
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. I
Le vendredi 25 septembre 2009, Selena Deckelmann a écrit :
> On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain
>
> wrote:
> > Le jeudi 24 septembre 2009, Selena Deckelmann a écrit :
> >> Hi!
> >>
> >> On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery
> >
> > wrote:
> >> > Hi,
> >> > I'm looking
On 25 Sep 2009, at 07:22, 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
meta-
On 25/09/2009 12:45 AM, Grzegorz Jaśkiewicz wrote:
On Thu, Sep 24, 2009 at 5:34 PM, Ms swati chande 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.
If you still hav
54 matches
Mail list logo
