Hey guys I have written a plpgsql function which takes anyelement as
argument. If I pass a string as input It gives an error "invalid input
for integer" . Cant I pass any datatype for anyelement
---(end of broadcast)---
TIP 8: explain analyze is your
Dear Sirs
I'm about to write plpgsql function which will "vacuum full" all existing
databases. Below is an example how to get list of databases.
What should I write instead of "raise notice" ?
CREATE OR REPLACE FUNCTION vacuum_all() RETURNS integer
AS '
DECLARE
query text;
list RECORD;
Am Donnerstag, 2. September 2004 09:32 schrieb Ilia Chipitsine:
> I'm about to write plpgsql function which will "vacuum full" all existing
> databases. Below is an example how to get list of databases.
>
> What should I write instead of "raise notice" ?
You normally cannot access different databa
Ilia Chipitsine wrote:
Dear Sirs
I'm about to write plpgsql function which will "vacuum full" all existing
databases. Below is an example how to get list of databases.
What should I write instead of "raise notice" ?
raise notice ''datname = %'',list.datname;
Something like:
EXECUTE ''VACUUM FU
> Ilia Chipitsine wrote:
> > Dear Sirs
> >
> > I'm about to write plpgsql function which will "vacuum full" all existing
> > databases. Below is an example how to get list of databases.
> >
> > What should I write instead of "raise notice" ?
>
> > raise notice ''datname = %'',list.datname;
>
> So
You've probably done this, but I should ask anyway.
Did you run the vcvars.bat to set the environment variables for MS VC?
I know I've run into this is previous versions, but IIRC it was operator error.
-Tony
---(end of broadcast)---
TIP 7: don't
Hi Elie,
Now I got the right information from the DB in Hebrew and french.
Still can't save value in Hebrew from client (browser) to server and in
french if I save 'été' in a column varchar(3) I got a range over exception.
you are working through the web. That makes the whole thing a lot more
com
Hi,
yes, I have been hit by the, now also known to me, foreign key locking
"feature". And yes I did read that I should use "defer" to solve the
problem. Question is:
Do I have to recreate my schema with all foreign keys set to "initially
defered deferable"?
Ulrich
---(e
On Thu, 2 Sep 2004, Richard Huxton wrote:
> Ilia Chipitsine wrote:
> > Dear Sirs
> >
> > I'm about to write plpgsql function which will "vacuum full" all existing
> > databases. Below is an example how to get list of databases.
> >
> > What should I write instead of "raise notice" ?
>
> > raise
On a nightly basis, we shut the database down and do a file system backup.
A short chronology of our database problem:
8/21 - count(*) of user tables succeeded (done once a week to get
statistics)
8/23 - A specific search on a specific value (one out of over 2 million)
caused postmaster to SEGV.
Is there any way to debug a procedural language shared library when you can't
createlang?
I get this...
L-897V601: {1} createlang pltcl template1
DEBUG: InitPostgres
DEBUG: StartTransactionCommand
DEBUG: PortalRun
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: PortalR
Hmm. I do a nightly dump of our production database, archive a copy
offsite, and verify the quality of the dump by running a little
verification script that is little more than a restore.
But if it would take you more than a day to do that, I'm not sure.
-tfo
On Sep 2, 2004, at 3:30 PM, Wes wrot
> "SS" == Stephan Szabo <[EMAIL PROTECTED]> writes:
SS> You really should just need to drop the constraints and recreate them, not
SS> the entire schema.
So do I want to do deferred checks on all transactions, or just
some/one of them? I'm assuming that if the advice is to make them
initall
"Ian Harding" <[EMAIL PROTECTED]> writes:
> Is there any way to debug a procedural language shared library when you can't
> createlang?
Hmm. I would bet on this being an abort() inside the dynamic linker.
It's annoying that it doesn't say anything beforehand :-( ... you are
capturing postmaster
Arundhati wrote:
Hi
I want the result of select query to be returned from a function. Or
is there any way to return a table from a function?
What you are looking for is a table function:
http://www.postgresql.org/docs/7.3/interactive/xfunc-tablefunctions.html
http://www.postgresql.org/docs/7.4/inte
* Richard Huxton <[EMAIL PROTECTED]> [020904, 16:54]:
> Ennio-Sr wrote:
>
> >My questions are then:
> [ ... ]
> >2. In case I put the memos in the main table, would it be possible to
> > control someway the display of memo-text fields? [Only some of the
> > records have a memo, and a referrin
> --- Tom Lane <[EMAIL PROTECTED]> escreveu:
> > the only mechanism I've heard of that causes this is the Linux
> > kernel's
> > out-of-memory killer --- see
> >
>
http://www.postgresql.org/docs/7.4/static/kernel-resources.html#AEN17068
> > Googling for "OOM kill" will give you additional gory de
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <[EMAIL PROTECTED]> writes:
>> --- Tom Lane <[EMAIL PROTECTED]> escreveu:
>>> Googling for "OOM kill" will give you additional gory details :-(.
>>
> I did:
> # /sbin/sysctl -w vm.overcommit_memory=2
> vm.overcommit_memory = 2
> But it didn't help much:
At my company we are looking at deploying clients for our client/server
app outside our firewall, which will then require our postgres box to be
internet-accessible.
Does anyone out there have experience with this or recommended best
practices? We have been looking at either (a) tunnelling ev
Hi all!
I'm writing a script that presents the user with a numbered lines
menu, each line corresponding to a which executes a psql
command. As the psql-commands are very similar to each other (all of
them have the structure:
1.- psql mydb -x -c "SELECT * FROM tb_nm WHERE col_nm LIKE '%$k_r%'" )
Hello,
I don't know if the C# postgresql provider can do this, but you can use
PostgreSQL with SSL + MD5 which would be fairly secure.
Another option would be to have them authenticate via a web application
that would open a tunnel specifically for that user per IP.
Sincerely,
Joshua D. Drake
Pa
> Does anyone out there have experience with this or recommended best
> practices? We have been looking at either (a) tunnelling everything
> over ssh, or (b) just making sure that users have "strong" passwords and
> requiring "md5" authentication in pg_hba.conf.
Have you considered using VPN
Paul Tillotson wrote:
At my company we are looking at deploying clients for our
client/server app outside our firewall, which will then require
our postgres box to be internet-accessible. Does anyone out there
have experience with this or recommended best practices? We have
been looking at either
23 matches
Mail list logo
