Re: [pgadmin-support] So... you're all just going to ignore anyone who asks about the HUGE issues with pgAdmin 4?

On Thu, Jun 15, 2017 at 10:05 AM, wrote: > It doesn't seem possible to get through to you. Whatever you spent those > one million dollars on, it sure as hell wasn't related to pgAdmin in any > way. More like very heavy drugs, if you think this is even acceptable for > pre-pre-pre-alpha software.

Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'

On Monday, May 22, 2017, Melvin Davidson wrote: > *>Unless you omit the E prefix on the string literal, which the OP did.* > > > *Nope! That results in 'a//b' but the op wants 'a/b';* > *Hence the need to Escape.* > PgAdmin is buggy if it doesn't know that there is no output difference between E

Re: [pgadmin-support] SQL syntax highlightning don't work for single backslash '\'

On Monday, May 22, 2017, Melvin Davidson wrote: > *>When I have somewhere in text value single backslash char, then > everything behind this char will not be highlighted correct.* > > * > * > *That is becau

Re: [pgadmin-support] Removing pg_trgm Extension - Upgraded from 9.1 to 9.5

On Fri, Jan 6, 2017 at 12:40 PM, Chuck Reed wrote: > Hi everyone, > > > > We have recently upgraded from postgres 9.1 to 9.5. When we create a > database dump from 9.5 and attempt to restore it on another 9.5 server, we > are running into the following warnings retarding the pg_trgm extension: >

Re: [pgadmin-support] Fwd: Returned mail: see transcript for details

You are missing a "g" in "postgresql.org" On Friday, August 19, 2016, Tom Kincaid wrote: > > Final-Recipient: RFC822; pgadmin-hackers-requ...@postresql.org > > > David J.

Re: [pgadmin-support] Please add the ability to add columns into the middle of a table.

On Fri, May 6, 2016 at 1:59 PM, Patrick Headley wrote: > > Please reconsider your original reply. > ​My personal opinion is not the issue here. Even if I wanted to I lack the skill set to make this happen. David J. ​

Re: [pgadmin-support] Please add the ability to add columns into the middle of a table.

On Fri, May 6, 2016 at 12:53 PM, Patrick Headley wrote: > I would like it if pgAdmin could generate the script to insert table > columns into the middle of an existing table. This is something that is > available in the SQL Server Management Studio, which uses essentially the > same steps that I

Re: [pgadmin-support] Please add the ability to add columns into the middle of a table.

On Fri, May 6, 2016 at 12:18 PM, Patrick Headley wrote: > Having the ability to insert a column in the middle of a table using the > PGAdmin 3 UI would be very nice. Benefits include grouping related fields > and creating a column list in the natural flow of data entry. Having it > automated with

Re: [pgadmin-support] What does "+01" mean in a timestamp field

On Thursday, May 28, 2015, Daniel Grace wrote: > What does "+01" mean in a timestamp field, for example: > "2015-06-28 22:00:00+01" > > I am assuming it is timezone information. > Correct. 1 hour ahead of GMT David J.

Re: [pgadmin-support] How can I test a function in the SQL window?

On Thu, Apr 2, 2015 at 10:02 AM, Rob Richardson wrote: > Hello! > > > > I suddenly find myself stumped. A co-worker gave me a function to use in > my database, but it doesn’t seem to be doing anything. So, I wanted to run > it from PGAdmin’s SQL window. But I can’t call it. When I try > > >

Re: [pgadmin-support] pg_proc?

Guillaume Lelarge-3 wrote > Hi, > > Le 8 déc. 2014 20:53, "Wim Bertels" < > wim.bertels@ > > a écrit : >> >> Hallo, >> >> pg_admin needs access to pg_proc of a database to work, >> it fails without having this access, (wanting to read out the metadata) >> while eg psql succeeds >> >> use case: >

Re: [pgadmin-support] New line for stored procedure parameters?

inspector morse wrote > I have a stored procedure with several input/output parameters (about 50 > of > them). Everytime I go to edit the stored procedure in pgAdmin3, it prints > all of the parameters in the same line...even if I last saved it with new > lines. This makes it really difficult to se

[pgadmin-support] Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

> > > ​I​ > f all the letters are lowercase, no double quotes are added. > ​I don't know if this statement is actually true but it makes no difference in reality whether the double-quotes are added in the case where only lowercase letters and numbers/underscore are used. As far the executor is co

[pgadmin-support] Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

RobR wrote > I then concluded that the table was being created with the double quotes > included in the table name. In short: log = "log" Log = "log" Log = log LoG = lOg Log <> "Log" Again, this is all just parser stuff. Whatever is present post-parse on a create table is stored, as-is, in the

[pgadmin-support] Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

RobR wrote > I selected the database in PGAdmin, went down to the Tables list (which > said I had 0 table), right clicked on the word "Tables", and selected "New > table". In the new table dialog I entered the table name as Log (no > quotes) Enter the table name in lower-case. If you cannot surr

Re: [pgadmin-support] Regarding Custom reports using pgadmin

soobia.arshad wrote > I have linked my postgresql database with pgadmin3 and now i want to > create > reports using data in my tables. How can i do this in pgadmin3? Moreover, > is there any other supporting tool to generate reports from the data > already imported in pgadmin3? pgadmin3 is a query

[pgadmin-support] Re: Use of uninitialized value $info{"pgdata"} in concatenation (.) or string at /usr/bin/pg_ctlcluster

espeake wrote > at /usr/bin/pg_ctlcluster This is a Debian/Ubuntu supplied script; not PostgreSQL core. The main packaging site is located here: http://wiki.postgresql.org/wiki/Apt and includes contact links/references. David J. -- View this message in context: http://postgresql.1045698.