On Tue, 12 Oct 2004, Ed Stoner wrote:
I am unable to use the CREATE USER command with numeric user names
(i.e. CREATE USER 35236 WITH PASSWORD '1234';). Is this a limitation or
a problem somewhere with how I have things configured? Is there are
workaround?
I believe you can create a user
I have the following function and I am getting an invalid syntax error
when I try to run it. I have tried the function a number of ways
including with named parameters and non-named parameters using the
args array. I also tried it with a tab at the beginning and without.
I've also tried with the
I don't know plpythonu but python ;-) As I really understood your
problem you want to return strings. In Pytho return(OK ) should work ;-)
Hagen
Sim Zacks wrote:
I have the following function and I am getting an invalid syntax error
when I try to run it. I have tried the function a number of
Am Dienstag, 19. Oktober 2004 02:31 schrieb Robby Russell:
Isn't the purpose to promote PostgreSQL? not *nix-only flavors?
It could be argued that the purpose is to get one's job done.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
I had tried it exactly the way I wrote it in python as a function and it
worked.
Just in case I tried changing it to return (OK) as you suggested and
got the same error.
Thank You
Sim Zacks
IT Manager
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Please forgive me if I'm posting to the wrong mailing list. I
am working with Windows XP and the beta2-dev3 version of
PostgreSQL. The issue I am having is under a login name that
has administrative rights to the machine the program is
running on (a program I wrote), database access is
Thanks for the link.
I had already looked at that page, and it gives basically no help at
all. I think the problem is how Pgadmin handles new lines or something
like that. because I can't get any 2 line program to work.
I also tried the code in PSQL and it worked when I indented manually
(hitting
Don Kelloway wrote:
I'm a first-time user with PostgreSQL so please forgive my ignorance.
I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL
Essential Reference (New Riders). So far, so good. I think learning
PostgreSQL will not be as difficult as I thought it would be.
On 18 Oct 2004 at 17:38, Eric wrote:
It is possible to mainteners of this list to keep this list from
/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor server OS like windows.
Now, we are invade
Hello,
You probably should look at the documentation for this.
http://www.postgresql.org/docs/current/interactive/sql-begin.html
PostgreSQL supports _exactly_ this notion, in exactly the way you
describe.
But this is normal 'transaction' - and I didn't find way, how can I 'store'
Hi,
Suppose you have a web form to edit data from a table... you add a field
in your table which contains a version identifier for that data, then you
UPDATE ... WHERE ... AND version_id = the old version id. The version_id
is passed around in a session variable or in hidden form fields. The
On 10/19/2004 7:11 AM, Raymond O'Donnell wrote:
On 18 Oct 2004 at 17:38, Eric wrote:
It is possible to mainteners of this list to keep this list from
/$?%/$?/? windows problems? I don't care about windows. The worst
thing never made was porting an excellent product like PostgreSQL to a
poor
Hi,
while upgrade to 8.0 (beta3) we got some problem:
we have a database which encoding is UNICODE,
when we do queries like:
select upper(''); --select some multibyte character,
then postgresql response:
ERROR: invalid multibyte character for locale
but when we do it in a SQL_ASCII encoding
Experimenting with Beta 8 on Windows; we got this message while running
PC-SAS queries against a table with over 7 million rows. Which setting(s)
should I be looking at?
Thanks
Mark R. Taber
Database Administrator,
Infrastructure and Architecture
State of California
Department of Finance
On Thu, Oct 14, 2004 at 10:29:11AM +0530, Nageshwar Rao wrote:
Hi,
We would like use Postgresql as our database. For high availability is it
possible to cluster DB in Postgresql. Appreciate if you can let me know how
this can be achieved.
Else is there any other way to achieve High
Weiping [EMAIL PROTECTED] writes:
we have a database which encoding is UNICODE,
when we do queries like:
select upper('ÖÐÎÄ'); --select some multibyte character,
then postgresql response:
ERROR: invalid multibyte character for locale
What locale did you initdb in? The most likely
Hi
I tried creating the function (from sec 19.3.1). But it gives me the
following error: ERROR: type tablename does not exist.
Any ideas of what i might be doing wrong?
CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
DECLARE
in_t ALIAS FOR $1;
BEGIN
RETURN in_t.f1 || in_t.f3
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 19 Oct 2004, Hicham G. Elmongui wrote:
I tried creating the function (from sec 19.3.1). But it gives me the
following error: ERROR: type tablename does not exist.
Any ideas of what i might be doing wrong?
You have to write the data type
Hicham G. Elmongui [EMAIL PROTECTED] writes:
I tried creating the function (from sec 19.3.1). But it gives me the
following error: ERROR: type tablename does not exist.
Any ideas of what i might be doing wrong?
CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
The example assumes
On Tue, Oct 19, 2004 at 01:29:41PM +0200, Lada 'Ray' Lostak wrote:
But this is normal 'transaction' - and I didn't find way, how can I 'store'
transaction to disc storage and 'reopen' later.
That you can't do. The usual recipe for this is something like
optimistic locking -- for instance, set
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can I do this functionality
Why not do this on the client side? I'm just curious as to the benfit
of doing this on the server.
On Tue, 19 Oct 2004 11:10:58 -0500, Hicham G. Elmongui
[EMAIL PROTECTED] wrote:
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between
Hicham G. Elmongui wrote:
I need to select all tuples from a table, but need them to be fetched with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can I
Use a cursor...
I need to select all tuples from a table, but need them to be fetched
with a
constant delay (say 1 sec) between every consecutive tuples.
The first idea that came up to my mind is to create a DelayedSeqScan
operator, and put delay before returning the scanned tuple.
Can
---BeginMessage---
Il me parait un peu illusoire de contester un test alors que CleverAge a
pris la peine de contacter la communauté francophone de PostgreSQL et que
personne ne s'est déplacée (pour des raisons que je ne critique pas).
Donc à partir de ce moment là, je trouve abhérant de
I am trying to download postgresql from one of the mirror sites. I get prompted for a username and password. I try anonymous login and my password and I get an error stating either the server doesn't support anonymous logins or that my email address wasn't accepted.
What am I doing incorrectly?
On Tue, 19 Oct 2004 00:48:34 -0500, Thomas F. O'Connell
[EMAIL PROTECTED] wrote:
Ah, yes. You're right.
Presumably you could use the hidden query from \dn in psql to get the
tables necessary for a script. That's the next best thing I can think
of.
I wrote a script to do the vacumming. I
[EMAIL PROTECTED] wrote:
I am trying to download postgresql from one of the mirror sites. I get
prompted for a username and password. I try anonymous login and my
password and I get an error stating either the server doesn't support
anonymous logins or that my email address wasn't accepted.
Is there a way to remove idle connections? My postgres server is
getting serveral hundred idle connections. It's due to a postgres .NET
provider not closing the connections properly. I don't want to kill
them all, or restart postgres everytime the connections go crazy.
-Josh
On Oct 19, 2004, at 1:14 AM, David Garamond wrote:
btw, TEXT is one of those postgres-specific features that makes you
stick (stuck? :-) with postgres. nowadays, i never ever have to bother
to think whether to give a column a max width of 32, 50, 64, 100, 150,
... is that a bad thing
I don't
No dice.
It tried ftp as the userid and anonymous as the password. I tried using anonymous and supplying my email [EMAIL PROTECTED]
Joshua D. Drake [EMAIL PROTECTED]
10/19/2004 01:53 PM
To:[EMAIL PROTECTED]
cc:[EMAIL PROTECTED]
Subject:Re: [GENERAL] download
Sure. The system tables can be accessed via SQL.
I frequently use the output of psql's hidden queries to glean more
information about postgres internals for needs like yours where
postgres has the information but not the interface to accomplish a
specific task.
-tfo
On Oct 19, 2004, at 12:50
On 19 Oct 2004 at 13:00, Josh Close wrote:
Is there a way to remove idle connections? My postgres server is
getting serveral hundred idle connections. It's due to a postgres .NET
provider not closing the connections properly. I don't want to kill
them all, or restart postgres everytime the
On Tue, 19 Oct 2004 19:24:23 +0100, Gary Doades [EMAIL PROTECTED] wrote:
I would have though it would be better to fix the client application. If the
app is not closing connections then you may be leaking handles and
memory.
What .NET provider is this? Are you sure it is not just normal
On 19 Oct 2004 at 13:32, Josh Close wrote:
The provider is corelabs. The programmer that wrote the code says he's
closing the connections, but they aren't actually closing.
Any ideas? Or better yet, do you know of a good postgres .net provider?
Hmm, I've had lots of problems with the
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
DelayedTable provides me with one tuple every 5 seconds.
Regards,
--h
Hicham G. Elmongui [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I need to select all tuples
On Tue, Oct 19, 2004 at 01:44:34PM -0500, Hicham G. Elmongui wrote:
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
You can probably build a sleep() function in C, and then use that to
cause delaying in a PL/pgSQL
Hicham G. Elmongui wrote:
I need this for a side project. Is there a way to do something like this:
SELECT *
FROM DelayedTable('tablename', 5);
No, at my knowledge you'll obtain the first tuple only when
the function exit.
Regards
Gaetano Mendola
---(end of
I'm trying to add some functionality to an already existing
application...this applications works fine, and uses the PHP function
pg_pconnect to make a persistent connection to the database. This works
very well.
My part is to make a new non-persistent connection (or whatever), to a
newly
Hallo!
I have a big problem, I am under time pressure to
finish my project. can anybody please help me?
I am developing a DB System associated with a File
server. The DB Server should manage directories which
could be, I thought, created through fired Triggers.
I wrote a C function and compiled
Works fine from here ... what FTP program are you using?
On Tue, 19 Oct 2004 [EMAIL PROTECTED] wrote:
No dice.
It tried ftp as the userid and anonymous as the password. I tried using
anonymous and supplying my email [EMAIL PROTECTED]
Joshua D. Drake [EMAIL PROTECTED]
10/19/2004 01:53 PM
Josh Close wrote:
Is there a way to remove idle connections? My postgres server is
getting serveral hundred idle connections. It's due to a postgres .NET
provider not closing the connections properly. I don't want to kill
them all, or restart postgres everytime the connections go crazy.
I do not
Internet explorer.
Marc G. Fournier [EMAIL PROTECTED]
10/19/2004 04:39 PM
To:[EMAIL PROTECTED]
cc:Joshua D. Drake [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: [GENERAL] download postgreql problem
Works fine from here ... what FTP program are you using?
On Tue, 19 Oct 2004 16:24:06 -0400, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Internet explorer.
That would be your problem right there. IE's handling of FTP sessions
is notoriously quirky. Do yourself a favor and download a shareware
FTP program, or open up a DOS prompt.
Regards,
oops on Joshua's part:
ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql
just accessed it from here using IE ...
On Tue, 19 Oct 2004 [EMAIL PROTECTED] wrote:
Internet explorer.
Marc G. Fournier [EMAIL PROTECTED]
10/19/2004 04:39 PM
To: [EMAIL PROTECTED]
cc: Joshua
I know this is kinda a debate, but how much ram do I give postgres?
I've seen many places say around 10-15% or some say 25%... If all
this server is doing is running postgres, why can't I give it 75%+?
Should the limit be as much as possible as long as the server doesn't
use any swap?
Any
Thats fine, but you do understand that nice (linux) will have *no*
effect on I/O?
For any non-trivial table (that can't be held entirely in memory),
re-nice will almost certainly have no effect.
-Barry
In article [EMAIL PROTECTED], Gaetano Mendola wrote:
Tom Lane wrote:
Gaetano Mendola
Sorry to burden this list (again) with a psycopg question.
I'm stuck at a table creation step and am not getting results
from their list.
Question: what's the appropriate syntax for specifying a primary
key?
My very simple table creation test (based on their first.py
example is failing ...
Hello,
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!
~RvR
---(end of broadcast)---
TIP 1: subscribe
Lada 'Ray' Lostak wrote:
I will also appreciate any links to web resources, talking about this
problem. I didn't find anything usefull around.
I'm working with developing a fairly big warehouse management system, and
there we see this problem every day. We've settled (many years ago) for
Hallo!
I have a big problem, could you please help me?
I am developing a DB System accociated with a File
server. The DB Server schould manage directories which
coulkd be, I thought, fired with after insert
Triggers. I wrote a C function and compiled as
-shared. But its not working. Is there
Hello,
Is there a way to recover from the following error?
I have (had) an existing database and wish not
to lose the data tables.
Thanks for any help,
Pete
[EMAIL PROTECTED] /]$ pg_ctl start
postmaster successfully started
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
Ack! I sent this msg on October 14. Since then, I've gotten the
primary
key stuff working.
Please disregard this msg.
Thanks
Scott
On Oct 14, 2004, at 4:16 PM, Scott Frankel wrote:
Sorry to burden this list (again) with a psycopg question.
I'm stuck at a table creation step and am not getting
Josh Close [EMAIL PROTECTED] writes:
I know this is kinda a debate, but how much ram do I give postgres?
I've seen many places say around 10-15% or some say 25%... If all
this server is doing is running postgres, why can't I give it 75%+?
Should the limit be as much as possible as long as
peter Willis [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG: open of /web2-disk1/grip/database/pg_xlog/ (log
file 0, segment 0) failed: No such file or directory
LOG: invalid primary checkpoint
Have you looked at the 7.3 configuration file vs. the 8.0. It's
possible that the 7.3 file is tweakled better then the 8.0. Have you
anaylzed the tables after loading the data into 8.0
On Thu, 14 Oct 2004 12:01:38 -0500, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Hi,
We are experiencing
There might be a better way then this but this works
SELECT a, a+1 as b from (SELECT 1+1 as a) as ab;
On 16 Oct 2004 11:18:48 -0700, ryan [EMAIL PROTECTED] wrote:
Hello,
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely
* ryan [EMAIL PROTECTED] [2004-10-16 11:18:48 -0700]:
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!
You could nest them...
xinu= select (1 + 1)
On Tue, 19 Oct 2004 17:42:16 -0400, Tom Lane [EMAIL PROTECTED] wrote:
The short answer is no; the sweet spot for shared_buffers is usually on
the order of 1 buffers, and trying to go for 75% of RAM isn't
going to do anything except hurt. For the long answer see the
pgsql-performance list
Tom Lane wrote:
peter Willis [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG: open of /web2-disk1/grip/database/pg_xlog/ (log
file 0, segment 0) failed: No such file or directory
LOG: invalid
Tom,
Thanks so much for your reply. In fact we were not vacuuming this
particular db at all! While we have other postgres db's on this same
host, this was a recently added db and it was never added to the
individual db list to be vacuumed. We have since modified the cronjob
to perform a vacuumdb
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups contained
no
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups
Hello
Searched around, but could not find this mentioned.
I've noticed the following behaviour in 7.4.5:
[explain analyse] select * from foo where
col1 = 1 or
col1 = 2 or
col1 = 3 or
col1 = 4 or
col1 = 5 or
col1 = 6 or
col1 = 7 or
col1 = 8;
where an index on foo.col1 exists.
The above works
Tom Lane wrote:
What locale did you initdb in? The most likely explanation for this
is that the LC_CTYPE setting is not unicode-compatible.
emm, I initdb --no-locale, which means LC_CTYPE=C, but if I don't use it
there are
some other issue in multibyte comparing (= operator) operation, will
On Wed, 20 Oct 2004, Henry Combrinck wrote:
Hello
Searched around, but could not find this mentioned.
I've noticed the following behaviour in 7.4.5:
[explain analyse] select * from foo where
col1 = 1 or
col1 = 2 or
col1 = 3 or
col1 = 4 or
col1 = 5 or
col1 = 6 or
col1 = 7 or
col1 =
Mike Nolan wrote:
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups
Weiping wrote:
Tom Lane wrote:
What locale did you initdb in? The most likely explanation for this
is that the LC_CTYPE setting is not unicode-compatible.
finally I get it work, while initdb, we should use matched locale
setting and database encoding, like:
initdb --locale=zh_CN.utf8 -E
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sim Zacks wrote:
| I have the following function and I am getting an invalid syntax error
| when I try to run it. I have tried the function a number of ways
| including with named parameters and non-named parameters using the
| args array. I also tried
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stuart Bishop wrote:
| create or replace function BatchBalanceStatus(int, int, int) returns
| varchar as '
| ~balance, needed, freestock = args
| ~if balance 0:
| ~return Unhandled
| ~elif freestock = needed:
| ~return OK
|
70 matches
Mail list logo