I have fixed it with dollar-quoting.
Original-Nachricht
Betreff:[SQL] copy from csv, variable filename within a function
Datum: Thu, 18 Apr 2013 09:26:09 +0200
Von:basti black.flederm...@arcor.de
An: pgsql-sql@postgresql.org
Hello,
i have try the following:
Hi,
I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD
newpassword
it changes ok but then I can't login with my newpassword...
It says authetication failed.
My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok,
but I accidentaly changed the password
Which version of postgresql.?
Sent from my Samsung Galaxy Note.
On 18 Apr 2013 11:01, Marcin Krawczyk jankes...@gmail.com wrote:
Hi,
I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD
newpassword
it changes ok but then I can't login with my newpassword...
It says
I figured it out... when changing role from pgAdmin, it has a default VALID
UNTIL 1970 set and after confirming changes it just made my abc user
account invalid... but upon connecting postgres complains about pass
authetication, maybe the message should be changed ?
It's 9.1 by the way.
OK then..
Sent from my Samsung Galaxy Note.
On 18 Apr 2013 11:22, Marcin Krawczyk jankes...@gmail.com wrote:
I figured it out... when changing role from pgAdmin, it has a default
VALID UNTIL 1970 set and after confirming changes it just made my abc user
account invalid... but upon connecting
On 2013-04-16, Mark Stosberg m...@summersault.com wrote:
My challenge is that I want to make very hard or impossible to access
the soft-deleted rows through SELECT statements. There are lots of
selects statements in the system.
My current idea is to rename the foo table to something that
Note: DELEMITER should be DELIMITER.
On Thu, Apr 18, 2013 at 1:34 AM, basti black.flederm...@arcor.de wrote:
I have fixed it with dollar-quoting.
Original-Nachricht Betreff: [SQL] copy from csv,
variable filename within a function Datum: Thu, 18 Apr 2013 09:26:09
+0200
Hi,
I am using Postgres DB with stand by database, configured with streaming in
synchronized mode (each commit on primary DB waits for commit on secondary DB).
Sometimes we suffer from network issues and as consequences, secondary machine
is not available.
In these situations, our
Sofer, Yuval yuval_so...@bmc.com wrote:
Hi,
I am using Postgres DB with stand by database, configured with streaming in
synchronized mode (each commit on primary DB waits for commit on secondary
DB).
Sometimes we suffer from network issues and as consequences, secondary
On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk wrote:
I figured it out... when changing role from pgAdmin, it has a default VALID
UNTIL 1970 set and after confirming changes it just made my abc user
account invalid...
FYI, this pgAdmin bug has been fixed. The fix will be available in the
I have a temporary table with columnszone_name, nodeid, nodelabel,
nodegainedservice, nodelostserviceZone1, 3, Windows-SRV1, 2012-11-27
13:10:30+08, 2012-11-27 13:00:40+08Zone1, 5, Windows-SRV2,
2012-12-20 13:10:30+08, 2012-12-18 13:00:40+08Many zones
and many nodes and
11 matches
Mail list logo