On Mon, Aug 23, 2010 at 8:21 PM, Craig Ringer
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 these values may
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 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 pl
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 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 ab
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.
This does not work. Please help.
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
--
Craig Ringer
--
Sent via pgsql-general mailing
Derrick Rice 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
that a particular rang
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
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, Francis
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 hits.
On Tue, Aug 24, 2010 at 12:44 AM, 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
> m
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 condit
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 i
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 http://momjian.us
EnterpriseDB
Derrick Rice wrote:
> On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian 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.
>
> T
On Mon, Aug 23, 2010 at 5:45 PM, Bruce Momjian 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 they can be
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
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:
http://www.postgresql.org/mailpref/pgsql-general
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.
wrote:
> 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 ca
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 b
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 l
http://phpsqldiff.sourceforge.net/
On Mon, Aug 23, 2010 at 4:32 PM, akp geek wrote:
> Hi all -
>
> Is there any open source tool available for postgres to compare
> data between 2 tables. Appreciate your help
>
> Regards
>
Hi,
Can cursors be returned to IBATIS. If so how. This is what I have written.
This does not work. Please help.
Regards,
Atul Goel
SENIOR DEVELOPER
Global DataPoint
Middlesex House, 34-42 Cleveland Street
London W1T 4LB, UK
T: +44 (0)20 7079 4827
M: +44
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 opened
On Mon, Aug 23, 2010 at 12:04, SUNDAY A. OLUTAYO 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 subscription:
http://w
Hi all -
Is there any open source tool available for postgres to compare
data between 2 tables. Appreciate your help
Regards
Mike Christensen 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 server param
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 A.
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
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,
On Mon, Aug 23, 2010 at 4:04 AM, SUNDAY A. OLUTAYO 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 (pgsql-general@post
On Mon, Aug 23, 2010 at 12:12, Garry Saddington
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 sometimes when
> data is
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
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 b
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
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 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
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 th
37 matches
Mail list logo
