.
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
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
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
.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
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
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
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
;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 &
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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]*
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 ?
&
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
> 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
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
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.
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
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
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/
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
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
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
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
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
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)---
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
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
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
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
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.
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.
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
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
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
> (
>
?
>
> 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.
> 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
on with them.
--
Jorge Godoy <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part.
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
--
> 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
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
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
,
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,
--
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
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
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]>
--
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
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
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
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
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]>
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
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)--
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"
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]>
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
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
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
; 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)
"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
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]>
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
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
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)
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
===
(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
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)---
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
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
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
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
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
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]
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
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
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
its fast & quick tho :-)
Indeed.
Be seeing you,
--
Jorge Godoy <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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
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)
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
nking about referential integrity with those files?
--
Jorge Godoy <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: explain analyze is your friend
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 - 100 of 214 matches
Mail list logo