On 2010-12-30, Lukasz Brodziak wrote:
> Hello,
>
> I have a problem with writing a select statement that would return
> records for which difference in values of this and following ID is
> bigger than 1. Example table
> ID Data
> 1 Text
> 2 Text2
> 5 Text5
> 23 Text23
>
On Dec 30, 2010, at 4:03 AM, Imre Oolberg wrote:
> 3. issued pg_start_backup('test') while script is still running
Well, yeah. Your procedure is going to get you a consistent snapshot of the
state of the database when you issued that command.
--
Scott Ribe
scott_r...@elevated-dev.com
http://ww
How good are certmagic.com practice exams for PostgreSQL
exam? My friends told me they are pretty good and he has passed many
exams with their material. Let me know guys!
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql
Hello,
i noticed that the user name as displayed in the postgresql log (specified by
%u) in the log_line_prefix
does not show the user name of the effective user (current_user)as set by "SET
SESSION AUTHORIZATION"
but, instead, shows the initial user which first authenticated against the said
c
On 30 December 2010 12:19, Lukasz Brodziak wrote:
> Hello,
>
> I have a problem with writing a select statement that would return
> records for which difference in values of this and following ID is
> bigger than 1. Example table
> ID Data
> 1 Text
> 2 Text2
> 5 Text5
> 23
Hello,
I have a problem with writing a select statement that would return
records for which difference in values of this and following ID is
bigger than 1. Example table
ID Data
1 Text
2 Text2
5 Text5
23 Text23
24 TXT
25
So I need to return rows with IDs 2,
Hi!
I did my usual test restoration from backup which leaded me to suspect
that some data is missing although database starts up. I did some more
testing to reproduce the problem as generally as i could and i wish to
present it here and hope that somebody could comment on this. It may
well be
