Alvaro Herrera writes:
> Maybe we should have another inter-backend signal: when a process gets
> ENFILE, signal all other backends and they close a bunch of files each.
I was wondering about that myself, but on balance I think it'd be a lot
of work to achieve not much. What you would have is th
On Fri, Aug 28, 2009 at 4:13 AM, Alvaro
Herrera wrote:
> Maybe we should have another inter-backend signal: when a process gets
> ENFILE, signal all other backends and they close a bunch of files each.
I wonder if this is a new problem due to the FSM and VM using up extra
file handles?
--
greg
Vick Khera wrote:
> On Tue, Aug 25, 2009 at 4:55 PM, Tom Lane wrote:
> > I've always thought that the fd.c layer is more about not having to
> > configure the code explicitly for max-files-per-process limits. Once
> > you get into ENFILE conditions, even if Postgres manages to stay up,
> > everyth
> Eg:
> I have a datatype in the DB which needs to be converted.
>
> DEC = 192
> BINARY = 1100
How about this
gwmdb=> select 192::bit(16);
bit
--
1100
(1 row)
Hope that helps
Allan
The material contained in this email may be confidential, p
Ow Mun Heng wrote:
Hi Guys,
Searching the net didn't give me much clues as to how to convert a Decimal
number into BINARY.
well, a decimal number is a fixed point number stored in a modified BCD
format, which optionally can contain a decimal fractional component.
you likely would want to
Hi Guys,
Searching the net didn't give me much clues as to how to convert a Decimal
number into BINARY.
Eg:
I have a datatype in the DB which needs to be converted.
DEC = 192
BINARY = 1100
DEC = 197
BINARY = 11000101
Which I then need to break down into pairs to do calculations on
11 : 0
On Thu, Aug 27, 2009 at 9:43 AM, Kelly Jones wrote:
> Many sites let you search databases of information, but the search
> queries are very limited.
>
> I'm creating a site that'll allow arbitrary SQL queries to my data (I
> realize I'll need to handle injection attacks).
>
> Are there other viable
Gauthier, Dave wrote on 27.08.2009 23:17:
Are there any GUI apps out there that can be used to edit (insert,
update, delete) table data? SOmething with enough smarts to sniff out
constraint violations and report accordingly. Also, ability to eval
constraints at commit time inside a transactio
Are there any GUI apps out there that can be used to edit (insert, update,
delete) table data? SOmething with enough smarts to sniff out constraint
violations and report accordingly. Also, ability to eval constraints at commit
time inside a transaction (option to rollback of course).
Thanks f
On Thu, 2009-08-27 at 16:28 -0400, Alan McKay wrote:
> Any ideas out there?
There is a ks file that I wrote for PostgreSQL Live CD's:
https://projects.commandprompt.com/public/pgcore/browser/livecd/PG84-Fedora-x86.ks
This may guide you. It is for Fedora-11, but you can easily move it to
RHEL 5.
On Aug 27, 2009, at 1:42 PM, Sergey Samokhin wrote:
Hello.
As I know upgrading database structure from one version to another is
usually done by applying some sql-script with a set of ALTER's that do
all the work.
But how do programmers guarantee that ALTER's they have wrote will
always be ap
> And within the directory for that repo, I've created a comps.xml file
And of course re-run "createrepo" ...
--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
Thanks Tom. That is what I suspected. I will install the branch tip on
Monday and see if the problem goes away.
Sean
Tom Lane wrote:
Sean Foreman writes:
We recently upgraded postgres from 8.1 to 8.4.
One of our queries stopped working and after some digging I've narrowed
the problem dow
This is not an autocast issue. These are all integers.
The query plan postgres is choosing to execute looks questionable. I
have provided an example of a working query and non-working query. The
change is subtle and takes advantage of the questionable query plan to
get the results I need. The
Hello.
As I know upgrading database structure from one version to another is
usually done by applying some sql-script with a set of ALTER's that do
all the work.
But how do programmers guarantee that ALTER's they have wrote will
always be applied by administrators to the corresponding version of
Sean Foreman writes:
> We recently upgraded postgres from 8.1 to 8.4.
> One of our queries stopped working and after some digging I've narrowed
> the problem down to this:
> select
> count(customer.customer_id)
> from
> acquire.customer customer
> inner join entity_setup.merchant_set
On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman wrote:
> We recently upgraded postgres from 8.1 to 8.4.
>
> One of our queries stopped working and after some digging I've narrowed the
> problem down to this:
>
> table structure of interest:
>
> merchant_set
> merchant_set_id
>
> merchant
> merchant_i
Alvaro Herrera wrote:
Rob Sargent escribió:
tablelog doesn't appear any more lively than the OPs audittrail2.
Perhaps, but I have heard of people using it successfully recently,
whereas Nathaniel reported that audittrail2 seems to have obvious bugs.
Fair enough.
--
Sent via p
Hey folks,
I realise this is probably more a matter for a kickstart list, but
then again, I have to think that someone else on this list has done
this and can help. So I'll ask here and there.
I'm dragging our company kicking and screaming into the realm of
Kickstart/Anaconda, and trying to get
Hello, Tom.
On Thu, Aug 27, 2009 at 5:25 AM, Tom Lane wrote:
> Yes, if it's submitted as a single Query message, that's what happens.
>
Thanks for the detailed explanation.
--
Sergey Samokhin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscr
There is no error message. Posgres "likes" the query. In this case, the
query returns a count of 1 instead of 3562.
Scott Marlowe wrote:
On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman wrote:
We recently upgraded postgres from 8.1 to 8.4.
So, is there an error message you get back? Or
On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman wrote:
> We recently upgraded postgres from 8.1 to 8.4.
So, is there an error message you get back? Or just no data?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
We recently upgraded postgres from 8.1 to 8.4.
One of our queries stopped working and after some digging I've narrowed
the problem down to this:
table structure of interest:
merchant_set
merchant_set_id
merchant
merchant_id
merchant_set_id
customer
customer_id
merchant_set_id
-- failure (c
Sam Mason wrote on 27.08.2009 21:51:
The information is all in the system catalogs; I've not had much
opportunity to fiddle with them so far but the following may be a start
to help get things out for you.
SELECT c.relname, a.attname, t.relname
FROM pg_class c, pg_depend d, pg_class t, pg_at
On Thu, Aug 27, 2009 at 09:18:57PM +0200, Thomas Kellerer wrote:
> I'm trying to extend the Postgres support in my SQL tool. I'm trying to
> recreate the SQL for a sequence, and I wonder if there is a way to find
> out the column to which a sequence "belongs".
The information is all in the syst
Rob Sargent escribió:
> tablelog doesn't appear any more lively than the OPs audittrail2.
Perhaps, but I have heard of people using it successfully recently,
whereas Nathaniel reported that audittrail2 seems to have obvious bugs.
--
Alvaro Herrerahttp://www.Comman
Hi,
I'm trying to extend the Postgres support in my SQL tool. I'm trying to recreate the SQL for a sequence, and I wonder if there is a way to find out the column to which a sequence "belongs".
I'm talking either about sequences that are created automatically by PG when
using the serial datat
Sam Mason wrote on 27.08.2009 21:06:
The OP leaves it somewhat open, but wouldn't date_trunc be better here?
Otherwise you'll end up getting values for other years as well as the
current one.
Good point, I didn't think of that :)
As an alternative, one could explicitely add the year into the
On Thu, Aug 27, 2009 at 11:09:36AM -0700, BlackMage wrote:
> The field I am using for sorting is a Date type with the format -mm-dd
> hh:mm:ss .
Values that look like that are normally stored in timestamp columns, not
date column. You wouldn't get the time part if it was just a date.
--
S
On Thu, Aug 27, 2009 at 08:36:45PM +0200, Thomas Kellerer wrote:
> BlackMage wrote on 27.08.2009 20:09:
> >I only want to select events happening for the current week(Mon-Sun).
>
> SELECT *
> FROM the_table
> WHERE extract(week from the_date_column) = extract(date from current_date);
The OP leave
On Thu, Aug 27, 2009 at 11:09:36AM -0700, BlackMage wrote:
>
> Hey all,
>
> I've been trying to figure this problem out with just using sql but I'm not
> sure how too. I have a table that holds events for each week but I only want
> to select events happening for the current week(Mon-Sun). So can
you need to group dates per number week
2009/8/27 Edwin Plauchu
> Postgresql has these functions
> http://www.postgresql.org/docs/8.1/static/functions-formatting.html for
> formatting data time
>
>
> 2009/8/27 BlackMage
>
>
>> Hey all,
>>
>> I've been trying to figure this problem out with just
Postgresql has these functions
http://www.postgresql.org/docs/8.1/static/functions-formatting.html for
formatting data time
2009/8/27 BlackMage
>
> Hey all,
>
> I've been trying to figure this problem out with just using sql but I'm not
> sure how too. I have a table that holds events for each
BlackMage wrote on 27.08.2009 20:09:
I've been trying to figure this problem out with just using sql but I'm not
sure how too. I have a table that holds events for each week but I only want
to select events happening for the current week(Mon-Sun). So can anyone help
me out with this just using sq
tablelog doesn't appear any more lively than the OPs audittrail2.
Alvaro Herrera wrote:
Nathaniel Smith wrote:
What do others use to accomplish this? Do most pg users just write
triggers by hand? Or is there some nice auditing module that Google
just isn't revealing to me?
I think ta
Hey all,
I've been trying to figure this problem out with just using sql but I'm not
sure how too. I have a table that holds events for each week but I only want
to select events happening for the current week(Mon-Sun). So can anyone help
me out with this just using sql? I've accomplished it sort
Nathaniel Smith wrote:
> What do others use to accomplish this? Do most pg users just write
> triggers by hand? Or is there some nice auditing module that Google
> just isn't revealing to me?
I think tablelog (to be found in pgfoundry too) is the most commonly
used audit module.
--
Alvaro Herre
Howdy,
(cross-posted to the pg.sql and pg.general lists)
I'm looking to set up an audit trail system--ie, logging every
INSERT/UPDATE/DELETE on a given table and tracking how the data
changes over time. I know I could do it by hand using triggers, but was
hoping to save a little time using someth
Joshua Tolley wrote:
I've never heard of the first two, as far as I can recall. T-SQL is quite
common, however (http://en.wikipedia.org/wiki/Transact-SQL), but although I've
never used it, I seriously doubt it will make things any more user friendly.
TransactSQL, sometimes called TSQL, is MS
>> There are actually no "real" data changes being made on your master
>> for some reason. So every time archive_timeout is reached a log full
>> of no changes is shipped to your slave and applied - and no checkpoint
>> times are changed for reasons I mentioned above.
>>
>>
>
> thanks, but we have
Dave,
The free and open-source SchemaCrawler for PostGresql tool will do
what you need. SchemaCrawler outputs details of your schema (tables,
views, procedures, and more) in a diff-able plain-text format (text,
CSV, or XHTML). SchemaCrawler can also output data (including CLOBs
and BLOBs) in the s
Check Talend for your training needs on an ETL tool.
Go look at the training page: http://www.talend.com/services/training.php
tv-8 wrote:
>
> I guess Talend (Open Studio) might be the right choice. But I do not have
> direct experience with the training.
>
> see www.talend.com
>
>>
>> Hi a
On Thu, Aug 27, 2009 at 06:43:51AM -0700, Kelly Jones wrote:
> Are there other viable ways to query data? I read a little on
> "Business System 12" (BS12), Tutorial D, and even something called
> T-SQL (I think), but they all seem theoretical and not fully
> implemented.
>
> I want a query languag
On Thu, Aug 27, 2009 at 8:43 AM, Kelly Jones wrote:
> Many sites let you search databases of information, but the search
> queries are very limited.
>
> I'm creating a site that'll allow arbitrary SQL queries to my data (I
> realize I'll need to handle injection attacks).
>
> Are there other viable
Hibernate is a ORM technology which configures bean classes which will
construct DB statements based on the method(create,replace,update,delete) from
the bean class attributes(columns)
to quote
"Hibernate allows you to express queries in its own portable SQL
extension (HQL), as well as in nativ
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).
Are there other viable ways to query data? I read a little on
"Business System 12" (BS
On 27/08/2009 00:18, Mark Kirkwood wrote:
Sébastien Lardière wrote:
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
Hi All,
I've a cluster ( Pg 8.3.7 ) with WAL Shipping, and a few hours ago,
the master had to restart.
I use walmgr from Skytools, which works very well.
47 matches
Mail list logo
