Merlin Moncure wrote:
On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich wrote:
Hello,
There is an existing function which takes an integer and returns a record.
I need to call this function with every integer in a table. Is there a
simple shortcut for doing this?
I'm looking for something like:
se
hi all,
having some memory leak issues with my app and spi_exec_prepared.
checking the docs:
"Normally, spi_fetchrow should be repeated until it returns undef,
indicating that there are no more rows to read. The cursor is
automatically freed when spi_fetchrow returns undef. If you do not
wish to
2009/11/17 Adam Rich :
> Hello,
> There is an existing function which takes an integer and returns a record.
> I need to call this function with every integer in a table. Is there a
> simple shortcut for doing this?
>
> I'm looking for something like:
>
> select f.*
> from function(t.value) f, ta
On Tue, Nov 17, 2009 at 1:02 AM, Adam Rich wrote:
> Hello,
> There is an existing function which takes an integer and returns a record.
> I need to call this function with every integer in a table. Is there a
> simple shortcut for doing this?
>
> I'm looking for something like:
>
> select f.*
>
Hello,
There is an existing function which takes an integer and returns a
record. I need to call this function with every integer in a table. Is
there a simple shortcut for doing this?
I'm looking for something like:
select f.*
from function(t.value) f, table t
Thanks,
Adam
--
Sent vi
Hi Dave,
You can always use the environment variable PGPASSWORD to do that.
Though - it is not recommended to use for security reason. :(
Please follow the link for the details.
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The
John DeSoi wrote:
On Nov 16, 2009, at 2:12 PM, Raymond Rodgers wrote:
a2hosting.com shows "unlimited" plans which include Postgres 8.4 (tsearch already included) for about $5/month. If you really need an older version, they might be willing to add your account to an older shared server. I know
Craig de Stigter writes:
> Somehow we've ended up with a few corrupt indices in our database.
What PG version is this exactly? Do you have any idea how you got into
this state? (Database crashes, system crashes, whatever?) We've seen
a few similar reports before, but never with enough clarity
Hi folks
Somehow we've ended up with a few corrupt indices in our database. We've
previously dropped the table they were on, but the indices are still there
(kind of):
Trying to drop the indices gives us:
drop index "v_038e_GEOMETRY";
ERROR: could not open relation with OID 9590980
Loo
I'm trying to read "money" field using PQgetvalue (PostgreSQL 8.3.7). The
function returns 9 bytes, smth like 0h 0h 0h 0h 0h 0h 14h 0h 0h, for the
Huh... You mean 8 bytes, right?
--
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/
--
Sent via pgsql-general mailing list (pgsql-
On Mon, Nov 16, 2009 at 3:02 AM, Jasen Betts wrote:
> On 2009-11-16, Konstantin Izmailov wrote:
>> --000e0cd5d09230ff7d04787526aa
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> I'm trying to read "money" field using PQgetvalue (PostgreSQL 8.3.7). The
>> function returns 9 bytes, smth like
On 16/11/2009 23:05, Raymond O'Donnell wrote:
> On 16/11/2009 22:51, Gauthier, Dave wrote:
>> --username foo --password fee
[snip]
> There are no options such as thesewhat you do instead is use a
Actually, to correct myself, there *are* these options - but the
--password option just forces
On 16/11/2009 22:51, Gauthier, Dave wrote:
> Hi:
>
> Is there a way to require and specify a password at the cmd line for a
> connect? At first glance...
>
> --username foo --password fee
>
> would seem to be what I want. But it just prompts me for a password (after
> interpreting "fee" as
Gauthier, Dave wrote:
Hi:
Is there a way to require and specify a password at the cmd line for a
connect?
You don't want to do that because any user on the system can see the
command, and thus the password. You want to use a .pgpass file instead:
http://www.postgresql.org/docs/8.4/int
Hi:
Is there a way to require and specify a password at the cmd line for a connect?
At first glance...
--username foo --password fee
would seem to be what I want. But it just prompts me for a password (after
interpreting "fee" as the DB name).
Thanks In Advance
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Sebastian Feher
> Sent: Monday, November 16, 2009 10:41 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Update on Insert
>
> Hi Everyone,
>
> Given a tabl
Hi!
Thanks again for the help. Just wanted to let you all know that it
seems like we had an issue with our install of Postgres 8.3 on our
development server. I installed 8.4 on my own local machine and the
indexing works as it should.
Jonathan
--
Sent via pgsql-general mailing list (pgsql-gen
Hi Everyone,
Given a table "Items" with a PK "item1" and "Qty" - a numeric column
I'd like to define a way in Postgres to insert when item11 doesn't
exist already in "Items" and update the Qty by adding the new quantity
to the existent when the item11 exists. What is a good approach and
where shou
Konstantin Izmailov wrote:
> I'm planning to use multiple statements via libpq. Before starting coding
> I'm trying to understand are there any limitations on passing parameters.
> E.g. would the following work:
> PQexecParams(conn, "BEGIN;INSERT INTO tbl VALUES($1,$2);SELECT
> lastval()
On Nov 16, 2009, at 2:12 PM, Raymond Rodgers wrote:
> Aside from this issue, they're the best I've found for the least amount of
> money in terms of bandwidth, disk space, and PostgreSQL support. I'd happily
> continue to use my current, more expensive, hosting provider if they weren't
> phasi
On Mon, Nov 16, 2009 at 9:55 AM, Reno Bladergroen
wrote:
> Today I restarted to install postgres from scratch, because I have a lot of
> installation problems. To summarize my system:
> I have two xubuntu logins: a "superuser" and postgres. The latter one is a
> user with basic privileges.
> I i
eh... no I installed once from source, because the package-manager failed to
install the main application (PostgreSQL 8.3). Somehow it could not configure
(after a few minutes the make command ended and an error popped up). Therefore
I had to start from source, which did work.
Today after gettin
John R Pierce writes:
> can't you install the contrib module as a regular database user into the
> database you own?
No, it would take superuser privs which he hasn't got. More, even with
superuser privs it would need the tsearch2.so library to be present on
disk, which it likely isn't if they
2009/11/16 Robert Haas :
> On Mon, Nov 16, 2009 at 1:31 PM, SebiF wrote:
>> Hi Everyone,
>>
>> Given a table "Items" with a PK "item1" and "Qty" - a numeric column
>> I'd like to define a way in Postgres to insert when item11 doesn't
>> exist already in "Items" and update the Qty by adding the new
Raymond Rodgers wrote:
I just signed up for web hosting with HostNine which offers PostgreSQL
8.1.x, which doesn't have the full text search support in the default
installl. I requested that they run the tsearch2.sql from the
contributed files on the server to provide me with those capabilities
On Mon, Nov 16, 2009 at 1:51 PM, Tom Lane wrote:
> Raymond Rodgers writes:
> > I just signed up for web hosting with HostNine which offers PostgreSQL
> > 8.1.x, which doesn't have the full text search support in the default
> > installl. I requested that they run the tsearch2.sql from the contri
Raymond Rodgers writes:
> I just signed up for web hosting with HostNine which offers PostgreSQL
> 8.1.x, which doesn't have the full text search support in the default
> installl. I requested that they run the tsearch2.sql from the contributed
> files on the server to provide me with those capabi
Reno Bladergroen writes:
> I have two xubuntu logins: a "superuser" and postgres. The latter one is a
> user with basic privileges.
> I installed pgsql according to the manual, generated a data folder, changed
> ownership to postgres, switched user postgres and initialized the database.
> start
I just signed up for web hosting with HostNine which offers PostgreSQL
8.1.x, which doesn't have the full text search support in the default
installl. I requested that they run the tsearch2.sql from the contributed
files on the server to provide me with those capabilities since I don't have
super u
Tom Lane írta:
> Boszormenyi Zoltan writes:
>
>> //ids =
>> PointerGetDatum(PG_DETOAST_DATUM(SPI_getbinval(prod_inv->vals[0],
>> prod_inv->tupdesc, 1, &isnull)));
>>
>
> well, for one thing, you probably want DatumGetPointer ...
You chose the commented out line to comment on. :-)
The
On Mon, 2009-11-16 at 17:55 +0100, Reno Bladergroen wrote:
> Today I restarted to install postgres from scratch, because I have a lot of
> installation problems. To summarize my system:
> I have two xubuntu logins: a "superuser" and postgres. The latter one is a
> user with basic privileges.
> I
On Mon, Nov 16, 2009 at 17:55, Reno Bladergroen
wrote:
> I installed pgsql according to the manual, generated a data folder, changed
> ownership to postgres, switched user postgres and initialized the database.
> starting the database is also successful (status says running).
[...]
I assume y
"Maria Cianci" wrote:
>
>I am running on a Windows XP machine, 4GB of RAM and over 26GB of
> free hard-disk an application that all it does is insert records into
> the Postgres 8.3 database. When the database is approx 17GB Postgres
> issues the "Not enough storage is available to complete
Today I restarted to install postgres from scratch, because I have a lot of
installation problems. To summarize my system:
I have two xubuntu logins: a "superuser" and postgres. The latter one is a user
with basic privileges.
I installed pgsql according to the manual, generated a data folder, cha
2009/11/16 Maria Cianci :
> All,
>
>
>
> I am running on a Windows XP machine, 4GB of RAM and over 26GB of free
> hard-disk an application that all it does is insert records into the
> Postgres 8.3 database. When the database is approx 17GB Postgres issues the
> “Not enough storage is available
All,
I am running on a Windows XP machine, 4GB of RAM and over 26GB of
free hard-disk an application that all it does is insert records into
the Postgres 8.3 database. When the database is approx 17GB Postgres
issues the "Not enough storage is available to complete this operation"
and refu
Boszormenyi Zoltan wrote:
> Hi,
>
> I am using this code on 8.4/8.5, which works on 64-bit,
> but segfaults on 32-bit Linux:
>
I'm not sure but perhaps this patch could help you. It may be a bit outdated.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQ
On Sun, Nov 15, 2009 at 3:45 PM, undisclosed user
wrote:
> Backing up data by user is required for my solution. A lot of times, users
> screw up and they want to rollback to a previous state.
In that case, being able to revert the state of an application should
be part of the application (and dat
On Mon, Nov 16, 2009 at 7:53 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to Amitabh Kant :
>
> test=# select * from t1;
> a1
>
> 0
> 12
> 8
> 0
> 1
> 10
> 7
> 19
> (8 rows)
>
> test=*# select a1 from t1 where (a1>>2)::bit = B'1';
> a1
>
> 12
>
On Mon, Nov 16, 2009 at 2:37 AM, Jasen Betts wrote:
> On 2009-11-14, Joao Ferreira gmail wrote:
>> ok. thx all for the explanation
>>
>> my problem is I a heavilly bloated pg database that has just filled up
>> the partition
>>
>> data is in /var/pgsql/.. and /var is 100% full...
>>
>> vacuum/rei
Boszormenyi Zoltan writes:
> //ids =
> PointerGetDatum(PG_DETOAST_DATUM(SPI_getbinval(prod_inv->vals[0],
> prod_inv->tupdesc, 1, &isnull)));
well, for one thing, you probably want DatumGetPointer ... for another,
you shouldn't really be converting to Pointer here at all, since the
next line e
2009/11/16 A. Kretschmer :
> In response to Amitabh Kant :
>> Hello
>>
>> I need to compare the bit values of a integer field in my table. For
>> example, I
>> have a table called "t1" with just one field "a1" having following values:
>>
>> a1
>> ==
>> 0
>> 12
>> 8
>> 0
>> 1
>> 10
>> 7
>> 19
>>
>>
In response to Amitabh Kant :
> Hello
>
> I need to compare the bit values of a integer field in my table. For
> example, I
> have a table called "t1" with just one field "a1" having following values:
>
> a1
> ==
> 0
> 12
> 8
> 0
> 1
> 10
> 7
> 19
>
> I am trying to fetch all records where the
2009/11/16 Amitabh Kant :
> Hello
>
> I need to compare the bit values of a integer field in my table. For
> example, I have a table called "t1" with just one field "a1" having
> following values:
>
> a1
> ==
> 0
> 12
> 8
> 0
> 1
> 10
> 7
> 19
>
> I am trying to fetch all records where the 3rd bina
Hello
I need to compare the bit values of a integer field in my table. For
example, I have a table called "t1" with just one field "a1" having
following values:
a1
==
0
12
8
0
1
10
7
19
I am trying to fetch all records where the 3rd binary bit is 1, which from
the above example should be 12 (000
"Greg Smith" wrote in message
news:4afde758.1050...@2ndquadrant.com...
> Tom Lane wrote:
>> The real problem that I think the OP hasn't considered is whether
>> his "bundled" RPM package isn't going to conflict with a preinstalled
>> postgresql RPM. Relocating the RPM, either dynamically as you
2009/11/16 Dave Page :
> Thanks for working on these Thom.
>
No problem, although I'm disappointed with the output. A bit of
planning before I left the UK and it would have been better. Oh well,
better than nothing.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
Thanks for working on these Thom.
/D
On 11/16/09, Thom Brown wrote:
> 2009/11/15 Thom Brown :
>> 2009/11/14 Thom Brown :
>>> 2009/11/14 Thom Brown
Mr Fetter has allowed me to post his lightning talk on lightning talks:
http://vimeo.com/7602006
Thom
>>>
>>> Harald's lightning
Greg Smith píše v ne 15. 11. 2009 v 22:16 -0500:
> Tom Lane wrote:
> > Simon Riggs writes:
> >
> > > If we did add an extra option then the option would be "initdb" not
> > > "init". It would take us all years to remove all evidence of the phrase
> > > "initdb" from the mailing lists and our m
2009/11/15 Thom Brown :
> 2009/11/14 Thom Brown :
>> 2009/11/14 Thom Brown
>>>
>>> Mr Fetter has allowed me to post his lightning talk on lightning talks:
>>> http://vimeo.com/7602006
>>> Thom
>>
>> Harald's lightning talk also available with his
>> permission: http://vimeo.com/7610987
>> Thom
>
>
Tom Lane píše v so 14. 11. 2009 v 11:22 -0500:
> Zdenek Kotala writes:
> > Because there is doubt if someone else want this I would like to ask
> > here for your opinion. There are following options:
>
> > 1) Yeah I like pg_ctl init
>
> > "pg_ctl init" will be preferred method and initd
The app is very similar to wordpress MU. Each user has the same schema but
different data. The app uses the same codebase for every user. Users do not
have direct access to data. Currently, the DB is 90% r / 10% w and about
80GB MyISAM. Most of the queries are simple (75%)...the rest are joins
(25%
On Nov 14, 8:07 am, zdenek.kot...@sun.com (Zdenek Kotala) wrote:
> Hi all,
>
>
> Because there is doubt if someone else want this I would like to ask
> here for your opinion. There are following options:
>
> 1) Yeah I like pg_ctl init
>
> "pg_ctl init" will be preferred method and initdb
BuyAndRead Test wrote:
This is a virtual server, so I could give it as much as 8 GB of memory if
this will give much higher performance. What should shared_buffere be
set to
if I use 8 GB, as much as 4 GB?
John R Pierce wrote:
I'd keep it around 1-2GB shared_buffers, and let the rest of the m
On Nov 15, 1:07 pm, lovetodrinkpe...@gmail.com (undisclosed user)
wrote:
> If I were to switch to a single DB/single schema format shared among all
> users , how can I backup each user individually?
>
> Frank
>
I would love to understand why that would be a requirement. I would
much
prefer backi
On 2009-11-14, Joao Ferreira gmail wrote:
> ok. thx all for the explanation
>
> my problem is I a heavilly bloated pg database that has just filled up
> the partition
>
> data is in /var/pgsql/.. and /var is 100% full...
>
> vacuum/reindex is saying: I can't do it cause I have no space :(
>
> how
In response to Malm Paul :
> Hi List,
> I have a database with two tables header and idata, they are connected with an
> conn_ID.
> I would like to dump header and the connected idata tables with a certain
> conn_ID. This I would like to import to the same type of database on another
> PostgreSQL s
On 2009-11-12, A. Kretschmer wrote:
> Hi,
>
> just to be sure, it is still (8.4) not possible to use RETURNING within an
> other INSERT?
not in pure SQL, but it should be possible in PLPGSQL etc.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
On 2009-11-05, Sam Mason wrote:
> On Thu, Nov 05, 2009 at 08:24:24AM -0600, Michael Gould wrote:
>> We want to control from our application how to handle certain exceptions. I
>> believe that Raise is the functionality that we want to use. The
>> documentation is a little light on what happens on
On 2009-11-08, Bret wrote:
>
> I need to back up a production database every night
> on FreeBSD 7.2, running Postgresql 8.3.
>
> Any good backup tips I should be aware of.
I backup using pgdump and move the dumps offsite using
rsync --compress
overwriting a copy of yesterdays backup
in this
On 2009-11-07, Joshua Berry wrote:
> On Mon, Nov 2, 2009 at 8:35 AM, Jasen Betts wrote:
>|
>| for this case: convert to seconds and then do abs.
>|
>| select * from enviados e, recibidos r where abs(extract ( epoch from
>| (e.fecha - r.fecha) )) < 1
>
> Cheers for that. The query cost is pretty
Hi List,
I have a database with two tables header and idata, they are connected with an
conn_ID.
I would like to dump header and the connected idata tables with a certain
conn_ID. This I would like to import to the same type of database on another
PostgreSQL server.
I would be gratefull if some
Hello
2009/11/16 Konstantin Izmailov :
> I'm planning to use multiple statements via libpq. Before starting coding
> I'm trying to understand are there any limitations on passing parameters.
> E.g. would the following work:
> PQexecParams(conn, "BEGIN;INSERT INTO tbl VALUES($1,$2);SELECT
> lastv
Hi,
I am using this code on 8.4/8.5, which works on 64-bit,
but segfaults on 32-bit Linux:
oids[0] = TEXTOID;
values[0] = lex;
nulls[0] = false;
ret = SPI_execute_with_args(
(just_title ?
"SELECT ids FROM product.t_product_inv_titleonly WHERE word
= $1"
On 2009-11-10, Antonio Ruggiero wrote:
> I am running PostgresSQL 8.3.8 on windows XP-64Bit. I am using psql
> client from the PostgreSQL installation and not the Cygwin client.
>
> My issue is that the command line argument "-c command" is not
> recognized. For example, if I run (from Cygwin)
>
On 2009-11-16, Konstantin Izmailov wrote:
> --000e0cd5d09230ff7d04787526aa
> Content-Type: text/plain; charset=ISO-8859-1
>
> I'm trying to read "money" field using PQgetvalue (PostgreSQL 8.3.7). The
> function returns 9 bytes, smth like 0h 0h 0h 0h 0h 0h 14h 0h 0h, for the
> value '$50.2'. I coul
66 matches
Mail list logo