gt; and http://www.liquibase.org/
>
> More: https://dbmstools.com/version-control-tools
>
> Also, if you know PHP, Laravel database migrations have worked great for
> us!
> https://laravel.com/docs/5.6/migrations
>
>
>
> On Feb 26, 2018, at 3:44 AM, Łukasz Jarych wrote:
>
-changes-
> programmatically
>
>
>
> On Feb 26, 2018, at 9:36 AM, Łukasz Jarych wrote:
>
> Thank you geoff!
>
> I think that i will test http://www.liquibase.org/ this one.
>
> what about setting up trigger to metadata (structural table) to find if
> column was added for
Hi Thiemo,
you can share the repository, maybe when i will go more into PostgreSQL i
would help you.
*Regarding table versionig.*
I am thinking about simple solution:
1. Create query or trigger which will be checking last date of inputed data
within Table.
2. Export the table into seperate file/b
Hi,
i added question to stackoverflow.
Can you help me and answer there about my problem?
https://stackoverflow.com/questions/49063257/multiple-developers-working-on-flyway-and-git
thank you !
Jacek
Hello,
i want to track changes (DML) within one table like here:
https://www.cybertec-postgresql.com/en/tracking-changes-in-postgresql/
I need script or tool which will be generating SQL script for each row with
possibility
to rollback each statement,
please help Guys,
Best wishes,
Jacek
Hi Guys,
do you have also problem that every time you have to log into your database
using shell and psql?
I have to write over and over localhost, username, password...how to force
shell to remember this?
Best,
Jacek
;
> On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych"
> wrote:
>>
>> Hi Guys,
>>
>> do you have also problem that every time you have to log into your
>> database using shell and psql?
>>
>> I have to write over and over localhost, username, pas
Hi,
yes, using psql there is an error.
Jacek
2018-03-05 15:22 GMT+01:00 Adrian Klaver :
> On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
>
>> Hi Guys,
>>
>> what is wrong with my pgAdmin?
>>
>> I am creating wrong query:
>>
>> select 1/0 bu
Hi geoff,
i am expecting that there will be error thrown by pg_admin.
Jacek
2018-03-05 15:09 GMT+01:00 geoff hoffman :
> What result were you expecting? A divide by zero error?
>
>
> > On Mar 5, 2018, at 07:05, Łukasz Jarych wrote:
> >
> > Hi Guys,
> >
I am using:
I am using:
thank you for help,
Jacek
2018-03-05 15:22 GMT+01:00 Adrian Klaver :
> On 03/05/2018 06:05 AM, Łukasz Jarych wrote:
>
>> Hi Guys,
>>
>> what is wrong with my pgAdmin?
>>
>> I am creating wrong query:
>>
>> select 1/0
Hello,
I ma trying to save query as sql file in pg_admin4 but file --> save as not
exists like here:
https://www.youtube.com/watch?v=L4KJ_Kpymh4
where can i do it ?
Best,
Jacek
thank you !
Jacek
2018-03-07 14:45 GMT+01:00 Adrian Klaver :
> On 03/06/2018 11:07 PM, Łukasz Jarych wrote:
>
>> Hello,
>>
>> I ma trying to save query as sql file in pg_admin4 but file --> save as
>> not exists like here:
>>
>> https://www.youtube
thanks you!
Jacek
2018-03-07 15:00 GMT+01:00 Melvin Davidson :
>
>
> On Wed, Mar 7, 2018 at 8:46 AM, Łukasz Jarych wrote:
>
>> thank you !
>>
>> Jacek
>>
>> 2018-03-07 14:45 GMT+01:00 Adrian Klaver :
>>
>>> On 03/06/2018 11:07 PM, Łuka
Hello,
i have a table when i have string in each row,
for example "DELETE FROM t_test WHERE ID = 3".
I want to execute for each row this command.
It is possible?
Best wishes,
Jacek
Hello,
i have a trigger which is added log history:
It is possible to create additional column here with string with inversed
SQL statement?
So in this case: "Delete FROM t_trig WHERE ID=1".
And what i want is to have possibility to loop through table and execute
inversed sql statement for ea
Hello Francisco,
thank you !
Jacek is the same as Łukasz. Is my second name and my artist's nickname ;-)
love your answer,
thank you!
Best,
Jacek
2018-03-08 13:40 GMT+01:00 Francisco Olarte :
> Hello:
>
>
>
> On Thu, Mar 8, 2018 at 1:26 PM, Łukasz Jarych wrote:
>
thank you,
what do you mean use external program to build inverted queries. Do you
have any examples?
Best,
Jacek
2018-03-08 13:44 GMT+01:00 Francisco Olarte :
> Hello:
>
> On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych wrote:
>
>>
>>
>> i have a trig
maybe somebody wrote SP to invert update statement?
Best,
Jacek
2018-03-08 13:51 GMT+01:00 Łukasz Jarych :
> thank you,
>
> what do you mean use external program to build inverted queries. Do you
> have any examples?
>
> Best,
> Jacek
>
> 2018-03-08 13:44 GMT+01:00 Fr
Hi Guys,
I am using postgres 10.3 (or 4?).
IT is possible to set up variable inside function?
Best,
Jacek
END IF;
END;
$$ LANGUAGE 'plpgsql' SECURITY DEFINER;
Best,
Jacek
2018-05-15 14:58 GMT+02:00 Adrian Klaver :
> On 05/15/2018 05:28 AM, Łukasz Jarych wrote:
>
>> Hi Guys,
>>
>> I am using postgres 10.3 (or 4?).
>> IT is possible to set up variable i
Thank you Pavel! I wilk set Up variable before function and use it Inside
function , best jacek
Pobierz aplikację Outlook dla systemu iOS<https://aka.ms/o0ukef>
From: Pavel Stehule
Sent: Wednesday, May 16, 2018 9:07:15 AM
To: Łukasz Jarych
Cc: Adrian
Hi Guys,
i am using Access FE and Postgresql BE.
To track DML changes i have history log table wotking like here:
https://www.fontstuff.com/access/acctut21.htm
It is ok but this doesnt solve the problem with trakich DDL changes.
For DDL changes i can use flyway system but how to combine this wi
-- Forwarded message --
From: Łukasz Jarych
Date: 2018-05-30 9:35 GMT+02:00
Subject: Re: Tracking DDL and DML changes in Postgresql and different
versions of database (advance)
To: Pavan Teja
Thank you Pavan,
I have a few questions.
Could you please describe in more details
Hi Guys,
When i have linked table based on DSN odbc connection to postgresql ,
i am going to :
VBA editor, in immediate window inputing:
?CurrentDb.TableDefs("TableName").Connect
i have very strange connection string:
ODBC;DSN=PostgreSQL35W;DATABASE=AccessTest;SERVER=localhost;PORT=5432;*CA=d;
Anyone?
Jacek
2018-06-01 14:21 GMT+02:00 Łukasz Jarych :
> Hi Guys,
>
> When i have linked table based on DSN odbc connection to postgresql ,
> i am going to :
>
> VBA editor, in immediate window inputing:
>
> ?CurrentDb.TableDefs("TableName").Connect
>
edure
>
> Resume
>
> End Sub
>
>
And my conf file is in attachment.
Only this strange DSN less conn string is working:
ODBC;DSN=PostgreSQL35W;DATABASE=AccessTest;SERVER=localhost;
> PORT=5432;*CA=d;A7=100;B0=255;B1=8190;BI=0;C2=;CX=1c305008b;A1=7.4*
Why?
Best,
Jacek
2018
Hi Adrian and Mike,
All is working fine, thank you !
Problem was with connection string and 32 bit computer.
My access is 32 bit so i should have odbc 32 bit driver for postgresql...
Best,
Jacek
2018-06-04 15:31 GMT+02:00 Adrian Klaver :
> On 06/03/2018 09:30 PM, Łukasz Jarych wr
Hi Guys,
how use git to catch delta between database versions?
As version i will do schemas.
So we have version one, finishing it, and this version should be put in
GIT.
And created schema for the version.
Which formats i should use?
pg_dump creates only binary files? (i should use text file he
Hi Adrian,
thank you .
why i should use sqitch or any other software to catch the delta?
When i will export plan-text SQL , git should catch delta automatically?
Can you please explain it?
Best,
Jacek
2018-06-13 19:47 GMT+02:00 Adrian Klaver :
> On 06/13/2018 10:42 AM, Łukasz Jarych wr
thank you Adrian,
Best,
Jacek
2018-06-13 21:09 GMT+02:00 Adrian Klaver :
> On 06/13/2018 11:13 AM, Łukasz Jarych wrote:
>
>> Hi Adrian,
>>
>> thank you .
>>
>> why i should use sqitch or any other software to catch the delta?
>>
>> When i wi
Hi Guys,
i have example function :
CREATE OR REPLACE FUNCTION totalRecords ()
RETURNS integer AS $total$
declare
total integer;
BEGIN
SELECT count(*) into total FROM COMPANY;
RETURN total;
END;
$total$ LANGUAGE plpgsql;
and i want to run it from VBA using odbc connection.
What is the best
Thank you Rob,
question is it is the optimal way to run SP from VBA?
Or not?
Best,
Jacek
2018-06-19 1:34 GMT+02:00 Rob Sargent :
>
>
> On Jun 18, 2018, at 9:47 AM, Łukasz Jarych wrote:
>
> Hi Guys,
>
> i have example function :
>
> CREATE OR REPLACE FUNCTION totalR
ent:* Wednesday, June 20, 2018 12:54 AM
> *To:* Łukasz Jarych
> *Cc:* pgsql-gene...@postgresql.org
> *Subject:* Re: Run Stored procedure - function from VBA
>
>
>
>
> On 06/18/2018 09:51 PM, Łukasz Jarych wrote:
>
> Thank you Rob,
>
> question is it is the optimal
Thank you Rob,
I googled it and there a loit about ODBC but not a lot about ODBC and
postgresql.
Best,
Jacek
2018-06-20 7:41 GMT+02:00 Rob Sargent :
> Sorry. I don’t use ODBC directly. If it’s not obvious in the manual,
> google ‘ODBC functions’
>
> On Jun 19, 2018, at 10:39 PM, Ł
Hi,
i am using windows server 2012 and connecting from Access FE to Postgresql
using DSN connection.
When i am using "select current_user;" in postgresql i have always user
"postgres" because it is my default user for database.
How to know in postgresql which specific windows user is using datab
:
> On Wednesday, June 20, 2018, Łukasz Jarych wrote:
>>
>> How to know in postgresql which specific windows user is using database?
>>
>
> You cannot. All the server knows is the specific user credentials it is
> authenticating.
>
> That said you can authenticat
1 0:11 GMT+02:00 Adrian Klaver :
> On 06/20/2018 07:06 AM, Łukasz Jarych wrote:
>
>> David G,
>>
>> thank you.
>> Can you confirm if i am thinking correctly ?
>>
>> So I can set up authetification to know which user is logged on and use
>> this as p
Best,
Luke
2018-06-21 6:15 GMT+02:00 Łukasz Jarych :
> Thank you Adrian,
>
> In the meantime just an idea, but could you capture the system user in a
>> table in Access and use that to pass on to Postgres?
>
>
> Brilliant ! simple and genious!
>
> The purpose of it i
Hi Guys,
the best option here i think is to:
1. Create users login in Access
2. Use DSN-less odbc connection.
3. When user is login to Access i am taking password and using it in
postgresql BE.
Best,
Luke
2018-06-21 9:17 GMT+02:00 Łukasz Jarych :
> Hmm one problem.
>
> How to disti
ver :
> On 06/21/2018 01:33 AM, Łukasz Jarych wrote:
>
>> Hi Guys,
>>
>> the best option here i think is to:
>>
>> 1. Create users login in Access
>> 2. Use DSN-less odbc connection.
>> 3. When user is login to Access i am taking password and usin
Hi Guys,
I want to create copies of tables in postgresql to use them by each user in
coherent way,
So version 1 will be schema1, version 2 will be schema2 (with copies of
tables from version 1).
How to perfom it ?
Using pg dump and creating new schemas (or databases is a better idea)?
Or it is
Hi Guys,
I am using code :
Sub copyingSchemas()
> Dim dbCon As Object
> Dim rst As Object
> Dim username, pass, strConnect As String
> username = Environ("username")
> pass = "PasswordAccess"
> Set dbCon = CreateObject("ADODB.Connection")
> Set rst = CreateObject("ADODB.Recordset")
> '''You can u
Maybe some security here?
Best,
Jacek
Hi Guys,
I am using code :
Sub copyingSchemas()
> Dim dbCon As Object
> Dim rst As Object
> Dim username, pass, strConnect As String
> username = Environ("username")
> pass = "PasswordAccess"
> Set dbCon = CreateObject("ADODB.Connection")
> Set rst = Creat
:27 AM, Łukasz Jarych wrote:
>
>> Maybe some security here?
>>
>
> 32/64 bit mismatch?
>
> Do you have both the 32 and 64 bit versions of the ODBC driver installed?
>
> Is your application calling the correct version?
>
>
>> Best,
>> Jacek
&
Hi,
i am trying to use postgresql clone schema function:
https://www.postgresql.org/message-id/CANu8FiwiBiAjYgdehYBkJcSRFd6ZFFnN5kDJE7TG4rad5BNXZQ%40mail.gmail.com
I created function clone_schema in public schema:
[image: image.png]
I am trying to use :
"select * from clone_schema('public','
check if the table "audit_sq" has the column "max_value"?
>
> On Jul 2, 2018, at 7:30 AM, Łukasz Jarych wrote:
>
> Hi,
>
> i am trying to use postgresql clone schema function:
>
>
> https://www.postgresql.org/message-id/CANu8FiwiBiAjYgdehYBkJcSR
Hi,
"
Strange. "audit_sq" looks like an invalid sequence table. I went here,
https://www.postgresql.org/docs/9.6/static/sql-createsequence.html, and
checked all the way back to version 7.1 and "maxvalue" has been a column
since back then.
Maybe skip that table for now? It even says the last value
Hi,
i see. thank you
I am using:
[image: image.png]
Best,
Jacek
pon., 2 lip 2018 o 16:03 Adrian Klaver
napisał(a):
> On 07/02/2018 06:57 AM, Łukasz Jarych wrote:
> > Hi,
> >
> > "
> > Strange. "audit_sq" looks like an invalid sequence table. I wen
gt;
>
> On Mon, Jul 2, 2018 at 10:14 AM, Łukasz Jarych wrote:
>
>>
>> Hi,
>>
>> i see. thank you
>>
>> I am using:
>>
>> [image: image.png]
>>
>> Best,
>> Jacek
>>
>> pon., 2 lip 2018 o 16:03 Adrian Klaver
&g
Hi Guys,
it is possible to use pgadmin 4 to run pgdump from query tool?
It is very imporant to me because i am running queries from Access FE using
ODBC connection.
Please help,
Jacek
Hi,
i tried today to log into psotgresql channel on inc but i can not:
[14:12] Copyright (C) 2008-2014 Chris Porter and the qwebirc project.
> [14:12] http://www.qwebirc.org
> [14:12] Licensed under the GNU General Public License, Version 2.
> [14:12] == Connecting to server, please wait...
> [14
Thank you Adrian ,
Best,
Jacek
wt., 3 lip 2018 o 15:23 Adrian Klaver
napisał(a):
> On 07/03/2018 04:44 AM, Łukasz Jarych wrote:
> > Hi Guys,
> >
> > it is possible to use pgadmin 4 to run pgdump from query tool?
>
> pg_dump is a client program in pgAdmin4 you can
Hi,
thank you, working now.
wt., 3 lip 2018 o 15:27 Adrian Klaver
napisał(a):
> On 07/03/2018 05:13 AM, Łukasz Jarych wrote:
> > Hi,
> >
> > i tried today to log into psotgresql channel on inc but i can not:
> >
> > [14:12]Copyright (C) 2008-2014 Chr
Hi Melvin,
thank you very much. Awesome!!!
Best,
Jacek
wt., 3 lip 2018 o 15:34 Melvin Davidson napisał(a):
>
>
>
>> ERROR: BŁĄD: you cannot add to column "TopoToVersion_ID" DETAIL: Column
>> "TopoToVersion_ID" is an identity column defined as GENERATED ALWAYS. HINT:
>> Use OVERRIDING SYSTEM V
Hi Melvin.
folks wrote only that it is old version and didnt care :)
Tahnk you very much,
Best,
Jacek
czw., 5 lip 2018 o 01:09 Melvin Davidson napisał(a):
>
> >The folks that wanted transactional ALTER SEQUENCE might disagree:):
> Ah, so you mean the previous version was not working or suffici
>From link function is not working.
czw., 5 lip 2018 o 07:49 Łukasz Jarych napisał(a):
> Hi Melvin.
>
> folks wrote only that it is old version and didnt care :)
>
> Tahnk you very much,
> Best,
> Jacek
>
> czw., 5 lip 2018 o 01:09 Melvin Davidson
> napisał(a
You gave me working example.
the function from here is not working:
https://www.postgresql.org/message-id/CANu8FiyJtt-0q%3DbkUxyra66tHi6FFzgU8TqVR2aahseCBDDntA%40mail.gmail.com
Best,
Jacek
czw., 5 lip 2018 o 16:02 Melvin Davidson napisał(a):
>
>
> On Thu, Jul 5, 2018 at 1:49 A
Melvin,
thank you once again ! Yes and this is working like a charm,
I love your function and file !
Best,
Jacek
czw., 5 lip 2018 o 16:53 Melvin Davidson napisał(a):
>
>
>
> On Thu, Jul 5, 2018 at 10:38 AM, Łukasz Jarych wrote:
>
>> You gave me working example.
>>
Hi Melvin,
i am trying to run postgresql 10 cloning schema function but still i am
getting error...
[image: image.png]
Error: Error in syntax near "SYSTEM"
Context: Function PL/pgSQL, row 212 in EXECUTE
What is happening?
Best,
Jacek
sob., 7 lip 2018 o 22:20 Melvin Davidson napisał(a):
>
>
Hi,
i have small database and i am tracking changes using trigger:
CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig
FOR EACH ROW EXECUTE PROCEDURE change_trigger();
It is possible to create general trigger for all tables?
Like event trigger?
It would be very helpful for me.
Hi Guys,
i am using sqls like below to track ddl changes:
CREATE TABLE track_ddl
> (
> event text,
> command text,
> ddl_time timestamptz,
> usr text
> );
> CREATE OR REPLACE FUNCTION track_ddl_function()
> RETURNS event_trigger
> AS
> $$
> BEGIN
> INSERT INTO track_ddl values(tg_tag, t
It is no possible?
Jacek
pon., 9 lip 2018 o 13:38 Łukasz Jarych napisał(a):
> Hi Guys,
>
> i am using sqls like below to track ddl changes:
>
> CREATE TABLE track_ddl
>> (
>> event text,
>> command text,
>> ddl_time timestamptz,
>>
No possible?
Jacek
pon., 9 lip 2018 o 13:03 Łukasz Jarych napisał(a):
> Hi,
>
> i have small database and i am tracking changes using trigger:
>
> CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig
>
> FOR EACH ROW EXECUTE PROCEDURE change_trigger();
Thank you very much Guillaume.
Do you know maybe any function to do it automatically?
Best,
Jacek
wt., 10 lip 2018 o 11:25 Guillaume Lelarge
napisał(a):
> 2018-07-10 10:56 GMT+02:00 Łukasz Jarych :
>
>> No possible?
>>
>>
> Nope, you need to set up the trigg
Maybe yes,
but for me when i am learning it is not...
Best,
Jacek
wt., 10 lip 2018 o 11:29 Guillaume Lelarge
napisał(a):
> 2018-07-10 11:28 GMT+02:00 Łukasz Jarych :
>
>> Thank you very much Guillaume.
>>
>> Do you know maybe any function to do it automatically?
>
Hi Guys,
Yesterday i tried all day to figure out system to read only schemas.
I want to :
1. Create user who can login (user: jaryszek)
2. Create role who can read only data (only watching tables) (role:
readonly)
3, Create role who can read all data (inserting, deleting, altering,
dropping) (ro
hi,
i am trying to alter table :
ALTER TABLE logging.t_history
alter column "id" GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
but this is not working. Error i have.
How to change this properly?
Best,
Jacek
Hi,
thank you.
I think that i have to add sequance here...
Best,
Jacek
pt., 13 lip 2018 o 09:50 Guillaume Lelarge
napisał(a):
> Hi,
>
> 2018-07-13 9:29 GMT+02:00 Łukasz Jarych :
>
>> hi,
>>
>> i am trying to alter table :
>>
>> ALTER TABLE logging
Sorry,
my error.
pt., 13 lip 2018 o 09:52 Łukasz Jarych napisał(a):
> Hi,
>
> thank you.
> I think that i have to add sequance here...
>
> Best,
> Jacek
>
> pt., 13 lip 2018 o 09:50 Guillaume Lelarge
> napisał(a):
>
>> Hi,
>>
>> 2018-07-13
Hi Guys,
i created boolean in postgresql table (in attachment) but linked table in
Access see this as short text.
I checked in odbc option Bools as Char to false and True is -1 as true.but
still tihs is not working.
I found linke here:
http://bahut.alma.ch/2006/04/access-odbc-postgresql-boolean
Hi Guys,
sorry for my late answer. I tested this today and working like a charm!
You are brilliant ! thank you, saved my ass!
Best,
Jacek
śr., 11 lip 2018 o 10:30 Ken Tanzer napisał(a):
>
>
> On Tue, Jul 10, 2018 at 5:45 PM Adrian Klaver
> wrote:
>
>> select add_trigger('trg_test');
>>
>> te
Maybe read-only view?
Best,
Jacek
pt., 13 lip 2018 o 07:00 Łukasz Jarych napisał(a):
> Hi Guys,
>
> Yesterday i tried all day to figure out system to read only schemas.
>
> I want to :
>
> 1. Create user who can login (user: jaryszek)
> 2. Create role who can read
Hmm so maybe better is use text field here
Best,
Jacek
pt., 13 lip 2018 o 15:36 Adrian Klaver
napisał(a):
> On 07/13/2018 02:19 AM, Łukasz Jarych wrote:
> > Hi Guys,
> >
> > i created boolean in postgresql table (in attachment) but linked table
> > in Ac
access? I mean give him access
to all functionalities like inserting, deleting, creating tables and staff
like this.
I mean i want to assign user "jaryszek" to this read_only role and after
changing schema i want to give user "jaryszek" all credentials.
Best,
Jacek
and delete? All ddl and dml
commands?
Or should i use GRANT ALL ON SCHEMA PUBLIC TO jaryszek ?
Best,
Jacek
sob., 14 lip 2018 o 08:23 Charles Clavadetscher
napisał(a):
> Hello
>
>
>
> *From:* Łukasz Jarych [mailto:jarys...@gmail.com]
> *Sent:* Freitag, 13. Juli 2018 16:39
nd how to delete User - drop role "Luke" is saying that there are
dependiences for this user...
Please help,
Jacek
sob., 14 lip 2018 o 12:31 Charles Clavadetscher
napisał(a):
> Hello Jacek
>
>
>
> *From:* Łukasz Jarych [mailto:jarys...@gmail.com]
> *Sent
Thank you Charles once again !
And best wishes,
Jacek
sob., 28 lip 2018 o 15:58 Charles Clavadetscher
napisał(a):
> Hello Jakek
>
>
>
> *From:* Łukasz Jarych [mailto:jarys...@gmail.com]
> *Sent:* Samstag, 28. Juli 2018 14:13
> *To:* Melvin Davidson ; pgsql-gene...@p
Hi,
i think that this is not possible to avoid installing driver.
pon., 27 sie 2018 o 09:55 Paul Suworow napisał(a):
> Hi team,
>
> I am working on an Excel tool that should allow users to update tables and
> charts from a PostgreSQL database. My workbook currently connects to the
> database us
Hi Guys,
i would like to ask you for help with track changes to my database.
I am new to PosgtreeSQL but i have to learn it quickly because of my boss.
I have to:
1. Keep all changes within table including:
-adding rows
-deleting
-editing
2. Save table with specific state and recover specific s
-change-scripts.aspx
Best,
Jacek
2018-02-26 12:16 GMT+01:00 Łukasz Jarych :
> Hi Manual,
> thank you very much!
>
> Regarding your tool - if it is not supported and it is for specific case
> - i will not use it but figure out something new. I do not even how to
> install this
80 matches
Mail list logo