2016-05-17 15:29 keltezéssel, Albe Laurenz írta:
Boszormenyi Zoltan wrote:
it was a long time I have read this list or written to it.
Now, I have a question. This blog post was written about 3 years ago:
https://aphyr.com/posts/282-jepsen-postgres
Basically, it talks about the client
Hi,
it was a long time I have read this list or written to it.
Now, I have a question. This blog post was written about 3 years ago:
https://aphyr.com/posts/282-jepsen-postgres
Basically, it talks about the client AND the server as a system
and if the network is cut between sending COMMIT and
2014-04-16 12:40 keltezéssel, Tony Theodore írta:
On 16 April 2014 18:48, Dev Kumkar devdas.kum...@gmail.com wrote:
We embed certain binaries and libssl.so.1.0.0 gets shipped along with
pre-build in-house database with product.
1.0.0 isn't affected.
The package version and the soversion are
2014-01-20 10:50 keltezéssel, Sameer Kumar írta:
Hi,
I still get issues with uuid-devel.
[root@pflex75 SOURCES]# rpmbuild -ba postgresql-9.2.spec
error: Failed build dependencies:
uuid-devel is needed by postgresql92-9.2.6-2PGDG.el6.ppc64
On googling a bit I found that uuid-devel is
2013-09-06 09:57 keltezéssel, Boszormenyi Zoltan írta:
2013-09-06 02:57 keltezéssel, Wang, Jing írta:
Hi,
ECPG don't support the following scenario:
char cur_name = cur1;
EXEC SQL DECLARE :cur_name CURSOR FOR ...
EXEC SQL OPEN :cur_name;
EXEC SQL FETCH cur1 INTO...
...
EXEC SQL CLOSE
2013-09-06 02:57 keltezéssel, Wang, Jing írta:
Hi,
ECPG don't support the following scenario:
char cur_name = cur1;
EXEC SQL DECLARE :cur_name CURSOR FOR ...
EXEC SQL OPEN :cur_name;
EXEC SQL FETCH cur1 INTO...
...
EXEC SQL CLOSE :cur_name;
An compile error will occur for above codes
2013-08-02 16:58 keltezéssel, Tom Lane írta:
Adrian Klaver adrian.kla...@gmail.com writes:
No I am saying that in the ALTER data_type case the column is not being
created and USING is working on data(assuming data had actually been
entered already) that exists. What you propose is a two step
2013-01-06 03:18 keltezéssel, Chris Travers írta:
Hi everyone;
I recently discovered that subselects in update statements don't assume that the select
is for update of the updating table.
For example, if I do this:
CREATE TABLE foo (
test int primary key,
);
INSERT INTO foo VALUES (1);
2012-11-01 16:32 keltezéssel, Kevin Burton írta:
This is probably a question for the authors of a book I have been reading but it may be
faster to get an answer here.
I was trying to follow along in a book 'Seven Databases in Seven Weeks' and chapter 2
deals with PostgreSQL. One of the
Hi,
2012-09-22 04:43 keltezéssel, David Johnston írta:
Has there been any discussion regarding adding a time-limited version of NOWAIT, say:
WAITONLY 50 (milliseconds), when dealing the explicit LOCK TABLE or the
SELECT...FOR(SHARE|UPDATE) commands?
David J.
we have a proposed patch for
2012-09-22 07:55 keltezéssel, Josh Kupershmidt írta:
On Fri, Sep 21, 2012 at 7:43 PM, David Johnston pol...@yahoo.com wrote:
Has there been any discussion regarding adding a time-limited version of
NOWAIT, say: “WAITONLY 50” (milliseconds), when dealing the explicit LOCK
TABLE or the
2012-09-22 06:08 keltezéssel, John R Pierce írta:
On 09/21/12 7:43 PM, David Johnston wrote:
Has there been any discussion regarding adding a time-limited version of NOWAIT, say:
“WAITONLY 50” (milliseconds), when dealing the explicit LOCK TABLE or the
SELECT…FOR(SHARE|UPDATE) commands?
is
2012-05-12 06:29 keltezéssel, Alexander Farber írta:
Or should I edit pg_hba.conf and restart the process?
hostallpostgres127.0.0.1/32md5
hostallall 0.0.0.0/0reject
Only postgres user is allowed to connect. You don't need
to restart the server, one of
Hi,
2012-05-02 11:28 keltezéssel, STERBECQ Didier írta:
We think of using Linux HugePages to isolate shared memory used by Postgres, hoping that
we got more performance.
I see some souce code samples for doing that, but I do not see any information
about compatibility : Postgres 7.x, 8.x,
2011-11-08 12:33 keltezéssel, Chrishelring írta:
Hi,
properbly a simple question (with a simple answer). Nevertheless I´ve been
struggeling with it for some time now. Hope you guys can point me in the
right direction!
I want to exclude access to our postgresql db using a configuration in
2011-10-04 13:30 keltezéssel, Robert Buckley írta:
Hi,
I have a column in a table called hist_id with the datatype integer. When I
created
the table I assigned this column the primary key constraint but didn´t make
it an
auto-increment column.
How could I do this to an the already
Hi,
2011-10-04 14:05 keltezéssel, Robert Buckley írta:
Thanks for the replies,
I have one question regarding this comment...
You also need to add a DEFAULT expression and optionally
make the sequence owned by the column:
What difference does it make if a table owns a sequence of
Hi,
here is the testcase:
create type mytype as (id integer, t varchar(255));
create table mytest (id serial, t1 varchar(255), t2 varchar(255));
create or replace function myfunc () returns setof mytype as $$
begin
return query select id, (t1 || t2)::varchar from mytest;
end;$$ language
2011-10-03 18:12 keltezéssel, Boszormenyi Zoltan írta:
Hi,
here is the testcase:
create type mytype as (id integer, t varchar(255));
create table mytest (id serial, t1 varchar(255), t2 varchar(255));
create or replace function myfunc () returns setof mytype as $$
begin
return query
2011-10-03 19:17 keltezéssel, Scott Ribe írta:
On Oct 3, 2011, at 10:12 AM, Boszormenyi Zoltan wrote:
But I would like to know why isn't the type conversion from unlimited varchar
to varchar(255) invoked in the pl/pgsql function?
What if t1 || t2 is longer than 255? You need to explicitly
2011-10-03 19:31 keltezéssel, Boszormenyi Zoltan írta:
2011-10-03 18:12 keltezéssel, Boszormenyi Zoltan írta:
Hi,
here is the testcase:
create type mytype as (id integer, t varchar(255));
create table mytest (id serial, t1 varchar(255), t2 varchar(255));
create or replace function myfunc
Hi,
2011-08-29 22:36 keltezéssel, Lonni J Friedman írta:
... I read that
(max_connections * work_mem) should never exceed physical RAM, and if
that's accurate, then I suspect that's the root of my problem on
systemA (below).
work_mem is process-local memory so
(max_connections * work_mem)
Hi,
COPY (SELECT ...) appeared in 8.2.x so you need to upgrade.
Best regards,
Zoltán Böszörményi
2011-08-11 13:21 keltezéssel, Siva Palanisamy írta:
Hi Andreas,
FYI, I am using PostgreSQL 8.1.4.
Thanks and Regards,
Siva.
-Original Message-
From:
Hi,
2011-08-01 16:11 keltezéssel, Paul Tilles írta:
I have an executable which uses ecpg which was created on a system using
postgres
version 8.2.6. I sent it to a site with version 8.4.7 installed. The
executable fails
with a memory fault.
Is there a problem doing this?
Try
Hi,
2011-05-12 00:28 keltezéssel, Tomas Vondra írta:
Hi,
I've studied the implementation of the btree indexes and how exactly the
fillfactor is used, and in general
- when a page split happens, the process needs to obtain more locks
than with simple insert, which may result in contention
Alvaro Herrera írta:
Excerpts from Boszormenyi Zoltan's message of lun ago 16 14:45:07 -0400 2010:
Matthew Wilson írta:
I don't care if the code is rearranged so that c is replaced with an
inline definition during compilation. I'm not concerned about
efficiency here. I just
Matthew Wilson írta:
On Mon Aug 16 10:26:36 2010, Tom Lane wrote:
Matthew Wilson m...@tplus1.com writes:
All I can come up with so far is to use a view and then another view on
top of that one:
Note that you don't actually need a view, as you can just write the
subselect
Hi,
I need to rework a custom notification scheme that sends TCP
messages about new/modified/deleted records to an external process.
It's obvious that I am using RegisterXactCallback() to do that.
The problem is with prepared transactions. I get XACT_EVENT_PREPARE
in the XactCallback function,
gvim írta:
I'm running PostgreSQL 8.4.3 on OS X Snow Leopard via MacPorts and I'm
getting strange inconsistent errors such as:
dbuser-# select * from log_form;
The error is here above. You had a -# prompt, saying
that you already started another statement in a previous line
but you haven't
Hi,
Davor J. írta:
I need to make certain views from the database visible online (on our
webpage) and I wonder if there is any reasonably quick solution for this
that works with Postgres?
At best, a query should be specified and the user should be able to select
the layout on certain
Hi,
I need to call a function via dblink that returns a void, i.e.
technically nothing.
=# select public.dblink_exec('import', 'SELECT
import.add_one_word(''word'', true)');
ERROR: statement returning results not allowed
=# select * from public.dblink('import', 'SELECT
mike stanton írta:
Hello all, I get the following error message when ecpg precompiles an
EXEC SQL INCLUDE on this variable:
short cst_vent[MAX_SUC][12]; (MAX_SUC is defined as 24)
Mesage:
No multidimensional array support for simple data types
Is there a fix or am I
Hi,
I have the $SUBJECT problem loading my own
module in PostgreSQL. The server is HP-UX/ia64,
PostgeSQL 8.4.2 was compiled with HP CC.
pl/PgSQL can be loaded fine.
...:/usr/local/pgsql/pgsql-cc-8.4/lib# ldd odbclink.so
libodbc.so.1 = /usr/local/pgsql/runtime/lib/libodbc.so.1
Korry Douglas írta:
I have the $SUBJECT problem loading my own
module in PostgreSQL. The server is HP-UX/ia64,
PostgeSQL 8.4.2 was compiled with HP CC.
pl/PgSQL can be loaded fine.
...:/usr/local/pgsql/pgsql-cc-8.4/lib# ldd odbclink.so
libodbc.so.1 =
Boszormenyi Zoltan írta:
Korry Douglas írta:
I have the $SUBJECT problem loading my own
module in PostgreSQL. The server is HP-UX/ia64,
PostgeSQL 8.4.2 was compiled with HP CC.
pl/PgSQL can be loaded fine.
...:/usr/local/pgsql/pgsql-cc-8.4/lib# ldd odbclink.so
libodbc.so.1
Hi,
I am using this code on 8.4/8.5, which works on 64-bit,
but segfaults on 32-bit Linux:
oids[0] = TEXTOID;
values[0] = lex;
nulls[0] = false;
ret = SPI_execute_with_args(
(just_title ?
SELECT ids FROM product.t_product_inv_titleonly WHERE word
= $1
Tom Lane írta:
Boszormenyi Zoltan z...@cybertec.at writes:
//ids =
PointerGetDatum(PG_DETOAST_DATUM(SPI_getbinval(prod_inv-vals[0],
prod_inv-tupdesc, 1, isnull)));
well, for one thing, you probably want DatumGetPointer ...
You chose the commented out line to comment
Hi,
I would like to execute the code below.
I SELECTed a bigint[] from the database into Datum ids,
I need to insert a new bigint ID in the middle.
Datum ids;
int n_ids;
int idx_min,
Hi,
Keaton Adams írta:
This is a QA system and unfortunately there is no recent backup So
as a last resort I am looking for any way to bring up Postgres when it
has corrupt data in it:
FATAL: could not remove old lock file postmaster.pid: Read-only file
system
HINT: The file seems
Thomas Guettler írta:
Hi,
how can you get N numbers (without holes) from a sequence?
Thomas
# create sequence tmp_seq cache 1000;
CREATE SEQUENCE
From the same client:
# select nextval('tmp_seq');
nextval
-
1
(1 sor)
# select nextval('tmp_seq');
nextval
-
Indexes could get corrupt, requiring rebuilding.
That problem is gone
with WAL. Transaction commits where always safe.
Thanks. I was specifically asking about Result '3'
above mentions 'totally corrupted table page content
because of partially written data pages' . Is this
41 matches
Mail list logo
