am 03.01.2006, um 18:19:12 -0500 mailte Greg Stark folgendes:
> Look in the contrib directory, build the intagg module (or if you use debian
> install the postgresql-contrib package) and then:
>
> SELECT id, int_array_enum(val) FROM t7
Cool, it works perfectly.
Andreas
--
Andreas Kretschmer
Allen Fair <[EMAIL PROTECTED]> writes:
> Our databases can get large and we want to find the best way to plan for
> when a database outgrows its current server.
>
> How about a replication scheme and cutover? If so, is there a preferred
> replication package to support this?
Slony-I was designed
Tom,
Thanks for the reply. That makes sense.
Do you or (or anyone else) suggest a method for moving databases from
one server to another without the time consuming dump/transfer/restore
process? Anything in the contrib directory or a good management tool?
Our databases can get large and we want
Joe Conway <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> It's not only the downstream packagers that have missed these: the
>> Makefiles don't install them either.
>>
>> It'd be a good idea to settle on what we want the installed file layout
>> to be --- do we need to create subdirectories unde
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
I'm happy to lump all the docs back into the README if that's what you
want, but I split it up in the first place because it was getting very long.
No, I'm not really proposing that we force all contrib modules to have
only a README. I'm
SunWuKung <[EMAIL PROTECTED]> writes:
> Thank you both, I will make good use of this.
>
> On a side note: isn't it a pity this has to be so difficult?
It doesn't have to be.
Look in the contrib directory, build the intagg module (or if you use debian
install the postgresql-contrib package) and
On Jan 3, 2006, at 16:01 , Emi Lu wrote:
I need to know when it is better that we use "timestamp without
time zone" ? And when it is better to use "timestamp with time zone"?
In my opinion, if you want to store a timestamp, you should always
use timestamp with time zone, as the UTC offset
Greetings,
Happy New Year listing!
I have a question about column type timestamp "with time zone" and
"without time zone".
. when data are import/export into different time zones, column
timestamp with time zone is necessary
For example, "2005-01-01 2001:01:01+05" under timezone1 will still b
Allen Fair <[EMAIL PROTECTED]> writes:
> Looking at the "create tablespace " command in the docs, I was wondering
> how easy it is to move a database/tablespace to another server/instance
> of PostgreSQL.
It's not. The contents of the tablespace are tied to the instance
(because rows contain tr
Hi!
Looking at the "create tablespace " command in the docs, I was wondering
how feasible it is to move a database/tablespace to another
server/instance of PostgreSQL.
Issue: moving databases using pg_dump and pg_restore is more
time-consuming than desired, requiring the db to be unavailable
Hi!
Looking at the "create tablespace " command in the docs, I was wondering
how easy it is to move a database/tablespace to another server/instance
of PostgreSQL.
We have lots of databases, with the same definitions, with 1 database
per client account on the server. I can setup the database
Peter Alberer" <[EMAIL PROTECTED]> writes:
> Hmmm, i suspect the problem comes from the fact that i did not globally
> change gcc to use -m64 nor did I set the enviroment flags (CFLAGS), but
> changed the command in the makefile. The configure script did its tests with
> the default -m32 and did no
""FERREIRA, William (GFI INFORMATIQUE)"" <[EMAIL PROTECTED]> wrote
>
> i'm trying to install Postgresql on Solaris.
> Looking at the generated code, i saw that it was in 32 bits.
> I would like to compile Postgresql in 64 bits but i didn't find any post
> in the archives about this.
>
Check out
Hmmm, i suspect the problem comes from the fact that i did not globally
change gcc to use -m64 nor did I set the enviroment flags (CFLAGS), but
changed the command in the makefile. The configure script did its tests with
the default -m32 and did not define HAVE_LONG_INT_64. Maybe even
INT64_IS_BUS
Marc Philipp wrote:
During a daily update process new timestamps are collected and existing
data rows are being updated (new rows are also being added). These
changes affect a large percentage of the existing rows.
What we have been observing in the last few weeks is, that the overall
data
The platform is a redhat advanced server 4 update 2 for power5 64bit. the
compiler is gcc:
Reading specs from /usr/lib/gcc/ppc64-redhat-linux/3.4.4/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-
Hi,
On Mon, 2 Jan 2006, cmire wrote:
I'm running into a dependency issue trying to install postgresql-8.1.1 on SuSE
10.0. I've resolved all but one dependency:
error: Failed dependencies:
initscripts is needed by postgresql-8.1.1-1PGDG
Hmm. It seems that you are trying to install Fe
Maybe you are right.
I am currently storing these values in a separate table and was looking for
a way to optimize it.
Without trying to pretend to be an expert on this I thought that using
arrays, storing calculated values, or using materialized views in a database
all violate the rules of normal
Marc Philipp <[EMAIL PROTECTED]> writes:
> A few performance issues using PostgreSQL's arrays led us to the
> question how postgres actually stores variable length arrays. First,
> let me explain our situation.
> We have a rather large table containing a simple integer primary key
> and a co
I figured it out myself. Not TOO difficult. I was just having a
hard time wading through the documentation before. Giving the answer
out here, just in case any one else wants to see the solution (not
using reserved words ;-)).
1. Made function:
CREATE FUNCTION "return_one_id" () RETURN
Michael Fuhr wrote:
On Mon, Jan 02, 2006 at 08:45:28AM -0200, alexandre - aldeia digital wrote:
In my Linux bash backup scripts, I wish to send an e-mail when an error
occurs in pg_dump proccess. And if possible, I want to send the error
output via e-mail.
Anybody knows how to capture the ou
Hello, there
I installed PostgreSQL on windows and when I try to
run some query's pgadmin says an error. I know that if I change the query this
it will work but is it possible to make this quey work in this
way
SELECT atthasdef FROM pg_attribute WHERE
attrelid=pg_class.oid AND pg_class.rel
I am new in this field and would appreciate it if someone points me to
the right direction.
I have a website with lots of users and each have lots of data in
multiple tables. I want to create a search box where a user can search
between all their data for the match. I want to search system to
cont
Realized. It was just a dummy-example, and I made a poor choice for
my example. Replaced reserved word, but the question still stands.
-a
Rewritten info without the reserved word:
CREATE TABLE "one" (
"one_id" BIGSERIAL,
"mytext" text NOT NULL,
CONSTRAINT "iu_mytext" UNIQUE (myt
A few performance issues using PostgreSQL's arrays led us to the
question how postgres actually stores variable length arrays. First,
let me explain our situation.
We have a rather large table containing a simple integer primary key
and a couple more columns of fixed size. However, there is
Hi all !
I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
I am using the latest installer from
http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
Here is my problem :
If I setup PostGreSQL to use the default data directory and my
language locale (French, Belgium) and UTF-8 encoding,
How about
SELECT * FROM pg_tables;
optionally add:
WHERE schemaname != 'pg_catalog'
AND schemaname != 'information_schema'
Willy-Bas Loos
>If you start psql with the -E option you can see the internal commands sent to
>the backend. This can often give you a lot of hints as to the best
I'm running into a dependency issue trying to install postgresql-8.1.1 on SuSE
10.0. I've resolved all but one dependency:
error: Failed dependencies:
initscripts is needed by postgresql-8.1.1-1PGDG
I downloaded a Fedora rpm for initscripts, initscripts-8.11.1-1.i386.rpm, but
got Red H
http://www.postgresql.org/about/licence
The short of it:
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written
agreement is hereby granted, provided that the above copyright notice
and this paragraph and the followi
P G <[EMAIL PROTECTED]> writes:
> I see that one can add a new column to an existing
> table. The documentation was not clear on how
> efficient this operation would be.
> Does PostgreSQL make a copy of the entire table when
> adding a new column? Or does it simply use extra
> space in the data
Tino Wildenhain <[EMAIL PROTECTED]> schrieb:
> *wink* ;)
> Tino
hehe ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
Hugo <[EMAIL PROTECTED]> schrieb:
> hello , is there a way to answer that question ?
Try this:
select * from pg_stat_activity ;
But some fields are only available with 8.1.
> thanks in advance
Please, no HTML.
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a c
SunWuKung schrieb:
> Thank you both, I will make good use of this.
>
> On a side note: isn't it a pity this has to be so difficult?
Well the pity is your data model - or the lack of it ;))
If redesign is possible, you probably want to change from
array to real connected table.
*wink* ;)
Tino
--
hello , is there a way to answer that question ?thanks in advanceHugoPd.Postgres 8.1 on FC4 and WinXP Pro
Alejandro,
I cannot build the list of errors because I am on
another project right now that is rush. I will trace and post the error(s)
as soon as I can.
Margaret.
On Tue, Jan 03, 2006 at 07:01:24PM +0800, xiapw wrote:
> Hi,who has some some document about extending postgresql,can you mail it to
> me?
See "Server Programming" in the documentation:
http://www.postgresql.org/docs/8.1/interactive/server-programming.html
If that doesn't help then please be mo
Here is a simple one, that keeps 2 copies (one for odd-numbered days and
one for even-numbered days), and emails the admin with the status:
#!/bin/sh
#This script is to back up the production databases
DBLIST="db1 proddb1 proddb2"
PGUSER=dbusername
DUMPDIR=/disk1/database/backups
MAILCMD=/bin/m
I see that one can add a new column to an existing
table. The documentation was not clear on how
efficient this operation would be.
Does PostgreSQL make a copy of the entire table when
adding a new column? Or does it simply use extra
space in the data blocks to add the new column?
2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
> 2006/1/3, [EMAIL PROTECTED] <
[EMAIL PROTECTED]>:
>
> >"Alejandro D. Burne" <[EMAIL PROTECTED]>
wrote on
> 01/01/2006 04:37:10 PM:
>
>
> > 2005/12/30, [EMAIL PROTECTED] <
[EMAIL PROTECTED]>:
>
> >
> > I am writing an application in Visual
> 2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
> >"Alejandro D. Burne" <[EMAIL PROTECTED]>
wrote on
> 01/01/2006 04:37:10 PM:
>
>
> > 2005/12/30, [EMAIL PROTECTED] < [EMAIL PROTECTED]>:
>
> >
> > I am writing an application in Visual Foxpro 9 (running
on Windows
> > 2000) but I get
If I understand this correctly, I think you want to implement the sort
of security that Veil provides. Take a look at
http://pgfoundry.org/projects/veil/
The documentation is at
http://veil.projects.postgresql.org/curdocs/index.html
__
Marc
On Sun, 2006-01-01 at 17:02 -0400, littlebutty wrote:
2006/1/3, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>"Alejandro D. Burne" <[EMAIL PROTECTED]>
wrote on 01/01/2006 04:37:10 PM:
> 2005/12/30, [EMAIL PROTECTED] <
[EMAIL PROTECTED]>:
>
> I am writing an application in Visual Foxpro 9 (running on Windows
> 2000) but I get errors when VFP9 tries to w
Karsten,
The project homepage has a reference to the project documentation. It
can be found here:
http://veil.projects.postgresql.org/curdocs/index.html
If this does not contain what you are looking for, please explain what
you need to know as I'd like to improve the documentation.
I'm guessin
Thank you both, I will make good use of this.
On a side note: isn't it a pity this has to be so difficult?
Balázs
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> am 03.01.2006, um 16:42:08 +0200 mailte Volkan YAZICI folgendes:
> > Hi,
> >
> > Here's a modified version of A. Kretsc
Hi,
i'm trying to install Postgresql on Solaris.
Looking at the generated code, i saw that it was in 32 bits.
I would like to compile Postgresql in 64 bits but i didn't find any post in the
archives about this.
Thanks in advance.
Will
This e-mail is intended only for the above addressee. It
Don't use reserved words for column names.
"Albert Vernon Smith" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have two tables, listed as below. I'm inserting values for "text" into
>table "two" (which must already exist as "text" values in table "one").
>When I do that, I'
Arnaud Lesauvage wrote:
>> Hi all !
>>
>> I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
>> I am using the latest installer from
>> http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
>>
>> Here is my problem :
>> If I setup PostGreSQL to use the default data directory and my
>> languag
On Fri, 2005-12-30 at 16:39, Harry Jackson wrote:
> On 12/30/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> >
> > On 12/30/05, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> >
> > QUOTE:
> > I used it once (2004) because it supported Postgres. It got hacked in
> > under a month. I admit that
"Ardian Xharra \(Boxxo\)" <[EMAIL PROTECTED]> writes:
> Yes it is the version 8.1.1 and the error is
> ERROR: missing FROM-clause entry for table "pg_class"
> I have too many queries like this in my program and I was thinking maybe is
> the fault of installation like I missed something. Is there a
"Peter Alberer" <[EMAIL PROTECTED]> writes:
> The command
> CREATE SEQUENCE assignment_task_elements_seq2
> INCREMENT BY 1
> MAXVALUE 9223372036854775807
> NO MINVALUE
> CACHE 1;
> Causes the following error: MINVALUE (1) must be less than MAXVALUE (-1)
Not for me. What *exactl
Thank you Micheal it was the add_missing_from
And sorry for the last post I didn't read the whole message from you.
Ardian
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 02/01/2006
am 03.01.2006, um 16:42:08 +0200 mailte Volkan YAZICI folgendes:
> Hi,
>
> Here's a modified version of A. Kretschmer's answer. This one checks
> array_upper() sizes and depending on it, doesn't provide unnecessary
> NULL fields. HTH.
>
> SELECT id, val[s.i]
> FROM t7
> LEFT JOIN
> (SELECT
On 2005-12-27, Eugene <[EMAIL PROTECTED]> wrote:
> I've indexed first two columns they are IPfrom, IPto also table is btree
> version of postgre is 7.4.8, on hosting
> I ask db like this SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom
> AND ipto;
>
> and get answer after 3-10 seconds, is t
Hi,
Here's a modified version of A. Kretschmer's answer. This one checks
array_upper() sizes and depending on it, doesn't provide unnecessary
NULL fields. HTH.
SELECT id, val[s.i]
FROM t7
LEFT JOIN
(SELECT g.s
FROM generate_series(1,
(SELECT max(arr
Hi all !
I am trying to install PostGreSQL 8.1.1 on my WinXP Pro.
I am using the latest installer from
http://www.postgresql.org/ftp/binary/v8.1.1/win32/.
Here is my problem :
If I setup PostGreSQL to use the default data directory and my
language locale (French, Belgium) and UTF-8 encoding, eve
On Tue, 27 Dec 2005 23:25:37 +0200, Eugene <[EMAIL PROTECTED]> wrote:
>SELECT * FROM ipdb2 WHERE '3229285376' BETWEEN ipfrom AND ipto;
If your [ipfrom, ipto] ranges are non-overlapping, you might be able
to exploit that fact by adding something like
... ORDER BY ipfrom DESC LIMIT 1
Servu
I have two tables, listed as below. I'm inserting values for "text"
into table "two" (which must already exist as "text" values in table
"one"). When I do that, I'd like to also insert the associated
"one_id" value from table "one" into the field "two.one_id". How is
best to go about tha
On 1/2/06 5:34 PM, "SunWuKung" <[EMAIL PROTECTED]> wrote:
> I will need to insert multiple rows into a table from php.
> The data will come in 'packages' of 50-500 rows (they are responses from
> different questionnaires). As there will be many people sending their
> results in at the same time
Yes it is the version 8.1.1 and the error is
ERROR: missing FROM-clause entry for table "pg_class"
I have too many queries like this in my program and I was thinking maybe is
the fault of installation like I missed something. Is there anything I can
do or it's
the wrong way I was doing the queries
am 03.01.2006, um 13:24:54 +0100 mailte SunWuKung folgendes:
> Unfortunately the number of elements in the array is not known
> beforehand. The dimension of the array is always 1, but the number of
> elements changes from 50-500.
Okay.
test=# select * from t1;
id | foo
+
Unfortunately the number of elements in the array is not known
beforehand. The dimension of the array is always 1, but the number of
elements changes from 50-500.
I looked at the article you mention and it creates a set returning
function. I found some functions like that in the archive
- like
am 03.01.2006, um 12:37:51 +0100 mailte SunWuKung folgendes:
> When storing data in an array, like this
>
> idarray
> 1,{1,2}
> 2,{10,20}
> 3,{100,200}
Forever 2 Elements in the array? Then:
test=# select * from t1;
id |foo
+---
1 | {1,2}
2 | {10,20}
3 | {
When storing data in an array, like this
id array
1, {1,2}
2, {10,20}
3, {100,200}
is there a generic way to retrieve them as arowset, like this
id array_dimension1
1 1
1 2
2 10
2 20
By writing something like this:
Select id, explode(array) From
Hi,who has some some document about extending postgresql,can
you mail it to me?
Sting
Hi there,
i am trying to restore a database I have dumped from
a postgres 8.0.4 power5 (64bit) machine onto another server with the same
version and architecture.
It seems that recreating sequences does not work:
The command
CREATE SEQUENCE assignment_task_elements_seq2
I
65 matches
Mail list logo
