On Dec 10, 2009, at 6:58 PM, Tom Lane wrote:
> It seems likely that the root cause is having somehow lost a wakeup signal
> somewhere
What would cause that?
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
7;t know that those are related or not, but making some change
seemed necessary. :( Everything has been fine since.
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
seems related to this
particular problem. And it's one we've never seen. Any of you experts out
there have any ideas?
Thanks!
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rate port (that I am aware of), we still
use the default port so we really haven't run into installs that required
running two versions of PostgreSQL on the same server at the same time.
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
out.
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ly be related to an old version
of PG, whose source isn't even downloadable anymore? Or would this
point to hardware problems?
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
""Filip Rembiałkowski"" wrote in message
news:92869e660908250856g62561141n557f88015cd21...@mail.gmail.com...
2009/8/25 Eric Comeau
"David Fetter" wrote in message
news:20090821170259.ga6...@fetter.org...
> On Fri, Aug 21, 2009 at 12
"David Fetter" wrote in message
news:20090821170259.ga6...@fetter.org...
> On Fri, Aug 21, 2009 at 12:16:45PM -0400, Eric Comeau wrote:
>> In the next release of our software the developers are moving to
>> JBoss and have introduced the use of JBoss Messaging. They wan
o);
and you execute some select query on D, does it necessarily join A and B
before joining the result to E, or might it decide to join B with E
first before joining the result to A?
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PostgreSQL database?
I'm leaning toward creating a new schema as we already have built-in
procedures to backup and restore the application database.
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
ting the better performance anyway, but I'm just
wondering if this behavior is expected.
Eric
Eric Schwarzenbach wrote:
> I'm in the process taking a large SELECT statement which had been
> written using implicit join syntax (that is, just listing all the tables
> in the FROM clau
Um, ok. You've listed some conditions in order of how well they should
perform and these generally agree with my understanding. But how does
this relate to the relative performance of the semantically equivalent
explicit and implicit join syntaxes?
Eric
Martin Gainty wrote:
> here is
ed up the query by 50%.
This is using Postgres 8.3 on a database with GEQO turned off.
Is this what would be expected? Does the query planner / optimizer
generally do better with explicit JOIN syntax?
Cheers,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
different data for the same query. In
particular odd situations like this arise around nulls. Conceivably this
could happen between versions of PostgreSQL and running such unit tests
to test your code's expectations against a real database guards against
this possibility.
Eric
--
Sent via pg
t post in this thread that I recieved was
the same one you mention and began with a "Re:" in the subject line as
if it wasn't the first message, but I can find no sign of a message
prior to it. Was this a cross-post where the thread started in another
group? Or did something go awry
;for update" in your select statements? Are you setting
an appropriate transaction isolation level?
A better way to do this is with a sequence instead. This is guaranteed
to give you a unique value:
select nextval('address_serial_num_seq');
eric
--
Sent via pgsql-general mailin
ve of your data this way.
Eric
David wrote:
> Hi there.
>
> When is a good time to use cascading deletes?
>
> Usually, for safety reasons, I prefer to not ever use cascading
> deletes. But that can lead to some complex code that uses topological
> sorts etc to manually delete r
Alan Hodgson wrote:
> On Tuesday 02 June 2009, "Carlos Oliva" wrote:
>
>> Is there a way to create a database or a table of a database in its own
>> folder? We are looking for ways to backup the sytem files of the
>> database to tape and one to exclude some tables from this backup. We
>> can
OK... never mind, everyone. The problem was elsewhere in the code.
Regards,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat
Very interesting.
when I set log_statement='all', I see entries for various queries, but
I see nothing for the query I list below. If I just use printf() to
print out the c-string, it looks just like all the other queries.
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Alrighty so, how do I turn on log_statement?
Thanks,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat:@"SELECT us
message is:
status=PGRES_FATAL_ERROR error=<>
I'm connecting to the database through a host IP address, not through
localhost. So, why does this break?
Thanks,
Eric
On May 10, 2009, at 8:39 AM, Tom Lane wrote:
Eric Smith writes:
You are correct. On an Intel, the failed comman
Tom,
Thanks for the detailed info... makes my life a lot easier!
Eric
On May 9, 2009, at 7:07 PM, Tom Lane wrote:
I wrote:
That isn't exactly a trivial thing to do, because the pg_config.h
data
differs for the two arches. It will *not* work to just run a basic
configure and build
er on the PPC. I'll look through
the archives as you suggest.
Regards,
Eric
On May 9, 2009, at 6:37 PM, Tom Lane wrote:
Eric Smith writes:
You bet... here you go.
Hmm, I see you are trying to build universal binaries:
CFLAGS=-arch i386 -arch ppc ...
That isn't exactly a tr
You bet... here you go.
Thanks,
Eric
BINDIR =
/Users/esmith/SoftwareBuilds/DentalImagingV3/Release/RadioVision.app/Contents/Resources/postgresql/bin
DOCDIR =
INCLUDEDIR =
/Users/esmith/SoftwareBuilds/DentalImagingV3/Release/RadioVision.app/Contents/Resources/postgresql/include
PKGINCLUDEDIR
I actually started with the source: postgresql-8.3.5.tar.gz, from the
source download location. I just build straight from that source...
no mucking around with any of the sources.
Eric
On May 9, 2009, at 5:44 PM, Tom Lane wrote:
Eric Smith writes:
Yep, using that command gives me the
Yep, using that command gives me the error.
I'm using a build that came from the postgres website, and just uses
the config that comes with it.
Eric
On May 9, 2009, at 5:16 PM, Tom Lane wrote:
Eric Smith writes:
When I try the command below, I get the very familiar error:
&quo
All,
When I try the command below, I get the very familiar error: "expected
just one rule action"
I'm running 8.3.5 on Mac OS 10.5.6.
Any ideas?
Thanks,
Eric
On May 7, 2009, at 11:24 PM, Albe Laurenz wrote:
Eric Smith wrote:
How do I get a list of database usernames usi
Never mind, everyone. I figured it out.
On May 7, 2009, at 8:05 PM, Eric Smith wrote:
All,
How do I get a list of database usernames using the postgres C API?
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
All,
How do I get a list of database usernames using the postgres C API?
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
loaded to a
database (such as the XML format used by DbUnit).
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
PostgreSQL's (not very meaningful or helpful, IMO)
characterization of itself as an "object-relational database system" no
doubt leads to his very reasonable query whether he should
be taking something more into account than normal relational database
design principles.
I think it's uncalled for to be attacking him or his motives.
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greetings,
Hopefully this can be easily answered but I have not seen any reference
to this within the online docs and mailing list archives. Can or does
autovaccuum also have the capability to reindex; or, is this something
that needs to be placed within a custom cron job?
Many thanks!
Eric
put of the encryption so that E(foo) != E(foo) just to prevent
this sort of attack.
You're looking for a hash function, since that's a one way, stable
function meant for comparing.
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
Tried this out, and got a very familiar error that I don't know what
to do with : "Error: expected just one rule action".
I'm using 8.3.5, and see this error quite a bit. Anyone know what's
behind this error?
Thanks,
Eric
On Apr 8, 2009, at 8:54 PM, John R P
e in regards to logging so perhaps there is some fine tuning
that could be done with the log configuration? Has anyone else on this
forum seen this problem and/or know of a solution to it?
Many thanks in advance,
Eric Crowe
-
This message (including
All,
From the C API, how do I check for the existence of a column name in
a given table?
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bingo!
I doubled each of the entries below, and the two servers are now
running together quite happily!
Regards,
Eric
On Mar 30, 2009, at 7:56 PM, Eric Smith wrote:
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't
... as a reminder, this is running on mac os 10.5
Eric
On Mar 30, 2009, at 7:53 PM, Eric Smith wrote:
Ahhh! Can't seem to make this go away!
Here is the log file entry:
FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=54
the same error. Should I
be bumping these numbers up?
Eric
On Mar 30, 2009, at 7:18 PM, Tom Lane wrote:
Eric Smith writes:
Log file says "could not create shared memory segment". It also says
that I should change max_connections or shared_buffers.
Error message claims that m
ers is 300, but postgresql.conf
has this listed as 2400kB.
What the heck is going on here? (no, the lines in the conf file are
not commented out). How do I enforce the conf file entries?
Thanks,
Eric
On Mar 29, 2009, at 8:19 PM, Tom Lane wrote:
Eric Smith writes:
Yes, if I start one, but not
Thomas,
When I start the servers, I use different ports via the -p option. Is
that equivalent to using different listener ports in postgresql.conf?
Thanks,
Eric
On Mar 28, 2009, at 3:51 PM, Thomas Kellerer wrote:
Adrian Klaver wrote on 28.03.2009 23:37:
On Saturday 28 March 2009 3:27:15
Yes, if I start one, but not the other, the process works just great.
It's only when trying to run both that I have a problem.
Thanks,
Eric
On Mar 28, 2009, at 3:37 PM, Adrian Klaver wrote:
On Saturday 28 March 2009 3:27:15 pm Eric Smith wrote:
All,
I'm trying to run tw
for server to start...".
The two servers are using different ports. I'm running v 8.3 on a
Mac running 10.5.
What's the secret step I'm missing here?
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
for server to start...".
The two servers are using different ports. I'm running v 8.3 on a
Mac running 10.5.
What's the secret step I'm missing here?
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
contexts. What is called metadata in
many contexts is simply becomes data from the context of using a
relational database to represent it.
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s for this distro, and it appears
that the pg_standby in that package is working properly.
thanks,
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
We managed to fail over and reset the spare at least 25 times.
I'm concerned that I don't understand why it's failing.
Any ideas?
thanks.
eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mar 6, 2009, at 3:49 PM, hubert depesz lubaczewski wrote:
On Fri, Mar 06, 2009 at 03:33:30PM -0500, Eric B. Ridge wrote:
So my question is really, what's the difference and why doesn't this
work with PL/PGSQL functions?
because it is long-time limitation of setof-returni
URNS SETOF anyelement AS 'unnest'
LANGUAGE 'C' IMMUTABLE;
SELECT unnest(...);
works just fine using the above defined C function.
So my question is really, what's the difference and why doesn't this
work with PL/PGSQL functions?
eric
--
Sent via p
RROR: set-valued function called in context that cannot accept a set
CONTEXT: PL/pgSQL function "unnest2" line 8 at return next
Is the definition of "unnest2" wrong or is this just a limitation of
PL/PGSQL? If this can't be done via PL/PGSQL in v8.1, what about v8.
arser. Are these tables
safe to drop? Will the remnants of tsearch2 be anywhere else in the database if
it was never used?
Thanks folks --
-- Eric Brown / Director of IT / www.mediweightlossclinics.com
Can anyone recommend a reasonably efficient system for changing a view
definition (say by adding a column) when it has a bunch of dependent
functions?
Right now I work with the output from pg_dump to recreate things after
doing "DROP VIEW ... CASCADE". But the pg_dump schema output is only
approx
t, Dec 27, 2008 at 1:14 AM, Craig Ringer
wrote:
> Eric Worden wrote:
>
>> The recursive function creates a temp table [...] I
>> have version 8.1.10.
>
> While I haven't looked in detail, I'd be surprised if this wasn't an
> issue with pre-8.3 versions la
ried to include the relevant parts below.
Any smarty out there see the problem? --Eric
--=
--The trigger is like this:
CREATE TRIGGER trigger_name AFTER INSERT OR UPDATE ON table_name
FOR EACH ROW EXECUTE PROCEDURE trigger_func()
--
--The trigger_func() (abbreviated):
b
Robert Treat wrote:
> On Tuesday 09 December 2008 19:43:02 Liraz Siri wrote:
>
>> Greg has a good point. Ubuntu is a bit of a moving target. In contrast,
>> Debian has a much slower release cycle than Ubuntu and is thus
>> considered by many people to be preferable for production server
>> appli
What's the simplest way to grant read-only access to an existing
database? One approach I guess would be to create a user who has
SELECT but not INSERT etc privileges. But it appears that GRANT SELECT
does not work at the schema or database level. This means I'd not only
have to create hundreds of
problem (the only question is when I will
have time to do it).
Thanks again,
Eric
Tom Lane wrote:
> Eric Schwarzenbach <[EMAIL PROTECTED]> writes:
>
>> Now ordinarily I would interpret this use of the word "random" loosely, to
>> mean "arbitrarily"
would think it would be much more sensible to have it
operate deterministically (such as with some predetermined random
sequence of numbers used repeatedly).
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
me,
but it would certainly answer my question.
Eric
Dann Corbit wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Eric Schwarzenbach
>> Sent: Friday, October 31, 2008 12:35 PM
>> To: pgsql-general@pos
his problem (the only question is when I will
have time to do it).
Thanks again,
Eric
Tom Lane wrote:
> Eric Schwarzenbach <[EMAIL PROTECTED]> writes:
>
>> Now ordinarily I would interpret this use of the word "random" loosely, to
>> mean "arbitrarily&qu
dea? Is non-deterministic behavior really
acceptable? I would think it would be much more sensible to have it
operate deterministically (such as with some predetermined random
sequence of numbers used repeatedly).
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
thout doing so. I don't expect the
execution plan to be optimal, however I do expect it to be deterministic.
Thanks,
Eric
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, Oct 13, 2008 at 09:10:41PM -0400, Tom Lane wrote:
> Eric Haszlakiewicz <[EMAIL PROTECTED]> writes:
> > I created this, which seems to solve the problem:
>
> > create function casting_eq_operator(integer, "char")
> >returns boolean as '
ing'
instead of '"char"', but that caused simple string comparisons in queries
to fail. e.g.
select * from foo where mycol = 'abc';
when mycol is a varchar column complained about "invalid input syntax
for integer". Is there a simple explanation for why
the hard drive
itself.
The performance of the sata-disks (raid) was very bad. We replaced them
with
sas-disks (raid) and now everything runs as fast as expected.
Greetings
Eric Bartels
-Original Message-
From: Bill Moran [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 13, 2008 2:44 PM
system memory is consumed after some time.
Are there any settings that need to be set to avoid this?
Currently the default settings are used ...
The system is a Suse Enterprise Linux (64bit).
Kind regards
Eric Bartels
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
>
> is there any quick hacks to do this quickly? There's around 20-30million
> rows of data.
>
> I want to change a column type from varchar(4) to varchar(5) or should I
> just use text instead.
>
ALTER TABLE tablename ALTER COLUMN columnname TYPE VARCHAR(5);
HTH.
-
Eric
My OS Type its: Windows Vista 64bits, Portuguese Brazil
I have installed the 8.3 with msi package
The message error was: "ailed to run initdb: 1!"
I serached google and i found nothing
On Sat, Apr 26, 2008 at 12:02 PM, Martijn van Oosterhout <[EMAIL PROTECTED]>
wrote:
> On Thu, Apr 24, 2008 at 0
rrent transactions and act like
if they were rolled back or something ?
On Feb 5, 2008 8:47 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Eric Renard escribió:
>
> > pg_dump: Error message from server: ERROR: could not access status of
> > transaction 3270404
> > DETAIL:
Ok I progressed a bit, now with psql I can see my main db and some tables,
but they don't contain many rows.
Noticable messages in the logfile :
2008-02-05 18:01:18 CET LOG: transaction ID wrap limit is 1073748480,
limited by database "wowdbu"
2008-02-05 18:01:18 CET LOG: autovacuum: processing d
Ok in fact, the times weird thing were because I copied the data dir on a 64
bits arch and it went from a 32 bit arch. On the 32 bit one :
pg_control version number:812
Catalog version number: 200510211
Database system identifier: 4989617165674917617
Database clu
What types of extensibility (possibly already available in
other DBMSs) are currently missing in PostgreSQL?
3. To what extent was your choice of PostgreSQL as a development
platform based primarily on its extensibility features?
**
Eric Davies,
Quoting Tom Lane <[EMAIL PROTECTED]>:
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
I've confirmed from the commandline using
psql -h -p -U database
"psql: could not connect to server: Connection refused
That's not a Postgres problem. You do not ha
idn't see any errors and
the startup scripts seemed to run successfully.
What else should I be looking at?
Thank you.
Eric
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
ning about an undefined reference.
Any ideas appreciated.
Thank you.
Eric.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
I can find all the check constraints, primary keys and foreign keys in
the information schema, but I cannot find the non-unique indexes. Is
there anyplace to get that information (name, columns, etc)?
Sorry if this is an FAQ. I couldn't find it with Google.
--
Eric Johnson
"
Dear all,
In Postgresql documentation we have an example of the directive archive_command
(for WAL) :
archive_command = 'cp -i %p /mnt/server/directory_archive/%f
un-time to choose if we want the performportalclose to raise an error or
just a warning
Thanks in advance for your help.
Eric Rasoa
f and see how things go. Maybe
implement a monthly CLUSTER and/or REINDEX on the largest tables to
help keep their sizes in check.
Thanks again!
eric
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
refix = '%m [xid=%x] [%p]: '
stats_start_collector = on
stats_command_string = on
stats_block_level = on
stats_row_level = on
autovacuum = on
Thanks in advance for any suggestions!
eric
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
s to go besides the PG documentation and the
pgsql newsgroups?
Regards, Eric
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
To respond to Alvaro's post, I did try setting TZ=PST, no luck there.
As Magnus points out, the install doesn't appear complete because of
the missing timezone dir.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
I am getting truly desperate! I am trying to build any version of
Postgres on Windows from source. First experience with Postgres
source. I have struggled for days trying to solve a problem. Would be
willing to pay for the solution!!!
The following error occurred when issuing a vanilla initdb c
thank you Tom!
that did the trick!
I'm still in the dark why my test data type didn't exhibit the
problem, but I'm certainly a much happier camper now.
Eric.
At 05:40 PM 05/01/2007, Tom Lane wrote:
Eric Davies <[EMAIL PROTECTED]> writes:
> Some of my custom server f
e this type of behavior?
Thank you,
**
Eric Davies, M.Sc.
Barrodale Computing Services Ltd.
Tel: (250) 472-4372 Fax: (250) 472-4373
Web: http://www.barrodale.com
Email: [EMAIL PROTECTED]
**
Mailing Address:
P.O. Box 3075 STN CSC
V
way to go about this? one question left
unanswered is how do I somehow automagically drop the view once a user
is done with it.
suggestions and comments welcomed. thanks
eric
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
he volumes, and everything was clean.
But I have a sata raid on this server, I never knew if a raid would
actually replicate badblocks to the other disk ?
Thanks for your advice!
Tom Lane a écrit :
Eric Rousse <[EMAIL PROTECTED]> writes:
...
2006-11-16 04:00:39 [8763] LOG: connection rec
h b > /dev/null 2>&1
00 5 * * * root rsync --password-file=/etc/.rs_sec -Cauzbqr
/export/dbsystem/backup/ rsync://[EMAIL PROTECTED]/rsync/
I'll move cron.daily to 4:30
brian a écrit :
Eric Rousse wrote:
Hello all,
I've been experiencing strange crash, never really took care of it
x27;en_US'
LC_NUMERIC = 'en_US'
LC_TIME = 'en_US'
I tested my memory with memtest, and it's perfect. I also did some
stress test within Linux, using stress and donnie++ to see if it would
crash with APCI or not, while doing a dump... So far its okay.
The machine:
, 1st item)
1.2 (1 branch, 2nd item)
1.2.1 (1.2 branch, 1st item)
1.2.2
1.2.2.1
1.3
2
2.1
2.1.1
2.1.2
2.1.3
2.2
2.3
etc.
Is there an option in connectby to do this directly, or do we need to
write another function to do this?
Thanks,
Eric
---(end of broa
type_info const &)"
(??0type_info@@[EMAIL PROTECTED]@@Z) already defined in LIBC.lib(typinfo.obj)
MSVCRT.lib(ti_inst.obj) : error LNK2005: "private: class type_info &
__thiscall type_info::operator=(class type_info const &)"
(??4type_info@@[EMAIL PROTECTED]@@Z) a
On 8/1/06, Reece Hart <[EMAIL PROTECTED]> wrote:
Eric Andrews wrote:
> I am not much of a schema designer and have a general questoin about
> the proper use of the array datatype. In my example, I have
> destinations, and destinations can have multiple boxes, and insid
On 8/1/06, Nikolay Samokhvalov <[EMAIL PROTECTED]> wrote:
On 8/1/06, Eric Andrews <[EMAIL PROTECTED]> wrote:
> ... and inside
> those boxes are a set of contents. what I want to do is search and
> basically "mine" data from the content sets. do I use an array
&g
misdesign. Consider using a separate table with
a row for each item that would be an array element. This will be
easier to search, and is likely to scale up better to large numbers of
elements.
thanks,
eric
---(end of broadcast)---
TIP 2: Don'
ATE TABLE tableTest(var varchar);
This lets psql interpret your connect request as a psql command instead
of as an SQL statement.
Regards,
Eric Faulhaber
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
work, but any
thoughts would be very welcome.
Thanks,
EE
Tom Lane wrote:
Eric E <[EMAIL PROTECTED]> writes:
I chased the problem down to the following lines in pg_regress:
"$bindir/postmaster" -D "$PGDATA" -F $postmaster_options
0:00 \_ postgres: stats buffer process
25058 ?S 0:00 \_ postgres: stats collector process
Then of course when the script tries kill -0 on a 25049 to see if the
postmaster came up, it wrongly concludes that postmaster did not start.
Can anyone help understand this behavi
Martijn van Oosterhout wrote:
> On Thu, Jul 20, 2006 at 12:07:54PM -0400, Eric Faulhaber wrote:
>>> Well, there's a really nasty workaround: create a cast from bytea to
>>> text which doesn't change the value. This will get your data into the
>>> dat
Martijn van Oosterhout wrote:
> On Wed, Jul 19, 2006 at 06:06:08PM -0400, Eric Faulhaber wrote:
>> Martijn van Oosterhout wrote:
>>> On Wed, Jul 19, 2006 at 05:24:53PM -0400, Eric Faulhaber wrote:
>>>> OK, but now that this "feature" has been removed i
101 - 200 of 421 matches
Mail list logo
