On Mon, Jan 30, 2006 at 09:28:14AM +0200, Ron Marom wrote:
Indeed I forgot to mention that I AM vacuuming the database using a
daemon every few hours; however this seems not to be the issue this
time, as when the CPU consumptions went up I tried to vacuum manually
and this seemed to take no
PostGreSQL 8.01 Gentoo
I renamed my schema from public to stock, and then I found out it didn't
change the schemas of the sequences. After searching through the
archives, I found that this was on a bug list and would probably be
fixed in version 8.2
I needed to fix the sequences in any case,
On Jan 30, 2006, at 18:51 , Sim Zacks wrote:
However, when I try to insert into the table I get an error that
public.sequence name is not found
Am I missing a reference or table update somewhere?
You probably need to update the defaults for the columns that call
the sequences. They may
I thought the pg_attrdef table was the defaults.
Is there another table that contains the defaults
Thank You
Sim
On Jan 30, 2006, at 18:51 , Sim Zacks wrote:
However, when I try to insert into the table I get an
On Jan 30, 2006, at 19:03 , Sim Zacks wrote:
I thought the pg_attrdef table was the defaults.
Is there another table that contains the defaults
What I'm thinking of is this situation:
create table foo
(
foo_id serial primary key
, foo_value text not null unique
);
This will
Thank you for your thoughts, but I am hoping that I don't have to
update 400 tables manually.
The way I understand the postgresql structure is that each field is
listed in the pg_attribute table and those fields with default values
have records in the pg_attrdef table. I changed both the text and
Oliver Fürst wrote:
'currval()' is specifically written to Do The Right Thing. See the
docs.
My problem isn't answered in the manual, otherwise I wouldn't have
asked. I know that sequences are working correct for transactions
(either implicit or explicit).
But is nowhere stated if
Silas Justiniano wrote:
enough for every query I want to perform? Or should I need
CREATE UNIQUE INDEX foo ON Intermediate(book_id, author_id);
CREATE UNIQUE INDEX bar ON Intermediate(book_id);
CREATE UNIQUE INDEX baz ON Intermediate(author_id);
If you'd use plain indexes for the last two
On Sunday 29 January 2006 19:03, Silas Justiniano wrote:
My question is about the indexes in Intermediate table. Is the
following index:
CREATE UNIQUE INDEX foo ON Intermediate(book_id, author_id);
enough for every query I want to perform? Or should I need
CREATE UNIQUE INDEX foo ON
On Fri, 27 Jan 2006, Harald Armin Massa wrote:
Teodor,
To all: May be, we should put all snowball's stemmers (for all available
languages and encodings) to tsearch2 directory?
Yes, that would be VERY helpfull. Up to now I do not dare to use tsearch2
because get stemmer here, get
Silas Justiniano [EMAIL PROTECTED] writes:
I normally create these two indexes:
CREATE UNIQUE INDEX foo ON Intermediate(book_id, author_id);
CREATE INDEX baz ON Intermediate(author_id);
Note that the second one isn't unique.
Or you can go the other way (author_id,book_id and book_id). The
Hello,
I am sorry for this little offtopic, but recently I was looking for some
matured DB frontend. I am licensed user of Aquafold Datastudio and before
I will start to spend another money for next licenses, I would like to ask
you if there are some similar frontends out there, but with three
It seems to be an in-memory issue or something like that.
5 hours later it gave me another error implying that it was reading the
pg_attrdef table.
Apparantly the first number in the byte string is the number of
characters in the string, and since my new schema is 1 character shorter
then the
Ron Marom [EMAIL PROTECTED] writes:
Indeed I forgot to mention that I AM vacuuming the database using a
daemon every few hours; however this seems not to be the issue this
time, as when the CPU consumptions went up I tried to vacuum manually
and this seemed to take no affect.
This is not
Sim Zacks [EMAIL PROTECTED] writes:
PostGreSQL 8.01 Gentoo
I renamed my schema from public to stock, and then I found out it didn't
change the schemas of the sequences. After searching through the
archives, I found that this was on a bug list and would probably be
fixed in version 8.2
I may not be a smart man, but I do know what love is
Of course I did this on a database that I didn't care about. This is my
development machine. If it actually fully worked after testing, I would
have considered moving it into production code.
Is there a more approved way of doing this,
Am 2006-01-25 16:56:04, schrieb Peter Eisentraut:
Michelle Konzack wrote:
Does anyone know a Frontend for PostgreSQL which I can use to design
and admin a very huge Database
OpenOffice 2?
Design a Database with OO2? code Functions?
Greetings
Michelle Konzack
Systemadministrator
Am 2006-01-25 17:01:39, schrieb Martijn van Oosterhout:
On Wed, Jan 25, 2006 at 04:43:18PM +0100, Michelle Konzack wrote:
Hello,
I am using PostgreSQL since more then 6 years now and for 1 1/2 years
rekall. Now there is a problem with the crapy QT and I have no
Frontend anymore which
Am 2006-01-25 17:21:48, schrieb Leif B. Kristensen:
I'm using PHP with plain old HTML forms. That way, I can slap together a
custom interface in no time. And it even works in links2 :)
How do you design a ned Database via your Webinterface?
How do you create functions and trigers?
The
What about PgAdmin III, I know, it is now perfect but I prefer it a lot
against similar commercial products.
Really, I have long time looking for a product with the same specs.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michelle Konzack
Sent:
On Jan 30, 2006, at 12:28 AM, Ron Marom wrote:
First of all thanks for you quick and efficient response.
Indeed I forgot to mention that I AM vacuuming the database using a
daemon every few hours; however this seems not to be the issue this
time, as when the CPU consumptions went up I tried
Hello,
I've created a user and a database both wrongly named phpbb.
After that I have renamed both to punbb using ALTER DATABASE
and ALTER USER. Now everything works fine, except I always
have to specify the database when connecting (both using psql or
the PQconnectdb() from my C-program):
Alexander Farber [EMAIL PROTECTED] writes:
Hello,
I've created a user and a database both wrongly named phpbb.
After that I have renamed both to punbb using ALTER DATABASE
and ALTER USER. Now everything works fine, except I always
have to specify the database when connecting (both using
Hello all,
I have setup a fedora 4 box with Postgress 8.0.6 (with Schemas). The
problem is that by windows odbc driver that i have setup shows me the tables
but when i double click to display the fields i get a message
Connectivity error. Error while executing the query,ERROR: schemas
postgress
Unfortunately, I think I understand your question. :-)
These TODO items are what you need:
* Point-In-Time Recovery (PITR)
o Allow point-in-time recovery to archive partially filled
write-ahead logs [pitr]
Currently only full WAL files are archived.
Hi,
On 1/30/06, Doug McNaught [EMAIL PROTECTED] wrote:
Alexander Farber [EMAIL PROTECTED] writes:
h754814:afarber {103} psql -U punbb
psql: FATAL: database phpbb does not exist
psql uses your Unix username as the default database if you don't
specify one.
but I do specify the
Alexander Farber [EMAIL PROTECTED] writes:
but I do specify the database username:
h754814:afarber {109} psql --help | grep -w user
-U NAME database user name (default: phpbb)
h754814:afarber {110} psql -U punbb
psql: FATAL: database phpbb does not exist
And it
Argh, I had phpbb in my env ( ~/.login) too:
setenv PGDATA /var/postgresql/data
setenv PGDATABASE phpbb
setenv PGHOST /var/www/tmp
setenv PGUSER phpbb
Now everything makes sense (I was thinking
about some kind of system table for default databases).
Sorry and
Michelle Konzack wrote:
Design a Database with OO2? code Functions?
I'm not sure about what kind of function coding support you have in
mind, but certainly you can design a database with it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
I've got some server functions that were previously written using
libpq.
They work fine. However because they need to open their own connection to
insert into tables and write into large objects, etc, they aren't
transaction safe. That is to say, if a user starts a transaction,
executes my
Just encountered this error on an 8.1.2 cluster:
LOG: statement: PREPARE dbdpg_5 AS SELECT * FROM foo WHERE visitnum = $1 and
(scheduledtime = $2 OR scheduledtime IS NULL) AND (scheduledtime $3 OR
scheduledtime IS NULL) UNION SELECT * FROM bar WHERE visitnum = $4 ORDER BY
I assume it is this TODO:
* Allow protocol-level BIND parameter values to be logged
---
Ted Powell wrote:
Our development group needs to have the option of logging all SQL
statements including substituted
On Mon, Jan 30, 2006 at 04:31:29PM -0500, Bruce Momjian wrote:
I assume it is this TODO:
* Allow protocol-level BIND parameter values to be logged
---
Ted Powell wrote:
Our development group needs to have
We had the same problem after re-compiling on 8.1.2. We had to edit the
/etc/ld.so.conf file and add /usr/local/pgsql/lib manually.
There is a mention to this in the DBD::Pg readme file.
Woody
iGLASS Networks
211-A S. Salem St
Apex NC 27502
(919)
Ed L. [EMAIL PROTECTED] writes:
Just encountered this error on an 8.1.2 cluster:
ERROR: direct correlated subquery unsupported as initplan
Can you provide a test case for this? (No, the query text is not
enough.)
regards, tom lane
---(end of
Ted Powell wrote:
On Mon, Jan 30, 2006 at 04:31:29PM -0500, Bruce Momjian wrote:
I assume it is this TODO:
* Allow protocol-level BIND parameter values to be logged
---
Ted Powell wrote:
Our
Eric Davies [EMAIL PROTECTED] writes:
Now I'm trying to make the functions transaction safe. In theory, all
I need to do is convert my libpq calls to equivalent SPI calls.
However, there don't appear to be any SPI equivalents for the large
object functions like lo_write and lo_read.
What
Hi Everyone
What is the best way to go about rotating the postgres security log file on
postgresql 7.4.11 under openbsd 3.7?
I got it to work logging to a file but as soon as the file rotates the new log
is dead. Would reloading the postmaster after the log rotation resolve this?
I also was
On Mon, Jan 30, 2006 at 05:19:23PM -0500, Bruce Momjian wrote:
[...]
* Allow protocol-level BIND parameter values to be logged
[...]
That's it! (I should have thought to look in the TODO.)
Has any design work been done on this?
No. I am with Simon Riggs today at my house and I
Hi,
I have been installed the PostgreSQL v8.1 (postgresql-8.1.2-1.zip) on
WinXP Pro as service with default settings suggested by setup wizzard.
When I tryed to start the service I have got en error message:
'could not create inherited socket: error code 10022'
Could anybody help me, or give
I have this table and index:
create table t(id int, hash int);
create index idx_t on t(hash);
The value of the hash column, which is indexed, is a pseudo-random
number. I load the table and measure the time per insert.
What I've observed is that inserts slow down as the table grows to
Yes! Thanks you! That is exactly what I was looking for.
So I take it that this means that it is save to copy the current in
use WAL file even as it is being written to?
And it also means that if I copy it with my physical file system
backup then I should have the last file that I need to
And here is the real million dollar question. Let's say for some
reason I don't have the last WAL file I need for my backup to be
valid. Will it die and tell me it's bad or will it just start up
with a screwed up data directory?
On Jan 30, 2006, at 4:29 PM, Rick Gigger wrote:
Yes!
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
Our Windows Installer is very attractive, for example.
Now, I and Burcu Guzel, who is a Senior Programmer, decided to launch a
new project:
Devrim GUNDUZ [EMAIL PROTECTED] writes:
http://pgfoundry.org/projects/pgnixinstaller/
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning
Just encountered this error on an 8.1.2 cluster, wondering if
anyone can provide troubleshooting hints:
LOG: statement: PREPARE dbdpg_5 AS SELECT * FROM foo WHERE
visitnum = $1 and (scheduledtime = $2 OR scheduledtime IS
NULL) AND (scheduledtime $3 OR scheduledtime IS NULL) UNION
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning phase,
if you join us
Devrim GUNDUZ wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt binaries from PostgreSQL FTP site (and possible
Devrim GUNDUZ [EMAIL PROTECTED] writes:
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
What value does this bring to systems that have a good package system
and up-to-date repositories? I can install Postgres today on Ubuntu
using a GUI tool, and install another GUI tool to
Hi,
On Mon, 2006-01-30 at 20:27 -0500, Andrew Dunstan wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
Hi,
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
Certainly you can install pre-built binaries without a compiler, and
let the user choose database location, autovacuum settings and stuff
like that.
That's another good point. We can adjust many settings before
installing.
Hi,
On Mon, 2006-01-30 at 21:34 -0400, Marc G. Fournier wrote:
OTOH, exluding Synaptic that I hate to use, FC / RH does not have a GUI
RPM interface for the repositories. So our installer will help them a
lot. Also, our installer will have an option to download and install the
prebuilt
Hi,
On Mon, 2006-01-30 at 20:31 -0500, Doug McNaught wrote:
You can install, but what if you need different configure options than
the package provides? This means a rebuild of the package. Instead, we
will build and install that package via the installer.
That's actually a pretty cool
[EMAIL PROTECTED] writes:
I have this table and index:
create table t(id int, hash int);
create index idx_t on t(hash);
The value of the hash column, which is indexed, is a pseudo-random
number. I load the table and measure the time per insert.
What I've observed is that inserts
Rick Gigger [EMAIL PROTECTED] writes:
And here is the real million dollar question. Let's say for some
reason I don't have the last WAL file I need for my backup to be
valid. Will it die and tell me it's bad or will it just start up
with a screwed up data directory?
It'll restore up
One of my database tables appears to corrupted see this post - Re: [GENERAL]
REPOST:Memory Allocation error using pg_dump on 7.4.
On checking the archives it appears I have to use a pg_filedump program to fix
it, which doesn't appear to be in my distribution. Where can I find it and
install it?
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get rid of all the
'cruft'
Hi,
On Mon, 2006-01-30 at 22:04 -0400, Marc G. Fournier wrote:
BTW, gcc is not installed on by default AFAIR.
Wow, how do you update the kernel each week? :)
More seriously, I know under FreeBSD, one of the first things that gets
done after installing is to customize the kernel to get
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do you? with every conceivable
Marc G. Fournier wrote:
More seriously, I know under FreeBSD, one of the first things that
gets done after installing is to customize the kernel to get rid of
all the 'cruft' part of the generic kernel, I take it that this isn't
something that ppl do with Linux?
The Linux kernel has
I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :)
On 1/30/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Hi,On Mon, 2006-01-30
General consensus is to use 10-25% of server memory for shared_buffers,
but much of that consensus was generated before 8.0, which introduced a
much more sophisticated management scheme for shared_buffers. Basically,
you need to do some testing to see what setting will work best. Reports
back to
Marc G. Fournier [EMAIL PROTECTED] writes:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on
On 1/30/06, Oleg Bartunov oleg@sai.msu.su wrote:
On Fri, 27 Jan 2006, Harald Armin Massa wrote:
Teodor,
To all: May be, we should put all snowball's stemmers (for all available
languages and encodings) to tsearch2 directory?
Yes, that would be VERY helpfull. Up to now I do not
On Jan 30, 2006, at 8:32 PM, Devrim GUNDUZ wrote:
However none of them are PostgreSQL Installers, none of them has the
ability to customize the packages and none of them has the ability to
install the community packages, etc. :)
You need to take a sniff over at the FreeBSD ports. Lets you
Marc G. Fournier wrote:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on your system, do
On Jan 30, 2006, at 6:58 PM, Tom Lane wrote:
Rick Gigger [EMAIL PROTECTED] writes:
And here is the real million dollar question. Let's say for some
reason I don't have the last WAL file I need for my backup to be
valid. Will it die and tell me it's bad or will it just start up
with a screwed
Quoting Tom Lane [EMAIL PROTECTED]:
[EMAIL PROTECTED] writes:
I have this table and index:
create table t(id int, hash int);
create index idx_t on t(hash);
The value of the hash column, which is indexed, is a pseudo-random
number. I load the table and measure the time per insert.
where we can check the execution of our program or we can dry run our code, is
there aby option or feature with PGSQL for the same purpose that we can check
our PGSQL statements?
No, unfortunately not. What I do is:
- error check everything you can, and use RAISE EXCEPTION with descriptive
Devrim GUNDUZ wrote:
Have you looked at AutoPackage?
http://autopackage.org
screen shots.
http://autopackage.org/gallery.html
Has a GUI wizard if X windows is available and a command line wizard if
no X is available.
Using autopackage is similar to using MSI,Wise,Inno etc on Windows.
Yes, I think copying it while it is being written is safe.
---
Rick Gigger wrote:
Yes! Thanks you! That is exactly what I was looking for.
So I take it that this means that it is save to copy the current in
use WAL
At present time, your best bet is to drop in on the IRC channel and ask
questions there. You'll normally get an immediate reply, even if it's
just a URL to look at.
On Tue, Jan 24, 2006 at 10:23:26PM +0800, Leonard Soetedjo wrote:
Hi,
Is there any documentation or wiki on PostgreSQL best
Thought people might like to know that the third edition of The
Third Manifesto by CJ Date and Hugh Darwen is going to be released
in February. It's been retitled Databases, Types and the Relational
Model: The Third Manifesto. Good stuff on relational theory by two
former IBM employees who
Hi!
I have an application, consisting of Struts 1.2 + Tomcat 5.5 + Hibernate
3.1 + PostgreSQL 8.1
The application is developed on WinXP and installed on Fedora Core 4.
On local machine everything works OK. Both databases are created from
the same script and application is the same.
But when
Hi,
Are you doing this as the same user that your application uses?
Maybe the application postgresql user doesn't have access to the
sequence but the default user you're connecting as does.
( You're connecting as a postgresql super-user because you have a '#' in
your command prompt - a
Devrim GUNDUZ schrieb:
Hi,
As you know, many databases that run on Linux / Unix systems have a GUI
installer which make installation easier and more attractive for some
people.
If you think of the *racle-GUI-Installer, most people find it very
s*cking ;)
Our Windows Installer is very
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
---(end of
Jonah H. Harris schrieb:
I had to deal with an installer written in python and several in Java...
IMHO, Java would be a better language for this and you could build off
some nice OSS installers that already exist (such as IzPack). Just my 2
cents :)
Yes! Use Java for ultimate suckiness of
On Tue, 31 Jan 2006, Tino Wildenhain wrote:
Devrim GUNDUZ schrieb:
Hi,
...
Are you going to work with the underlying system's package manager, or
put everything in /usr/local?
We'll work with the package manager -- I'm an RPM guy ;)
RPM isnt the only packaging system out there ;)
I
80 matches
Mail list logo