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
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
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 b
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
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 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 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 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
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.
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
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 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
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
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
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
>
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
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
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
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
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
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
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
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
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
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
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
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.
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
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 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
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
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 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 pl
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
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
37 matches
Mail list logo
