-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]on Behalf Of edisan
Sent: Thursday, 3 September 2009 2:48 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] handle audiofiles in postgres
Can anyone used or tell me how to handl
edisan wrote:
Can anyone used or tell me how to handle audio files in postgres
Audio files may be in wav / vox / dss format and each have average 30
min running time.
probably too large to want to store in the database, as a 30 minute PCM
.WAV file in CD quality could easily be 300 megabyte
Can anyone used or tell me how to handle audio files in postgres
Audio files may be in wav / vox / dss format and each have average 30 min
running time.
Thanks in advance
Regards
edi
> Most of the time, my application will set the edited_by field to
> reflect an application username (i.e., the application logs into the
> database as a database user, and that's not going to be the
> application user) So I log into my application as "Dave", but the
> application connects to the
Hi,
I think you can use the overlay function to do this.
http://www.postgresql.org/docs/current/static/functions-string.html
create table t1 (f char(10));
insert into t1 values ('abcdefg'),('hijklmno');
-- the below cmd will display only the first 2 characters of f.
-- if you want trim th
On Wed, Sep 02, 2009 at 04:40:13PM +0400, Igor Katson wrote:
> I have a table, which has a creation_ts (timestamp) column, but does
> not have a id (serial) column. I want to add such a one, but, AFAIK,
> if I enter
>
> ALTER TABLE table ADD COLUMN id serial
>
> it will randomly put the sequence
Karina Guardado writes:
> I hope some one can help me, I have created the following function but
> I always get the error that there is not function
> pg_catalog.btrim(date), in the version postgresql 8.1 it worked but now
> it does not so I don't know if it is related with a configuration
>
How to "use the stackbuilder to get hold of the postgis installer binary",
could you explain it more exactly?
I execute stackbuilder, but there is an error
r...@ubuntu-yingxia:/opt/PostgreSQL/8.4/stackbuilder/bin# ./stackbuilder
./stackbuilder: error while loading shared libraries: libgtk-x11-2.
I do follow your instruction. I successfully install postgis, but I can't
find postgis.sql under any folder.
My postgresql installed by apt-get.
After apt-get postgis, What should I to do? Only execute sql in
postgis.sql?
Joshua D. Drake wrote:
>
> On Wed, 2009-09-02 at 22:23 +0530, Sachin S
On Wed, Sep 02, 2009 at 02:45:39PM -0400, Tom Lane wrote:
> "V S P" writes:
> > Well, actually somebody has written a C++ ORM
> > [ that is causing all your problems and you say you can't discard ]
>
> Just out of curiosity, does anyone know of any ORM anywhere that
> doesn't suck? They seem to
Hi everybody,
I hope some one can help me, I have created the following function but
I always get the error that there is not function
pg_catalog.btrim(date), in the version postgresql 8.1 it worked but now
it does not so I don't know if it is related with a configuration
problem of the post
- On Wed, 9/2/09, August Lilleaas wrote:
From: August Lilleaas
Subject: [GENERAL] Ungooglable error message when running initdb: Symbol not
found: _check_encoding_conversion_args
To: pgsql-general@postgresql.org
Date: Wednesday, September 2, 2009, 7:52 AM
Hello there,
I'm configuring with `./
On Wed, Sep 2, 2009 at 3:50 PM, Dave
Huber wrote:
> I have an old table with a column specified as integer[]. The data within
> this column was stored as text ala {1,2,3,…} yada yada. I have an
> application where I am reading all the columns from a row in this table in
> binary format. Does anybod
Hello.
Some days ago I started using partitioning to make it possible to work
with large amount of data.
I created master table as documentation suggest, created some child
tables which inherit from the master one and then added a constraint
for each child table to define the allowed key value. C
I have an old table with a column specified as integer[]. The data within this
column was stored as text ala {1,2,3,...} yada yada. I have an application
where I am reading all the columns from a row in this table in binary format.
Does anybody know how I can recast/reshape this binary data back
Hmmm.
If I do:
select * from pg_settings where name='custom_variable_classes';
I see my entry "phone", but I can't see how I can tell if I've set "phone.id"
GTG
From: Tom Lane [...@sss.pgh.pa.us]
Sent: 02 September 2009 19:16
To: Gordon Ross
Cc: pgsql-ge
I do not know of any for C++.
That's why I started my own (which is not the one used for the problem I
am having :- ) )
http://github.com/vladp/CppOrm
it works with Pg 8.3+ and VC++ compiler sofar (but support for more
platforms and Dbs will be added in the future).
My Orm is not really an ORM be
"V S P" writes:
> Well, actually
> somebody has written a C++ ORM
> [ that is causing all your problems and you say you can't discard ]
Just out of curiosity, does anyone know of any ORM anywhere that doesn't
suck? They seem to be uniformly awful, at least in terms of their
interfaces to SQL da
Well, actually
somebody has written a C++ ORM
that allows to do things (just a sketch)
class L: CDbCapable
{
public:
int prop1;
int prop2;
}
class A: CDbCapable
{
QArray list_of_props_xyz;
}
int main ()
{
A inst1;
inst1.create_or_update_DbSchemaIfNeeded();
inst1.read
"V S P" writes:
> The application typicall goes like this
> select id, child_tb_key_id, from tb1
> then for each selected row above
> select from the child table do a select (like the above)
> and so on -- many levels deep
Seems like you need to fix your data representation so that this
Gordon Ross writes:
> Sorry, no joy :-(
> grails=> SELECT current_setting('phone.id');
> ERROR: unrecognized configuration parameter "phone.id"
> grails=> SELECT coalesce(current_setting('phone.id'),'SYSTEM');
> ERROR: unrecognized configuration parameter "phone.id"
You could use a SELECT fro
"Wellmann, Harald" writes:
> The problem occurs with PostgreSQL 8.4.0. I cannot reproduce it with
> PostgreSQL 8.3.7.
There are known bugs in 8.4.0 having to do with improperly exchanging
the ordering of semijoins (IN joins) and other joins. You haven't
provided enough information to test whethe
Hi,
yes, I am sure I have to continue supporting Postgres
at this time, it would take enormous effor to change to something else
But yes, sqlite or tokiocabinet in my view would be good options (the
decison was made
some time ago, unfortunately).
On Wed, 02 Sep 2009 19:49 +0200, "Pavel Stehule"
Hi,
On Wed, 2009-09-02 at 13:47 -0300, Emanuel Calvo Franco wrote:
> > I released initial version of my PostgreSQL 8.4 live CD, which i
> > based on CentOS 5.3. It includes the PostgreSQL related packages
> > that I build on http://yum.pgsqlrpms.org , along with PostgreSQL
> > 8.4.0.
>
> I'm tes
Hello
Are you sure, so you have to use PostgreSQL - maybe SQLite or
memcached is better for your task.
regards
Pavel Stehule
2009/9/2 V S P :
> Hi,
> our application is using Postgres in a rather unusuall way.
> It is used by a GUI application to store several hundred
> thousand 'parameters'. B
Here is my first post which missed the list. Not that it makes that
much of a difference now as all my points have been addressed by others.
raa
Himanshu Gupta wrote:
Hi,
I have multiple applications, i want to create separate schema for each
of the application. I dont want to change search
Sam Mason wrote:
On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
Thanks for response, bit if I point it to all the schema, I am just
wondering how data insertion will work, I have multiple ables with
same name in these applications.
Do you know that you can schema qualify ta
Hi,
our application is using Postgres in a rather unusuall way.
It is used by a GUI application to store several hundred
thousand 'parameters'. Basically it is used like a big INI
file.
There are about 50 tables with various parameters.
The application typicall goes like this
select id, child_t
Thanks for this! It's a great resource for the community.
2009/9/2 Devrim GÜNDÜZ :
>
> You wanted it, and here we go:
>
> I released initial version of my PostgreSQL 8.4 live CD, which is based
> on CentOS 5.3. It includes the PostgreSQL related packages that I build
> on http://yum.pgsqlrpms.org
On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
> Thanks for response, bit if I point it to all the schema, I am just
> wondering how data insertion will work, I have multiple ables with
> same name in these applications.
Do you know that you can schema qualify table names don'
OOPS I got caught by the reply verses reply-all and only sent this to
Scott. Plus I see it has already been addressed in a later message.
raa
Scott Marlowe wrote:
So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
The only issue I s
On Wed, 2009-09-02 at 22:23 +0530, Sachin Srivastava wrote:
> On 09/02/2009 08:20 PM, shane_china wrote:
> > I want to know is there any way can install postgis for postgresql so
> > easily,
> > just like one click bin on Ubuntu using command line?
sudo apt-get install postgresql-8.3-postgis
The
On 09/02/2009 08:20 PM, shane_china wrote:
I want to know is there any way can install postgis for postgresql so easily,
just like one click bin on Ubuntu using command line?
I know there is a tool called stack builder which work after version 8.2 for
easily installing extensions, I have tried,
> You wanted it, and here we go:
>
> I released initial version of my PostgreSQL 8.4 live CD, which is based
> on CentOS 5.3. It includes the PostgreSQL related packages that I build
> on http://yum.pgsqlrpms.org , along with PostgreSQL 8.4.0.
>
I'm testing it, works well!
> https://projects.cen
I want single user to see all the schema at once. Database server is
on client side and it takes time to get new user or new database
instance, So i am trying to find a workaround for that.
Thanks,
Himanshu
On Sep 1, 2009, at 6:04 PM, Scott Marlowe wrote:
On Tue, Sep 1, 2009 at 2:58 PM, Hi
[Sorry if you receive multiple copies of this message.]
[Please feel free to forward the message to others who may be
interested.]
Hi,
We are a computer systems research group at the Computer Science
department at Rutgers University, and are conducting research on
simplifying the software conf
I want to know is there any way can install postgis for postgresql so easily,
just like one click bin on Ubuntu using command line?
I know there is a tool called stack builder which work after version 8.2 for
easily installing extensions, I have tried, but it seem doesnt work under
command line.
Hi Scott,
Thanks for response, bit if I point it to all the schema, I am just
wondering how data insertion will work, I have multiple ables with
same name in these applications.
-HImanshu
On Sep 2, 2009, at 10:48 AM, Scott Marlowe wrote:
you just set search_path to point to all the sche
On Wed, Sep 2, 2009 at 4:41 PM, Tom Lane wrote:
> August Lilleaas writes:
> > I'm configuring with `./configure
> > --prefix=/usr/local/Cellar/postgresql/8.4.0`, without sudo. I hawe
> chowned
> > /usr/local so that I don't need to sudo it. I'm getting the following
> error
> > when running `ini
Thanks Thomas! Your help is very appreciated :)
I'm going to test what you suggest.
Thanks again!
Thomas Kellerer wrote:
>
> Inigo Barandiaran, 02.09.2009 14:53:
>> Thanks Thomas!.
>> That sounds very interesting. How can I set privileges for writing in
>> data
>> directory for the postgres
Inigo Barandiaran, 02.09.2009 14:53:
Thanks Thomas!.
That sounds very interesting. How can I set privileges for writing in data
directory for the postgres user account?.
Right click on the directory and choose "Security". Anything after that is
off-topic in this list ;)
Or is it very to di
On Wed, Sep 02, 2009 at 10:11:24PM +0900, tanjunhua wrote:
> thanks for your response.
>
> >Maybe if you could describe what you want to do in English then the
> >query would make a bit more sense.
> I just want those records as the below rule:
> 1. the record of which uid is 2, status is more tha
On 02/09/2009 15:39, "Andreas Kretschmer" wrote:
> Gordon Ross wrote:
>> Is there a way to either test if the custom variable is set, or to specify a
>> global default for the custom variable ?
>
> I think, you can use COALESCE(your_variable, default_value) to solve
> that problem. Try it, it is
So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
On Wed, Sep 2, 2009 at 7:19 AM, Himanshu
Gupta wrote:
> I want single user to see all the schema at once. Database server is on
> client side and it takes time to get new user or new datab
>nope...it's an array of composite types, each type with one field, and
>array of two ints. this is waht you wanted? what are you trying to do
>exactly?
yeah, that is quite what I want, just was "surprised" by the way psql
displayed the result. What I am doing:
I have a table:
key1 key2 key3 in
August Lilleaas writes:
> I'm configuring with `./configure
> --prefix=/usr/local/Cellar/postgresql/8.4.0`, without sudo. I hawe chowned
> /usr/local so that I don't need to sudo it. I'm getting the following error
> when running `initdb` after successfully compiling postgresql
> Symbol not fou
Gordon Ross wrote:
> (I'm using Postgres 8.3)
>
> I have a trigger that references a custom variable. Most of the time this
> custom variable is set, and I have no problems.
>
> However, in certain corner cases the custom variable is not set and the
> trigger fails.
>
> Is there a way to eithe
I'm not sure if I'm making wrong assumptions on the semantics of
subselect or if this a problem in PostgreSQL:
I'm using query with the following structure
select a1.id, c1.foo
from a as a1
join b on ...
join c as c1 on ...
where a.id in (
select a2.id
from a as a2
left join c as c2
On Wed, Sep 2, 2009 at 9:47 AM, Massa, Harald Armin wrote:
> Sam,
>
>> To all: is there a deeper reason why there is no array type for datatype
>> record available?
>>
>> Not enough demand :)
>
> seams reasonable :)
>
>>
>> Try:
>>
>> CREATE TYPE intarr AS (arr int[]);
>> SELECT array(
>> SELE
On Wed, Sep 02, 2009 at 03:47:53PM +0200, Massa, Harald Armin wrote:
> ibox=# CREATE TYPE intarr AS (arr int[]);
> CREATE TYPE
> ibox=# SELECT array(
> SELECT x::intarr FROM (
> SELECT array[2,3]
> UNION ALL
> SELECT array[3,4]) x(a));
>?column?
> --
(I'm using Postgres 8.3)
I have a trigger that references a custom variable. Most of the time this
custom variable is set, and I have no problems.
However, in certain corner cases the custom variable is not set and the
trigger fails.
Is there a way to either test if the custom variable is set, o
Sam,
> To all: is there a deeper reason why there is no array type for datatype
> record available?
> Not enough demand :)
>
seams reasonable :)
> Try:
>
> CREATE TYPE intarr AS (arr int[]);
> SELECT array(
>SELECT x::intarr FROM (
> SELECT array[2,3]
> UNION ALL
> SELECT
thanks for your response.
Maybe if you could describe what you want to do in English then the
query would make a bit more sense.
I just want those records as the below rule:
1. the record of which uid is 2, status is more than 20, bpassword is 0 and
realdelflag is 0 in tab_main;
1.1 the recor
Thanks Thomas!.
That sounds very interesting. How can I set privileges for writing in data
directory for the postgres user account?. Or is it very to directly install
posgreSQL out of "Program Files" Directory?
Thanks in advance!
I've check
Thomas Kellerer wrote:
>
> Inigo Barandiaran, 02.09
I have a table, which has a creation_ts (timestamp) column, but does not
have a id (serial) column. I want to add such a one, but, AFAIK, if I enter
ALTER TABLE table ADD COLUMN id serial
it will randomly put the sequence numbers.
I wrote a function, which uses a cursor and UPDATE WHERE CURRENT
Inigo Barandiaran, 02.09.2009 12:39:
We have included PostgreSQL 8.3(exe) installation in the installation
process of our software, and we are experimenting some errors, mainly
related with Windows Vista. The problem is that the installation of
PosgreSQL seems to be correct, but the service is no
It is in /usr/local/Cellar/postgresql/8.4.0/bin/, but `which initdb` returns
"/usr/local/bin/initdb". The /usr/local/bin one is a symlink to the
/usr/local/Cellar/postgresql/8.4.0/bin one.
Running "/usr/local/Cellar/postgresql/8.4.0/bin/initdb -D
/usr/local/Cellar/postgresql/8.4.0/defaultdb" yields
Thanks Raymond.
Where can I find that log?
I took a look in the bin folder where the service, and there is no log
there.
Thanks in advance!
On 02/09/2009 11:39, Inigo Barandiaran wrote:
PosgreSQL seems to be correct, but the service is not started afterwards. I
tried to start it
Sorry, I've just found it in: data\pg_log
I'm going to take a look.
Thanks again :)
Inigo Barandiaran wrote:
>
> Thanks Raymond.
>
> Where can I find that log?
> I took a look in the bin folder where the service, and there is no log
> there.
>
> Thanks in advance!
>
>
> Raymond O'Donnell wr
Thanks Raymond.
Where can I find that log?
I took a look in the bin folder where the service, and there is no log
there.
Thanks in advance!
Raymond O'Donnell wrote:
>
> On 02/09/2009 11:39, Inigo Barandiaran wrote:
>> PosgreSQL seems to be correct, but the service is not started afterwards.
>
On Wed, Sep 02, 2009 at 02:31:46PM +0900, tanjunhua wrote:
> I
> have the trouble that it cost me a lot of time when execute the select
> syntax. the following is the select syntax and analyze result.
> EXPLAIN ANALYZE SELECT count(Id) FROM (SELECT DISTINCT t1.Id AS Id FROM
> tab_main t1, tab_
On 02/09/2009 11:39, Inigo Barandiaran wrote:
> PosgreSQL seems to be correct, but the service is not started afterwards. I
> tried to start it manually but takes a lot of time and finally a windows
> error appears telling that "the PostgreSQL Database server 8.3 service on
> Local Computer Started
Hi all.
We have included PostgreSQL 8.3(exe) installation in the installation
process of our software, and we are experimenting some errors, mainly
related with Windows Vista. The problem is that the installation of
PosgreSQL seems to be correct, but the service is not started afterwards. I
tried
On Wed, 2009-09-02 at 09:52 +0200, August Lilleaas wrote:
> augu...@honk:~$ initdb -D /usr/local/Cellar/postgresql/8.4.0/defaultdb
Is initdb under /usr/local/Cellar/postgresql/8.4.0/bin, or is there
another one in $PATH?
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim
On Wed, Sep 02, 2009 at 11:50:38AM +0200, Massa, Harald Armin wrote:
> select array(
> > select x from (
> > select array[2,3] as a
> > union
> > select array[3,4] as a ) x);
> >
> > ERROR: could not find array type for datatype record
>
> ... I remember being there before :( arrays of rows
Sam,
No, as depesz says it's not doing that. Depending on what you want out
> you can get most of the way by having an array of ROWs that contain an
> array of integers. You just need to change:
>
> the sad thing is:
select array(
> select x from (
> select array[2,3] as a
> union
> selec
Hi,
I've added a wiki page with some information you might find helpful,
if you are attending the PostgreSQL Conference 2009 in Japan. However,
I've never been to Tokyo before, so please feel free to correct and
add better links, hints and recommendations:
http://wiki.postgresql.org/wiki/
On Wed, Sep 02, 2009 at 10:34:31AM +0200, Massa, Harald Armin wrote:
> postgres=# select array[[2,3],[3,4]];
> array
> ---
> {{2,3},{3,4}}
>
> -> the result looks for me as an array of integer-arrays
No, as depesz says it's not doing that. Depending on what you want out
you can
On Wed, Sep 02, 2009 at 10:34:31AM +0200, Massa, Harald Armin wrote:
> Is there a bug in my thinking that array[[2,3],[3,4]] really constitutes an
> array of integer[],
no. array[[2,3],[3,4]] is 2 dimensional array of integers. not array of
arrays of integers.
Best regards,
depesz
--
Linkedin:
Hello,
if I use this statement:
postgres=# select array[[2,3],[3,4]];
array
---
{{2,3},{3,4}}
-> the result looks for me as an array of integer-arrays
now I try:
select array(
select a from
(
select array[2,3] as a
union
select array[3,4] as a
) x);
and the result is:
FEHL
You wanted it, and here we go:
I released initial version of my PostgreSQL 8.4 live CD, which is based
on CentOS 5.3. It includes the PostgreSQL related packages that I build
on http://yum.pgsqlrpms.org , along with PostgreSQL 8.4.0.
Details are here:
http://yum.pgsqlrpms.org/livecd.php
http://
Hello there,
I'm configuring with `./configure
--prefix=/usr/local/Cellar/postgresql/8.4.0`, without sudo. I hawe chowned
/usr/local so that I don't need to sudo it. I'm getting the following error
when running `initdb` after successfully compiling postgresql
Symbol not found: _check_encoding_co
72 matches
Mail list logo
