Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows

2007-07-01 Thread Jorge Godoy
. This looks like that old Windows bug. Try using "Document~1" as the directory name. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Can't change working directory to C:/Documents and Settings in Windows

2007-07-01 Thread Jorge Godoy
variation like that (I've seen ~2 due to some unknown reason). This looks like a Windows problem on finding directories with spaces in its name. The same happens with diacriticals... -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Accent-insensitive search

2007-07-12 Thread Jorge Godoy
e world to have to use it and code things by yourself, but it works. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMA

Re: [GENERAL] Suse RPM's

2007-08-03 Thread Jorge Godoy
.13 ones for 10.0. I usually get a .src.rpm, the tarball and run rpmbuild -bb. It works fine and I have new packages very fast. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Suse RPM's

2007-08-03 Thread Jorge Godoy
hand, but would definitely draw more attention to OpenSuSE... I had a few cases where it had to be handed down because of the lack of updates -- not security related, of course -- to "older" releases). -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broa

Re: [GENERAL] ON UPDATE trigger question

2007-09-12 Thread Jorge Godoy
e a huge table you might want to add a WHERE clause: "WHERE my_val IS NOT NULL". -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Partial index with regexp not working

2007-09-12 Thread Jorge Godoy
ID and have "(anonymous)" when you have the IP address on the table (maybe even NULL, it all depends on what you want). -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Postgresql and SSL

2007-09-20 Thread Jorge Godoy
;krb5", "ident", "pam" or "ldap". Note that "password" sends passwords # in clear text; "md5" is preferred since it sends encrypted passwords. At least, this is what I understand by "client certificate"... -- Jorge Godoy &

Re: [GENERAL] Postgresql and SSL

2007-09-20 Thread Jorge Godoy
On Thursday 20 September 2007 11:41:00 Tom Lane wrote: > "Albe Laurenz" <[EMAIL PROTECTED]> writes: > > Jorge Godoy wrote: > >> Even though one can require connections using only SSL on the > >> server side, I don't see a method (in pg_hba.conf) tha

Re: [GENERAL] COPY for .CSV files problem

2007-10-01 Thread Jorge Godoy
is data as a field in the table (otherwise, problems with COPY). Maybe > can I use catalog? COPY won't allow you to process your data. You either write something to insert record by record or you change your data to include the needed information before using COPY. I would change t

Re: [GENERAL] Design Question (Time Series Data)

2007-10-04 Thread Jorge Godoy
umns (if you're searching using the value as a parameter, then index it as well) and this would be the basis of my design for this specific condition. Having good statistics and tuning autovacuum will also help a lot on handling new inserts and deletes. -- Jorge Godoy <[EMAIL PRO

Re: [GENERAL] Suggestions for Remote Procedure Calls from PG, please?

2007-10-18 Thread Jorge Godoy
allow you to retrieve the row that has been changed and take your action based on that. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] running postgres

2007-10-18 Thread Jorge Godoy
ill post it. > > > > Sorry again.. > > > > Ken > > We'll put it down as "thinking out loud" then. It happens. ;-) OK... But was it harder or easier than MS SQL Server? :-) -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broad

Re: [GENERAL] Crosstab Problems

2007-10-18 Thread Jorge Godoy
TICE? If I were using it and having this problem I'd rather have an ERROR. It isn't uncommon for people not look at their logs and it isn't uncommon for them just run command from some language using a database adapter that might not return the NOTICE output.

Re: [GENERAL] select count() out of memory

2007-10-25 Thread Jorge Godoy
Putting the data inside the DB fast is part of the solution, getting it out fast to be processes / analyzed is another part. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Have you searched our list archiv

Re: [GENERAL] print command in sproc

2007-10-29 Thread Jorge Godoy
Em Tuesday 23 October 2007 07:17:53 Goboxe escreveu: > Hi, > > What is the equivalent MSSQL 'print' command in pg sproc? What does the MSSQL 'print' command "prints"? -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broad

Re: [GENERAL] Postgres SQL Client for Suse Linux

2007-10-29 Thread Jorge Godoy
ux. Sure! A lot of them. They include psql, OpenOffice.org, gda, ODBC and other. If you can be more specific it will be easier to help you. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Populating large DB from Perl script

2007-11-01 Thread Jorge Godoy
you have to respect the order you need to restore your data. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] any way for ORDER BY x to imply NULLS FIRST in 8.3?

2007-11-08 Thread Jorge Godoy
ich is not very intuitive. I vote for sort_nulls_first defaulting to > false in order not to break bc. But then, when ordering by login date, you should use COALESCE and infinity for them (http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html). -- Jorge Godoy

Re: [GENERAL] any way for ORDER BY x to imply NULLS FIRST in 8.3?

2007-11-11 Thread Jorge Godoy
rmance gets better and better every time I optimize *any* of the two sides: application or database. It is always an enhancement, as if I was coding things directly by hand. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] view management

2007-11-18 Thread Jorge Godoy
issued to prevent that need of dropping and recreating all dependent objects it would be great. A suboptimal alternative would be allowing the number of columns be greater than it was before -- i.e., add new columns to the view --, but block name changes for those columns and removing colu

Re: [GENERAL] plpython array support

2007-11-19 Thread Jorge Godoy
sure, but I think that on 7.4 I already had code with arrays inside the database... -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Recommendations for a datasync scenario ?

2007-12-02 Thread Jorge Godoy
heir PK, so that there are no clashes and you don't need to rely on sequences and the correct value being used everywhere. It is the same kind of problem that we have on supermarkets and POSs: the POS has to sell even if the connection with the server is down. -- Jorge G

Re: [GENERAL] Hijack!

2007-12-12 Thread Jorge Godoy
uess something that is there shouldn't be? :-) Always a good reference: http://www.goldmark.org/jeff/stupid-disclaimers/ -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Hijack!

2007-12-12 Thread Jorge Godoy
as > top-posters, except it is much worse because the actual text they wrote > is harder to find. The worst thing is people who bottom-posts at top-posted messages... Can you see the mess? -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

2007-12-13 Thread Jorge Godoy
ice if you could get ready before they tell you that they want doing some pF correction on the facility and you need to have that counted as well. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Better alternative for Primary Key then serial??

2007-12-13 Thread Jorge Godoy
to > updates??? Shouldn't the definition of a primary key be an immutable thing that is unique to the row? If you change it, then it is not immutable anymore... You can also have triggers to prevent PK updates... But I wouldn't go this route. Why are you needing updating the PKs

Re: [GENERAL] Linux

2010-11-04 Thread Jorge Godoy
better in your environment. I am more prone to use SuSE (SLES) as I have OpenSuSE on my laptop for years now. -- Jorge Godoy On Thu, Nov 4, 2010 at 13:00, Michael Gould < mgo...@intermodalsoftwaresolutions.net> wrote: > I know that this is probably a "religion" issue bu

Re: [GENERAL] Copy From suggestion

2010-12-20 Thread Jorge Godoy
With OpenOffice.org that 65K limit goes away as well... I don't know why it is still like that today for MS Office... It is almost 2011 and they still think 64K is enough? :-) -- Jorge Godoy On Mon, Dec 20, 2010 at 11:49, Mark Watson wrote: > Thanks, Adrian, > > I’ll

Re: [GENERAL] How to generate unique invoice numbers for each day

2011-01-15 Thread Jorge Godoy
Use a sequence. -- Jorge Godoy 2011/1/15 Andrus Moor > Invoice numbers have format yymmddn > > where n is sequence number in day staring at 1 for every day. > > command > > SELECT COALESCE(MAX(nullif(substring( substring(tasudok from 7), > '^[0-9]*&#x

Re: [GENERAL] How to generate unique invoice numbers foreach day

2011-01-15 Thread Jorge Godoy
Why would you do that? You can always reset the sequence at the end of the day. -- Jorge Godoy On Sat, Jan 15, 2011 at 17:09, Andrus Moor wrote: > There are 365 days in year. > Do you really think pre-creating sequence for every day for every year is > best solution ? &

Re: [GENERAL] Trigger vs web service

2011-04-05 Thread Jorge Godoy
d. If you have code in the database, then checking how this specific function works there would also be worth a shot. -- Jorge Godoy On Tue, Apr 5, 2011 at 09:16, Marc-André Goderre wrote: > > > I receive a long string (about 1 per second) than content many information. > For the

Re: [GENERAL] [OT] "advanced" database design (long)

2008-02-04 Thread Jorge Godoy
> are more efficient. I'd say 1 byte every 8 NULLs instead of 1 bit. If you only have 1 NULL, it will cost you 1 byte (not 1 bit). If you have 9, it will cost you 2 bytes (not 9 bits). -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] PGSQL ERROR: FATAL: terminating connection due to administrator command

2008-02-04 Thread Jorge Godoy
ackend that was serving my application. Enable query logging and see what is happening. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nom

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Jorge Godoy
Em Monday 04 February 2008 14:38:31 Csaba Nagy escreveu: > Why don't you go ahead and create those special lists and make general > collect all of them ? Some sort of hierarchy of lists... if doable at > all, that could make everybody happy... That's an excellent idea.

Re: [GENERAL] Universal libpq.a ?

2008-02-05 Thread Jorge Godoy
he hardest part: "that Tom would approve" :-) -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] the feasibility of sending email from stored procedure in Postgres

2008-02-17 Thread Jorge Godoy
FY as an useful tool for sending emails, though. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so th

Re: [GENERAL] longest prefix match

2008-02-20 Thread Jorge Godoy
you don't always receive area code, country code, etc.) -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL]

2008-02-20 Thread Jorge Godoy
wn. Maybe the titles should allow guessing the contents better... Or maybe some items should be promoted to an upper level :-) It is very uncommon to go up to the latest level of an index in a summary. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadca

Re: [GENERAL] PostgreSQL 8.3.0 RPMs are available for download

2008-02-22 Thread Jorge Godoy
still just the client and server, without the bells and whistles :-) If you use other packages that depend on PG you can't use these. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] need some help on figuring out how to write a query

2008-02-22 Thread Jorge Godoy
oday: SELECT INTO weeks_avg avg(value) FROM table WHERE date BETWEEN start_date AND start_date+'10 weeks'::interval; start_date:=start_date + '1 week'::interval; END WHILE; Start from that and you'll have it done. (Of course, above is pseudo co

Re: [GENERAL] need some help on figuring out how to write a query

2008-02-23 Thread Jorge Godoy
gt; they want. Then just add more parameters to your function. Instead of just start date also include an optional period, in weeks, days, hours, whatever you think is the better granularity for this. So, in your interface, add the period and make "10" the default value

Re: [GENERAL] Connect to postgres from a dynamic IP

2008-03-03 Thread Jorge Godoy
phy such as SSL for that. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Connect to postgres from a dynamic IP

2008-03-03 Thread Jorge Godoy
specially to authenticate the connection. Opening your access to everyone without crypto sounds like something you don't want to do. Specially if users can change their own passwords... -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)---

Re: [GENERAL] Connect to postgres from a dynamic IP

2008-03-03 Thread Jorge Godoy
he channell -- be it with SSL or SSH, for example -- will prevent the sniffer from being able to capture the hash, so your password will be safer. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: don't forget

Re: [GENERAL] Using tables in other PostGreSQL database

2008-03-27 Thread Jorge Godoy
e is insterested on the history for the same month but comparing it to the last three years history? A big mess... -- Jorge Godoy <[EMAIL PROTECTED]> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Check if table or View exists

2008-03-31 Thread Jorge Godoy
e the client schema first in the search path. Then, you should just call the function and it would follow the search path order and give you what you want without having to check anything. -- Jorge Godoy <[EMAIL PROTECTED]> -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Source RPM for 8.3.3?

2008-06-14 Thread Jorge Godoy
gh... But I believe that it wouldn't be hard to have it added to the list. Specially to have more people using those "standard" RPM packages for all the distributions above. Regards, -- Jorge Godoy <[EMAIL PROTECTED]> -- Sent via pgsql-general ma

Re: [GENERAL] Database design questions

2008-06-18 Thread Jorge Godoy
reads instead of 1 thread for > all my questions? I would submit all of the questions in separate messages. It is tiresome to read everything, you'll loose a lot of context after one or two messages levels or reply and people won't read the email because of its size.

Re: [GENERAL] Probably been asked a hundred times before.

2008-06-24 Thread Jorge Godoy
compile PG myself than switch to Fedora just because of a PostgreSQL package. Generating new RPMs / updating existing ones isn't so hard. -- Jorge Godoy <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part.

[GENERAL] Using WITH queries on VIEWs

2009-08-30 Thread Jorge Godoy
Hi! Is it possible to use WITH queries ( http://www.postgresql.org/docs/8.4/interactive/queries-with.html) on VIEWs? I have a rather complex view that I could optimize with it... Regards, -- Jorge Godoy

Re: [GENERAL] Cannot access various Postgres sites

2010-04-17 Thread Jorge Godoy
Make 8.8.4.4 primary and 8.8.8.8 secondary and try again. You can also try using OpenDNS servers. -- Jorge Godoy On Sat, Apr 17, 2010 at 11:57, Eric Ridge wrote: > I'm only subscribed to -general and -hackers, so if this message should go > to a different list, please feel fr

Re: [GENERAL] Good candidate query for window syntax?

2010-09-10 Thread Jorge Godoy
Have you checked the OVERLAPS operator in the documentation? http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html -- Jorge Godoy On Fri, Sep 10, 2010 at 10:03, Ketema Harris wrote: > Hello, I have a table defined as: > > CREATE TABLE demo AS > ( >

Re: [GENERAL] upgrading from 8.1.4 to 8.3.3

2008-08-28 Thread Jorge Godoy
? > > Is there a more apropriate approach ? The dump & restore approach for major version upgrades is the appropriate, correct and documented way to upgrade. Check the docs and it is there. -- Jorge Godoy <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] storing repeating dates / events

2008-09-06 Thread Jorge Godoy
> this? Along with the timestamp store a boolean that indicates if the event should consider the year or not. But you might surely design it better, specially for things that repeat on intervals other than yearly. -- Jorge Godoy <[EMAIL PROTECTED]> signature.asc Descript

Re: [GENERAL] storing repeating dates / events

2008-09-06 Thread Jorge Godoy
on with them. -- Jorge Godoy <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] Experience with many schemas vs many databases

2009-11-15 Thread Jorge Godoy
became simpler and fast enough. This also allowed me to work with some other aggregates that provided very useful "global" statistics. -- Jorge Godoy On Sun, Nov 15, 2009 at 04:28, undisclosed user wrote: > Hello everyone, > > I have hit a wall on completing a solut

Re: [GENERAL] Shall I apply normalization in the following case?

2010-02-03 Thread Jorge Godoy
-- > width > area depth volume And so on. You'd benefit from a normalized structure, you'd have constraints checking for valid units and types and you wouldn't need join to get the resulting information. -- Jorge Godoy On Wed, Feb 3, 201

Re: [GENERAL] serial columns with replication/cluster

2010-02-04 Thread Jorge Godoy
Sean, take a look at UUID type. It might suit you better than serial. Changing the increment also works, but puts a lot of restrictions on you (such as planning to prevent collision, having to change the increment on several nodes when adding a new node, etc.). Regards, -- Jorge Godoy

Re: [GENERAL] General Question about database -- redirection

2010-04-15 Thread Jorge Godoy
create database db_1 template db_2; This will create a new DB_1 using DB_2 as template. Otherwise, you'll change your code to connect to DB_2 instead of connecting to DB_1. -- Jorge Godoy On Thu, Apr 15, 2010 at 14:49, akp geek wrote: > dear all - > > I am n

[GENERAL] Documenting stored procedures and functions

2006-09-26 Thread Jorge Godoy
, updates/versioning, etc. I'm starting to create some internal standard to do that and it there are any tools -- preferably multiplatform, including specially Windows and Linux -- to help with that I'd greatly appreciate any recommendations. Be seeing you, --

Re: [GENERAL] Documenting stored procedures and functions

2006-09-27 Thread Jorge Godoy
todoc/. It might fit my needs, with some work done with comments. :-) -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Expected accuracy of planner statistics

2006-09-29 Thread Jorge Godoy
cuum et al from > messing it up. It could not touch these setting if the specific command isn't called, it could gain a new parameter "VACUUM FULL N_DISTINCT ..." to touch it (and then we probably discard the extra command / function) or it could update these settings when called with ANA

Re: [GENERAL] using schema's for data separation

2006-09-29 Thread Jorge Godoy
as they are > released. I'd avoid modifying source code and go with either a function or view. All queries should be against those and they'd fail if the id is missing. All filtered tables should have an index on such id, of course... -- Jorge Godoy <[EMAIL PROTECTED]> --

Re: [GENERAL] memory issues when running with mod_perl

2006-10-01 Thread Jorge Godoy
Andreas Rieke <[EMAIL PROTECTED]> writes: > It's 2.6.13-15. Thus, if we have a kernel bug, the newest known leaky > version is 2.6.13-15, whereas the oldest fixed version should be 2.6.16.27. I have a few servers with 2.6.16.21 and I don't see the problem as wel

Re: [GENERAL] increment row number function question

2006-10-07 Thread Jorge Godoy
Matthew Peter <[EMAIL PROTECTED]> writes: > Hello. I need a way to return an iterator result as a column eg, > SELECT increment() as ii, some_col from some_tbl order by some_col desc limit > 50; Use a sequence for the iterator. -- Jorge Godoy &l

Re: [GENERAL] more anti-postgresql FUD

2006-10-10 Thread Jorge Godoy
Tom Lane <[EMAIL PROTECTED]> writes: > Some days I think database independence is a myth. I believe it is as real as Santa Claus and the Easter Bunny. All of us know that those three exist, right? :-) -- Jorge Godoy <[EMAIL PROTECTED]> ---(e

Re: [GENERAL] more anti-postgresql FUD

2006-10-10 Thread Jorge Godoy
ts (I doubt that a developer who optimizes his code for MySQL and says that on his website will have read about optimizing PG and done something like that). Using PG's advanced features (specially triggers, functions and rules) will make it MUCH better than having to deal with things a

Re: [GENERAL] Versioning/updating schema

2006-10-11 Thread Jorge Godoy
rate a script that went from one situation to the other. I haven't put my hands on that to see if it really works, though... There's something that Pentaho can do (another developer told me he used it for doing that). -- Jorge Godoy <[EMAIL PROTECTED]>

Re: RES: [GENERAL] Dates rejected

2006-10-16 Thread Jorge Godoy
that weren't updated / fixed by their administrators are showing this problem. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jorge Godoy
ere's no way to decrypt it besides a brute force attack or something like that. If he's got, e.g., 10 users with strong passwords this kind of thing can take some weeks. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--

Re: [GENERAL] Database users Passwords

2006-10-17 Thread Jorge Godoy
on must be linked with -lcrypt. CONFORMING TO SVID, X/OPEN, 4.3BSD, POSIX 1003.1-2001 Well... I suppose DES is not Enigma, but I may be wrong. I just quoted this "extension"

Re: [GENERAL] plpython

2006-10-27 Thread Jorge Godoy
eted version ? I hope never, otherwise we loose some facilities. You understood the concept of 'safe' and 'unsafe' in PostgreSQL's docs, right? It might not be what you're thinking. Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]>

[GENERAL] Isolation / Visibility inside a trigger

2006-11-03 Thread Jorge Godoy
BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED; Any hints would be greatly appreciated. Thanks in advance, -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Isolation / Visibility inside a trigger

2006-11-03 Thread Jorge Godoy
n, the answer to my question is that even inside the same transaction or receiving the NEW row those functions called by the trigger shouldn't see the information. Did I get it right? Thanks Martijn! -- Jorge Godoy <[EMAIL PROTECTED]> pgpuxBZdb6n9U.pgp Description: PGP signature

Re: [GENERAL] Isolation / Visibility inside a trigger

2006-11-03 Thread Jorge Godoy
Martijn van Oosterhout writes: > On Fri, Nov 03, 2006 at 10:24:21AM -0300, Jorge Godoy wrote: >> But then, the answer to my question is that even inside the same transaction >> or receiving the NEW row those functions called by the trigger shouldn't see >> the inform

Re: [GENERAL] Can PostgreSQL notify a client that a trigger has fired?

2006-11-08 Thread Jorge Godoy
; raise client event I have the impression that you're missing a lot of sections in the manual... How about some time to re-read it? http://www.postgresql.org/docs/8.1/interactive/sql-notify.html -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)

Re: [GENERAL] Can PostgreSQL notify a client that a trigger has fired?

2006-11-09 Thread Jorge Godoy
"Bill" <[EMAIL PROTECTED]> writes: > Jorge Godoy wrote: > >> I have the impression that you're missing a lot of sections in the >> manual... How about some time to re-read it? > > I don't know about you but for me a 1500 page manual is at l

Re: [GENERAL] Why overlaps is not working

2006-11-09 Thread Jorge Godoy
give correct results ? It might give you false positives... 2006-11-30 -- 2006-12-05 AND2006-12-06 -- 2006-12-15 (original) -- FALSE 2006-11-29 -- 2006-12-06 AND2006-12-05 -- 2006-12-16 (changed) -- TRUE Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]>

Re: [GENERAL] Why overlaps is not working

2006-11-09 Thread Jorge Godoy
ps bool) as $_$ SELECT (($3 between $1 and $2) or ($4 between $1 and $2)); $_$ language sql; Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [GENERAL] Why overlaps is not working

2006-11-11 Thread Jorge Godoy
u can time it. :-) But I don't believe it will be too slow since it is a simple operation... -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Why overlaps is not working

2006-11-11 Thread Jorge Godoy
d work for you, but instead of using NULL to > represent infinity, why not use 'infinity' to represent infinity? If he casts all his dates to timestamps then this might be a good option. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)

Re: [GENERAL] DB Designer??

2006-11-12 Thread Jorge Godoy
ts using 5K tables know what I mean :-)) It shouldn't be -- graphically -- all that hard to implement this separation... So I believe it might be something they hold a patent for because I've never seen another tool with this feature. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Why isn't it allowed to create an index in a schema other than public?

2006-11-12 Thread Jorge Godoy
=== (I wouldn't mind if the autogenerated index for the PK was created on the public schema if no specific name was supplied.) This would also help identifying all objects to make a certain feature available and where they belong to on the database... TIA, -- Jorge Godoy

Re: [GENERAL] Why isn't it allowed to create an index in a schema other than public?

2006-11-12 Thread Jorge Godoy
ere's some reason (such as performance gain, for example) for that decision. Using this approach, though, doesn't group all items that belong to a schema inside of it. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)---

Re: [GENERAL] Why isn't it allowed to create an index in a schema other than public?

2006-11-12 Thread Jorge Godoy
n says: D'oh! :-) I've seen it now... I just can't specify where the index should go, it always goes with the table... That's fine... My fault... I need to rest on the weekend, not start having those crazy ideas about where indices go... :-) -- Jorge Godoy <[EMAIL PROTECTED

Re: [GENERAL] Why isn't it allowed to create an index in a schema other than public?

2006-11-12 Thread Jorge Godoy
Tom Lane <[EMAIL PROTECTED]> writes: > Jorge Godoy <[EMAIL PROTECTED]> writes: >> I'd like to know if there's any reasoning for not allowing creating an index >> inside the same schema where the table is. > > Actually, you've got that exactly back

Re: RE : Re: [GENERAL] database design ...

2006-11-15 Thread Jorge Godoy
correct field... Also remember that barcode readers can be programmed to "press" TAB / ENTER after reading. If you're on a web application this might submit the form instantaneously so take care with that. Most of them come with a default to "press" ENTER after re

Re: [GENERAL] Multiple currencies in a application

2006-11-22 Thread Jorge Godoy
sent S&H costs, import / export taxes, etc. and how this will impact on the value you'll be showing to the user. This is just the tip of the iceberg, but I hope it helps a little to see what is important or not for you. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] IS it a good practice to use SERIAL as Primary Key?

2006-11-23 Thread Jorge Godoy
u anticipate > the use of more than 231 identifiers over the lifetime of the table. "" > http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-SERIAL What would be those "231 identifiers"? -- Jorge Godoy <[EMAIL PRO

Re: [GENERAL] Male/female

2006-12-08 Thread Jorge Godoy
ortant, then there should be some way to point that. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED]

Re: [GENERAL] Male/female

2006-12-08 Thread Jorge Godoy
to inform the gender. To cover all these possibilities with one single column we need a set of discrete states. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Numeric or Integer for monetary values?

2006-12-11 Thread Jorge Godoy
e a company) instead of truncation... Dealing with money is a really complex subject and requires a lot of planning. My recommendation is to get two decimal places more than needed to avoid rounding issues (and if you need truncation, the truncate only at the very end where you&#x

Re: [GENERAL] Creating multiple Rules for on update

2006-12-11 Thread Jorge Godoy
RULE with your filtering conditions AND add an unqualified RULE that is always run - use an unqualified RULE and call a function that will perform the action for you on the right tables I believe the second solution leads to cleaner code and is easier to update / debug. But I

Re: [GENERAL] Let's play bash the search engine

2006-12-18 Thread Jorge Godoy
its fast & quick tho :-) Indeed. Be seeing you, -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Database versus filesystem for storing images

2007-01-05 Thread Jorge Godoy
u guarantee that on a failure all needed data is restored? I mean, how do you handle integrity with data outside the database? -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please sen

Re: [GENERAL] Database versus filesystem for storing images

2007-01-05 Thread Jorge Godoy
and without losing > anything. So there ;) Anyway, you have no guarantee that all your images exist on file and that all existing files have a corresponding entry in your database. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)

Re: [GENERAL] Database versus filesystem for storing images

2007-01-05 Thread Jorge Godoy
atabase. Not counting that depending on your choice of filesystem and image size you might get a very poor performance. -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Database versus filesystem for storing images

2007-01-05 Thread Jorge Godoy
nking about referential integrity with those files? -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Database versus filesystem for storing images

2007-01-05 Thread Jorge Godoy
corresponding entries on the database. Couting them is not enough since I can have one file with the wrong "name" present on the filesystem or some duplicate record on the DB... -- Jorge Godoy <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

  1   2   3   >