Hi,
I tried using integer array within a structure array in ECPG code. But it
resulted in some garbage values being printed from the table. Here are the
details,
The ECPG program is attached (array_test.pgc). It tries to read the
contents of table emp, whose structure and contents are as follows
On Fri, Mar 21, 2014 at 12:24 PM, MauMau maumau...@gmail.com wrote:
From: Amit Kapila amit.kapil...@gmail.com
On Wed, Jan 15, 2014 at 8:12 PM, MauMau maumau...@gmail.com wrote:
Thanks for reviewing and testing the patch. Yes, at first I did what you
mentioned, but modified the patch
A few 'the the' typos in code docs.--- src/backend/access/transam/xlog.c.orig 2014-03-23 22:43:44.864504319 +0100
+++ src/backend/access/transam/xlog.c 2014-03-23 22:44:02.735634100 +0100
@@ -1089,7 +1089,7 @@
* has progressed. There is a small fixed number of insertion locks,
* determined
On 03/24/2014 08:40 AM, Erik Rijkers wrote:
A few 'the the' typos in code docs.
Thanks, fixed.
- Heikki
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Hi,
Note the following comment in src/backend/commands/vacuumlazy.c:lazy_scan_heap()
1088 /* If no indexes, make log report that lazy_vacuum_heap
would've made */
1089 if (vacuumed_pages)
1090 ereport(elevel,
Just wondering if it would read better as:
1088 /* Make the log
Le dimanche 23 mars 2014 02:44:26 Noah Misch a écrit :
On Tue, Mar 18, 2014 at 09:31:06AM +0100, Ronan Dunklau wrote:
Le mardi 18 mars 2014 03:54:19 Kouhei Kaigai a écrit :
(1) To acquire the old tuple for UPDATE/DELETE operations, the patch
closely
parallels our handling for
I want to add a column to system catalog pg_attribute for getting an oid
for a column also. How do we add a column into pg_attribute ?
Why do you want to add OID to pg_attribute? The relid and attnum would be
able to uniquely identify each row of pg_attribute and hence each column of
any relation in the database.
On Mon, Mar 24, 2014 at 1:10 PM, Tanmay Deshpande
tp.deshpand...@gmail.comwrote:
I want to add a column to system
I was looking at
http://www.postgresql.org/docs/devel/static/bgworker.htmlwith a client
today.
It says:
Unlike RegisterBackgroundWorker, which can only be called from within the
postmaster,RegisterDynamicBackgroundWorker must be called from a regular
backend.
Is that the correct restriction? In
As we all know, when you compile with WAL_DEBUG, and enable wal_debug
GUC, you get output like this in the log for every inserted WAL record:
LOG: INSERT @ 0/5407E578: prev 0/5407E4D0; xid 0; len 32: Standby -
running xacts: nextXid 774 latestCompletedXid 771 oldestRunningXid 772;
2 xacts:
Hi,
I want to set a *global flag* with which I can decide whether to use my
code or not
in modified source code.
How I can do that?
Thank you
-Swapnil
2014-03-24 07:22 keltezéssel, Ashutosh Bapat írta:
Hi,
I tried using integer array within a structure array in ECPG code. But it resulted in
some garbage values being printed from the table. Here are the details,
The ECPG program is attached (array_test.pgc). It tries to read the contents of
I need to set a global flag in such a way that only if the flag is on then
my modified code will get executed, so how can I do that?
Thank you.
On 23/03/14 19:38, Pavel Stehule wrote:
doc should be enhanced by:
snip
Docs updated.
--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index
On Mon, Mar 24, 2014 at 5:54 PM, Magnus Hagander mag...@hagander.net wrote:
I was looking at http://www.postgresql.org/docs/devel/static/bgworker.html
with a client today.
It says:
Unlike RegisterBackgroundWorker, which can only be called from within the
On 24 March 2014 10:58, Petr Jelinek p...@2ndquadrant.com wrote:
Docs updated.
OK, it looks to me that all outstanding comments have been resolved.
I'll be looking to commit this later today, so last call for comments.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL
On Thu, Mar 20, 2014 at 3:43 PM, Kyotaro HORIGUCHI
horiguchi.kyot...@lab.ntt.co.jp wrote:
Hello,
At Wed, 19 Mar 2014 19:34:10 +0900, Fujii Masao wrote
Agreed. Attached patches do that and I could recover the
database state with following steps,
Adding new option looks like new feature
On Sat, Mar 22, 2014 at 9:33 AM, Tatsuo Ishii is...@postgresql.org wrote:
That's because the parameter is checked at the beginning of recovery
(i.e. at standby start) before XLOG_PARAMETER_CHANGE is received and
applied on the standby. Please see CheckRequiredParameterValues() in
On 03/24/2014 06:28 PM, Rajashree Mandaogane wrote:
I need to set a global flag in such a way that only if the flag is on
then my modified code will get executed, so how can I do that?
PostgreSQL is single-threaded, multi-processing. So if you need to set
this flag only within a given backend,
On Sat, Mar 22, 2014 at 12:56 AM, Emanuel Calvo
emanuel.ca...@2ndquadrant.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Hi guys,
I realized that the output of the CREATE RULE has not a detailed
output for the events parameter.
But the question here is that I'm not sure
Hi,
I want to set or reset a global flag.
1) What currently I'm thinking is, I'll declare that global flag in
*postgres.h*
2) I'll set that depending on my custom flag given at server startup
3) I encountered function *getopt* but I couldn't understand it
So my question is how should I process
Hi,
I'm currently looking for candidates who might be suitable for a C# Developer
position based in Kentish Town and I wondered if you might know anyone who is
interested. Salaries are around the £55000 level but might be flexible
dependent on experience.
Software Developer / Programmer
Swapnil Bhoite swapnil.tem...@gmail.com writes:
I want to set or reset a global flag.
1) What currently I'm thinking is, I'll declare that global flag in
*postgres.h*
2) I'll set that depending on my custom flag given at server startup
3) I encountered function *getopt* but I couldn't
On Mon, Mar 24, 2014 at 12:20 PM, Michael Paquier michael.paqu...@gmail.com
wrote:
On Mon, Mar 24, 2014 at 5:54 PM, Magnus Hagander mag...@hagander.net
wrote:
I was looking at
http://www.postgresql.org/docs/devel/static/bgworker.html
with a client today.
It says:
Unlike
Heikki Linnakangas hlinnakan...@vmware.com writes:
As we all know, when you compile with WAL_DEBUG, and enable wal_debug
GUC, you get output like this in the log for every inserted WAL record:
LOG: INSERT @ 0/5407E578: prev 0/5407E4D0; xid 0; len 32: Standby -
running xacts: nextXid 774
From: Amit Kapila amit.kapil...@gmail.com
1. Assume a tablespace tbs already exists.
2. Create table t1(c1 int) tablespace tbs;
3. drop table t1;
4. Drop tablespace tbs;
5. Do immediate shutdown (pg_ctl stop -mi);
6. During recovery it will create a table in directory (in function
On Sun, Mar 23, 2014 at 11:49:37AM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Is this the patch you had in mind? I kept the pg_catalog filter. Do we
want to always show the replica identity line for \d+?
Doesn't seem like a great idea to remove the filter tests for
On 2014-03-22 23:47:57 -0400, Bruce Momjian wrote:
test= \d+ test
Table public.test
Column | Type | Modifiers | Storage | Stats target | Description
+-+---+-+--+-
x |
On Mon, Mar 24, 2014 at 05:06:25PM +0100, Andres Freund wrote:
On 2014-03-22 23:47:57 -0400, Bruce Momjian wrote:
test= \d+ test
Table public.test
Column | Type | Modifiers | Storage | Stats target | Description
Bruce Momjian wrote:
On Mon, Mar 24, 2014 at 05:06:25PM +0100, Andres Freund wrote:
On 2014-03-22 23:47:57 -0400, Bruce Momjian wrote:
test= \d+ test
Table public.test
Column | Type | Modifiers | Storage | Stats target | Description
I came up with the attached patch, to reduce the WAL volume of GIN
insertions. It become fairly large, but I guess that's not too
surprising as the old WAL-logging method was basically to dump the whole
page to WAL record. This is now a lot more fine-grained and smarter. I
separated
We are trying add columnar support to postgreSQL and for that we need
identify each column in each relation by an oid. So my doubt is how do we
add an attribute/ a column to catalog pg_attribute ?
On Mon, Mar 24, 2014 at 2:53 AM, Swapnil Bhoite swapnil.tem...@gmail.comwrote:
Hi,
I want to set a *global flag* with which I can decide whether to use my
code or not
in modified source code.
How I can do that?
edit src/backend/utils/misc/guc.c to add an external variable declaration
near
On 3/22/14, 11:26 AM, Jim Nasby wrote:
On 3/21/14, 4:54 PM, Tom Lane wrote:
Merlin Moncure mmonc...@gmail.com writes:
There is no way for psql to handle that case though unless you'd strip
*all* BOMs encountered. Compounding this problem is that there's no
practical way AFAIK to send multiple
On 03/24/2014 02:50 PM, Jim Nasby wrote:
On 3/22/14, 11:26 AM, Jim Nasby wrote:
On 3/21/14, 4:54 PM, Tom Lane wrote:
Merlin Moncure mmonc...@gmail.com writes:
There is no way for psql to handle that case though unless you'd strip
*all* BOMs encountered. Compounding this problem is that
Andrew Dunstan and...@dunslane.net writes:
I suspect suspect trying to do this in the parser will be quite messy.
This needs to happen before the input is converted to the server
encoding, I think.
Indeed --- what if the server isn't using utf8 internally?
And a larger point is that the
On Mon, Mar 24, 2014 at 2:16 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Andrew Dunstan and...@dunslane.net writes:
I suspect suspect trying to do this in the parser will be quite messy.
This needs to happen before the input is converted to the server
encoding, I think.
Indeed --- what if the
On Mon, Mar 24, 2014 at 2:37 PM, Merlin Moncure mmonc...@gmail.com wrote:
psql -1 already requires '-f' to work
actually, it doesn't. this was fixed recently.
merlin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On 03/19/2014 02:16 PM, Darren Duncan wrote:
On 2014-03-18, 2:42 PM, Josh Berkus wrote:
Other PostgreSQL 9.3 only fixes in this update include:
* Add read-only data_checksum parameter
I recall being told last fall that this would not be added to 9.3.x
(9.3.1 at the time I think) and only
On 3/24/14, 1:59 PM, Andrew Dunstan wrote:
It occurs to me that we're going about this the wrong way...
The error here isn't being generated by psql; it's generated by the backend. In
the context of a statement (and not, say, a COPY command).
So instead of trying to handle this on the psql
Jim Nasby j...@nasby.net writes:
Wait... I thought that was one of the objections... that we wanted to
leave a BOM in something like a COPY untouched?
I think most of us are okay with stripping a BOM that appears at the
*beginning* of a text file (assuming there's reason to believe the file
is
On Mon, Mar 24, 2014 at 7:14 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Heikki Linnakangas hlinnakan...@vmware.com writes:
As we all know, when you compile with WAL_DEBUG, and enable wal_debug
GUC, you get output like this in the log for every inserted WAL record:
LOG: INSERT @ 0/5407E578: prev
On Thu, Mar 20, 2014 at 12:30 PM, Maxence Ahlouche
maxence.ahlou...@gmail.com wrote:
My proposal is now available on Google melange website:
http://www.google-melange.com/gsoc/proposal/public/google/gsoc2014/viod/5668600916475904
There seems to be a formatting issue: half of the text is a link
Robert Haas wrote:
On Mon, Mar 24, 2014 at 7:14 AM, Tom Lane t...@sss.pgh.pa.us wrote:
3. Remove the feature altogether, so that enabling wal_debug doesn't
cause all insertions to be logged anymore (no changes to the logging
during replay). It's a lot less interesting now that we have
Just a quick comment on this. Yes, pgAdmin always added a BOM in every
SQL files it wrote.
From
http://stackoverflow.com/questions/2223882/whats-different-between-utf-8-and-utf-8-without-bom:
According to the Unicode standard, the BOM for UTF-8 files is not recommended:
2.6 Encoding
On Tue, Mar 25, 2014 at 2:44 AM, Tanmay Deshpande
tp.deshpand...@gmail.com wrote:
We are trying add columnar support to postgreSQL and for that we need
identify each column in each relation by an oid. So my doubt is how do we
add an attribute/ a column to catalog pg_attribute ?
You can identify
The code would probably be pretty trivial, *if* we had consensus on
what the behavior ought to be. I'm not sure if we do. People who
only use Unicode would probably like it if BOMs were unconditionally
swallowed, whether or not psql thinks the client_encoding is UTF8.
(And I seem to recall
On Mon, Mar 24, 2014 at 01:35:20PM -0300, Alvaro Herrera wrote:
Bruce Momjian wrote:
On Mon, Mar 24, 2014 at 05:06:25PM +0100, Andres Freund wrote:
On 2014-03-22 23:47:57 -0400, Bruce Momjian wrote:
test= \d+ test
Table public.test
My doubt is what changes does one have to make in the source code if he/she
is trying to add an attribute to the existing system catalogs table ?
On 03/24/2014 08:28 PM, Tatsuo Ishii wrote:
The code would probably be pretty trivial, *if* we had consensus on
what the behavior ought to be. I'm not sure if we do. People who
only use Unicode would probably like it if BOMs were unconditionally
swallowed, whether or not psql thinks the
while adding a column to an existing system catalog I am getting following
error while initdb
FATAL: incorrect number of columns in row (expected 22, got 21)
where do I have to make the changes ?
On Mon, Mar 24, 2014 at 11:03 PM, Magnus Hagander mag...@hagander.net wrote:
That's what I thought. Can a dynamic background worker start *another*
dynamic background worker, or can they only be started from first level
background workers?
I have never really tried by myself, but I don't see
Tanmay Deshpande tp.deshpand...@gmail.com writes:
while adding a column to an existing system catalog I am getting following
error while initdb
FATAL: incorrect number of columns in row (expected 22, got 21)
where do I have to make the changes ?
I'd say you missed updating relnatts in the
On Mon, Mar 24, 2014 at 7:49 PM, MauMau maumau...@gmail.com wrote:
A bit contrived example is:
1. After the directory is created by TablespaceCreateDbspace(), recovery is
stopped (e.g. due to power outage). The directory remains.
2. Restart the server, redoing CREATE TABLESPACE during
On 03/25/2014 02:50 AM, Jim Nasby wrote:
So instead of trying to handle this on the psql side[1], I think we need
to handle it in the backend; specifically in the parser. Is there an
easy way to get the parser to ignore the BOM character in the context of
commands (but not in strings)?
I
On 03/25/2014 07:05 AM, Tom Lane wrote:
Jim Nasby j...@nasby.net writes:
Wait... I thought that was one of the objections... that we wanted to
leave a BOM in something like a COPY untouched?
I think most of us are okay with stripping a BOM that appears at the
*beginning* of a text file
On 03/24/2014 05:53 PM, Swapnil Bhoite wrote:
Hi,
I want to set a *global flag* with which I can decide whether to use my
code or not
in modified source code.
How I can do that?
Please reply to existing mailing list threads. Don't make a new message
for every post. It's confusing and
MarkBufferDirty() always increment BufferUsage counter
(shared_blks_dirtied) for dirty blocks whenever it dirties any
block, whereas same is not true for MarkBufferDirtyHint().
Is there any particular reason for not incrementing
shared_blks_dirtied in MarkBufferDirtyHint()?
With Regards,
Amit
On 03/25/2014 01:44 AM, Tanmay Deshpande wrote:
We are trying add columnar support to postgreSQL and for that we need
identify each column in each relation by an oid. So my doubt is how do
we add an attribute/ a column to catalog pg_attribute ?
Is this some kind of class project?
I've seen at
On Mon, Mar 24, 2014 at 3:40 PM, Boszormenyi Zoltan zbos...@pr.hu wrote:
2014-03-24 07:22 keltezéssel, Ashutosh Bapat írta:
Hi,
I tried using integer array within a structure array in ECPG code. But
it resulted in some garbage values being printed from the table. Here are
the details,
60 matches
Mail list logo