How do I "preload" perl modules so they are available in trusted pl/perl? The modules I want to use are not dangerous, they are typically utility routines like HTML::Entities, URI::Escape, and the like. Do I have to resort to plperlu for this and invoke "use HTML::Entities;" directly in the pl func
Andrus wrote:
> Will NTFS file system prevent all corruptions ? If yes, how to convert FAT32
> to NTFS without losing data in drive ?
iirc (i'm not on windows currently, google for the exact syntax),
at the dos prompt, type:
convert /fs:ntfs C:
and it will schedule a conversion after the next
Hi,
Our current project requires a fine-grained permission system (row-level
and possibly column-level as well). We have a pretty large (tens of
thousands) of users in the 'party' table. I'm thinking of choosing
Unix-style security for now (adding 'ugo' and 'owner' and 'group'
columns to each tabl
I need to check whether a SQL subexpression (to be used in WHERE
clause), e.g.:
colname > 200
or an entire SELECT statement, e.g.:
SELECT * FROM t1, t2 WHERE colname > 200
is syntactically valid. Is there a quick (and also safe) way to do this?
I'm thinking of doing "SELECT ... FROM ... WHERE
[EMAIL PROTECTED] wrote:
The trick is making database administration invisible to the user. Since
Firebird requires no administration, it's easy. The single file database
architecture in Firebird is also easy since you generally have only one
drive.
The decision not to create an embedded Postgres
John DeSoi wrote:
But on Windows 8.0 you can't run the postmaster with an administrative
account, correct? I really wish this was configurable in the PostgreSQL
settings (of course, defaulting to the way it is now).
I think there have been several threads debating this issue in the past
(on whet
Joshua D. Drake wrote:
Well that isnt exactly true. EXT3 is a bolt on to EXT2 which was always
there. Reiser is also a long time kernel at least from 2.2.
I remember first using reiser3 by patching early 2.4 kernels. IIRC,
reiser was not in linus tree until 2.4.7 or so (not sure which release)
a
Dann Corbit wrote:
True, but the standard says nothing about the creation of an index, so
you can make it behave in any way that you see fit.
But I thought we are talking about unique _constraint_ here (which is
certainly regulated by the standard).
--
dave
---(end of broa
Tzahi Fadida wrote:
I recommend you don't use ext3 for any database:
http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
apparently its still buggy.
So what is the recommended fs under Linux? I don't need the best
speed/throughput, but I prefer not to use ext2 due to long fsck time. I
also
Merlin Moncure wrote:
6. for large tables, you can get a pretty accurate count by doing:
select count(*) * 10 from t where random() > .9;
on my setup, this shaved about 15% off of the counting time...YMMV.
That's an interesting idea, using sampling to get an estimate.
Thanks for the tip.
--
dave
-
Martijn van Oosterhout wrote:
You misunderstand the TIMESTAMP WITH TIMEZONE type, it doesn't store
the timezone you gave it, it's just a point in time. Saying AT TIMEZONE
just converts it to a TIMESTAMP WITHOUT TIMEZONE with the local time it
was in the timezone you gave it. So you are complaring d
Sorry, hit Sent too early...
David Garamond wrote:
The Postgres manual says:
The AT TIME ZONE construct allows conversions of time stamps to
different time zones.
I'd guess most people would think what's meant here is something like
"unit conversion", and that the timestamp
The Postgres manual says:
The AT TIME ZONE construct allows conversions of time stamps to
different time zones.
I'd guess most people would think what's meant here is something like
"unit conversion", and that the timestamp value stays the same (much
like 2 feet becomes 24 inches when it's bein
John Ossmann wrote:
I'm not sure where to find it exactly, but does anyone know how much
data a column of type "text" in a postgres DB can hold?
it's in the manual, in the Data Types section. the manual says "around 1GB".
btw, TEXT is one of those postgres-specific features that makes you
stick (s
When a timestamp string input contains a timezone abbreviation (CDT,
PST, etc), which timezone offset is used? The input date's or today
date's? The result on my computer suggests the latter.
# create table ts (ts timestamptz);
# insert into ts values ('2004-10-17 00:00:00 CDT'); -- UTC-5
# inse
Vivek Khera wrote:
"GS" == Greg Stark <[EMAIL PROTECTED]> writes:
GS> David Garamond <[EMAIL PROTECTED]> writes:
GS> Another reason to move to 7.4.5 would be that each version
GS> introduced changes in behaviour. You're going to be dealing with
GS> minor he
Michael Glaesemann wrote:
In any case, one would never use NULL. Either the domain includes a
value for all possible values (including N/A) or you set up the db
schema appropriately.
Hm, that can be painful. What if I have ten optional attributes;
separate them to ten different tables?
Strictly?
Michael Glaesemann wrote:
For employees you don't have birthdates for, you could use NULL in SQL.
However, as relationally one shouldn't use NULL, you would do the
following:
CREATE TABLE employees (
emp_id SERIAL NOT NULL UNIQUE
, emp_name TEXT NOT NULL
);
CREATE TABLE employees_birthda
Peter Eisentraut wrote:
What is "text + text" supposed to do right now?
Nothing.
Then are these bugs? (7.4.5 and 8.0.0beta1 give same results). Frankly,
the current behaviour is quite strange to me.
--
=# select coalesce('1'+'0','NULL');
a
=# select coalesce('1'+'1','NULL');
b
=
Peter Eisentraut wrote:
Am Freitag, 8. Oktober 2004 07:22 schrieb Miles Keaton:
What's the prevailing wisdom & best-practice advice about when to let
a varchar (or any) column be NULL, and when to make it NOT NULL
DEFAULT '' (or '-00-00' or whatever) - in PostgreSQL?
Briefly, you always do the
Btw, MySQL manual used to recommend (or still does?) defining all
columns as NOT NULL as much as possible, "because NULL is slow"... :-)
For me it's pretty obvious, if you are never going to allow the column
to have an "unknown value", then define it NOT NULL to let the database
guarantee that.
What is "text + text" supposed to do right now? It doesn't seem very
useful to me. What about making "text + text" as an equivalent for "text
|| text"? Most strongly-typed programming languages do this. And MS SQL
Server too, I think (CMIIW).
--
dave
---(end of broadcast
Thomas Madsen wrote:
A quite impressive list of changes in version 8.0.0. ...
But the question from me is: When is it done?
Two words: Nobody knows. Beta cycle is usually at least 2-3 months.
First beta is in Aug. So a release is probably Nov at the earliest.
We have a lot of 7.2.5 versions runn
Joshua D. Drake wrote:
This brings up an interesting idea. What if it were possible to set
some kind of rules on DDL at database creation time? For example, I'd
like to be able to throw an error if somebody tries to name an object
any of the SQL keywords.
Other possible rules:
* Every table must
David Fetter wrote:
BTW, "id" is a terrible name for a column. Better call it foo_id.
I disagree with the idea that "id" is a terrible name for a column. The
only negative to it, is that you will have to be explicit in your
declarations when doing joins and such... ex:
SELECT * FROM foo
JOIN
Am I correct to assume that SERIAL does not guarantee that a sequence
won't skip (e.g. one successful INSERT gets 32 and the next might be 34)?
Sometimes a business requirement is that a serial sequence never skips,
e.g. when generating invoice/ticket/formal letter numbers. Would an
INSERT INTO
Tom Lane wrote:
At least in Linux, mysql replaces the password in the command line
argument with "" so you can't see them via "ps" nor via peeking
into /proc//cmdline.
There is a short period where the password is visible though.
Are there any other risks? Or is the reason for not doing
Tom Lane wrote:
Is it possible that we setup the password in the pg_dump command line
You might as well put it on a billboard --- anything in the command line
can be seen by anyone who runs "ps".
If you don't want to supply it manually, put it in ~/.pgpass.
At least in Linux, mysql replaces the pa
Does anyone know what the SQL standard say (or doesn't say) about
division by zero for NULL?
--
dave
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
Is there a function like IS_VALID_REGEX() to check whether a pattern is
valid (i.e. it compiles)? I'm storing a list of regex patterns in a
table. It would be nice to be able to add a CHECK constraint to ensure
that all the
Steve Atkins wrote:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
My experience with tsearch2 has been that indexing even moderately
large chunks of data is too slow to be feasible. Moderately large
meaning tens of megab
All of my non-superusers are restricted from creating databases.
Whenever I upgrade Postgres, I have to hand-edit my dump and change:
CREATE USER usr1 WITH SYSID 101 PASSWORD '...' NOCREATEDB NOCREATEUSER;
into:
CREATE USER usr1 WITH SYSID 101 PASSWORD '...' CREATEDB NOCREATEUSER;
and then af
Tom Lane wrote:
I think David is suggesting that the hypothetical attacker could gain
economies of scale in multiple attacks (ie, if he'd been able to steal
the contents of multiple installations' pg_shadow, he'd only need to
generate his long list of precalculated hashes once). I think this is
to
Tom Lane wrote:
I read that the password hash in pg_shadow is salted with username. Is
this still the case? If so, since probably 99% of all PostgreSQL has
"postgres" as the superuser name, wouldn't it be better to use standard
Unix/Apache MD5 hash instead?
How does that improve anything? If we
I'm pretty clueless in regard to the PostGIS situation. Will it be
integrated with PostgreSQL in the future? What are the benefits of using
the builtin geometry types (since they don't have R-tree indexes)?
--
dave
---(end of broadcast)---
TIP 4: D
Wouldn't it be cool if someday psql could do value completion?
# delete from person where lastname = 'Garam
# delete from person where lastname = 'Garamond' _
# delete from person where firstname = 'Da
# delete from person where firstname = 'Da
Damian Darren DaveDavidDawson
# delete
David Garamond wrote:
-- plruby 0.4.2, ruby 1.8.1, pg 7.4.3, linux
Just to note here that the plruby has fixed this issue. He apparently
does not read -general daily, so I'll post to ruby-talk mailing list in
the future.
--
dave
---(end of broa
Can psql be told to exit immediately after an error (especially when
doing commands from a file, -f)? This is the default behaviour of the
mysql client, except when we give it -f option ("force").
The problem is, when restoring a dump, a failure at the some point might
cause the subsequent comm
Is there anyone on this list who has preferred to use regexes from PL's
(e.g. plperl, plruby) in CHECK constraints or other places instead of
the flavor provided by Postgres? Do you find your approach satisfying?
Do you also do things like cache the pattern so you don't have to
compile the rege
David Garamond wrote:
2a. individual string values will be tagged with charset+encoding. this
incurs an overhead of 1-2 bytes per value.
forgot to add: this overhead is just for "in-memory" or temporary value
(e.g. when being passed as arguments). in the storage itself, this is
Stephan Szabo wrote:
Could you point me where in the archives can I read more? I'm having a
bit of trouble finding discussion on this. Thanks.
I didn't spend too much time looking, but there are a few that look like
they'll touch upon related issues:
http://archives.postgresql.org/pgsql-hackers/200
Stephan Szabo wrote:
in oracle 10g, you can issue:
ALTER SESSION SET NLS_COMP = ansi;
ALTER SESSION SET NLS_SORT = binary_ci;
do you think this is an elegant solution for case insensitive sorting &
searching? is there interest in seeing this in postgres?
IMHO, no on both questions. There's alway
- not transparent
- can't automatically make all values fed to SELECT case-converted
- not transparent
Pierre-Frédéric Caillaud wrote:
create a functional index on lower case value of your column.
ORDER BY lower case value of your column.
in oracle 10g, you can issue:
ALTER SESSION SET N
in oracle 10g, you can issue:
ALTER SESSION SET NLS_COMP = ansi;
ALTER SESSION SET NLS_SORT = binary_ci;
do you think this is an elegant solution for case insensitive sorting &
searching? is there interest in seeing this in postgres?
--
dave
---(end of broadcast)
When I distribute a binary-only distribution of Postgre to a client, can
I exclude some parts of Postgres (to make it smaller), e.g.
documentation (all of doc/), some PL's, or even psql, initdb, pg_dump,
etc.?
--
dave
---(end of broadcast)---
TIP 5:
CREATE TABLE somereallylongname1 (...);
CREATE TABLEALIAS name1 somereallylongname1;
SELECT * FROM name1 ...;
Is there such a thing? I know there's alias in SELECT and completion in
psql (or even views). But this is more like a filesystem
symlink/hardlink. Would this be cool/useful?
--
dave
-
Kragen Sitaker wrote:
On Tue, Apr 27, 2004 at 10:36:24AM +0700, David Garamond wrote:
Glen Parker wrote:
Sounds an aweful lot like RAID level one :-) Why would a DB system need to
do what RAID already does quite well?
I think IB/FB's shadowing was implemented before RAID was invented
Heh
Greg Stark wrote:
Actually, each record will be incremented probably only thousands of times a
day. But there are many banners. Each record has a (bannerid, campaignid,
websiteid, date, countrycode) "dimensions" and (impression, click) "measures".
In the past when I had a very similar situation we
Manfred Koizar wrote:
You mean InnoDB cannot handle the load?
Perhaps it's more appropriate to say that the disk becomes the bottleneck.
--
dave
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscri
Manfred Koizar wrote:
begin;
update t set val=val+1; -- 1000 times
commit;
How many record versions does it create? 1 or 1000?
1000
I'm implementing a
banner counter which is incremented at least 2-3 millions a day.
How many rows? I would VACUUM that table after every few hundred
updates or whene
begin;
update t set val=val+1; -- 1000 times
commit;
How many record versions does it create? 1 or 1000? I'm implementing a
banner counter which is incremented at least 2-3 millions a day. I
thought I'd cheat by only commiting after every few minutes. Would that
work or would I still create as m
scott.marlowe wrote:
And yes, toasting is fully automatic. Just insert a large
text/varchar/bytea field and the database does the rest. which is why
they are generally recommended over using large objects, which require
specialized handling.
They are not always recommended though. The manual c
Jason Tesser wrote:
I am converting data from Access into Postgres and ran into an issue
with case sensitivity. Can I write queries in Access that will be case
insensitive without rewriting the queries. So I would like to know if
this be handled in Postgres or even if someone knows in Access. Tha
[=> ] 56% ETA ...
I know there is no such thing in Postgres right now (though there is
pg_stat_activity). But is there database product that can do this?
--
dave
---(end of broadcast)---
TIP 8: explain analyze is your friend
postgresql 7.4.0, redhat 7.3 (under vmware 4.0 on win2k)
Windows crashed and some of the files on Redhat got corrupted, including
some files in /var/lib/pgsql/data/pg_xlog/. When I tried to start
postmaster, it fails with message "Invalid primary checkPoint record". I
think it was trying to look f
[EMAIL PROTECTED] wrote:
died it caused corruption elsewhere. I have also seen (a couple of times) a
controller go bad and proceed to write garbage all over the disks. The
mirroring worked quite well - we had a very nice file system full of
mirrored garbage.
Does this mean software RAID is actual
Bruce Momjian wrote:
David Garamond wrote:
Is there a feature similar to this currently in Postgres, or will there
be? Sometimes (like in a shared hosting environment), we cannot have the
luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to
have a synchronous backup so
Gregory Wood wrote:
I think he probably means like an Oracle job. Although cron works,
that would be handy so you wouldn't need to write wrapper scripts
just to run a proc.
I hate to sound like an oldbie crank (although I'll admit to being a
crank), but what exactly is the advantage supposed to
What do people think of adding some more aggregate functions. These are
the ones that MySQL has and PG doesn't:
- STD/STDDEV
- VARIANCE
- BIT_OR
- BIT_AND
- GROUP_CONCAT (for strings, added in MySQL 4.x)
Particularly, I find GROUP_CONCAT practical to quickly display 1-many
relationship, e.g.:
Alex wrote:
MySQL is still the default database offered by any web hosting company
and if Postgres wants to become the designated db engine for these
services or become the worlds no.1 open source db then i think lots of
things need to be done. Take for example the admin interface (MySQL
Admini
Tom Lane wrote:
This script is lacking a VACUUM or ANALYZE command, so the planner
doesn't know how large the table is. Note the ridiculously small
cost estimates in EXPLAIN ...
I see, I never knew about having to VACUUM/ANALYZE first. Thanks.
--
dave
---(end of broadcast)
Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
The table contain +- 1 mil records, all of the actual version of the
queries below return < 10 rows, so an index should be used. Using an
index scan, the query ran < 100ms. Using seq scan, 2-3 secs. So there is
no good reas
Bruce Momjian wrote:
So can I quietly beg the Win32 group to expedite this port. I believe
you will be utterly astonished at the demand. Please.
Speaking of win32 port, do/will we need a win32 users list
(pgsql-win32)? MySQL has one. For now, I think such a list can assert to
the world that a
The table contain +- 1 mil records, all of the actual version of the
queries below return < 10 rows, so an index should be used. Using an
index scan, the query ran < 100ms. Using seq scan, 2-3 secs. So there is
no good reason why a seq scan should be used, especially in a case of
b='foo' or b='
Is there anyone using object table in Oracle? How does it differ from
table inheritance in PG (aside from the declaration syntax).
I actually just found out about table inheritance today, and absolutely
love it! However, it's a shame if this feature is totally unportable.
Are there any other po
Andrew Dunstan wrote:
(btw, if you want to work offline, which i saw referred to a couple of
times, wouldn't cvsup do most of the job?).
From what I understand, a "distributed" source control means each
developer gets his own _repository_, not just a working copy. This means
you can commit to yo
Table of 2mil records, two columns: id (BYTEA/GUID, PK) and i (INT,
UNIQUE INDEX). i values range from 1 to 200.
I'm creating several partial index for i as follows:
create unique index i_partition_i_1to100k on partition(i)
where i>=0 and i<=10;
create unique index i_partition_i_100k1
I have a table of 2mil records. The table consists of two columns, id
(BYTEA/GUID, PK) and i (INT, UNIQUE INDEX). Could someone explain why,
when using a bigint value like this:
select * from partition where i=30;
or
select * from partition where i in (1,2,3,30);
Postgres im
Yannick Warnier wrote:
Imagine an Orkut-like site. Suppose we have 'person' table of 100k
people. About 75% of these people fill in their location
(City/State/Country) information. We also have a 'city' table containing
list of cities with their state & country and each city's
latitude/longitud
Imagine an Orkut-like site. Suppose we have 'person' table of 100k
people. About 75% of these people fill in their location
(City/State/Country) information. We also have a 'city' table containing
list of cities with their state & country and each city's
latitude/longitude. Assume all people's
I'm making a "relocatable" Postgres binary distribution for my clients.
Everything goes into postgresql-7.4.1/ directory, including libraries
and binaries. This will be installed by a non-privileged user under his
own home directory. The goal is that they could just extract the
tarball, adjust
Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
Does it currently work? src/backend/utils/mb/conversion_procs/*/ is not
building anything, and 'make install' fails because it tries to copy
*.so files.
For sufficiently small values of "current", it builds.
Does it currently work? src/backend/utils/mb/conversion_procs/*/ is not
building anything, and 'make install' fails because it tries to copy
*.so files.
--
dave
---(end of broadcast)---
TIP 8: explain analyze is your friend
Tom Lane wrote:
StopService()
{
ConsoleMessage "Stopping PostgreSQL database services"
/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data
x=`/bin/ps axc | /usr/bin/grep postgres`
if /bin/test "$x"
then
set $x
kill -9 $x
Joe Conway wrote:
--without patch
regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
'parent_keyid', 'row\\134', 0, '') AS t(keyid bytea, parent_keyid bytea,
level int, branch text);
ERROR: invalid input syntax for type bytea
--with attached patch
regression=# SELECT * FROM connec
Can anybody confirm whether these databases support partial indexes (and
what are their term and syntax)?
SQL Server 2000: I've glanced the T-SQL Reference and it seems it
doesn't support it, though it supports indexing views. CLUSTERED index
is not the same thing, right?
Oracle: I've glanced
Joe Conway wrote:
regression=# SELECT * FROM connectby('connectby_bytea', 'keyid',
'parent_keyid', 'row\\002', 0, '') AS t(keyid bytea, parent_keyid bytea,
level int, branch text);
Oh, I was specifying the fourth argument in BYTEA (decode('hex...','hex')).
Now that I enter as an escaped string,
John Siracusa wrote:
SELECT * FROM t WHERE a = 1 AND b = 2 AND c = 3 ORDER BY b;
Let's say the table just has one index:
CREATE INDEX b_idx ON t (b);
In this case, obviously the b_idx will be used and no sorting after the fact
will be required. Now let's add an index:
CREATE INDEX k
Anton Nikiforov wrote:
Dear sirs,
Does someone made PL/Ruby working on 4.7.1?
I tried alot of things. Manual install, port install and nothing happend.
Please give me the idea how to fix the problem with
plruby.c: In function `pl_tuple_put':
plruby.c:498: error: too few arguments to function `tuple
I want to know how functional indexes are used "in the real world". Here
are the common uses:
* non-unique index on the first parts of a longish text field
(SUBSTRING(field)) to save disk space, while still allowing faster
searches than a sequential scan.
* indexing on LOWER(field)/UPPER(field
I want to know how functional indexes are used "in the real world". Here
are the common uses:
* non-unique index on the first parts of a longish text field
(SUBSTRING(field)) to save disk space, while still allowing faster
searches than a sequential scan.
* indexing on LOWER(field)/UPPER(field
Richard Huxton wrote:
On Thursday 05 February 2004 10:28, David Garamond wrote:
Would someone mind divulging the size (= number of members) of the
@postgreql.org mailing lists (particularly pgsql-general and
pgsql-hackers)?
Dunn, but Marc posted a message to -general recently which mentioned
Richard Huxton wrote:
On Thursday 05 February 2004 10:25, David Garamond wrote:
Glad to see your problem is solved. Your locale/charset settings look a bit
odd though:
# These settings are initialized by initdb -- they may be changed
lc_messages = 'en_US.iso885915' #locale for sy
Would someone mind divulging the size (= number of members) of the
@postgreql.org mailing lists (particularly pgsql-general and
pgsql-hackers)? To tell you the truth, I've always got good responses
from this list. Apparently most other question posts do too. There seems
to be always someone kno
Lincoln Yeoh wrote:
If you use an exact = does it use the index?
> e.g. explain select ... where lower(f)=''
Yes it does.
If so it could be your locale setting. On some versions of Postgresql
like is disabled on non-C locales.
I'm using 7.4.1. These are the lines in postgresql.conf (it'
Reading the archives and the FAQ, it seems to be implied that LIKE can
use index (and ILIKE can't; so to do case-insensitive search you need to
create a functional index on LOWER(field) and say: LOWER(field) LIKE
'foo%').
However, EXPLAIN always says seq scan for the test data I'm using. I've
I was thinking on how one would design an optimal (performance-wise)
database of large number of schedules with crontab-like semantic. There
will potentially be hundreds of thousands or even millions of "crontab"
entries, and there will be a query run once every minute to determine
which entrie
Chris Ochs wrote:
I still have to respectfully disagree. Postgresql is IMO just the wrong
software for the job, and given that there are still a number of really
important things that postgresql lacks, it should concentrate on those.I
am not against it however for technical reasons, because th
David Helgason wrote:
I'm already using 'real' GUIDs, which in my case means that the database
never generates them (since I don't have a generate_real_guid() function
in the database (and don't need to).
Neither GUID project on gborg (mentioned in another thread) seem to be
Mac OSX compatible,
Chris Gamache wrote:
You want
http://gborg.postgresql.org/project/uniqueidentifier/projdisplay.php
Another alternative:
http://gborg.postgresql.org/project/pguuid/projdisplay.php
(How do the two compare, aside from uniqueidentifier seeming to be
Linux-only? Should I use one of the above for pro
David Helgason wrote:
I'm switching right away. The notation doesn't really do anything for
me, but that's fine. I've been using bit(128), but always suspected that
of being unoptimal (for no particular reason).
I think bit(128) is quite efficient (OCTET_LENGTH() function shows me
it's using 16
Tom Lane wrote:
Jeff Bowden <[EMAIL PROTECTED]> writes:
That makes sense to me. I wonder if sqlite suffers for this problem
(e.g. app crashing and corrupting the database).
Likely. I can tell you that Ann Harrison once told me she made a decent
amount of money as a consultant fixing broken Inte
Rick Gigger wrote:
I have just about the same sort of needs now and concluded that postgres
just is not suited for embedding into apps like that.
Why not? It's not that the PostgreSQL backend is a mammoth like Oracle.
The Firebird embedded version is pretty much the same as their server,
but wi
Jeff Bowden wrote:
For ease of configuration and other reasons, I would like for my
single-user GUI app to be able to use postgresql in-process as a library
accessing a database created in the users home directory. I think I
could possibly get what I want by launching a captive copy of postmast
Thapliyal, Deepak wrote:
Hi,
Assume I have a bank app.. When customer withdraws $10 from his accouint I
have to do following
--> update account_summary table [subtract $10 from his account]
--> update account detail_table [with other transaction details]
Requirement:
either both transactions
Nigel J. Andrews wrote:
I can't comment on the real content of this discussion though since a) I
haven't be reading it and b) I probably wouldn't know what it was on about if
I had been.
Um, any insight on the original question (see subject)? :-)
--
dave
---(end of broadcas
Alex Satrapa wrote:
As long as you don't use RFC1918 addresses, the IPv4 address(es) of the
host should be unique for the Internet. Append/prepend a 32 bit
timestamp and you have a 64bit unique identifier that is "universally"
unique (to one second).
Remember that /sbin/ifconfig output usually i
Tom Lane wrote:
David Garamond <[EMAIL PROTECTED]> writes:
Perhaps I can make a GUID by MD5( two random numbers || a timestamp || a
unique seed like MD5 of '/sbin/ifconfig' output)...
Adding an MD5 hash contributes *absolutely zero*, except waste of space,
to any attempt to m
D. Dante Lorenso wrote:
GUID? Isn't that really nothing more than an MD5 on a sequence?
SELECT (MD5(NEXTVAL('my_table_seq'))) AS my_guid;
I know there are several algorithms to generate GUID, but this is
certainly inadequate :-) You need to make sure that the generated GUID
will be unique th
In Interbase and Firebird, NUMERIC is implemented as 64-bit integer.
This limits the range to NUMERIC(18, *) but for many uses that's
adequate. And moreover it's fast and efficient.
Is there a way in PostgreSQL to do something similar, i.e. I want to:
- use 64-bit ints, not string bits or arbit
1 - 100 of 103 matches
Mail list logo
