Ron,
I have done this by adding the attribute to the table with nulls allowed and adding a
constraint to the table for the foreign key... works like a charm:
CREATE TABLE TESTTYPE (
TESTTYPEKEY char(30) NOT NULL,
TESTTYPENAME varchar(255) NULL,
TESTTYPEDESC
Mark Kirkwood wrote:
> Its worth checking - isn't it ?
>
> I appeciate that you may have performed such tests previously - but as
> hardware and software evolve its often worth repeating such tests (goes
> away to do the suggested one tonight).
>
> Note that I am not trying to argue away the is
hi,
it seems you use the /usr/bin/pg_dumpall featured by the redhat default
install
verify this with "which pg_dumpall"
(rpm -ql postgresql to see all the files of this package)
you upgraded from sources didn't you ?
your fresh new install has the default prefix /usr/local (redhat uses /usr)
2
Isnt the erserv project limited to Read-only slave stations?
When I looked at it, it did not seem to indicate that I could make an update
on any of the postgres servers and have that update replicated to all others. It
looked as though I could only update at 1 server.
> El Jue 2
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribió:
> I am trying to perform what I best understand as Multi-master asynchronous
replication for postgres 7.3.3 servers. After researching, I tried the
pgReplication project (and made the simple modification as listed in their
mailing lists), but w
On Wednesday 22 October 2003 01:19 pm, Jeff Eckermann wrote:
> --- Oksana Yasynska <[EMAIL PROTECTED]> wrote:
> > Jeff,
> >
> > thank you for the time and suggestion.
> > I'm also trying to use SETOF custom_type as a
> > solution
>
> I don't believe that works in 7.2. But if you do make
> it work
Hi, Stan,
We're in the early stages of testing a new Postgres (7.3) cluster. For
background, our database is about 14gb on disk, and we see about a
transaction a second (out of about 120 queries/sec.) Our application
is a large dynamic Apache-based web system, written in Perl. Our main
data
[EMAIL PROTECTED] (CSN) writes:
> For updating sequences after copy importing data (with
> id's).
>
> select setval('table_id_seq', (select max(id) from
> table));
>
> vs.
>
> select setval('table_id_seq', (select last_value from
> table_id_seq));
>
> Is there a transaction-safe way?
There's not l
I posted this to 'questions' yesterday instead of 'general' by mistake.
Sorry if anyone received duplicates.
Mandatories: Ver 7.3.4, Redhat Linux 8.0, P4, 2GB RAM
I want to add a 'nullable' foreign key to a column in a table. I have
tables "c
[EMAIL PROTECTED] (Gail Zacharias) wrote:
> I am investigating the possibility of using pgsql as the database in
> an application. I have some unusual requirements that I'd like to
> ask you all about. I apologize in advance if my terminology is a
> little "off", I'm not familiar with pgsql (yet)
[EMAIL PROTECTED] (Richard Ellis) wrote:
> Some of their (3Ware's) larger cards allow you to attach up to 12 IDE
> disks to the card as well as giving you hot swap capability.
This is all well and good, but may not sufficiently cover over the
Vital Problem with IDE drives, namely that they are lik
Is it possible to do something like:
select 1 as a, a*a;
in postgres?
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hello all,
I am interested in know if anyone has set up clustering for performance and fail over using PostgreSQL. We are currently using Oracle for a distribution application and would like to use PostgreSQL with multiple application and database servers.
Regards Stan.Post your free ad now!
On Thu, 23 Oct 2003, Mark Kirkwood wrote:
>
> scott.marlowe wrote:
>
> >
> >OK, but here's the real test. As the postgres user, run 'pgbench -i',
> >then after that runs, run 'pgbench -c 50 -t 100'. While it's running
> >and settled (pg aux|grep postgres|wc -l should show a number of ~54
Its worth checking - isn't it ?
I appeciate that you may have performed such tests previously - but as
hardware and software evolve its often worth repeating such tests (goes
away to do the suggested one tonight).
Note that I am not trying to argue away the issue about write caching -
it *has*
First one will be a bit faster
Diogo Biazus wrote:
Hi,
Is there any performance diference between the following SQL commands:
SELECT * FROM documents WHERE content_ix @@
to_tsquery('word1&word2|word3');
SELECT * FROM documents WHERE content_ix @@ to_tsquery('word1') AND
content_ix @@ to_tsque
On Thu, 23 Oct 2003, Alvaro Herrera wrote:
> On Thu, Oct 23, 2003 at 08:16:27AM +0100, Peter Childs wrote:
> >
> >
> > On Wed, 22 Oct 2003, scott.marlowe wrote:
> >
> > > On Wed, 22 Oct 2003, Peter Childs wrote:
> > >
> > > > Is it possible to deferr a trigger until commit, Or to have th
I have a table that II am constantly inserting into (around 10 times a
second right now but hope to increase latter). I hold these rows for a
week then summarize and delete them. During that week I need to access
ranges of these rows based on a timestamp in each row set to now() when I
insert
Agreed, however if its working fine on someone else's end then the problem
is local to my environment. People do have difficulties setting up DSPACE
but I currently have the front-end running fine. The dependencies are
just crazy along with third party apps for DSPACE. However, all that is
done
> Looking at the dspace docs (system prerequisites):
> "Then when PostgreSQL has compiled, copy the new postgresql.jar to
> dspace-1.1/lib."
>
> Strikes me as a bit strange it won't just use the classpath, but have you got
> the jar in there too?
Yes and in j2sdk's lib directory and in pgsql's sha
On Thursday 23 October 2003 15:52, Ashwin Kutty wrote:
>
> I thought and still under the impression that its looking in the classpath
> for this and I have edited /etc/profile to include it, checked env before
> running the program and it according to it the jar file is included fine
> and the clas
On Wed, 22 Oct 2003, Gail Zacharias wrote:
> I need to be able to move the database files, as normal user-visible
> files, between machines. I.e. given a database on machine A, I want to
> be able to copy either a single file (ideally) or a single directory
> (less ideal but still ok) to, say,
On Thu, 23 Oct 2003, Peter Childs wrote:
>
>
> On Wed, 22 Oct 2003, scott.marlowe wrote:
>
> > On Wed, 22 Oct 2003, Peter Childs wrote:
> >
> > > Is it possible to deferr a trigger until commit, Or to have the
> > > trigger not occur if the transaction is rolled back? Like transaction.
> > >
> On 22/10/2003 20:41 Gail Zacharias wrote:
>
> >I need to be able to move the database files, as normal user-visible
> >files, between machines. I.e. given a database on machine A, I want to be
> >able to copy either a single file (ideally) or a single directory (less
> >ideal but still ok) to, sa
On Wed, 22 Oct 2003, Joshua D. Drake wrote:
>
> > I believe that 3ware have a non blocking implementation of ATA RAID -
> > I intend to sell the Promise and obtain a 3ware in the next month of
> > so and test this out.
>
>
> I use 3Ware exclusively for my ATA-RAID solutions. The nice thing abo
On Thu, 23 Oct 2003, Tom Lane wrote:
> Peter Childs <[EMAIL PROTECTED]> writes:
> > Great idea shame drivers to get at these are rare. Anyway you
> > still need a trigger to fire the notify and these get sent when the query
> > is done not when its commented. hmmm
>
> But the NOTIFY isn't de
Mark Kirkwood wrote:
I should have said that I was using Freebsd 4.8 with write caching off.
write caching *on* - I got myself confused about what the value "1"
means
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choo
Whenever I need to use the postgresql JDBC driver in my programs, I
have to manually include the line:
Class.forName("org.postgresql.Driver");
somewhere *before* I call DriverManager.getConnection.
Try this in your test program and see if it works. Unfortunately,
you may not be able to modify
> It's complaining that it cannot find a driver. The obvious steps are:
> 1. Check you have your JDBC driver installed and configured.
Yes. I have done so. Included in the Classpath env var as well. I have
gone so far as to downloading it from jdbc.postgresql.org rather than
using the compiled
On Thursday 23 October 2003 14:20, Ashwin Kutty wrote:
>
> I am currently testing a product by the name of dspace
> (http://www.dspace.org) and require installing java since dspace is
> completely java based. The problem is that during its installation it
> needs to talk to pgsql via jdbc and I am
On Thu, 23 Oct 2003, Alvaro Herrera wrote:
> On Thu, Oct 23, 2003 at 08:16:27AM +0100, Peter Childs wrote:
> >
> >
> > On Wed, 22 Oct 2003, scott.marlowe wrote:
> >
> > > On Wed, 22 Oct 2003, Peter Childs wrote:
> > >
> > > > Is it possible to deferr a trigger until commit, Or to have the
Birahim FALL a écrit :
>It seems that there's no concept of PACKAGE in PL/pgSQL as in Oracle
PL/SQL.
>Is is definitely that? or did I missed something? or is it planned for
a future version?
Hello,
This feature is in the TODO list : Commands --> SERVER-SIDE LANGUAGES
(cf. http://developer.postgr
On Thu, 2003-10-23 at 01:49, Marc G. Fournier wrote:
...
> With suitable testing, and few bugs reported, we hope to get an RC1 out
> the door within the next 7 to 10 days, leading up to a full release of
> v7.4 ...
>
> ... so, if you haven't tested her out yet, please do so ...
Debian packages ar
33 matches
Mail list logo
