> 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 sync
--- 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/
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 practic
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
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 i
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'v
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
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? Do
"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
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 col
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
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: catal
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
packa
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
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 n
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 statement
"res = SQLAllocHandle(SQL_HANDLE
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 Files/PostgreSQL/8.0.0-rc2/b
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])
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 i
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 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
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 Message---
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
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? Re-install?
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 /usr/lo
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
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),
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 prob
"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 ex
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 statement
"res = SQLAllocHandle(SQL_HANDLE
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 fro
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, 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 clie
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 th
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 wa
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 al
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 cluste
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
Hello !
I wish to create a rule to write
in records 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_user WHERE dmodtar <>
current_date AND umodtar
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
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,
> 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
> >
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
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
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 differ
45 matches
Mail list logo
