[SQL] copy from csv, variable filename within a function

Hello, i have try the following: -- Function: wetter.copy_ignore_duplicate(character varying) -- DROP FUNCTION wetter.copy_ignore_duplicate(character varying); CREATE OR REPLACE FUNCTION wetter.copy_ignore_duplicate(_filename character varying) RETURNS void AS $BODY$ declare sql text; BEGI

Fwd: [SQL] copy from csv, variable filename within a function

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 An: pgsql-sql@postgresql.org Hello, i have try the following: -- Function: wetter.copy_i

[SQL] ALTER USER abc PASSWORD - what's going on ???

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 f

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

Which version of postgresql.? Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:01, "Marcin Krawczyk" 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 autheticatio

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

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. pozdrowie

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

OK then.. Sent from my Samsung Galaxy Note. On 18 Apr 2013 11:22, "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... but upon connecting postgres compla

Re: [SQL] Peer-review requested of soft-delete scheme

On 2013-04-16, Mark Stosberg 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 would > stand-out

Re: [SQL] copy from csv, variable filename within a function

Note: "DELEMITER" should be "DELIMITER". On Thu, Apr 18, 2013 at 1:34 AM, basti 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 Von: bastiA

[SQL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

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 applic

Re: [SQL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

Sofer, Yuval 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 machine > is no

Re: [SQL] ALTER USER abc PASSWORD - what's going on ???

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

[SQL] SQL query with Overlapping date time ranges

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+08"Zone1, 5, Windows-SRV2, "2012-12-20 13:10:30+08", "2012-12-18 13:00:40+08"Many zones and many no