Re: [GENERAL] grep -f keyword data query

On Dec 28, 2015 00:55, "Hiroyuki Sato" wrote: > > Hello Andreas and Tom > > Thank you for replying. > > Sorry, I re-created my questions. I was mis-pasted query log on previous question. > (@~ operator is PGroonga extension (http://pgroonga.github.io)) > Please ignore it. > > Best regards. > > 1,

Re: [GENERAL] Regex "embedded options" does only work on the whole pattern?

matshyeq writes: > I can see postgresql claims to supports regular expression flags: Yup. > What I find don't makes sense to me is that those flags could be used to > switch on/off match feature locally as opposed to the whole regex (same as > though flags parameters of regex functions). Not al

Re: [GENERAL] PostgreSQL GUI tools

On Sun, Jan 3, 2016 at 2:15 AM, subhan alimy wrote: > Is there any PostgreSQL GUI tools to pull the tables structure along with > the relationships? > Along with the other suggestions, I have personally used http://www.dbschema.com/. It works well, but I don't recall if there was a free version.

Re: [GENERAL] PostgreSQL GUI tools

On 01/03/2016 02:15 AM, subhan alimy wrote: Hello everyone, Is there any PostgreSQL GUI tools to pull the tables structure along with the relationships? A simple Google will show you that there are literally dozens. Much appropriated. -- View this message in context: http://postgresql.

Re: [GENERAL] Regex "embedded options" does only work on the whole pattern?

On Sun, Jan 3, 2016 at 8:49 AM, matshyeq wrote: > Does that mean these "EMBEDDED OPTIONS" can be only defined at the > beginning of the pattern and therefore don't offer anything extra over *flags > *option? > ​Yes, this is how they behave. The most important difference is that: column ~ 'rege

Re: [GENERAL] PostgreSQL GUI tools

Here is the list of tools: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools#pgEdit On Sun, Jan 3, 2016 at 3:45 PM, subhan alimy wrote: > Hello everyone, > > Is there any PostgreSQL GUI tools to pull the tables structure along with > the relationships? > > > Much appropri

[GENERAL] Regex "embedded options" does only work on the whole pattern?

Hi, I can see postgresql claims to supports regular expression flags: http://www.postgresql.org/docs/current/static/functions-matching.html#POSIX-EMBEDDED-OPTIONS-TABLE which I suppose aims to be the equivalent of perl's *(?adluimsx-imsx:pattern)

[GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't seem to help. -bash-4.1$ /usr/pgsql-9.4/bin/pg_u

[GENERAL] PostgreSQL GUI tools

Hello everyone, Is there any PostgreSQL GUI tools to pull the tables structure along with the relationships? Much appropriated. -- View this message in context: http://postgresql.nabble.com/PostgreSQL-GUI-tools-tp5879926.html Sent from the PostgreSQL - general mailing list archive at Nabbl

[GENERAL] 2 tuples to same chunk in toast table

Hi 4 all! In upgrade from PostgresSQL 9.2 to 9.3.10 using pg_upgrade the disks space ends and upgrade fail... After run upgrade again the process ends, resulting in one TOAST with two lines for same chunk (chunk_id and chunk_seq)unique-key... Someone have suggestion to solve this problem??? -- T

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

On 1/3/2016 1:32 PM, Melvin Davidson wrote: As others have pointed out, storing session data in a table is not a good idea. Even if you use TRUNCATE, you will still not reclaim all the space used unless you use vacuum full. More to the point, if you absolutely must store session data, then why

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

On 01/03/2016 01:32 PM, Melvin Davidson wrote: As others have pointed out, storing session data in a table is not a good idea. Even if you use TRUNCATE, you will still not reclaim all the space used unless you use vacuum full. More to the point, if you Actually: http://www.postgresql.org/docs/

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

e is pseudocode for the *supervisoty process* (use a wide viewing >> window to avoid line wrap): >> >> >> *Supervisory Process* --- >>Change operational state of table sql_table_01 >>

Re: [GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

On 01/03/2016 12:03 AM, Arthur Pemberton wrote: I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't

Re: [GENERAL] Question -- Session Operations - Feasibility Of Proposed Synchronization Method?

>| ... (change operational state of table sql_table_01 > | ... >| ... e.g. *TRUNCATE ONLY TABLE sql_table_01;*) >| ... >| >| /* >| Advance sequence >| > *sql_sequence_01* |to indicate that the operationa

Re: [GENERAL] tsrange format

On 01/03/2016 11:40 AM, Greg Jaskiewicz wrote: Hi, Is it easily possible to supply and receive tsrange types in epoch values, or is it really all down always to string parsing? AFAIK, not without resorting to a using some mishmash of EXTRACT, to_date() and casting. As a general rule, I pa

[GENERAL] tsrange format

Hi, Is it easily possible to supply and receive tsrange types in epoch values, or is it really all down always to string parsing? As a general rule, I pass time in the app in epoch-float values, which is then converted by the presenter/controller layer to the right format used by views, wheth

Re: [GENERAL] How do I implement a .XSD in Postgres?

On Sat, 2016-01-02 at 00:20 +, ERR ORR wrote: > I need to import some DB schemas which are defined in .XSD (a XML > derivative) format. > I've googled about this but have found no satisfactory answer. Perhaps > I > just don't know what exactly to ask Google. > > So please: > - What tool can I

Re: [GENERAL] Happy New Year

Happy New Year to all! On Fri, Jan 1, 2016 at 10:35 PM, Dorian Hoxha wrote: > Happy Holidays! > > Let's have automatic sharding and distributed transactions! > > On Fri, Jan 1, 2016 at 3:51 PM, Melvin Davidson > wrote: > >> Happy New Year to all! >> >> On Fri, Jan 1, 2016 at 2:40 AM, Michael Pa

[GENERAL] Cannot upgrade from 9.3 to 9.4 using pg_upgrade

I'm trying to use pg_upgrade to upgrade from 9.3 to 9.4 on CentOS 6 with packages from Postgres' yum repo. I've revered to vanlla ph_hda.conf on 9.3, and ran initdb on 9.4. I don't get very far however, I get the following error, and Google doesn't seem to help. -bash-4.1$ /usr/pgsql-9.4/bin/pg_u