On Wed, 15 Jul 2009 16:02:09 +0200, Alvaro Herrera
wrote:
My bet is on the pg_auth flat file. I doubt we have ever tested the
behavior of that code with 1 billion users ...
I've noticed this behaviour some time ago, on a cluster with 50k+ roles
(not sure about the number now). Restoring the
On Fri, 10 Apr 2009 11:55:03 +0200, Durgabhavani.g
wrote:
I am trying to port my application from Oracle to PostGREs. I have a
problem while doing so. In my application i need to update record if the
delete on the respective record is failed due to Constraint Violation.
But SQL Error:
On Fri, 06 Mar 2009 14:25:44 +0100, carl wrote:
When running the following code, a number representing the number of
effected rows is returned, but the database entries have not been
changed.
Just a quick idea: aren't you running that in a transaction which is ROLLED
BACK at the end (this al
On Mon, 16 Feb 2009 10:37:27 +0100, Heikki Linnakangas
wrote:
You can read the value returned by currval into a host language variable
and send it back as a ?.
Wouldn't it be possible to do UPDATE booking_entries SET date = ? where id =
(SELECT currval('booking_entries_id_seq'::regclass)); t
On Fri, 28 Nov 2008 19:36:31 +0100, <[EMAIL PROTECTED]> wrote:
i reinstal postgre but they ask me a password but i find i can put dbpass
but this not work what i had to do plz?
Hmm... Ok, here it goes:
if i wer u i wud try to remov ze old postgre data dir unfortunaty i haz no
idea wher it res
On Sun, 23 Nov 2008 17:19:38 +0100, Ferdinand Gassauer <[EMAIL PROTECTED]>
wrote:
currently the columns are sorted by attnum (not very userfriendly)
instead
of attname (userfriendly)
Actually, I prefer it the old way. I just like to know the column order
`SELECT *' would return (though I never
On Thu, 23 Oct 2008 18:46:34 +0200, Viraj Kanwade <[EMAIL PROTECTED]> wrote:
psql -d mydb -U usr -t -c " select val1 from ""MyTable"" where val2 =
'abc' "
OR
psql -d mydb -U usr -t -c ' select val1 from "MyTable" where val2 =
''abc'' '
Both work fine on my windows machine.
This is complete
On Thu, 09 Oct 2008 14:06:35 +0200, Peter Eisentraut <[EMAIL PROTECTED]>
wrote:
If this is the location you give it, why should it avoid creating
tablespaces there?
I believe this is called "making things `idiot-proof'". This is the
direction Microsoft's software takes, and I wouldn't be real
On Tue, 23 Sep 2008 11:44:24 +0200, security improvement proposal:
pg_hba.conf and CIDR mask <[EMAIL PROTECTED]> wrote:
Description:entries like "hostall all 10.0.50.31/0
..."
should not be allowed or trigger a warning
A CIDR mask length of 0 will allow to connect from
Dnia 22-07-2008 o 14:36:22 Alexandre Payment <[EMAIL PROTECTED]>
napisał(a):
I'm afraid that's what the warning:
WARNING: You are connected to a server with major version 8.2,
but your psql client is major version 8.3. Some backslash commands,
such as \d, might not work
On Tue, 01 Jul 2008 19:44:28 +0200, Avilio Alarcón
<[EMAIL PROTECTED]> wrote:
pg_dump: not found
I have no idea what you just said, but I think I understand the problem.
Cron's PATH is reset to quite simple value in each cron script, so,
instead of:
pg_dump -Ft -b radius > $(date +%Y%m%d)_al
albums WHERE id = 22927;
count
---
1
(1 row)
toruvinn=> \d albums
Table "public.albums"
Column|Type |
12 matches
Mail list logo
