On Wed, 2004-12-29 at 23:12, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
What's happening is that there are two databases behind pgpool, and each
has managed to assign a different (set of) OID(s) to the table(s). So,
when pg_dump asks for an OID, it gets two different ones.
On Wed, 2004-12-29 at 17:30, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2004-12-29 at 16:56, Tom Lane wrote:
No, we'd be throwing more, and more complex, queries. Instead of a
simple lookup there would be some kind of join, or at least a lookup
that uses a
Scott Marlowe [EMAIL PROTECTED] writes:
I don't think it's worth that price to support a fundamentally bogus
approach to backup.
But it's not bogus. IT allows me to compare two databases running under
a pgpool synchronous cluster and KNOW if there are inconsistencies in
data between them,
On Wed, 2004-12-29 at 17:30, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2004-12-29 at 16:56, Tom Lane wrote:
No, we'd be throwing more, and more complex, queries. Instead of a
simple lookup there would be some kind of join, or at least a lookup
that uses a
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2004-12-29 at 23:12, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
What's happening is that there are two databases behind pgpool, and each
has managed to assign a different (set of) OID(s) to the table(s). So,
when
On Thu, 2004-12-30 at 09:46, Tatsuo Ishii wrote:
On Wed, 2004-12-29 at 17:30, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2004-12-29 at 16:56, Tom Lane wrote:
No, we'd be throwing more, and more complex, queries. Instead of a
simple lookup there would be some
Hello !
I wish to create a rule towrite
inrecords who and when modified them.
I wrote :
CREATE OR REPLACE RULE tarif_upd AS
ON UPDATE TO tarifs DO ALSO
UPDATE
tarifs SET
dmodtar = current_date, umodtar =
current_userWHERE dmodtar
current_date AND umodtar current_user ;But I obtain an
You get infinite recursion because your ON UPDATE rule does another
UPDATE which of course calls the rule ; so no, it's not a bug ; also your
UPDATE updates almost the whole table so it won't do what you had in mind
in the first place. You should rather change the NEW row in your update so
On Thu, 2004-12-30 at 09:20, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
I don't think it's worth that price to support a fundamentally bogus
approach to backup.
But it's not bogus. IT allows me to compare two databases running under
a pgpool synchronous cluster and KNOW if
Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as a foreign key.
When I delete a client, I want it to delete all
Miles Keaton wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as a foreign key.
When I delete a client, I
On Thu, 30 Dec 2004 11:10:38 -0800, I wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
Sorry - to be more clear : I like having my foreign keys RESTRICT from
this kind of cascading happening automatically or accidently.
So I'm looking for a query
On Thu, 2004-12-30 at 11:10 -0800, Miles Keaton wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
I see DROP CASCADE, but not a DELETE CASCADE.
What I'm trying to do:
I have a clients table.
I have many different tables that use the clients.id as
What is the syntax for inserting a unicode character literal? I
thought it would be something like '\u05D0', but that doesn't work.
Any help would be appreciated!
Thanks,
Tim
---(end of broadcast)---
TIP 6: Have you searched our list archives?
On Thu, Dec 30, 2004 at 11:40:21 -0800,
Miles Keaton [EMAIL PROTECTED] wrote:
On Thu, 30 Dec 2004 11:10:38 -0800, I wrote:
Is it possible for a query to delete a record and all of its
foreign-key dependents?
Sorry - to be more clear : I like having my foreign keys RESTRICT from
this
I do see thefollowing error
in/var/log/messages when I try to start my application. It was working
fine in 7.4.6. I did upgrade from 7.4.6 to 8.0 Rc1.
"ERROR:unregcongnized configuration parameter
'ksqo'" .
This is happening after I execute this statement
"res =
Prasad Duggineni [EMAIL PROTECTED] writes:
I do see the following error in /var/log/messages when I try to start my =
application. It was working fine in 7.4.6. I did upgrade from 7.4.6 to =
8.0 Rc1.
ERROR:unregcongnized configuration parameter 'ksqo' .
This is happening after I execute this
Specificaly I am looking at executing something like this:
UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid =
(select pg_class.oid from pg_class where relname = 'mytable');
On December 23, 2004 05:13 pm, Derik Barclay wrote:
Hello Group,
I've run into a bit of a
Hi,
I'm doing some PL/pgSQL programming at work and today I realized a small
glitch in my application design.
The following recreates my problem...
I have two tables with triggers on each:
CREATE TABLE public.tableone (
id SERIAL,
columnone VARCHAR(64),
Cool. Thanks for all the advice, guys.
I'll just keep my script manually deleting dependencies, then. It
gives me peace of mind.
:-)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Here are the results of pgconfig and ldd. They both look correct. Do I need
a link to libc.so.6 in my pglib/lib directory? It isn't there on my other
machine and that is working fine.
[EMAIL PROTECTED] /usr/local/pgsql/bin/pg_config --pkglibdir
/usr/local/pgsql/lib
[EMAIL PROTECTED] ldd
Trying vacuumdb eventuallydisplays this:
ERROR: catalog is missing 3 attribute(s) for relid 31457
vacuumdb: vacuum databasename failed
There is another thread which states this is a corrupted systems
catalog. Is this definitely the case? Does it mean I need to re-build
the database?
I need to do some investigation into the way Postgres handles large
objects for a major project involving large objects. My questions are:
* Can large objects be stored within a field value or must they be
referenced by OID?
* Are large objects backed up in the normal way or does special
Yes, this is exactly the same behaviour as mine. I've also seen the exact
same entries in the log file (tested this last night). Many, many of these
entries spanning only a couple of seconds.
Does anyone have any ideas I can try to rectify this problem?
Thanks,
Peter
-Original
I think I am having a problem with database connection
leakage between PostgreSQL 7.3.4 on a Linux box and JBoss 2.4.3 on a separate Linux
box
What would be a good tool for monitoring connection usage
and finding leaks?
Wiebe de Jong
In one of my apps, I have an images manager that's become unmanageable. I'd
like to be able to easily track key dependencies.
Let's say I have a set of tables like this:
create table Customers (
id serial unique not null primary key,
name varchar not null,
address varchar not null
image
Hello,
I'm trying to convert a
series of C programs written originally using Informix ESQL to use Postgres'
ECPG.
All of my test programs
written from scratch seem to work ok, and I can now precompile, compile and link
without error, but when I actually run the program, I get a segfault.
I can't find any solution.
Is it a bug or a config problem ?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Probably not even worth a bug report, but an entry in the install FAQ..
or a fix in the installer.. whatever. should be pretty uncommon.
rc2 would not install (had not attempted to use any prior rc/beta
either).
last 2 lines of initdb.log showed:
command C:/Program
I do see thefollowing error
in/var/log/messages when I try to start my application. It was working
fine in 7.4.6. I did upgrade from 7.4.6 to 8.0 Rc1.
"ERROR:unregcongnized configuration parameter
'ksqo'" .
This is happening after I execute this statement
"res =
Am I the only one who has trouble reading the website? Some of the
fonts are way too small, especially the Mirrors | Donate | Contact
set. The other problem is that it is too light. My eyes strain to
read the text as the background is white, and the text is also a light
color.
Also, on the
First I had install PostgreSQL 8.0
RC2 on Windows 2003 server. Remote clients connect to databese, so I have to set
listen_addresses = '*' in the posrgresql.conf file. After this change I have
error message:
"could not receive server response to SSL
negotiation packet; connection reset by
Hi!
I'm maintaining a bunch of FreeBSD ports for postgresql stuff. I get
problems when building postgresql with Kerberos, because packages like
libpqxx does not automatically understand that it will also need to link
with libkrb.so. Is there any default way to get gnu configure for such
I honestly have no idea what that error means, however I'd imagine
that you should be able to dump the DB, and reimport it as a last
resort to fixing this.
On Tue, 28 Dec 2004 18:33:24 -0500, Matthew Terenzio
[EMAIL PROTECTED] wrote:
Trying vacuumdb eventuallydisplays this:
ERROR: catalog
In my postgresql.conf I set it to log the query durations and this seems to
goof up odbc. I know this sounds stupid but I did a search and actually found
taht others have had the problem though I found no solution. I am running 7.4
on a suse 9.2 box. I have noticed that it appears to work on
Derik Barclay [EMAIL PROTECTED] writes:
Specificaly I am looking at executing something like this:
UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid =
(select pg_class.oid from pg_class where relname = 'mytable');
If you have any indexes or views referencing this column,
Sim Zacks [EMAIL PROTECTED] writes:
Here are the results of pgconfig and ldd. They both look correct.
[EMAIL PROTECTED] /usr/local/pgsql/bin/pg_config --pkglibdir
/usr/local/pgsql/lib
[EMAIL PROTECTED] ldd /usr/local/pgsql/lib/utf8_and_iso8859.so
libc.so.6 - /lib/i686/libc.so.6
Matthew Terenzio [EMAIL PROTECTED] writes:
Trying vacuumdb eventuallydisplays this:
ERROR: catalog is missing 3 attribute(s) for relid 31457
vacuumdb: vacuum databasename failed
There is another thread which states this is a corrupted systems
catalog. Is this definitely the case? Does it
On Thu, 2004-12-30 at 13:19 -0800, Mike Cox wrote:
Am I the only one who has trouble reading the website? Some of the
fonts are way too small, especially the Mirrors | Donate | Contact
set. The other problem is that it is too light. My eyes strain to
read the text as the background is
Wiebe de Jong wrote:
I think I am having a problem with database connection leakage
between PostgreSQL 7.3.4 on a Linux box and JBoss 2.4.3 on a separate
Linux box
What would be a good tool for monitoring connection usage and finding
leaks?
Plain text formatting is encouraged. I've
On Thu, Dec 30, 2004 at 09:26:48PM -0800, ramesh phule wrote:
Subject: [PATCHES] reqd patch
To: pgsql-patches@postgresql.org
I'm not sure what reqd patch has to do with your question -- a
subject with the word cursor would be more appropriate since
that's the topic. Also, pgsql-patches is
On Sun, Dec 26, 2004 at 09:43:59 -0800,
Benjamin Smith [EMAIL PROTECTED] wrote:
Something like
Select pg_table.name from pg_table where pg_field references images.id
?
How else do I put it? The output I'd like would be something like
images.id / tablename / table.primary key
11
On Mon, Dec 27, 2004 at 10:39:48 -0600,
Dan Boitnott [EMAIL PROTECTED] wrote:
I need to do some investigation into the way Postgres handles large
objects for a major project involving large objects. My questions are:
I don't know the answer to all of your questions.
* Is it
--- ramesh phule [EMAIL PROTECTED] escribió:
Dear Sir,
I am working as Teacher in college.
I am teaching PostgreSQL to student.
I am facing problem in running CURSOR. version of
postgresql is 7.3.2
An old version, maybe you want to update to 7.4.6. In
the next days/weeks??
On Thu, 2004-12-30 at 09:20, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
I don't think it's worth that price to support a fundamentally bogus
approach to backup.
But it's not bogus. IT allows me to compare two databases running under
a pgpool synchronous cluster and
45 matches
Mail list logo