Is a dump and reload required when going from beta1 to beta3?
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 8 beta1 I get 'SMgrRelation hashtable corrupted' *sometimes* when
executing the following, but only when there are other clients connecting to
the same database.
ALTER TABLE declines
ALTER COLUMN comp_name TYPE varchar(128),
ALTER COLUMN f_name1 TYPE varchar(48),
ALTER COLUMN l_nam
Has anyone ever taken a look at adding radius authentication to
Postgresql? I know it's not terribly secure in itself, but some 2
factor authentication schemes like Cryptocard use it for verifying one
time passwords, and at least in our case having 2 factor
authentication for remote access would b
>
> Does anyone know what's the most reliable platform postgresql can run on?
> With or without scheduled downtime?
This reminded me... Not long ago I was looking at used sun servers. You
can pick up refurbished sun enterprise systems for between $4,000 and
$10,000 fairly easily. For instance
>
> > (gdb) bt
> > #0 0x284f9dcf in kill () from /lib/libc.so.5
> > #1 0x284ee878 in raise () from /lib/libc.so.5
> > #2 0x28566f82 in abort () from /lib/libc.so.5
> > #3 0x08226a6a in errfinish ()
> > #4 0x08226953 in errfinish ()
> > #5 0x0822f54d in GetUserNameFromId ()
> > #6 0x081183a3
I have been able to crash the server a few times with the following function
when it is called on a user and schema that was recently deleted. Following
is a log of what happened and also the function that was called. This is
7.4.3 on Freebsd 5.2.1. It doesn't always panic when it encounters a
ginal Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Chris Ochs" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 21, 2004 9:25 AM
Subject: Re: [GENERAL] Possible SET SESSION AUTHORIZATION bug
> "Chris Ochs" <[EMAIL PR
cache the
session user/current user? I'll leave that to those that understand the
implications more than I do.
Chris
- Original Message -
From: "Chris Ochs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 21, 2004 8:25 AM
Subject: Re: [GENERAL] P
es_allowed,debug_log from account_settings where username = in_username;
RETURN r;
END '
LANGUAGE 'plpgsql';
----- Original Message -
From: "Chris Ochs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 21, 2004 8:07 AM
Subject: [GENERAL] Pos
It doesn't currently seem possible to switch between different users using
SET SESSION AUTHORIZATION. If I log in as the superuser and switch to
another user that works, but if I then switch to a second user in succession
I get permission denied when I try to select from a table that the user doe
ED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 15, 2004 8:13 AM
Subject: Re: [GENERAL] Feature idea
> Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> > Chris Ochs wrote:
> > >
re we
have where we have anonymous users that need insert rights on a whole bunch
of different schema's.
Chris
> - Original Message -
> From: "Bruce Momjian" <[EMAIL PROTECTED]>
> To: "Chris Ochs" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECT
What if SET SESSION AUTHORIZATION could also accept a password so that non
superusers could switch to a different user? How difficult would this be?
One nice side benefit to this would be that you could effectively connect as
many users with Apache::DBI under mod perl without having an open conn
We have a number of tables in a CRM that is written in MS access that I need
to be able to provide a web interface to. I can export the tables just fine
using pgadmin II, but I cant' think of a clean way to import them from
postgresql back to access. Synchronizing only needs to happen once a day
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because those things can
alw
A good clean replication system is not available for bsd platforms as far as
I can tell, which is the preferred OS of choice for many PG installations.
I am playing around with Erserver, but the download has to be updated from
cvs or it won't even compile (corrupted file in the distribution). It
I am pretty sure I know this already, but every time you run a Pl/Perl
function it is just like running a perl script as far as having to load and
compile the code right? My application runs under mod perl so I'm thinking
that speed is not something I would gain by putting any of the code into the
ll take it out and
see what happens.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Chris Ochs" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, January 13, 2004 8:36 AM
Subject: Re: [GENERAL] sql insert function
>
running with autocommit turned off, so it seems there would have to be
a transaction or the data wouldn't get inserted. Either that or there is
something else that is causing the data to commit without an explicit commit
being called? I'm at a loss.
> Chris Ochs wrote:
> &g
I am seeing another strange thing when using a function that does an insert
instead of doing the insert directly. This is using cached connections with
apache/mod_perl.
My program starts a transaction, does about 20 inserts, then commits. When
I replace once of the inserts with a function that d
t: Re: [GENERAL] sql insert function
> Chris Ochs wrote:
> > Never mind, I forgot to quote the quote's...
>
> Heh... and here I was thinking you were trying to build a function ;)
>
> And I made the same mistake as you... guess I should pr
I want to do a series of inserts within a single transaction block, but with
postgresql if one insert fails, the whole block is aborted. Is there any
way to get around this behavior so that postgresql won't abort the entire
transaction if a single insert returns an error?
Chris
22 matches
Mail list logo
