Re: Connection to PostgreSQL from Excel

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

Re: Read only to schema

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

Re: Read only to schema

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

Re: Read only to schema

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

Re: Read only to schema

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 pt., 13

Re: Handlind booleans Postgresql-Access

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

Re: Read only to schema

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

Re: Create event triger

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'); >> >>

Handlind booleans Postgresql-Access

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:

Re: Using always genereted

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

Using always genereted

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

Re: Create event triger

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? >

Re: Create event triger

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

Re: Create event triger

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(

Re: Create DDL trigger to catch which column was altered

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, >>

Create DDL trigger to catch which column was altered

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,

Create event triger

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

Re: Cloning schemas

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): >

Re: Cloning schemas

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

Re: Cloning schemas

>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

Re: Cloning schemas

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

Re: Cloning schemas

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

Re: Using pg Admin to create backups and restore them

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

problem wirh irc ffreenode

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

Using pg Admin to create backups and restore them

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

Re: Cloning schemas

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

Re: Cloning schemas

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

Re: Cloning schemas

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

Re: Cloning schemas

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

Re: Fwd: problem with using VBA connection string to postgresql

: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 &

problem with using VBA connection string to postgresql

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

Copies or tables in schema or copiyng of database - database versioning

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

Re: Using DSN Connection and knowing windows username

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 u

Re: Using DSN Connection and knowing windows username

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

Re: Using DSN Connection and knowing windows username

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

Re: Using DSN Connection and knowing windows username

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

Re: Using DSN Connection and knowing windows username

: > 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

Using DSN Connection and knowing windows username

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

Re: Run Stored procedure - function from VBA

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, Ł

Re: Run Stored procedure - function from VBA

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

Re: Run Stored procedure - function from VBA

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

Run Stored procedure - function from VBA

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

Re: Using GIT to caught delta between database versions

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

Re: Using GIT to caught delta between database versions

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

Using GIT to caught delta between database versions

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

Re: VBA to connect to postgresql from MS Access

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

VBA to connect to postgresql from MS Access

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:

Fwd: Tracking DDL and DML changes in Postgresql and different versions of database (advance)

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

Tracking DDL and DML changes in Postgresql and different versions of database (advance)

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

Re: Function to set up variable inside it

M To: Łukasz Jarych Cc: Adrian Klaver; pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: Function to set up variable inside it Hi 2018-05-16 6:52 GMT+02:00 Łukasz Jarych <jarys...@gmail.com<mailto:jarys...@gmail.com>>: Hi Guys, thank you for your help ! H

Re: Function to set up variable inside it

; $$ LANGUAGE 'plpgsql' SECURITY DEFINER; Best, Jacek 2018-05-15 14:58 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com>: > 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 v

Function to set up variable inside it

Hi Guys, I am using postgres 10.3 (or 4?). IT is possible to set up variable inside function? Best, Jacek

Re: Trigger to create string to inverse SQL statement

maybe somebody wrote SP to invert update statement? Best, Jacek 2018-03-08 13:51 GMT+01:00 Łukasz Jarych <jarys...@gmail.com>: > thank you, > > what do you mean use external program to build inverted queries. Do you > have any examples? > > Best, > Jacek > > 201

Re: Trigger to create string to inverse SQL statement

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 <fola...@peoplecall.com>: > Hello: > > On Thu, Mar 8, 2018 at 1:32 PM, Łukasz Jarych <jarys...@gmail.com> wro

Re: Command to execute SQL string

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 <fola...@peoplecall.com>: > Hello: > > > > On Thu, Mar 8, 2018 at 1:26 PM,

Trigger to create string to inverse SQL statement

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

Command to execute SQL string

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

Re: save query as sql file

thanks you! Jacek 2018-03-07 15:00 GMT+01:00 Melvin Davidson <melvin6...@gmail.com>: > > > On Wed, Mar 7, 2018 at 8:46 AM, Łukasz Jarych <jarys...@gmail.com> wrote: > >> thank you ! >> >> Jacek >> >> 2018-03-07 14:45 GMT+01:00 Adrian Klave

Re: save query as sql file

thank you ! Jacek 2018-03-07 14:45 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: > 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

save query as sql file

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

Re: What is wrong with my pgadmin?

I am using: I am using: thank you for help, Jacek 2018-03-05 15:22 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 03/05/2018 06:05 AM, Łukasz Jarych wrote: > >> Hi Guys, >> >> what is wrong with my pgAdmin? >> >> I am creati

Re: What is wrong with my pgadmin?

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 <ge...@rxmg.com>: > What result were you expecting? A divide by zero error? > > > > On Mar 5, 2018, at 07:05, Łukasz Jarych <jarys...@gmail.com

Re: What is wrong with my pgadmin?

Hi, yes, using psql there is an error. Jacek 2018-03-05 15:22 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 03/05/2018 06:05 AM, Łukasz Jarych wrote: > >> Hi Guys, >> >> what is wrong with my pgAdmin? >> >> I am creating wrong query: &

Re: Requiring pass and database psql shell command

t; > On March 5, 2018 7:55:46 AM EST, "Łukasz Jarych" <jarys...@gmail.com> > 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

Requiring pass and database psql shell command

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

Tracking changes DML in history log table

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

Flyway and postgree multiple developers

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

Re: Creating complex track changes database - challenge!

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

Re: Creating complex track changes database - challenge!

/24772591/check-if-git-has-changes- > programmatically > > > > On Feb 26, 2018, at 9:36 AM, Łukasz Jarych <jarys...@gmail.com> wrote: > > Thank you geoff! > > I think that i will test http://www.liquibase.org/ this one. > > what about setting up trigger to metadata (struc

Re: Creating complex track changes database - challenge!

://flywaydb.org/ > 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 Jar

Re: Creating complex track changes database - challenge!

-change-scripts.aspx Best, Jacek 2018-02-26 12:16 GMT+01:00 Łukasz Jarych <jarys...@gmail.com>: > 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

Creating complex track changes database - challenge!

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