Better than most paid-for support, cheaper, friendlier... The PG community is
probably prettier too and makes a better cup of tea ;-)
Or coffee, if you want to come over one day or another :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
the one I'm interested in, which is companyID.
^^^
SELECT companyID FROM app;
^
ERROR: column companyid does not exist
^^^
Look closely at the capitalization and quoting.
--
GPG key ID E4071346 @
This query is going to return between 0 and n records, each with many
columns. I can't seem to grasp how to teach the procedure to return
an arbitrary number of rows with columns from the select statement.
I think you need to read up on Set Returning Functions, or
SRFs, which are quite new to
Regexes are optimized the same way as equivalent LIKE expressions. In
particular, the pattern has to be left-anchored to consider using it
with an index. In LIKE that means no wildcard at the start of the
pattern, in regex it means there has to be a ^.
What about ^.*oobar in a regex ? I
I think those best practices threads are a treat to follow (might even
consider archiving some of them in a sort of best-practices faq), so
Please do.
1) Bytea column. Seems the cleanest solution, but
*) I seem to remember reading in a discussion in the [hackers] list
that the TOAST
Remember that /sbin/ifconfig output usually include MAC address too. Not
that MAC addresses are 100% unique, but that should increase the
uniqueness.
How do you increase uniqueness? Either a value is unique or it isn't -
It increases the *likelihood* of uniqueness, IOW the expected
How do you increase uniqueness? Either a value is unique or it isn't -
It increases the *likelihood* of uniqueness, IOW the expected
collision frequency.
..., IOW ... decreases
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
to offer PostgreSQL in their environment (yes, we know
about CygWin).
(clients because we don't do business as in selling stuff)
Karsten Hilbert, MD
www.gnumed.org
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end
think medical DB designers are wont to be paranoid about
quality/integrity of data ...
Karsten Hilbert, MD
www.gnumed.org
(we do try to do a better job and this list is invaluable for it)
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
Bruce Momjian wrote:
I'm tired of MySQL being beaten up by the PostgreSQL guys. I am going
to fight back! Where is my sword?
Carefull Bruce. The MySQL sword is razor sharp only on one side and is
missing the handle! But if you succeed to pull it out without cutting
off your fingers,
In fact, I only need to decide whether a table (the whole) has been updated
since last query. I have some pulldown menus in a VB app which extract data
from a remote site with slow connection. And the data in those tables for
pulldowns changes rarely. So if the pulldown has to extract the data
Depends on whether you need random access to the contents. You can
lo_seek() inside a large object and retrieve parts of the data with
lo_read(), while 'text' and 'bytea' currently require fetching the
whole file.
Not so unless I misunderstand. We use substr() on bytea for
chunking access to
fine). PG returns: ERROR: Relation _con does not exist
This is my query:
SELECT
_CON.con_id,
Please make sure you get the quoting right regarding table
names. PostgreSQL will fold _CON into _con unless quoted
_CON. So, it may be that you created the table with quotes
(_CON). Now, in
Why can't you just take my word for it, this is the way it should be
sorted
He *does* take your word that this is the way it should be
sorted. But without knowing WHY this is the way it should be
sorted it is hard to deduce an algorithm for doing so.
What you probably need to do is sort
...what is the best way to force duplicated unique
or primary key'ed row inserts not to raise errors?
Remove the columns' UNIQUE or PRIMARY KEY constraints.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end of
Shackelford Motto: ACTA NON VERBA - Actions, not words
Your sig defies your motto.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end of broadcast)---
TIP 5: Have you checked our extensive
Hi, I've created an index but it's not being used by
postgresql when doing a query. But doing an explain
analyze shows that with index, it's faster. Here's
the output:
This sounds like someone needs to put a big fat link to
this FAQ item at the top of the PostgreSQL frontpage URL ?
Karsten
it seems to me what would be more useful is an even
lazier vacuum: something that could be told clean up as cycles are
available, but make sure you stay out of the way. Of course, that's
easy to say glibly, and mighty hard to do, I expect.
You mean, like, nice 19 or so ?
Karsten
--
GPG key
serial primary key,
id_org integer not null references org(id),
id_address integer not null references org_address(id),
unique (id_org, id_address)
);
Karsten Hilbert, MD
---
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
city that satisfy:
- not listed in street OR
- listed in street but street.id_city points to a different city
Any help would be appreciated.
Thanks,
Karsten Hilbert, MD
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end
UNION. Duh. I knew why I wrote to this list :-)
Thanks Mike.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
How does PostgreSQL figure out what the difference
when copying a file?
It doesn't. 'file' does. The data you export just happens to
look like the formats 'file' thinks it is in. And maybe it is.
Have you tried actually *looking* at the data in question ?
Karsten
--
GPG key ID E4071346 @
just out of curiosity: how can I find out which files in the PG_DATA
directory belong to which database/table?
I have looked through the documentation of the system catalogs, but couldn't
you should also look through the mailing list archives...
Karsten
--
GPG key ID E4071346 @
You can store them in the filesystem or in PostgreSQL. In PostgreSQL, you
can either store them as BLOBs or bytea columns. I prefer bytea columns
for numerous reasons. The only reason I can think of to use a BLOB is if
you only want to return _part_ of the file.
And even that can be done
If I turn fsync on and then pull the power cord while a
number of clients are doing lots of inserts/updates and stuff,
will the fsync then guarantee that no data will be lost or
corrupted?
You are surely kidding, aren't you ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291
This shows that the row exists in the table:
emystery= select aid,useragent from useragent where useragent like '%ntserver-ps%';
aid|useragent
host all the.machine's.ip.address 255.255.255.255
and still gives me the error that it doesn't have an entry for the servers
ip.
Warning: Unable to connect to PostgreSQL server: FATAL: No pg_hba.conf entry
for host machine's.ip user postgres, database nm in
Well, you of course need to
---
There are known drawbacks but this is what we currently use.
Hope that helps !
Karsten Hilbert, MD
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---(end
601 - 628 of 628 matches
Mail list logo