On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
Hi all,
I was trying to create function in postgres, but it returns error mentioning
the language is NOT defined.
snip
ERROR: language plpgsql does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.
I
You can also create the language in template1 and then you'll have it in any
other database you'll create (from template1).
Il Wednesday 31 October 2007 08:21:08 Martijn van Oosterhout ha scritto:
On Wed, Oct 31, 2007 at 11:07:36AM +0800, carter ck wrote:
Hi all,
I was trying to create
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230
On Wed, Oct 31, 2007 at 4:07 AM, in message
[EMAIL PROTECTED], carter ck
[EMAIL
Hello all,
I got surprised by this message:
-
The program pg_dump is needed by pg_dumpall but was not found in the
same directory as /usr/bin/pg_dumpall.
Check your installation.
--
It's quite strange because I'm quite the
Hi,
How I configure password to postgres user in Linux?
I'm using trust, but I needing configure password in database.
Thanks!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index
On 31 out, 07:33, [EMAIL PROTECTED] (João Paulo Zavanela) wrote:
Hi,
How I configure password to postgres user in Linux?
I'm using trust, but I needing configure password in database.
Thanks!
---(end of broadcast)---
TIP 9: In versions below
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
These two databases do not have the same ER model. However, I want to
access tables on company_a there are in company_b. I want to use
them as local tables (as other databases like Sybase allows, since you
have opened a
On 31 out, 06:56, [EMAIL PROTECTED] (Joao Miguel
Ferreira) wrote:
Hello all,
I got surprised by this message:
-
The program pg_dump is needed by pg_dumpall but was not found in the
same directory as /usr/bin/pg_dumpall.
Check your installation.
Joao Miguel Ferreira [EMAIL PROTECTED] writes:
This is what I do:
system(su postgres -c \pg_dumpall --clean some_file\);
This is going to try to find pg_dumpall in whatever PATH is currently
active within the script --- maybe there's something bogus about that
path? Personally I'd use su -
Hi,
How I configure password to postgres user in Linux?
I'm using trust, but I needing configure password in database.
Thanks!
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
On Tue, Oct 30, 2007 at 01:58:29PM -0500, Decibel! wrote:
Does anyone have a .vim file that takes dollar quoting into account?
I've tried the one mentioned at
http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
it doesn't appear to understand dollar quotes.
The magic
The Amazon Dynamo framework is going to replace RDBMS?
http://www.readwriteweb.com/archives/amazon_dynamo.php
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
These two databases do not have the same ER model. However, I want to
access tables on company_a there are in company_b. I want to use
them as local
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One of
the features that is really nice in ASA is the ability to add the attribute
hidden to a Create procedure, Create function and Create trigger. Essentially
what this does is encrypt the code so that if anyone or any
Hi Oisin,
The only similar issues I have seen was where the user was created for
the DB with the user must change password at next login option and this
caused some issues?
I checked and I have the option never change password checked. However, for
the user I used for the previous 8.0
I don't understand, where I do it?
-- Mensagem Original --
From: Martin Gainty [EMAIL PROTECTED]
To: João Paulo Zavanela [EMAIL PROTECTED]
Subject: Re: [GENERAL] active connections
Date: Mon, 30 Oct 2000 16:51:30 -0500
ps aux | grep postgres
M--
- Original Message -
From: João Paulo
| system(su postgres -c \pg_dumpall --clean some_file\);
I'd try su - postgres ...; this will use postgres' environment here.
That was a good one but still didn't work
| this is run from within a Perl module called from within a Perl script.
|
| I've tried the same command
2007/10/30, Decibel! [EMAIL PROTECTED]:
Does anyone have a .vim file that takes dollar quoting into account?
I've tried the one mentioned at
http://archives.postgresql.org/pgsql-general/2006-04/msg01266.php , but
it doesn't appear to understand dollar quotes.
dollar quoting is mostly used for
On Mittwoch, 31. Oktober 2007, Joao Miguel Ferreira wrote:
| I got surprised by this message:
|
| -
| The program pg_dump is needed by pg_dumpall but was not found in the
| same directory as /usr/bin/pg_dumpall.
| Check your installation.
|
On 10/31/07, João Paulo Zavanela [EMAIL PROTECTED] wrote:
Hi,
How I configure password to postgres user in Linux?
I'm using trust, but I needing configure password in database.
Thanks!
---(end of broadcast)---
TIP 9: In versions
João Paulo Zavanela [EMAIL PROTECTED] schrieb:
I don't understand, where I do it?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?
Please no top-posting, it's hard to
João Paulo Zavanela [EMAIL PROTECTED] writes:
Thanks, but I need configure password to connect to server!
Now the pg_hba.conf is trust, I need change to passwd.
Changing the file to passwd, I don't know how configure password to connect!
Set pg_hba.conf to 'trust', connect and use ALTER USER
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
(all I want is to get a
On Wed, 2007-10-31 at 08:01 -0700, Craig White wrote:
I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
This should do the trick:
$ psql -Atc select table_schema||'.'||table_name from
information_schema.tables
-Reece
--
On 31/10/2007, T.J. Adami [EMAIL PROTECTED] wrote:
Hi people. I have 2 databases named as follows:
1) company_a
2) company_b
hello
you can access others databases via dblink
look to contrib
Pavel Stehule
---(end of broadcast)---
TIP 5:
Il Wednesday 31 October 2007 15:39:55 mgould ha scritto:
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One
of the features that is really nice in ASA is the ability to add the
attribute hidden to a Create procedure, Create function and Create trigger.
Essentially what
mgould wrote:
We are currently migrating from Sybase's ASA 9/10 to PostGres
8.2.4. One of the features that is really nice in ASA is the
ability to add the attribute hidden to a Create procedure,
Create function and Create trigger. Essentially what this
does is encrypt the code so that
On 10/31/07, Reg Me Please [EMAIL PROTECTED] wrote:
Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:
The question is: can I do this using remote database servers
(different hosts)? If does not, can I do it at least on local
databases on the same server?
As far as they are
On 31 out, 12:01, [EMAIL PROTECTED] (Craig White) wrote:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to
On 31 out, 11:00, [EMAIL PROTECTED] (Phoenix Kiula) wrote:
The Amazon Dynamo framework is going to replace RDBMS?
http://www.readwriteweb.com/archives/amazon_dynamo.php
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Wednesday 31 October 2007 T.J. Adami's cat, walking on the keyboard, wrote:
The question is: can I do this using remote database servers
(different hosts)? If does not, can I do it at least on local
databases on the same server?
I guess the dblink module could help you.
Luca
mgould [EMAIL PROTECTED] writes:
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4.
One of the features that is really nice in ASA is the ability to add
the attribute hidden to a Create procedure, Create function and
Create trigger. Essentially what this does is encrypt the
I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252.
On PostgreSQL 8.2.5 I'm able to create data
Craig White wrote:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
my script looks like this...
There's not bulletproof way, in my opinion.
If they copy the whole DB structure *and* the object binaries they'll
have the very same functionalities!
Il Wednesday 31 October 2007 16:13:23 Douglas McNaught ha scritto:
mgould [EMAIL PROTECTED] writes:
We are currently migrating from Sybase's
On Wed, Oct 31, 2007 at 08:01:41AM -0700, Craig White wrote:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a
way to query a database and get a text file with just the table
names and cannot figure out a way
João Paulo Zavanela wrote:
The file pljava.dll exist in directory, why this error?
Someone can help me?
PL/Java has it's own mailing list here:
http://gborg.postgresql.org/mailman/listinfo/pljava-dev
I think it is still active, but I'm not sure. Sorry, I'm short on time.
Search the
2007/10/31, Craig White [EMAIL PROTECTED]:
I wrote a little script to individually back up table schemas, table
data and then vacuum the table and it works nicely but I wanted a way to
query a database and get a text file with just the table names and
cannot figure out a way to do that.
for
On 10/31/07, mgould [EMAIL PROTECTED] wrote:
We are currently migrating from Sybase's ASA 9/10 to PostGres 8.2.4. One of
the features that is really nice in ASA is the ability to add the attribute
hidden to a Create procedure, Create function and Create trigger.
Essentially what this does
On 10/29/07, Kalra, Ashwani [EMAIL PROTECTED] wrote:
Hi,
In our thick client application, I want to update the schema on the
user's machine automatically as normal software update process using JNLP
etc
We will be using Eclipser RCP. Is it possible?
Sure. IF nothing else, you can just
On 10/31/07, Douglas McNaught [EMAIL PROTECTED] wrote:
The only bulletproof way to do this currently is to write all your
stored functions in C and load them as a shared library.
Well, as I pointed out in my post, even that's not bullet-proof. As
long as decompilers / debuggers etc... exist,
T.J. Adami [EMAIL PROTECTED] writes:
I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
createdb: database creation failed: ERROR: encoding LATIN1 does not
match server's locale Portuguese_Brazil.1252
DETAIL: The server's LC_CTYPE setting requires encoding WIN1252.
That's
On 10/31/07, T.J. Adami [EMAIL PROTECTED] wrote:
On 31 out, 11:00, [EMAIL PROTECTED] (Phoenix Kiula) wrote:
The Amazon Dynamo framework is going to replace RDBMS?
http://www.readwriteweb.com/archives/amazon_dynamo.php
This is another idea trying to put down RDBMS. I really think SQL and
Alvaro Herrera wrote:
Bruce Momjian wrote:
Is this item closed?
No, it isn't. Please add a TODO item about it:
* Prevent long-lived temp tables from causing frozen-Xid advancement
starvation
Thanks. Added to TODO.
--
Bruce Momjian [EMAIL PROTECTED]http://momjian.us
Thanks all. In the open source community there seems to be more talent to
hack than in other environments. Once I told ASA to set the hidden
attribute, I've not had any problems with this, at least that I've heard of. I
was hoping that I'd be able to keep others out of the database totally
Title: can someone please tell me how to unsubscribe from this group - thanks
can someone please tell me how to unsubscribe from this
group - thanks
Regards,
Ian
Ian Goldsmid
www.semanticdiscoverysystems.com
can someone please tell me how
When I run a query, and the number of lines exceeds what the screen can
hold, the results seem to get piped into more (or less). How can I
turn that off and just have everything stream out without stopping? I
tried -echo-all, but that doesn't seem to do the trick.
Thanks in Advance !
Scott Marlowe [EMAIL PROTECTED] writes:
On 10/31/07, Douglas McNaught [EMAIL PROTECTED] wrote:
The only bulletproof way to do this currently is to write all your
stored functions in C and load them as a shared library.
Well, as I pointed out in my post, even that's not bullet-proof. As
Joao Miguel Ferreira [EMAIL PROTECTED] writes:
This is what I do:
system(su postgres -c \pg_dumpall --clean some_file\);
this is run from within a Perl module called from within a Perl script.
I've tried the same command directlly on the shell and it works fine.
But from the perl script
Tom Lane wrote:
Michael Harris [EMAIL PROTECTED] writes:
The tip is ''kill -9' the postmaster', which has two important
differences to the scenario I just described:
1) kill -9 means the OS kills the process without allowing it to clean
up after itself
2) The postmaster is the master
Hello,
We had a great time at the conference and subsequent party. If you are
ever in PDX and want some great food and interesting accommodations I
strongly suggest the Paramount Hotel and Dragon Fish cafe. They treated
all of us very well and had great food!
The conference did well above
=?ISO-8859-1?Q?Christian_Schr=F6der?= [EMAIL PROTECTED] writes:
But then, when I tried to reconnect to the database, I received the
following message:
2007-10-31 22:50:01 CET - chschroe FATAL: the database system is in
recovery mode
Ok, you wrote Postgres will recover automatically, but
Tom Lane wrote:
Ok, you wrote Postgres will recover automatically, but could this take
several minutes?
Yeah, potentially. I don't suppose you have any idea how long it'd been
since your last checkpoint, but what do you have checkpoint_timeout and
checkpoint_segments set to?
I did
On 30/10/2007, Oleg Bartunov [EMAIL PROTECTED] wrote:
ok, then you have to formalize many things - how long should be excerpts,
how much excerpts to show, etc. In tsearch2 we have get_covers() function,
which produces all excerpts like:
=# select get_covers(to_tsvector('1 2 3 4 5 3 4 abc x y
Hi list,
I have a strange problem: When I connect to one of my databases, the
current_user immediatly changes without any interaction from my side.
This is what I do:
[EMAIL PROTECTED]:~ psql -h db2 testdb
Welcome to psql 8.2.5, the PostgreSQL interactive terminal.
Type: \copyright for
On Wed, Oct 31, 2007 at 05:18:58PM -0400, mgould wrote:
Thanks all. In the open source community there seems to be more
talent to hack than in other environments.
I think we're just much more honest about what the technology is
really capable of. None of us is likely to actually bother
=?ISO-8859-1?Q?Christian_Schr=F6der?= [EMAIL PROTECTED] writes:
I have a strange problem: When I connect to one of my databases, the
current_user immediatly changes without any interaction from my side.
That's bizarre. Do you have anything in ~/.psqlrc? I'm also wondering
(though too lazy
CREATE ROLE db_users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE db_users SET search_path=mydb, public;
When I create a login,
CREATE ROLE oli LOGIN
ENCRYPTED PASSWORD 'mXXX'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE oliver SET search_path=xmms; I have to set
On Thu, 2007-11-01 at 00:02 -0400, Tom Lane wrote:
Ow Mun Heng [EMAIL PROTECTED] writes:
Why is this such or is this an intended feature?
No, there is no intention that ALTER ROLE SET values be inherited ---
what you get is just what is attached to the role you logged in as.
What would
Ow Mun Heng [EMAIL PROTECTED] writes:
Why is this such or is this an intended feature?
No, there is no intention that ALTER ROLE SET values be inherited ---
what you get is just what is attached to the role you logged in as.
What would you do with conflicting sets from different inherited roles,
Tom Lane wrote:
=?ISO-8859-1?Q?Christian_Schr=F6der?= [EMAIL PROTECTED] writes:
I have a strange problem: When I connect to one of my databases, the
current_user immediatly changes without any interaction from my side.
That's bizarre. Do you have anything in ~/.psqlrc? I'm also
am Wed, dem 31.10.2007, um 17:14:02 -0400 mailte Gauthier, Dave folgendes:
When I run a query, and the number of lines exceeds what the screen can hold,
the results seem to get piped into ?more? (or ?less?). How can I turn that
off
and just have everything stream out without stopping? I
62 matches
Mail list logo