my point is that maybe the hint is not entirely correct..
Could be, it is a hint not a requirement. Have you tried unsetting the
LC_ALL variable in xcode?
--
Adrian Klaver
adrian.kla...@aklaver.com
h_path TO "$user", public;
drop role sp_test ;
psql -d test -U postgres -f sp_test.sql
\du
sp_test| Cannot login
| {}
\drds
List of settings
Role | Database | Settings
-+--+-----
sp_test |
) How are the subscriptions set up?
4) Are the virtual machines on continuously?
Thanks a lot!
--
xOCh
--
PAranoids Group
218
--
Adrian Klaver
adrian.kla...@aklaver.com
On 07/30/2018 12:40 AM, vardenis pavardenis wrote:
hello.
thats interesting.
maybe you have clue why it happened (i tried install by instructions)
and how to fix it? :)
Purge the existing packages and try installing again.
thanks
HTH,
Robert
--
Adrian Klaver
adrian.kla
:
https://www.postgresql.org/download/linux/ubuntu/
only the LTS versions are officially supported. You might want to try
installing the 16.04 version on the theory it is more likely to be
backwards compatible then the 14.04 being forward compatible.
thanks
HTH,
Robert
--
Adrian
On 07/30/2018 10:33 AM, vardenis pavardenis wrote:
2018-07-30 16:51 GMT+03:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
On 07/30/2018 12:40 AM, vardenis pavardenis wrote:
hello.
thats interesting.
maybe you have clue why it happened (i tried i
until it is validated by using the
VALIDATE CONSTRAINT option.
"
TABLE page. Should it not also appear in the ALTER TABLE page?
--
Adrian Klaver
adrian.kla...@aklaver.com
tps://www.postgresql.org/message-id/flat/b1a24c6c-6913-f89c-674e-0704f0ed6...@2ndquadrant.com
--
*Melvin Davidson**
Maj. Database & Exploration Specialist**
Universe Exploration Command – UXC***
Employment by invitation only!
--
Adrian Klaver
adrian.kla...@aklaver.com
On 07/30/2018 02:24 PM, Rob Sargent wrote:
On 07/30/2018 03:07 PM, Adrian Klaver wrote:
On 07/30/2018 09:57 AM, Rob Sargent wrote:
I was just looking up alter table add constraint syntax under
"current(10)" and we get
ADD /table_constraint/ [ NOT VALID ]
e the view from the original definition:
CREATE VIEW test_tmp AS (SELECT 1 FROM l_payment_form WHERE
payment_form_code IN ('CREDIT_CARD','OTHER'));
Thanks!
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
/http://agency-software.org//
/https://demo.agency-software.org/client/
ken.tan...@agency-software.org <mailto:ken.tan...@agency-software.org>
(253) 245-3801
Subscribe to the mailing list
<mailto:agency-general-requ...@lists.sourceforge.net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
--
Adrian Klaver
adrian.kla...@aklaver.com
price everybody is paying.
*
*Random atavistic things? I hardly think relhaspkey is random. It's been
there since version 7.2.*
*Exactly how does keeping it around slow you/us down?
*
--
*Melvin Davidson**
Maj. Database & Exploration Specialist**
Universe Exploration Command – UXC***
Employment by invitation only!
--
Adrian Klaver
adrian.kla...@aklaver.com
separate and repeat
them? Also when asking for input on query planning/outcomes running
EXPLAIN ANALYZE on the queries and posting the results here will help
arrive at answer.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 07/30/2018 04:29 PM, Ken Tanzer wrote:
On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver
Thanks Adrian. I do have what are supposed to be the original view
definitions, but I'm less than 100% confident they are accurate and
up-to-date, which is why I thought to use the actual definitio
On 07/30/2018 04:57 PM, Ken Tanzer wrote:
On Mon, Jul 30, 2018 at 4:52 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 07/30/2018 04:29 PM, Ken Tanzer wrote:
> On Mon, Jul 30, 2018 at 4:10 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>
>
On 07/31/2018 06:12 AM, vardenis pavardenis wrote:
2018-07-31 0:02 GMT+03:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
On 07/30/2018 10:33 AM, vardenis pavardenis wrote:
2018-07-30 16:51 GMT+03:00 Adrian Klaver
mailto:adrian.kla...@ak
-09-01,2018-09-30] '::daterange
If data_sub_periods are actually sub periods of period then you should
need only search for the period [2018-09-01,2018-09-30] and join
data_periods_info to period on period.id =
data_periods_info.data_periods_id.
--
Adrian Klaver
adrian.kla...@aklaver.com
you are right. This old Viet Vet shall now end this conversation
and his career.
I just need a way to do so quietly and painlessly.
The truth is absolute and cannot be changed.
Perception is not the truth.
Flerp!*
*
*
**--
*Melvin Davidson**
Maj. Database & Exploration Specialist**
Universe Expl
On 07/31/2018 01:42 PM, Johnes Castro wrote:
Hi
is there any way to do pg_basebackup without copying the logs?
Are you talking about the transaction logs(WAL) or the logging messages?
Best Regards,
Johnes Castro
Tecnisys
--
Adrian Klaver
adrian.kla...@aklaver.com
On 07/31/2018 01:59 PM, Johnes Castro wrote:
Please reply to list also.
Ccing list.
logging messages.
Not that I know of.
*De:* Adrian Klaver
*Enviado:* terça-feira, 31 de julho de 2018 18:57
*Para:* Johnes Castro
On 07/31/2018 02:04 PM, Johnes Castro wrote:
logging messages.
I've noticed that in version 10, you have the -X none option.
That refers to the transaction(WAL) logs.
*De:* Adrian Klaver
*Enviado:* terça-feir
you referring to?
Thank you
--
Adrian Klaver
adrian.kla...@aklaver.com
tic/app-psql.html#APP-PSQL-PROMPTING
<https://www.postgresql.org/docs/devel/static/app-psql.html#APP-PSQL-PROMPTING>
although it's just talking about a color change.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
are PG 9.6.8 and 9.6.9 - Are there maintained only
latest 2 build releases?
plv8 - there are versions 2.0.0-1 and 2.1.0, since latest plv8 are
already 2.3.7 and latest for 2.1.X is 2.1.3 contating major fixes
Thanks,
AlexL
--
Adrian Klaver
adrian.kla...@aklaver.com
ry which can list all users who have access to a
> particular schema.
Something involving
SELECT ... FROM pg_user
WHERE has_schema_privilege(usename, 'schema-of-interest', 'usage');
would probably be what you want.
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
would be nice
to have in some scenarios and thus would like it considered. I do not
wish to start a discussion on whether using it is a sound approach or
not as that is a different discussion.
--
Adrian Klaver
adrian.kla...@aklaver.com
little more, this is what I
found:
Happy to provide any additional relevant info, or for someone to point
out what obvious thing I'm overlooking. Thanks in advance!
What is the definition for target_date()?
Ken
--
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/06/2018 04:44 PM, Ken Tanzer wrote:
On Mon, Aug 6, 2018 at 4:36 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
What is the definition for target_date()?
Hi Adrian. Happy to provide this info. Though on a side note, I don't
understand why it sho
ency_project_code='SSP' LIMIT 1))
ELSE
---SPC answer
(SELECT staff_inspector FROM tbl_residence_own ro LEFT JOIN
l_housing_project USING (housing_project_code) WHERE client_id=client
AND asof BETWEEN residence_date AND COALESCE(residence_date_end,asof)
AND NOT ro.is_deleted LIMIT 1)
END
--LIMIT 1
$$ LANGUAGE SQL STABLE;
Cheers,
Ken
--
Adrian Klaver
adrian.kla...@aklaver.com
nothing. If the 2nd is violated some
fields should be updated. And violation of the 3rd one should raise an
error.
Can that be expressed?
Yes as a trigger and associated function.
Thanks,
Torsten
--
Adrian Klaver
adrian.kla...@aklaver.com
at we expected.
* This check typically fails when an old WAL segment is recycled,
* and hasn't yet been overwritten with new data yet.
*/
...
report_invalid_record(state,
"unexpected pageaddr %X/%X in log segment %s,
offset %u",
(uint32) (hdr->xlp_pageaddr >> 32), (uint32) hdr->xlp_pageaddr,
fname,
offset);
"
Thanks,
Phil.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/11/2018 12:42 PM, Phil Endecott wrote:
Hi Adrian,
Adrian Klaver wrote:
Looks like the master recycled the WAL's while the slave could not
connect.
Yes but... why is that a problem? The master is copying the WALs to
the backup server using scp, where they remain forever. The
On 08/12/2018 12:25 PM, Phil Endecott wrote:
Hi Adrian,
Adrian Klaver wrote:
On 08/11/2018 12:42 PM, Phil Endecott wrote:
Hi Adrian,
Adrian Klaver wrote:
Looks like the master recycled the WAL's while the slave could not
connect.
Yes but... why is that a problem? The master is co
ap due to record sizes. But
the slave tries to start streaming from this point, D0FFF088, not D100.
If the master still had a copy of segment D0 then it would be able to stream
this gap followed by the real content in the current segment D1.
Does that make any sense at all?
Regards, Phil.
--
Adrian Klaver
adrian.kla...@aklaver.com
ization then it is anyone's guess on what is appropriate for
wal_keep_segments.
Regards, Phil.
--
Adrian Klaver
adrian.kla...@aklaver.com
ered and
for a fast moving cluster or slow moving one with sufficient downtime
that would not be the case. Better to let the end user know this is not
a simple problem and some thought needs to go into configuration.
--
Adrian Klaver
adrian.kla...@aklaver.com
of a constraint of the table. There is no
effect on the stored data.
"
Thanks
Samuel
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/13/2018 05:39 AM, Stephen Frost wrote:
Greetings,
* Phil Endecott (spam_from_pgsql_li...@chezphil.org) wrote:
Adrian Klaver wrote:
On 08/12/2018 02:56 PM, Phil Endecott wrote:
Anyway. Do others agree that my issue was the result of
wal_keep_segments=0 ?
Only as a sub-issue of the
On 08/13/2018 05:08 AM, Phil Endecott wrote:
Adrian Klaver wrote:
On 08/12/2018 02:56 PM, Phil Endecott wrote:
Anyway. Do others agree that my issue was the result of
wal_keep_segments=0 ?
Only as a sub-issue of the slave losing contact with the master. The
basic problem is maintaining two
g Python and psycopg2.
Any suggestions or modifications are most welcome.
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
.
Thanks in Advance
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
d in why every node dealing with the gifts
table thinks rows=75 when the actual is much, much higher. And 75 seems
like too round of a number to be random?
--
Don Seiler
www.seiler.us <http://www.seiler.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
:21'
AND
lts.date_gifted >= '2017-08-13 11:13:05'
AND
lts.date_gifted < '2017-08-13 14:14:21'
is
lts.date_added > '2017-07-14 11:13:05'
and
lts.date_gifted >= '2017-08-13 11:13:05'
?
In other words one '>' and the other '>=' ?
--
Adrian Klaver
adrian.kla...@aklaver.com
ommand detect the case where it is asked to
write the same file again with the same contents, and report
success in that case?
- Is this a bug?
Thanks,
Phil.
--
Adrian Klaver
adrian.kla...@aklaver.com
ux-gnu, compiled by gcc (SUSE Linux)
4.8.5, 64-bit
lc_collate | en_US.UTF-8
lc_ctype| en_US.UTF-8
test=# select 'abcd'||chr(2006) ~ E'abcd\s';
?column?
--
f
(1 row)
In your example you are working on Postgres devel. Have you tried it on
Postgres 10 and/or 11?
Cheers,
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/16/2018 01:48 AM, Phil Endecott wrote:
Adrian Klaver wrote:
On 08/15/2018 01:25 PM, Phil Endecott wrote:
Dear Experts,
The above is not clear to me. My best guess:
It's not part of the error for the archive command; it's just the
next thing in the log file. Y is (1) tr
# select 'abcd'||chr(8198) ~ E'abcd\s';
?column?
--
f
(1 row)
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/16/2018 07:47 AM, Andreas Joseph Krogh wrote:
På torsdag 16. august 2018 kl. 16:32:40, skrev Adrian Klaver
mailto:adrian.kla...@aklaver.com>>:
On 08/16/2018 07:04 AM, Andreas Joseph Krogh wrote:
> char(2006) produces the wrong character as 2006 is the hex-value. You
On 08/16/2018 08:13 AM, Adrian Klaver wrote:
Wonder if the OP has standard_conforming_strings='off' and
escape_string_warning='off'?
In the above referring to 9.6.9 instance.
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@vis
On 08/16/2018 08:19 AM, Adrian Klaver wrote:
On 08/16/2018 08:13 AM, Adrian Klaver wrote:
Wonder if the OP has standard_conforming_strings='off' and
escape_string_warning='off'?
In the above referring to 9.6.9 instance.
Well that theory is no good:
t
nment:_ Windows physical server machine intel x86-64
architecture with PostgreSQL Database version 10.5 and pgAdmin 4 version
3.2 .
Thanks so much for your help.
Regards,
Diego.
--
Adrian Klaver
adrian.kla...@aklaver.com
t and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn:https://postgresconf.org
* Unless otherwise stated, opinions are my own. *
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
--
Adrian Klaver
adrian.kla...@aklaver.com
with time zone Time when the currently active
query was started, or if state is not active, when the last query was
started"
Justin
--
Adrian Klaver
adrian.kla...@aklaver.com
.317..66777.438 rows=16 loops=1)"
" Filter: (sztext ~~* '%480GB%'::text)"
" Rows Removed by Filter: 125930"
"Planning time: 236.354 ms"
"Execution time: 66784.651 ms"
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/18/2018 08:12 AM, Oleksii Kliukin wrote:
Hi Adrian,
On 16. Aug 2018, at 18:13, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
test=# select 'abcd'||chr(8198) ~ 'abcd\s';
?column?
--
t
(1 row)
Wonder if the OP has standard
to do this.
https://www.postgresql.org/docs/10/static/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL
pg_rotate_logfile() boolean Rotate server's log file
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/19/2018 10:53 AM, Sonam Sharma wrote:
I am planning to migrate my db from db2 to postgresql. Before that I
wanted to know is postgresql better than db2? Is it completely free ?
Any performance issues or any limitations?
Yes, yes, depends
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/19/2018 10:56 AM, Sonam Sharma wrote:
Thank you! Can you please help me with any advantages/disadvantages.. my
db size is less than 10gb. I am very new to this.
I would start here:
https://www.postgresql.org/about/
On Sun, Aug 19, 2018, 11:25 PM Adrian Klaver <mailto:adrian.
the standard copy command with binary format with some succes.
[1] https://grokbase.com/t/postgresql/pgsql-general/01597pv3qs/copy-locking
[2] https://www.postgresql.org/docs/current/static/sql-copy.html
[3] https://github.com/bytefish/PgBulkInsert
--
Adrian Klaver
adrian.kla...@aklaver.com
before running the *ALTER/DDL *or creating *TRIGGER *on
that table in postgresql database.
Take a look at:
https://www.postgresql.org/docs/10/static/view-pg-locks.html
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla...@aklaver.com
ue as
9158892). Why "checkpointer process" is consuming this much amount of
memory and how to limit the usage of the "checkpointer process" memory.
Take a look at:
https://www.postgresql.org/docs/10/static/wal-configuration.html
image.png
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla...@aklaver.com
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/23/2018 07:39 AM, Naveen Dabas wrote:
sir from where should i install it.
I tried but i didn't found separate link for pg_sample
can you help me in this
I am guessing it is this:
https://github.com/mla/pg_sample
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/23/2018 07:39 AM, Naveen Dabas wrote:
sir from where should i install it.
I tried but i didn't found separate link for pg_sample
can you help me in this
Something similar:
https://github.com/18F/rdbms-subsetter
It is Python based and can be pip installed.
thanks
--
A
se(stores) on the workstation going to be working
with data independent to each or is the data shared/synced between
instances?
Thanks in Advance !
--
Adrian Klaver
adrian.kla...@aklaver.com
way, if you need any kind of maintenance, you can program it in
your app (even backup, restore and vacuum) - it is easy to throw
administrative commands thru the available interfaces.
And if the database get out of access, no matter if it is
centralized or
remote: you will need someone phisically there to fix it.
AFAIK, you don't even PostgreSQL installer - you can run it embed if
you
wish.
Just my2c,
Edson
--
Adrian Klaver
adrian.kla...@aklaver.com
_id" btree (rtypid)
"idx_tab_tkey" btree (tkey)
--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425
--
Adrian Klaver
adrian.kla...@aklaver.com
rhel6 @pgdg10
postgresql10-libs.i686 10.5-1PGDG.rhel6 @pgdg10
postgresql10-odbc.i686 10.03.-1PGDG.rhel6 @pgdg10
postgresql10-server.i686 10.5-1PGDG.rhel6 @pgdg10
--
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
--
Adrian Klaver
adrian.kla...@aklaver.com
you are running pg_basebackup from?
Just to be clear both Postgres instances are running 10.5, correct?
My area:
- Updated Debian GNU/Linux 9
- PostgreSQL 10.5 (Debian 10.5-1.pgdg90+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
Thx,
Csaba
--
Adrian Klaver
adrian.kla...@aklaver.com
primarily addressed to. If you are not the primary recipient
or are not supposed to receive this email, you are advised to kindly
delete the email or the thread and notify of the error. The logo is a
registered and copyrighted property of *ACTAS TECHNOLOGIES PRIVATE
LIMITED*. Do not use it without authorization.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/27/2018 07:38 AM, Csaba Ragasits wrote:
2018-08-27 16:08 GMT+02:00 Adrian Klaver <mailto:adrian.kla...@aklaver.com>>:
Can you connect to node1 using psql with and without SSL?
Where is node1 relative to the machine you are running pg_basebackup
from?
Just to
l
So you can do something like:
select * from plant1 TABLESAMPLE system (25);
on a single table.
I could see doing the above in a program and INSERTing the output to
another database.
thanks
On Mon, Aug 27, 2018 at 7:42 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
my pg_basebackup command let me know.
-X stream
See link below.
Please clarify me what it means *--pgdata=--D* in my above
*pg_basebackup *command.
https://www.postgresql.org/docs/10/static/app-pgbasebackup.html
--
Regards,
Raghavendra Rao J S V
--
Adrian Klaver
adrian.kla
,
Csaba
2018-08-28 4:49 GMT+02:00 Michael Paquier <mailto:mich...@paquier.xyz>>:
On Mon, Aug 27, 2018 at 04:40:34PM -0700, Adrian Klaver wrote:
> Is there more then one copy of pg_basebackup on the machines?
Or this user has created a tablespace directly in the main data fo
FUNCTION('y2012')
select t1.cola t1.colb, t1.colc, t2.y2012 from . Where
t2.y2012 != 0;
to generalize
select * from FUNCTION( year_column )
select t1.cola t1.colb, t1.colc, t2.year_column from . Where
t2.year_column != 0;
is it possible? if so how?
--
regards,
Tim
--
Tim Cross
--
Adrian Klaver
adrian.kla...@aklaver.com
sql.org/message-id/flat/152106914669.1223.5104148605998271987%40wrigleys.postgresql.org
I think you have to change your index function to specify the schema
name before the unacces function call, e.g.
SELECT lower(public.unaccent(btrim(regexp_replace(
--
Bruce Momjian
CREATE INDEX ix_semantic_normalize_title on unaccent_test(title);
VACUUM ANALYZE unaccent_test;
VACUUM
vacuumdb -U postgres -z -t unaccent_test test
vacuumdb: vacuuming database "test"
The only thing I can think of is that you have an older version of
vacuumdb that is not awar
installed extensions
Name | Version | Schema | Description
--+-++-
unaccent | 1.1 | public | text search dictionary that removes accents
--
Adrian Klaver
adrian.kla...@aklaver.com
om Postgres 9.6 --> 10 pg_clog became pg_xact.
Are you sure you are not working across versions?
If not do pg_clog/ and 0C68 actually exist?
thanks,
dave
--
Adrian Klaver
adrian.kla...@aklaver.com
On 08/31/2018 08:51 AM, Dave Peticolas wrote:
On Fri, Aug 31, 2018 at 8:14 AM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 08/31/2018 08:02 AM, Dave Peticolas wrote:
> Hello, I'm running into the following error running a large query
on a
&g
Table "public.fk_child"
Column | Type| Collation | Nullable | Default
+---+---+--+-
col1 | character varying | | |
Foreign-key constraints:
"fk_child_col1_fkey" FOREIGN KEY (col1) REFERENCES fk_parent(col2)
"fk_child_col1_fkey1" FOREIGN KEY (col1) REFERENCES fk_parent(col2)
Regards, Andreas
--
Adrian Klaver
adrian.kla...@aklaver.com
e Postgres version, 10.5.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 09/01/2018 09:47 AM, Olivier Leprêtre wrote:
Mine is 9.6
I would submit a bug report here:
https://www.postgresql.org/account/login/?next=/account/submitbug/
-Message d'origine-
De : Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Envoyé : samedi 1 septembre 2018 18
you ran tar to do the snapshot of
$PG_DATA.
Was there any error when tar ran the backup that caused you problems?
--
Adrian Klaver
adrian.kla...@aklaver.com
dave
--
Adrian Klaver
adrian.kla...@aklaver.com
chive.org/PostgreSQL-general-f1843780.html
--
Adrian Klaver
adrian.kla...@aklaver.com
dat | head
CDSLBXW/8412.dat
CDSLBXW/8414.dat
CDSLBXW/8416.dat
CDSLBXW/8418.dat
CDSLBXW/8420.dat
CDSLBXW/8422.dat
CDSLBXW/8423.dat
CDSLBXW/8425.dat
CDSLBXW/8427.dat
CDSLBXW/8428.dat
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
On 09/02/2018 07:07 PM, Ron wrote:
On 09/02/2018 08:41 PM, Adrian Klaver wrote:
On 09/02/2018 05:40 PM, Ron wrote:
Hi,
I can associate these dat names with their source tables through a
bunch of bash and vim manual operations, but I was wondering if
there's any automated method (maybe
below
error and the process is failing:
--
“AutomationException: Underlying DBMS error[ERROR: prepared statement
\"sde_1535573518_38_9763483\" does not exist::SQLSTATE=26000]”
Regards,
Virendra
--
Adrian Klaver
adrian.kla...@aklaver.com
ch dictionary "unaccent" does not exist
LINE 1: SELECT public.unaccent('unaccent', 'fóö');
SET search_path = "$user"; SELECT public.unaccent('public.unaccent', 'fóö');
SET
unaccent
--
foo
That eliminates hard wiring the OID.
The proper fix is, I suppose, to make the single-argument unaccent
function explicitly look up the dictionary in the same schema as the
function itself is in.
Cheers,
Gulli
--
Adrian Klaver
adrian.kla...@aklaver.com
ndamental level.
Thank you for your advice and best wishes,
Lutz
--
Adrian Klaver
adrian.kla...@aklaver.com
-
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | h...@hjp.at <mailto:h...@hjp.at> | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
--
Adrian Klaver
adrian.kla...@aklaver.com
| | | h...@hjp.at <mailto:h...@hjp.at> | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>
--
Adrian Klaver
adrian.kla...@aklaver.com
n?
--
t
The formatting is different.
The field type:
entry_timestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL,
Our difference every time the last 0 values. The time values are same,
but our field based data comparing mechanism every time mark it as error.
As Ron stated it should not.
strictly prohibited from disseminating or
distributing this information (other than to the intended recipient) or
copying this information. If you have received this communication in
error, please notify us immediately by e-mail or by telephone at the
above number. Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
the 9.1 instance, using psql, what does:
\dn+ public
show.
Repeat for other schemas.
--
Adrian Klaver
adrian.kla...@aklaver.com
eived this communication in error, please notify us immediately by
e-mail or by telephone at the above number. Thank you.
--
Adrian Klaver
adrian.kla...@aklaver.com
A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
* Unless otherwise stated, opinions are my own. *
--
Adrian Klaver
adrian.kla...@aklaver.com
Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
--
Adrian Klaver
adrian.kla...@aklaver.com
ver you will not know the actual times until you run them.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 9/14/18 6:59 AM, Robert Eckhardt wrote:
On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver
wrote:
On 9/14/18 1:31 AM, Chris Travers wrote:
I really have to object to this addition:
"This Code is meant to cover all interaction between community members,
whether or not it takes place w
501 - 600 of 4934 matches
Mail list logo
