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:
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
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:
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:
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 get
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:
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
select
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 are also not
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
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
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 and
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_user
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.
I
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 wrote:
On
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
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
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
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,
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
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 array[3,4])
(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,
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?
On Wed, Sep 2, 2009 at 9:47 AM, Massa, Harald Arminc...@ghum.de 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(
SELECT x::intarr
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
Gordon Ross gr...@ucs.cam.ac.uk 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
August Lilleaas augustlille...@gmail.com 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
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
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
Guptahimanshu.gu...@semanticbits.com wrote:
I want single user to see all the schema at once. Database server is on
client side and it takes
On 02/09/2009 15:39, Andreas Kretschmer akretsch...@spamfence.net wrote:
Gordon Ross gr...@ucs.cam.ac.uk 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
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 than 20,
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
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 user
On Wed, Sep 2, 2009 at 4:41 PM, Tom Lane t...@sss.pgh.pa.us wrote:
August Lilleaas augustlille...@gmail.com 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
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
[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
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,
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!
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,
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
Then
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
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't
Thanks for this! It's a great resource for the community.
2009/9/2 Devrim GÜNDÜZ dev...@gunduz.org:
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
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,
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
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 torea...@fastmail.fm:
Hi,
our application is using Postgres in a rather unusuall way.
It is used by a GUI application to store several hundred
thousand
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 testing it,
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
Wellmann, Harald harald.wellm...@harman.com 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
Gordon Ross gr...@ucs.cam.ac.uk 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
V S P torea...@fastmail.fm writes:
The application typicall goes like this
select id, child_tb_key_id, fields with parms 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
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
{
QArrayL list_of_props_xyz;
}
int main ()
{
A inst1;
inst1.create_or_update_DbSchemaIfNeeded();
V S P torea...@fastmail.fm 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
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
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:
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
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.
On Wed, Sep 2, 2009 at 3:50 PM, Dave
Huberdhu...@letourneautechnologies.com 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
- On Wed, 9/2/09, August Lilleaas augustlille...@gmail.com wrote:
From: August Lilleaas augustlille...@gmail.com
Subject: [GENERAL] Ungooglable error message when running initdb: Symbol not
found: _check_encoding_conversion_args
To: pgsql-general@postgresql.org
Date: Wednesday, September 2,
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
On Wed, Sep 02, 2009 at 02:45:39PM -0400, Tom Lane wrote:
V S P torea...@fastmail.fm 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?
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
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:
Karina Guardado karina.guard...@ues.edu.sv 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
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
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
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
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
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
69 matches
Mail list logo