Greg Smith wrote:
On Mon, 4 Feb 2008, Dave Page wrote:
We intentionally have not done that as we wanted to ensure that all
documentation published under postgresql.org was appropriately
moderated first.
OK, so hosting a probably inaccurate in many ways (at first) community
documentation proj
This is really a web site error report, but I don't see any links on the
site to report such errors. On the 8.3 Features List page here:
http://www.postgresql.org/about/press/features83.html, it mentions
"Version 2.0 of Slony-I, our most popular replication system, now uses
the new replication
On Feb 5, 2008, at 10:17 AM, Alex Turner wrote:
On Feb 4, 2008 7:09 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Feb 3, 2008 10:14 PM, Alex Turner <[EMAIL PROTECTED]> wrote:
I"m not a database expert, but wouldn't
create table attribute (
attribute_id int
attribute text
)
create tabl
On Mon, 4 Feb 2008, Dave Page wrote:
We intentionally have not done that as we wanted to ensure that all
documentation published under postgresql.org was appropriately
moderated first.
OK, so hosting a probably inaccurate in many ways (at first) community
documentation project wiki is inappro
On Feb 5, 2008, at 4:28 PM, Jeff Davis wrote:
On Mon, 2008-02-04 at 16:11 -0600, Erik Jones wrote:
Are you sure the postmaster is being launched
under ulimit unlimited?
ulimit -a gives:
core file size(blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size
On Tue, 05 Feb 2008 17:56:22 -0800
Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> Looks like SuSE is not updating PostgreSQL binaries that much:
>
> ftp://ftp.suse.com/pub/projects/postgresql/
>
> I CC'ed this e-mail to Reinhard, who is (still?) responsible for
> PostgreSQL packaging @ SuSE.
>
> Y
Hi,
On Tue, 2008-02-05 at 00:20 -0600, Pepe Barbe wrote:
> I am interested in deploying PG 8.3.0 on one of our in-house appliance
> product that is managed using RPMs and openSuse. Will there be RPMs
> for Suse from PostgreSQL or should I wait until Suse releases their
> own RPMs?
Our project doe
On Tuesday 05 February 2008 04:40:18 pm brian wrote:
> Jeff Davis wrote:
> > On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
> >> I create a table named "Account_Text_Table" the owner is 'johnf'.
> >>
> >> select has_table_privilege('johnf', 'public.Account_Text_Table',
> >> 'SELECT') I get the fol
Jeff Davis wrote:
On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
I create a table named "Account_Text_Table" the owner is 'johnf'.
select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
I get the following error:
ERROR: relation "public.account_text_table" does not exist
On Tue, 2008-02-05 at 16:10 -0800, johnf wrote:
> I create a table named "Account_Text_Table" the owner is 'johnf'.
>
> select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
> I get the following error:
>
> ERROR: relation "public.account_text_table" does not exist
PostgreS
I create a table named "Account_Text_Table" the owner is 'johnf'.
select has_table_privilege('johnf', 'public.Account_Text_Table', 'SELECT')
I get the following error:
ERROR: relation "public.account_text_table" does not exist
SUSE 10.3 Postgres 8.1.9
--
John Fabiani
-
On Fri, 2008-02-01 at 20:33 -0500, Venks wrote:
> Hi,
>
> I am trying to copy some data from MySQL to Postgres using Ruby. This
> is NOT a MySQL to PostgreSQL conversion project. I need to read the
> data from a MySQL database and load it into PostgreSQL database.
>
> How do I handle "nil" in rub
On Mon, 2008-02-04 at 16:11 -0600, Erik Jones wrote:
> > Are you sure the postmaster is being launched
> > under ulimit unlimited?
>
> ulimit -a gives:
>
> core file size(blocks, -c) unlimited
> data seg size (kbytes, -d) unlimited
> file size (blocks, -f) unlimited
>
In response to "alan bryan" <[EMAIL PROTECTED]>:
> I've got a web site (apache/php) with a postgres 8.2.5 database(s).
>
> We're now getting some periods of high load. We have a lot of dynamic
> queries so I'm not able to just tune and optimize a few known queries
> ahead of time.
>
> Is there
I am new to Postgresql, and although it would be my first choice of
database, I am trying to see what sort of complexities await me
depending on which route I go down. Though I have read as much as I can,
I am still stuck on knowing how I will approach the enforcement some
fundamental rules on my
I've got a web site (apache/php) with a postgres 8.2.5 database(s).
We're now getting some periods of high load. We have a lot of dynamic
queries so I'm not able to just tune and optimize a few known queries
ahead of time.
Is there a way that I can get a list of all the actually SQL queries
as p
Tony Caduto wrote:
At the bottom of that Register article I saw this article:
http://www.regdeveloper.co.uk/2008/01/24/stonebraker_dewitt_mapreduce/
In which it says:
"Ingres inventor and Postgres architect Mike Stonebraker"
So this Stonebraker guy is the Postgres Architect?
Yes in the early
"Wade Hampton" <[EMAIL PROTECTED]> writes:
> I am currently testing Postgresql 8.3 on Centos 5. When I try to run
> service postgresql initdb, I get the following error:
> WARNING: could not read time zone file "Default": Permission denied
> FATAL: invalid value for parameter "timezone_abbrevia
I have only 2 files in this dir :
total 336
-rw--- 1 postgres postgres 262144 2006-11-15 18:34
-rw--- 1 postgres postgres 73728 2008-02-05 14:09 0001
I thought clog files were only files related to transactions in progress ?
There's no way to tell psql to ignore all current transact
Tony Caduto wrote:
> At the bottom of that Register article I saw this article:
> http://www.regdeveloper.co.uk/2008/01/24/stonebraker_dewitt_mapreduce/
>
> In which it says:
>
> "Ingres inventor and Postgres architect Mike Stonebraker"
>
> So this Stonebraker guy is the Postgres Architect?
Hmm, I
Eric Renard escribió:
> pg_dump: Error message from server: ERROR: could not access status of
> transaction 3270404
> DETAIL: could not open file "pg_clog/0003": No such file or directory
> pg_dump: The command was: SELECT tableoid, oid, proname, prolang, pronargs,
> proargtypes, prorettype, pro
Greetings! I am really excited about trying 8.3 for the speedups,
autovacuum, and UUID support.
I am currently testing Postgresql 8.3 on Centos 5. When I try to run
service postgresql initdb, I get the following error:
WARNING: could not read time zone file "Default": Permission denied
FATAL:
Em Tuesday 05 February 2008 13:27:08 Larry Rosenman escreveu:
> On Tue, 5 Feb 2008, Dave Page wrote:
> >
> > Yeah, but can you wrap it all up into a patch to the build system that
> > Tom would approve of? :)
>
> I knew that was coming, and it's on my list :)
The hardest part: "that Tom would appr
On Feb 5, 2008, at 12:29 PM, Tony Caduto wrote:
So this Stonebraker guy is the Postgres Architect?
That doesn't imply Postgres == PostgreSQL :-)
The original Postgres wasn't even SQL, was it?
---(end of broadcast)---
TIP 9: In versions below
At the bottom of that Register article I saw this article:
http://www.regdeveloper.co.uk/2008/01/24/stonebraker_dewitt_mapreduce/
In which it says:
"Ingres inventor and Postgres architect Mike Stonebraker"
So this Stonebraker guy is the Postgres Architect?
Interesting stuff on the Register :-)
Csaba Nagy <[EMAIL PROTECTED]> writes:
> I found an old post regarding the subject, where modifying the
> pg_constraint entry was recommended:
> http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php
> Is this still safe to do ?
What kind of constraint?
regards,
Ok I progressed a bit, now with psql I can see my main db and some tables,
but they don't contain many rows.
Noticable messages in the logfile :
2008-02-05 18:01:18 CET LOG: transaction ID wrap limit is 1073748480,
limited by database "wowdbu"
2008-02-05 18:01:18 CET LOG: autovacuum: processing d
I just thought of another problem, the system can have multiple values
for a single attribute. How do you normalise that without basically
adding a link table that's just the same thing as given below (I know
there are array types in Postgresql, but there aren't in other DBs and
I'm a fan of keepi
That is a very awesome system. I am constantly impressed at the
awesomeness of Postgresql.
Alex
On Feb 4, 2008 1:06 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Jorge Godoy <[EMAIL PROTECTED]> writes:
> > Em Monday 04 February 2008 07:03:47 Dawid Kuroczko escreveu:
> >> Well, but PostgreSQL's NULLs
How do you normalize 90 arbitrary attributes away into subordinate tables?
There will still be 90 of them, you can split them up into multiple tables,
but it would just make joins a pain and potentially bog down the query
planner I would think.
Alex
On Feb 4, 2008 7:09 AM, Scott Marlowe <[EMAIL P
Tony Caduto wrote:
http://digg.com/programming/PostgreSQL_8_3_has_been_released
I felt The Register's headline was good "PostgreSQL packs record punch"
http://www.regdeveloper.co.uk/2008/02/04/postresql_record_update/
--
Richard Huxton
Archonet Ltd
---(end of broad
Ok in fact, the times weird thing were because I copied the data dir on a 64
bits arch and it went from a 32 bit arch. On the 32 bit one :
pg_control version number:812
Catalog version number: 200510211
Database system identifier: 4989617165674917617
Database clu
http://digg.com/programming/PostgreSQL_8_3_has_been_released
I dugg it :-)
Later,
Tony
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
On Tue, 5 Feb 2008, Dave Page wrote:
On Feb 5, 2008 3:07 PM, Larry Rosenman <[EMAIL PROTECTED]> wrote:
On Tue, 5 Feb 2008, Dave Page wrote:
Another option which may be doable for someone with more knowledge of
make would be to build binaries for all architectures seperately (you
can build i3
Larry Rosenman wrote:
> On Tue, 5 Feb 2008, Dave Page wrote:
>> Another option which may be doable for someone with more knowledge of
>> make would be to build binaries for all architectures seperately (you
>> can build i386, ppc, x86_64 and ppc64), and then use lipo to glue them
>> together.
> I
On Feb 5, 2008 7:52 AM, Hermann Muster <[EMAIL PROTECTED]> wrote:
> I'm using a clean Virtual PC Image of a German Windows XP SP2.
OK - I've been testing on a clean English XP Pro SP2.
> I also checked the folder C:\Program Files\Common Files\Merge Modules
> Microsoft_VC80_CRT_x86.msm which is n
On Feb 5, 2008 3:07 PM, Larry Rosenman <[EMAIL PROTECTED]> wrote:
>
> On Tue, 5 Feb 2008, Dave Page wrote:
>
> > Another option which may be doable for someone with more knowledge of
> > make would be to build binaries for all architectures seperately (you
> > can build i386, ppc, x86_64 and ppc64)
[EMAIL PROTECTED] escribió:
> My server crashed yesterday, the hd was saved though and I was able to
> get a copy of the data directory of my pg cluster. On the server now,
> when I start pg, I can see only like 1% of my data, there are many dbs/
> tables and rows missing. But the data dir seems ok
On Tue, 5 Feb 2008, Dave Page wrote:
On Feb 5, 2008 1:24 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
# Fixup the makefiles
echo "Post-processing Makefiles for Universal Binary build"
find . -name Makefile -print -exec perl -p -i.backup -e 's/\Q$(LD)
$(LDREL) $(LDOUT)\E (\S+) (.+)/\$(LD)
My server crashed yesterday, the hd was saved though and I was able to
get a copy of the data directory of my pg cluster. On the server now,
when I start pg, I can see only like 1% of my data, there are many dbs/
tables and rows missing. But the data dir seems ok in size though. So
I copied the who
On Mon, 4 Feb 2008, Tom Lane wrote:
"Dave Page" <[EMAIL PROTECTED]> writes:
On Feb 4, 2008 6:25 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
"Dave Page" <[EMAIL PROTECTED]> writes:
The Mac build of EDB Postgres is universal throughout,
Yeah? How painful is it? We've had more than one request t
peter pilsl wrote:
#make
/usr/bin/ld:exports.list:1: parse error in VERSION script
collect2: ld returned 1 exit status
make[3]: *** [libpq.so.5.1] Error 1
The machine is a very old machine, that uses GNU ld 2.11.90.0.8 but it
was able to compile and run postgres8.0.13 without any troubles.
Am Dienstag, 5. Februar 2008 schrieb peter pilsl:
> The machine is a very old machine, that uses GNU ld 2.11.90.0.8 but it
> was able to compile and run postgres8.0.13 without any troubles.
Yes, it is a known problem that "old" Linux systems can't build newer
PostgreSQL releases. You can edit th
#make
make[3]: Entering directory
`/opt_noraid/src/postgresql-8.3.0/src/interfaces/libpq'
echo '{ global:' >exports.list
gawk '/^[^#]/ {printf "%s;\n",$1}' exports.txt >>exports.list
echo ' local: *; };' >>exports.list
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-fno-strict-al
While upgrading our schema between application versions, we also had a
few constraint changes. Some of those changes were dropping NOT NULL
constraints on some columns. Our schema had a few such NOT NULL
constraints, which were created using the named variant of the column
constraint clause (someth
I found an old post regarding the subject, where modifying the
pg_constraint entry was recommended:
http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php
Is this still safe to do ? The pertinent docs don't say anything pro or
contra:
http://www.postgresql.org/docs/8.2/static/catalog-pg-
Can somebody help me to appreciate the difference between returning a
setof record with cursor or with for _row in select ... as in
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html
Once I use and define cursors read only, no scroll, insensi
On Mon, Feb 04, 2008 at 08:12:51PM +0100, [EMAIL PROTECTED] wrote:
> what's an alternative to tableoids?
>
> As I've learned today they are not consistant across pg_dump/restore.
>
> I need to point to (lots of dynamically added) tables and used tableoids
> before.
>
> Are there other solutions
On Feb 5, 2008 1:24 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> > # Fixup the makefiles
> > echo "Post-processing Makefiles for Universal Binary build"
> > find . -name Makefile -print -exec perl -p -i.backup -e 's/\Q$(LD)
> > $(LDREL) $(LDOUT)\E (\S+) (.+)/\$(LD) -arch ppc \$(LDREL) \$(L
On Feb 5, 2008 3:39 AM, LiuYan 刘研 <[EMAIL PROTECTED]> wrote:
>
> When I try to execute psql.exe or pg_ctl.exe, I got an error: can't find
> gssapi32.dll.
> see the attachment:
> http://www.nabble.com/file/p15282929/pgsql-8.3.0-noinstaller-win32-missing-gssapi32.dll.png
> pgsql-8.3.0-noinstaller-win
rihad <[EMAIL PROTECTED]> writes:
> Should the usual dump/restore cycle be performed during the upgrade on
> FreeBSD? Any minor backward-incompatible changes one should be aware of?
8.3RC2 to release does not require a dump/reload. I think we forced an
initdb after beta3, but not since then...
Dave Page schrieb:
On Feb 4, 2008 6:37 PM, Hiroshi Saito <[EMAIL PROTECTED]> wrote:
Hi.
MSVCR80.dll which the binary of 8.3 refers to is this.
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\MSVCR80.dll
I tried again in the beautiful environment which does
"rihad" <[EMAIL PROTECTED]> writes:
>> If you want to support multiple encodings, the only safe locale choice
>> is (and always has been) C.
>
> I should be ashamed for asking this, but would someone care to tell me how
> encoding differs from locale?
One you missed is a character set, which is j
53 matches
Mail list logo
