of my ROLLBACK. Apparently I need to do
> transactions with Npgsql's transaction class.
>
> --Brian
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
> On Thu, Dec 12, 2013 at 8:34 AM, Francisco Figueiredo Jr. <
> franci...@npgsql.org> wrote:
>
>>
>> Hi, Mike.
>>
>> We are working to get EF6 properly supported and our master branch
>> already has support for it.
>> Unfortunately pgf
rom:
>
>
> http://pgfoundry.org/frs/download.php/3494/Npgsql2.0.13.91-bin-ms.net4.5Ef6.zip
>
> No luck there. Any ideas?
>
> Mike
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Whooops. Sorry for not replying. :-(
I'll check the problem and reply you back.
Em 02/12/2013 20:21, "AK" escreveu:
> I did a week ago - and got no replies at all. Thank you.
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/NpgsqlCopySerializer-blows-up-if-n
Hi!
You should post Npgsql questions to our user's forums :
http://forums.npgsql.org
In this case I think it is a bug in Npgsql. Please add this test program to
your post when talking about this problem.
Thanks in advance.
Em 02/12/2013 19:29, "AK" escreveu:
> I am not sure if this is the cor
On Tue, Nov 12, 2013 at 4:17 PM, Brian Crowell wrote:
> On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
> wrote:
> > I'm looking forward your patch.
> > Npgsql source can be found at github.com/npgsql/Npgsql
>
> I figured out the username issue, an
Em 12/11/2013 03:37, "Brian Crowell" escreveu:
>
> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell wrote:
> > I think I'm getting closer though. I have psql on Windows successfully
> > authenticating, so I can't be too far off.
>
> Got it.
>
> The NpgsqlPasswordPacket class has a bug: a utility f
oblem.
I hope it helps.
> --
> Christian
>
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Thanks for the tip, Samit. I didn't know about Assembla.
On Sun, Apr 14, 2013 at 5:52 AM, Sumit Raja <
sumit.r...@raja-consulting.co.uk> wrote:
> Assembla does free git repositories as well http://www.assembla.com/
>
>
> On 14 April 2013 05:22, Francisco Figueiredo Jr. wr
2013 at 4:12 PM, Magnus Hagander wrote:
> On Sat, Apr 13, 2013 at 9:10 PM, Francisco Figueiredo Jr.
> wrote:
> >
> > Hi all!
> >
> >
> > I was thinking about moving Npgsql from cvs to another SCM. Possibly git.
> >
> > I'd like to know if there is
for your help and advice.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
(role) objects and on
> database objects in the database? That might just take out your need to
> specify it in your ,NET application.
>
> I try to find out my problem by your ideas. Thanks guys.
>
> Regards
> Kalai
>
>
>
--
Regards,
Francisco Figueiredo
ion?
> Yes 2 and 4.
> I've tried with both pools and get same result.
>
> >Also, can you try to add a bin folder in the root of your web app and put
> npgsql.dll and mono.security there?
> You mean create a folder called bin in: C:\inetpub\wwwroot ?
>
>
> 2012/11/2
All rights reserved.
>
> The Global Assembly Cache contains the following assemblies:
> mono.security, Version=2.0.0.0, Culture=neutral,
> PublicKeyToken=0738eb9f132ed7
> 56, processorArchitecture=MSIL
>
> Number of items = 1
>
>
> 2012/11/26 Francisco Figueiredo J
orArchitecture=MSIL
>
> Number of items = 1
>
>
> 2012/11/26 Francisco Figueiredo Jr.
>
>> gac -l Npgsql
>
>
>
> You should check if npgsql has been correctly installed in the gac by
running gac -l Npgsql. If it is it will return something.
>
> Another possibility is to add a folder called bin to the root of your web
app and put npgsql.dll and mono.security. dll inside.
>
> I hope it helps.
>
> Em 26/11/201
Regarding npgsql, range types have no direct mapping so they will be
treated like strings. Sorry for that.
I'll work to add support to it. Would you mind to fill a feature request
about that on our feature requests project page? http://project.npgsql.org
Thanks in advance.
Em 03/08/2012 17:01, "M
Thanks!
Em 03/08/2012 17:25, "Mike Christensen" escreveu:
> Done. Bug #1011216
>
> On Fri, Aug 3, 2012 at 1:11 PM, Francisco Figueiredo Jr.
> wrote:
> >
> > Regarding npgsql, range types have no direct mapping so they will be
> treated
> > like string
;
> *From:* francisco.figueiredo...@gmail.com [mailto:
> francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr.
> *Sent:* Friday, March 09, 2012 12:41 PM
> *To:* Randy Ficker
> *Cc:* Marti Raudsepp; pgsql-general@postgresql.org
> *Subject:* RE: [GENERAL] 9.1 causing &q
raight back down to the 8.4 level. Awesome!
>
> ** **
>
> Thanks for the quick replies guys!
>
> ** **
>
> *From:* francisco.figueiredo...@gmail.com [mailto:
> francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr.
> *Sent:* Friday, Marc
Thanks for the heads up.
I'll fix that in Npgsql so it sends the correct isolation level when
running on 9.1+
Sent from my Android phone
On Mar 9, 2012 3:27 PM, "Randy Ficker" wrote:
> Hey Marti,
>
> I almost replied that yes, I was 100% sure, since I know my code requests
> the REPEATABLE READ
ing datatype which
>> maps to postgresql bit fields which could give you the information you
>> want. But I don't know if it would be too much overkill for your
>> rating system.
>> BitString datatype already have a lot of helpers methods though
>> including one
ter varying, OUT recipecount integer, out ingredientcount
> integer)
> RETURNS SETOF record AS
> $BODY$
> BEGIN
> -- All sorts of stuff way too mind-blowing for this email
> END;
>
> Then I call it as so:
>
> IDbCommand cmd = session.Connection.Cr
On Sun, Jan 8, 2012 at 21:31, Mike Christensen wrote:
> On Sun, Jan 8, 2012 at 10:12 AM, Francisco Figueiredo Jr.
> wrote:
>> On Sun, Jan 8, 2012 at 06:54, Mike Christensen wrote:
>>>>>>>> According to the manuals, Postgres has smallint (2 byte), integer (4
d since a byte type isn't required by
>> the SQL spec, it would take some effort to get a standard one included
>> in the core.
>
> That makes sense.
>
> I guess my question is more of a NpgSql question then. Is there a way
> to create a custom PG type, and have npgs
elational
> features like hstore through a layer that tries to be db-independent and
> purely relational. I don't have any experience with Castle ActiveRecord.
> When I've used hstore with hibernate I've always done it by direct native
> queries.
>
> --
> Craig Ri
1], '.') as weight
> from product_list
>
> Looks simpler than using XmlReader, isn't it?
> How to invoke asmx web service call (= http POST request) from
> PostgreSql server which reads http response to xml_import table ?
>
> How to call stored proce
> 6500
> 6501
> 65010200
> 10001125
> AM
> Acme API Specification v 1.0
> 13
> ADA3000AXBOX
> AMD Athlon64 3000+ (2000MHz/1600MHz/L2 Cache 512KB) Socket 754,
> BOX
> 36
> 296.0
> 0
> 3.6000
> 1999-01-01T00:00:00
> false
>
>
>
>
you. Sorry for that.
On the good side, we released a new beta last week. :)
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
<>
the right choice for ORM framework of .NET.
>
> I want to know whether there is any efficient .NET provider and is PGSQL
> compatible with the .NET entity framework.
>
> Regards,
> Rohit.
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http:/
w bug reports and checking the
status of current bugs.
Thanks in advance and again, sorry for bothering you in this list.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-gener
ive it a try and feel free to let us know if you find any problem.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/franciscojunior
Em 18/03/2011 22:01, "Tom Lane" escreveu:
> "Francisco Figueiredo Jr." writes:
>> My database has encoding set to UTF-8 although my lc_collate is
pt.BR.UTF-8
>> th
ting my have cause some trouble?
I also have problems with psql client where the char doesn't appear at all.
Andreas could see the char though...
I hope it helps.
Thanks in advance.
--
Sent from my Android phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/f
Any ideas??
Would it be possible that Postgresql would be using another encoding
for the identifiers when they aren't wrapped by double quotes?
On Tue, Mar 15, 2011 at 23:37, Francisco Figueiredo Jr.
wrote:
> Now, I'm using my dev machine.
>
> With the tests I'm doing,
compiled postgresql 9.0.1 from source code.
Thanks in advance.
[1] - http://en.wikipedia.org/wiki/UTF-8
On Tue, Mar 15, 2011 at 15:52, Francisco Figueiredo Jr.
wrote:
> H,
>
> What would change the encoding of the identifiers?
>
> Because on my dev machine which unfor
ere any config I can change at runtime in order to have it
returned correctly?
Thanks in advance.
On Tue, Mar 15, 2011 at 15:45, Andreas Kretschmer
wrote:
> Francisco Figueiredo Jr. wrote:
>
>>
>> What happens if you remove the double quotes in the column name identifier?
>
>
7;t test putting double quotes in the column name identifier as
the bug report isn't using it.
What happens if you remove the double quotes in the column name identifier?
Thanks in advance.
On Tue, Mar 15, 2011 at 15:21, Andreas Kretschmer
wrote:
> Francisco Figueiredo Jr. wrote:
>
ion I need to change to specify the encoding of
the identifiers?
I'm using UTF-8 for my database.
Thanks in advance.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mail
That's great!
I'm glad to hear it.
Thank you very much for providing patches for this issue.
--
Sent from my Android phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/franciscojunior
Em 10/03/2011 09:01, "Ahmed Shinwari" escreveu:
> Hi
ards,
> Radek
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fx
instead of Brar's code wouldn't break cases like the one he said in
his last email?
Thanks for feedback.
On Wed, Feb 2, 2011 at 14:11, Francisco Figueiredo Jr.
wrote:
> Thank you very much for your patch!
>
> I'm going to review and apply it.
>
> As soon as it is done
tml
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Fi
Francisco Figueiredo Jr
Sent from my Android phone.
Em 21/01/2011 13:50, "orgilhp" escreveu:
>
> Hello,
Hello!
> I have postgresql 8.3.9 database. Now I am working on reading file
> from bytea data and save to filesystem.
> I am using Npgsql.dll on c#.net.
>
Whi
# hex, escape
>>
>> into postgresql.conf.
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
Regards,
la base de firmas
> de virus 5575 (20101029) ______
>
> ESET NOD32 Antivirus ha comprobado este mensaje.
>
> http://www.eset.com
>
> __ Información de ESET NOD32 Antivirus, versión de la base de firmas
> de virus 5575 (20101029) __
>
> ESET NOD32 A
ums linked to off that page. It looks like the
> npgsql folks primarily use forums and the tracker for user support.
>
Yeap. That's our primary support way.
But I also keep eye on general, dev and interfaces mailing list in
case something about Npgsql appears.
--
Regards,
Francis
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 set
l@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ll use this if there's no other way.
>>
>
> Just run them in one transaction.
> You can also just show the Next/Prev buttons and then do something just for
> the case where there is no data.
> Or use LIMIT 31 so you always know that there is the next page with at least
&g
y cast to either a string or an int and I
>> shouldn't have to worry about that. Thanks!!
>>
>> Mike
>>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Mar 26, 2010 at 1:02 AM, Allan Kamau wrote:
> A classic problem. I would like to assign integer values (from a
> sequence) to records in a table based on the order (of contents) of
> other field(s) in the same table.
Do you have a simple example? (create table, insert some data, then sho
pAdapter = new NpgsqlDataAdapter();
> NpAdapter.SelectCommand = new NpgsqlCommand(query, conn);
> NpAdapter.Fill(dset, "npdata");
> dtsource = dset.Tables["npdata"];
>
> deleteCmd();
> updateCmd();
> insertCmd();
> }
>
&
Hi,
We're evaluating Postgresql for a possible transition from MS SqlServer. We
have 100s of MS Sql servers and one way of replicating data changes is to use
MQ Series Queue management system, some servers who were recently changed to
Sql 2005 are using Service Broker. We're interested if there
is error if I use Npgsql?
>>
That's correct. But there may be a bug in Npgsql code itself.
That's why I asked you to try to raise minpoolvalue to check if you
see less errors.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http
ool values in your connection string. Try to put a higher
value of min connection pool, so they aren't closed too frequently.
Also, as Richard said, check your connection usage pattern in your application.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http:
ented methods. It is
strongly advised that current users update from Npgsql1 to Npgsql2"
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Sent from Brasilia, DF, Brazil
--
Sent v
On Tue, May 12, 2009 at 05:02, Richard Huxton wrote:
> Francisco Figueiredo Jr. wrote:
>>
>> Hi all!
>>
>> I was playing with "in (...)" and "= any (...)" queries and found a
>> difference between them and I wonder:
>>
>> why this
eger_column in (array[5,6]);
Although documentation says:
9.20.4. ANY/SOME
[...]
SOME is a synonym for ANY. IN is equivalent to = ANY.
[...]
I thought that if IN is equivalent to = any, both queries above should work.
Am I missing something?
Thanks in advance.
--
Regards,
Francisco Figueiredo
t;
> Thanks & regards,
>
> Peeyush Jain | Software Engineer –Netezza Dev | Persistent Systems Ltd
>
> peeyush_j...@persistent.co.in | Cell: +91 9373069475 | Tel: +91 (20) 3023
> 6762
>
> Innovation in software product design, development and delivery-
> www.persiste
ed recipient, you are not authorized to read, retain,
> copy, print, distribute or use this message. If you have received this
> communication in error, please notify the sender and delete all copies of
> this message. Persistent Systems Ltd. does not accept any liability fo
support for returning
setof refcursor. You can check examples about how to do that
in our user manual: http://manual.npgsql.org
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Jan 23, 2009 at 11:25 AM, Howard Cole wrote:
> Francisco Figueiredo Jr. wrote:
>>
>> About the memory issue of Npgsql, did you try to use a prepared
>> statement for this? We have some performance improvements when
>> handling bytea values but only when the Npg
have some performance improvements when
handling bytea values but only when the NpgsqlCommand.Prepare() method
is called.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-ge
gister
Npgsql as a dbproviderfactory.
Also note that Npgsql supports sqlclient parameter style with the '@'
prefix to easy porting sql code from sqlserver to postgresql.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.o
eiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
me path/dir variable?
>
I think you need to install the developer tools.
I compile postgresql from sources with no problem on osx 10.5.4 but I
installed developer tools before.
The library which is missing is the following:
> configure:2246: checking for C compiler default output file name
>
On Tue, Oct 14, 2008 at 1:18 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
>>> ERROR: invalid input syntax for type date: "infinity"
>>> I thought I could use it anywhere in my sql.
>
>
On Tue, Oct 14, 2008 at 12:58 PM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> It gives me the following error:
>
> ERROR: invalid input syntax for type date: "infinity"
>
> I thought I could use it anywhere in my sql.
>
> I have to add a cast to t
.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Aug 28, 2008 at 1:42 AM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> Hi all!
>
Any clues about this?
Thanks in advance.
> I'm playing with client thread abort issues in Npgsql. And with a test
> sample one of our users provided us we are seeing that
using Postgresql 8.3.3 on OSX 10.5.4
Thanks in advance for any advice about this issue.
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
es slower than with the
pool enabled.
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d by default.
>
> //Magnus
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.np
SELECT extract (epoch from your_time_field) from your_table;
SELECT to_timestamp(your_epoch_field) from your_table;
--
Valter Douglas Lisbôa Jr.
Sócio-Diretor
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
www.trenix.com.br
[EMAIL PROTECTED]
Tel. +55 19 3402.2957
Cel. +55 19 9183.424
On Thursday 03 July 2008 13:03:49 Joshua D. Drake wrote:
> On Thu, 2008-07-03 at 12:05 -0300, Valter Douglas Lisbôa Jr. wrote:
> > Hello all, I have a perl script thats load a entire day squid log to a
> > postgres table. I run it at midnight by cronjob and turns off the indexes
&
e the on-line inserting and do a job moving all
lines to the main indexed table at midnight.
My question is, Does exists a better solution, or this tatic is a good way to
do this?
--
Valter Douglas Lisbôa Jr.
Sócio-Diretor
Trenix - IT Solutions
"Nossas Idéias, suas Soluções!"
www.treni
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Apr 9, 2008 at 1:31 PM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> > >
> > >
> >
> > Ask the .npgsql mailing lists. They'll be able to tell you. There must be
> a
> > way of handling "non-standard" types in any
helps.
--
Regards,
Francisco Figueiredo Jr.
fxjr.blogspot.com
www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e fix for it.
Check it out here:
http://pgfoundry.org/forum/message.php?msg_id=1003377
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
fxjr.blogspot.com
www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr
hi, allow me to show-off my ignorance.. I think that logging via
'syslogd' and managing log files with 'logrotate' already meets the
requirements.
Alvaro Herrera wrote:
Perhaps we should add a log_file_group option, to which we would chgrp()
the log files.
regards, jr
companies
that support PostgreSQL. Just check out the PostgreSQL home page. So I don't
this this point is correct either.
If you don't get too much feed back on this subject, just remember that topics
like this come up frequently to the point of list me
--- On Tue, 1/29/08, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
>> other than defining a function such that I can write:
SELECT ( a-b ) as pippo
FROM Yourtable
WHERE ( a-b ) = 7
UNION ALL
SELECT ( a*b ) as pippo
FROM Yourtable
WHERE ( a*b ) < 12
AND a > 3
UNION
N KEY your_column
REFERENCES parent_table( primary_column )
ON UPDATE CASCADE;
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
y.
The other tables referenced this composite primary key as foreign keys using
referential integrity ON UPDATE CASCADE. This means that they database ~would~
maintain/enforce the object-type portion of the foreign key automatically for
you.
Regards,
Richard Broersma Jr.
---
--- On Mon, 1/7/08, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> wrote:
> > what is a botherboard?
>
> Brotherboard -- motherboard is a bit old.
Maybe a Freudian slip? ;)
---(end of broadcast)---
TIP 5: don't forget to increase your free space map s
--- On Mon, 1/7/08, Erik Jones <[EMAIL PROTECTED]> wrote:
> From: Erik Jones <[EMAIL PROTECTED]>
> Subject: Re: [GENERAL] many to one of many modeling question
> To: "Richard Broersma Jr" <[EMAIL PROTECTED]>
> Cc: "Postgres General List" , &
REIGN KEY (obj_id)
REFERENCES ONE OF o(id),
...
);
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
t; case that's the UPDATE, in the second it's the COMMIT.
Thanks for the help Tom. This information is good to know.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Sees NEW.
I was my understanding that all single DML statement are wrapped in their own
transaction so I thought that these two statements should preform the same.
Regards,
Richard Broersma Jr.--
-- PostgreSQL database dump
--
-- Started on 2008-01-02 05:35:55
SET client_encoding =
e non-committed records. I.E.
the record that should be equal to NEW is in fact equal to OLD.
Is this correct? Is there a way to adjust the visibility so that yet-to-be
committed tuples are seen by the trigger function?
Regards,
Richard Broersma Jr.
---(end of broa
this correct? Shouldn't it also return an error?
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
these posts are prefixed with [TLM].
I've noticed that one of the emails that I posted a couple of days ago was
reciently reposted with the prefix [TLM].
I wonder if someone is bouncing emails from this list.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
to alter the column on your table to
use your new type.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
---(end of broadcast)---
TIP 6: explain analyze is your friend
, my Postgresql directory was altered to be READ-ONLY. Once
this happened, postgresql wan't able to start.
After spending a quited a bit of time to dicover the cause of the problem, I
simply had to reset the directoy to be write-able.
I hope this helps.
Regards,
Richard Broersma Jr.
ys use tar to spit the
file up to make the transition a bit more manageable.
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 6: explain analyze is your friend
using a select statement.
This way the contents of the type can be seen in a base table. and it would be
easy to recreate the type when new elements are added or removed. I'll have to
play around with this in the future to see what is possible.
Regards,
Richard Broersma Jr.
--
1 - 100 of 475 matches
Mail list logo
