More information including a workaround.
VACUUM ANALYZE is not freeing space after an array_append, but it does
after replacing a specific element in the array.
So if I do this:
update array_big1 set chunk_ids = array_append(chunk_ids, '1') where id
= 0;
update array_big1 set chunk_ids[1] =
Sorry, when I had emailed the NHibernate DL the exception was in the
subject line. I forgot to copy the subject this time. The exception
is:
ERROR: 42704: unrecognized configuration parameter
ssl_renegotiation_limit
On Sun, Aug 22, 2010 at 8:54 PM, Mike Christensen m...@kitchenpc.com wrote:
I am using PostgreSQL 8.4 on Fedora Linux 13 and using MS Access as the
front end for our application. It is not the problem associated with MS
Access. I got the some entries while searching for the said topic that
Oracle provides such facility.
DESCRIBE SELECT LIST which gives the details about
Isn't this provided in odbc by myQuery.columns? Is that not
accessible to MSAccess??
On Mon, Aug 23, 2010 at 2:02 AM, c k shreeseva.learn...@gmail.com wrote:
I am using PostgreSQL 8.4 on Fedora Linux 13 and using MS Access as the
front end for our application. It is not the problem associated
How can I reset a sequence column due to deletion of some rolls?
Sunday Olutayo
Sadeeb Technologies Ltd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
We have had a problem with postgresql 8.3 on a Windows server 2008. I
wonder whether there has been any other experiences like this. We have
connected to Potsgres from Zope via a Psycopg adapter and noticed that
sometimes when data is inserted via a form in Zope, the data is
available in Zope
On 23/08/2010 11:04, SUNDAY A. OLUTAYO wrote:
How can I reset a sequence column due to deletion of some rolls?
You can use the setval() function to set its value to whatever you like:
http://www.postgresql.org/docs/8.4/static/functions-sequence.html
HTH
Ray.
--
Raymond O'Donnell :: Galway
On Mon, Aug 23, 2010 at 12:12, Garry Saddington
ga...@schoolteachers.co.uk wrote:
We have had a problem with postgresql 8.3 on a Windows server 2008. I wonder
whether there has been any other experiences like this. We have connected to
Potsgres from Zope via a Psycopg adapter and noticed that
On Mon, Aug 23, 2010 at 4:04 AM, SUNDAY A. OLUTAYO olut...@sadeeb.com wrote:
How can I reset a sequence column due to deletion of some rolls?
Note that a design of a column that holds the output of a sequence and
can't handle gaps is pretty much broken.
--
Sent via pgsql-general mailing list
On Monday 23 August 2010 3:15:28 am Magnus Hagander wrote:
On Mon, Aug 23, 2010 at 12:12, Garry Saddington
I don't know anything about Zope, but it sounds like the db adapter
opens a transaction and never commits it. Perhaps the previous version
was working in autocommit mode by default, and
On 08/19/10 20:19, Benjamin Smith wrote:
On Wednesday, August 18, 2010 04:58:08 pm Joshua D. Drake wrote:
Well if you are just using it for updates to the schema etc... you
should only need to launch a single connection to each database to make
those changes.
And that's exactly the problem.
I can't tell what a roll is based on your question, but here is how to
set a sequence to a specific value.
SELECT setval('foo', 42); Next nextval will return 43
http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html
-Randall
On Mon, 2010-08-23 at 05:04 -0500, SUNDAY
Mike Christensen m...@kitchenpc.com writes:
Sorry, when I had emailed the NHibernate DL the exception was in the
subject line. I forgot to copy the subject this time. The exception
is:
ERROR: 42704: unrecognized configuration parameter
ssl_renegotiation_limit
ssl_renegotiation_limit is a
Hi all -
Is there any open source tool available for postgres to compare
data between 2 tables. Appreciate your help
Regards
On Mon, Aug 23, 2010 at 12:04, SUNDAY A. OLUTAYO olut...@sadeeb.com wrote:
How can I reset a sequence column due to deletion of some rolls?
ALTER SEQUENCE sequence_name RESTART 1;
--
- Rikard
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Hello guys,
PostgreSQL 8.3.5. Compiled and installed on Slackware 10.2, kernel 2.6.15.
We have a transaction based system that creates a new process every time a
user connects (just fork()s, no exec()s). Each of these processes has several
threads. Some database connections are
Hi,
Can cursors be returned to IBATIS. If so how. This is what I have written.
parameterMap id= getUsersParam class=Map
parameter property=results jdbcType=REF
javaType=java.sql.ResultSet mode=OUT resultMap=allUsersResult/
parameter property=errors jdbcType=VARCHAR
http://phpsqldiff.sourceforge.net/
On Mon, Aug 23, 2010 at 4:32 PM, akp geek akpg...@gmail.com wrote:
Hi all -
Is there any open source tool available for postgres to compare
data between 2 tables. Appreciate your help
Regards
Has anyone on this list (other than Command Prompt people) had any
experience with Mammoth Replicator? If so, what are your thoughts /
opinions of the system? Are there any drawbacks you can think of for
using it verses something else?
I like the fact that it is integrated into PostgreSQL, and I
Are you using Npgsql with NHibernate?
We added an option to send this command when starting a connection.
But the setting is inside a try catch error handler, so you aren't
supposed to receive it.
On my tests I couldn't reproduce the error. The only error we got
about that was a user who had a
Whooops,
I didn't check the message header...
You can ignore my first question :)
On Mon, Aug 23, 2010 at 15:56, Francisco Figueiredo Jr.
franci...@npgsql.org wrote:
Are you using Npgsql with NHibernate?
We added an option to send this command when starting a connection.
But the setting is
There is a new pg_notify function in pgsql 9.0 but no pg_listen equivalent?
Why? It sure would be handy to pass quoted strings...
Cheers,
M
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Yaroslav Tykhiy wrote:
On Sat, Aug 21, 2010 at 12:45:44PM -0400, Bruce Momjian wrote:
Derrick Rice wrote:
I've been reading up on the documentation for WAL shipping and warm
standby
configuration. One concern that I have (a common one, I'm sure) is that it
seems that after bringing
On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian br...@momjian.us wrote:
Sorry, I don't know. I think the timelines are only there for safety if
you have to fall back to the previous timeline, and to prevent timeline
mixing.
Thanks for the helpful answers.
Two follow up questions which, if
Derrick Rice wrote:
On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian br...@momjian.us wrote:
Sorry, I don't know. I think the timelines are only there for safety if
you have to fall back to the previous timeline, and to prevent timeline
mixing.
Thanks for the helpful answers.
A.M. wrote:
There is a new pg_notify function in pgsql 9.0 but no pg_listen
equivalent? Why? It sure would be handy to pass quoted strings...
Notify sends the notify; there is no place to send a 'listen' payload.
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB
Hello all,
I am trying to do a SELECT operation with a WHERE condition. However, the
column with which I am trying to do the comparison has several values which
are pipe-delimited. I want to return a match(true) if the WHERE condition
matches any of the bar-delimited values.
For example, SELECT
On Mon, Aug 23, 2010 at 05:44:09PM -0500, san man wrote:
Hello all,
I am trying to do a SELECT operation with a WHERE condition. However, the
column with which I am trying to do the comparison has several values which
are pipe-delimited. I want to return a match(true) if the WHERE condition
On Tue, Aug 24, 2010 at 12:44 AM, san man neelakas...@gmail.com wrote:
Hello all,
I am trying to do a SELECT operation with a WHERE condition. However, the
column with which I am trying to do the comparison has several values which
are pipe-delimited. I want to return a match(true) if the
Thanks for the replies.
David, I would have normalized it to 2 or more tables, but the number of
bar-delimited are not fixed and as new data are added the maximum number of
these values may change. Also, the problem with like I think is that
matching is not strict and thus might give spurious
Sounds good, I think I'll take Tom's advice.. Actually I'm planning
on waiting for the 9.0 release to upgrade, so in theory that should
just fix everything.. This only happens if I break on all exceptions,
which I usually have turned off.. Thanks!
Mike
On Mon, Aug 23, 2010 at 11:56 AM,
BTW, version is:
'PostgreSQL 8.3.4, compiled by Visual C++ build 1400'
I don't have any such setting referenced in any .conf file. So I
guess NHibernate tries to set this setting, assuming I have a more
recent version of PG. If that's the case, it'll go away when I
upgrade..
Mike
On Mon, Aug
Derrick Rice derrick.r...@gmail.com writes:
Is it possible to interpret the requested file and ignore the timeline
digits and provide a file from some other timeline? Or is the timeline mean
more than just the file name?
Sounds dangerous as can be to me. The point of the timeline stuff is
On 08/24/2010 12:11 AM, atul.g...@globaldatapoint.com wrote:
Hi,
Can cursors be returned to IBATIS. If so how. This is what I have written.
parameterMap id=// /getUsersParam/ class=/Map/
parameter property=/results/ jdbcType=/REF/
javaType=/java.sql.ResultSet/ mode=/OUT/
On 08/24/2010 06:43 AM, Bruce Momjian wrote:
A.M. wrote:
There is a new pg_notify function in pgsql 9.0 but no pg_listen
equivalent? Why? It sure would be handy to pass quoted strings...
Notify sends the notify; there is no place to send a 'listen' payload.
I assume what they want is the
On 08/24/2010 07:07 AM, san man wrote:
Thanks for the replies.
David, I would have normalized it to 2 or more tables, but the number of
bar-delimited are not fixed and as new data are added the maximum number
of these values may change. Also, the problem with like I think is that
matching is not
On Aug 23, 2010, at 10:18 PM, Craig Ringer wrote:
On 08/24/2010 06:43 AM, Bruce Momjian wrote:
A.M. wrote:
There is a new pg_notify function in pgsql 9.0 but no pg_listen
equivalent? Why? It sure would be handy to pass quoted strings...
Notify sends the notify; there is no place to send
On 24/08/2010 11:06 AM, A.M. wrote:
On Aug 23, 2010, at 10:18 PM, Craig Ringer wrote:
On 08/24/2010 06:43 AM, Bruce Momjian wrote:
A.M. wrote:
There is a new pg_notify function in pgsql 9.0 but no pg_listen
equivalent? Why? It sure would be handy to pass quoted strings...
Notify sends the
On Mon, Aug 23, 2010 at 8:21 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 08/24/2010 07:07 AM, san man wrote:
Thanks for the replies.
David, I would have normalized it to 2 or more tables, but the number of
bar-delimited are not fixed and as new data are added the maximum number
of
39 matches
Mail list logo