On Tue, Aug 04, 2009 at 04:04:42PM +0100, Paul Taylor wrote:
> >You don't really need to run an installer and/or create registry
> >entries (for windows). This would then resemble more the Derby
> >network server setup.
> Yeah, but this is messy and low because you have to wait the
> database to b
> I just have to read more on how to get it out relative to a different
> time zone than it went in. I'll find it.
Sounds like a job for SELECT ... AT TIME ZONE ...;
Karsten
--
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/g
On Thu, Jun 04, 2009 at 01:48:28PM +0300, Jennifer Trey wrote:
> and its possible
> that the two drives are misconfigured. I have checked into that a little and
> can't rule it out completely.
See, this is what others have talked about. You don't give
details on what you checked, what you found,
On Mon, May 18, 2009 at 11:33:03PM +0430, Zico wrote:
> > we still don't understand exactly what you have to work from
> > Do you have a backup of the Postgres "data" directory,
>
> No, I don`t have any data of Postgres "data" directory.
Well, in that case I would suggest to IMMEDIATELY STOP
On Thu, Apr 23, 2009 at 01:21:05PM +0200, Ivan Sergio Borgonovo wrote:
> I'll try to rephrase to check if I understood and for reference.
>
> varchar is slower than text since it has to do some "data type
> check".
Yes but no. It is said to be slower because it has to do a
data length check, not
On Thu, Apr 23, 2009 at 11:33:34AM +0200, Ivan Sergio Borgonovo wrote:
> Karsten Hilbert wrote:
>
> > On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
> >
> > > I have a set of dynamically composed objects represented in
> > > Java, with string
On Thu, Apr 23, 2009 at 09:44:53AM +0100, Seref Arikan wrote:
> I have worked with very capable DBAs before, and even though it has been
> quite some time since I've done real DB work, I would like to invest in
> postgresql as much as I can
Seref, if you can muster the man power to build archetyp
On Wed, Apr 22, 2009 at 06:21:41PM -0600, Scott Marlowe wrote:
> > CREATE TABLE "app"."archetype_data" (
> > "id" BIGINT NOT NULL,
> > "context_id" VARCHAR(1000),
> > "archetype_name" VARCHAR(1000),
> > "archetype_path" VARCHAR(1000),
> > "name" VARCHAR(1000),
> > "value_string" VARCHA
On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
> I have a set of dynamically composed objects represented in Java, with
> string values for various attributes, which have variable length. In case
> you have suggestions for a better type for this case, it would be my
> pleasure to he
On Tue, Mar 17, 2009 at 12:25:08PM +0100, Juan Pereira wrote:
> I'm currently developing a program for centralizing the vehicle fleet GPS
> information -http://openggd.sourceforge.net-, written in C++.
>
> The database should have these requirements:
...
> - The database also should create a ta
On Thu, Mar 12, 2009 at 04:18:50PM +0530, Nagalingam, Karthikeyan wrote:
> Is there any way to keep each database in separate partition ie)
> separate folder for each database.
>
> I would like to do the dabase level backup in storage side, for that If
> I am able to separate the database in fo
On Tue, Mar 10, 2009 at 05:02:59PM +0100, Marc Cuypers wrote:
> Is it possible to upgrade from 7.4 to 8.3 at once?
>
> I upgraded as follows:
> when 7.4 was installed i dumped the data with:
> su postgres -c "pg_dumpall --create" > out
Just a side note in case you didn't know: It is usually
Is there any chance of this being considered for 8.4 ?
Unfortunately I cannot provide patches myself as my
knowledge of C is next to nothing.
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql
On Tue, Mar 03, 2009 at 12:35:37AM +0900, Hiroshi Saito wrote:
> Sorry very late reaction.
> I desire problem solution.
So do I :-)
Ganbatte !
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-general mailing list (pgsql-gene
On Wed, Feb 25, 2009 at 09:26:26AM +, Thom Brown wrote:
> We've set up a primary server in archive mode to continuously archive to an
> NFS mount, and the standby server to continuously recovery from that
> directory (although I'm not sure that's actually working... I've probably
> overlooked
On Wed, Feb 11, 2009 at 02:20:47PM +0900, Hiroshi Inoue wrote:
> Tom Lane wrote:
> > Hiroshi Inoue writes:
> >> I'm thinking of the following steps in the backend code.
> >
> >> 1.Set LC_MESSAGES to "C" until the client_encoding is
> >> determined.
I have tried that but it didn't work out for
On Thu, Feb 12, 2009 at 10:28:38PM +0900, Hiroshi Inoue wrote:
> >>> Reflecting on the bigger picture ... I would imagine that the vast
> >>> majority of existing applications depend on client_encoding settings
> >>> that come from postgresql.conf, ALTER USER SET, ALTER DATABASE SET, or
> >>> jus
On Sun, Feb 08, 2009 at 10:38:16AM -0500, Tom Lane wrote:
> I believe the only real "fix" is to guarantee that messages are sent
> as untranslated ASCII until we have sent an encoding indicator at
> the end of the startup sequence. Which has its own pretty clear
> downside: no more translation of
> > Debian has an add-on named pg_upgradecluster which transforms an
> > existing cluster into a new one transferring databases via dump/restore.
> >
> > This works nicely as long as the databases are not "too large" with
> > respect to the hardware specs they are running on.
> Ah really? Is that
> We (you, me, everyone) are currently presented with a problem when
> upgrading
> our installed version of PostgreSQL when upgrading to a major release
> version (i.e. 8.2 to 8.3, or 8.3 to 8.4) Is it not possible to have
> PostgreSQL "upgrade" the actual database cluster upon installing a new
>
On Wed, Feb 04, 2009 at 12:37:31PM -0500, Guy Rouillier wrote:
> Karsten Hilbert wrote:
>>>> Craig, what kind of "events" are you thinking about? Triggers are
>>>> already pieces of code that run upon "certain events", namely
>>>> i
> > Craig, what kind of "events" are you thinking about? Triggers are
> > already pieces of code that run upon "certain events", namely insert,
> > update or delete events. What others do you have in mind?
>
> That's a good point, actually. I can't think of much you can't do with a
> trigger
On Thu, Jan 29, 2009 at 09:51:42AM -0800, Joshua D. Drake wrote:
> If we are listing pet peeves :)
>
> Up to 8.4, postgresql didn't accurately represent timestamps because
Ah, speaking of timestamps:
GNUmed could nicely use a timestamp with time zone which
preserves the time zone that was used
On Thu, Jan 29, 2009 at 02:22:28PM -0300, Alvaro Herrera wrote:
> > I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
> > FOSDEM 2009 this year. I have a pretty good idea what some them are of
> > course,
> > but I would be interested to hear if people have any complaints f
On Tue, Jan 27, 2009 at 05:30:23PM -0500, Tom Lane wrote:
> Karsten Hilbert writes:
> > the explain analyze of which is (I've actually gotten it to
> > work better in the meantime as you can see):
>
> Looks like most of the problem is in the subquery scans on v_st
On Tue, Jan 27, 2009 at 04:42:02PM -0500, Tom Lane wrote:
> What does EXPLAIN ANALYZE say about it? Also, what is the use-case
> you are concerned about --- selecting the whole view contents, or
> selecting WHERE something-or-other?
Oh, and the use case is to select all the test_results which
be
On Tue, Jan 27, 2009 at 04:42:02PM -0500, Tom Lane wrote:
> Karsten Hilbert writes:
> > The view in question is in fact a lot more complicated. This
> > is the best I've been able to come up with so far (and it is
> > still slow - slow as in 3-4 seconds for 20 records
On Tue, Jan 27, 2009 at 06:48:11PM +, Sam Mason wrote:
> > table test_results
> > modified_by integer foreign key staff(pk),
> > intended_reviewer integer foreign key staff(pk),
> > actual_reviewer integer foreign key staff(pk)
> >
> > (this table will contain millions of rows)
>
Hello all,
maybe some general advice can be had on this:
table test_results
modified_by integer foreign key staff(pk),
intended_reviewer integer foreign key staff(pk),
actual_reviewer integer foreign key staff(pk)
(this table will contain millions of rows)
table staff
On Wed, Jan 21, 2009 at 01:49:44PM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > Karsten Hilbert writes:
> > > This is what my 8.3 manual says:
> >
> > > conkey │ int2[] │ pg_attribute.attnum │ If a table constraint, list of
> > > columns which t
Bruce, et al,
given the thread partially quoted below would this warrant a
TODO item "improve communication of encoding between client
and server regarding early startup messages" ?
A very usable band-aid for 8.4 - short of a proper fix -
would be the minimal-invasive sending of messages in 7-bit
> Hm, so maybe both Peter and Alvaro are right:
>
> 1) Setting the translation wrapper to a NOOP as early as possible.
>
> Thus, the first messages are sent in 7-bit ASCII English.
Despite being *marked* for translation and a translation
to exist in the .po file, that is.
Karsten
--
Sensat
> > The proper fix is probably to include the client encoding in the
> connection
> > startup message.
>
> What of errors occurring before such an option could be applied?
>
> I think that ultimately it's necessary to accept that there will be some
> window during connection startup where sendin
> On Wednesday 31 December 2008 18:57:29 Karsten Hilbert wrote:
> > The solution is to find the right layer to take control of the encoding
> but
> > this is eventually only possible if the encoding is *known*. Thus the
> plea
> > for "7-bit-ascii English by def
> Karsten Hilbert writes:
> > On Mon, Dec 29, 2008 at 09:07:14AM -0300, Alvaro Herrera wrote:
> >> And I'm now wondering if we should delay initializing the translation
> >> stuff until after client_encoding has been reported.
>
> > Or else
>
> >
On Mon, Dec 29, 2008 at 09:07:14AM -0300, Alvaro Herrera wrote:
> > That would not quite be enough -- I am talking about
> > messages reported *during* auth, say
> >
> > FATAL: password authentication failed for user "postgres"
> >
> > or
> >
> > fe_sendauth: no password supplied
> >
>
On Tue, Dec 23, 2008 at 06:45:17PM -0300, Alvaro Herrera wrote:
> > How can I programmatically detect which encoding a
> > PostgreSQL server I am trying to connect to sends back
> > messages -- before I connect (so client_encoding and
> > the pg_settings table are flat out).
>
> Hmm, isn't client
Hi all !
How can I programmatically detect which encoding a
PostgreSQL server I am trying to connect to sends back
messages -- before I connect (so client_encoding and
the pg_settings table are flat out).
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B
On Sun, Dec 14, 2008 at 02:37:51PM -0500, Tom Lane wrote:
> Subject: Re: [GENERAL] how to find foreign key details (column, that is)
>
> Karsten Hilbert writes:
> > I cannot, however, for the life of it find out how to learn
> > the *column* the foreign key is on.
>
&g
Hello all,
suppose I know that there are several tables with foreign
keys pointing to
demographics.identity.pk
With the help of pg_constraint I can get a list of *tables*
which hold those foreign keys (schema = demographics, tbl = identity,
col = pk):
select
%(schema)s as refer
> Especially when I haven't edited anything yet?
Because you might want to.
--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED]
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
> How can I
> > even include something *outside* a transaction *inside* it
I was referring to conditions outside the database which you
detect while the transaction is in progress and which
invalidate the semantic integrity of the transaction as a
whole. Under such circumstances you would want to
On Wed, Jul 23, 2008 at 11:49:38PM +0200, Michal Seidl wrote:
> Hi, I can not figure out how to solve the problem with LOCALE. Example:
> - 3 tables, each of them with a text or varchar column.
> - The first table with text in German
> - The second table with text in Czech
> - the third one with
On Wed, Jul 23, 2008 at 07:18:15PM +0930, admin wrote:
> 1. Is a SEQUENCE what I use instead of auto_increment?
Yes. Perhaps better use it indirectly with (BIG)SERIAL:
create table foo (
pk (big)serial
);
> 2. Does this work in PostgreSQL:
>
> INSERT INTO table VALUES ('x','y','z')
Yes
On Wed, Jul 23, 2008 at 01:15:30PM +1000, Chris wrote:
> >> Now *any* error inside transaction will trigger auto rollback for
> >> *all* inserts so I don't need to explicitly issue conditional
> >> rollback? Also is "begin/commit transaction" == "start/end
> >> transaction"??
>
> What if somethin
On Tue, Jul 22, 2008 at 12:20:46PM +0200, A. Kretschmer wrote:
> > is it possible to make a SELECT query with some nasty follow up commands,
> > which damages the database.
> >
> > Something like:
> >
> > SELECT *,(DROP DATABASE enterprise) AS roger FROM sales WHERE sales >
> > (UPDATE order S
On Sat, Jul 12, 2008 at 11:14:27PM -0300, Alejandro D. Burne wrote:
> Hi, I need to write a function that gives me a password string, no
> just a numbers-characters string; something like people wrote in php,
> its based on determined syllables and numbers.
> I think it be useful to other people,
On Mon, Jun 30, 2008 at 12:44:31PM +0200, A B wrote:
> By changing c2,c3,etc. to something else xc2,xc3, etc. it worked!
> So was the problem that I refered to the same names in the SELECT statement?
Yes.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9
On Tue, Jun 24, 2008 at 11:31:16AM -0500, Ryan Wells wrote:
> Subject: [GENERAL] String Encoding Conversion Problem
>
> We've got a .NET application that's trying to move data from an old MySQL
> database to a shiny new Postgres db, but we keep getting this error:
> invalid byte sequence for enc
On Thu, Jun 19, 2008 at 11:46:42AM +0200, David wrote:
> > That will happen anyway, no matter what the message
> > transport is like. Apps will have to read state at startup
> > anyway, no ?
>
> I have a small problem with this. If app1 wants to tell app2 to
> perform an expensive operation (whic
On Thu, Jun 19, 2008 at 11:09:12AM +0200, David wrote:
> One pattern I've used is for apps to communicate events to each other
> through the database.
Works nicely with LISTEN/NOTIFY. We use it a lot in GNUmed.
> - App 1 sents a boolean value to True
> - App 2 queries the field every 10s, sets t
On Wed, Jun 18, 2008 at 02:03:05PM +0200, David wrote:
> If I want to start providing user-customizable defaults to the
> database (ie, we don't want apps to update database schema), is it ok
> database design to add a table2 record, with a NULL table1_id field?
>
> In other words, if table1 has
On Wed, Jun 18, 2008 at 02:04:14PM +0200, David wrote:
> 1) table1 becomes a view of an updated table, with a 'WHERE field4 IS
> NULL' clause.
>
> Problem with this is that some RDBMS (Postgresql specifically) don't
> let you run update statements on views.
Given 1) the view will be "fairly unco
On Tue, May 20, 2008 at 09:47:55AM -0700, Dan Joo wrote:
> Is there a command that I can use to find out which file PG is looking
> into for the settings in pg_hba.conf? Could it be that the config file
> is not even titled "pg_hba.conf"?
http://www.postgresql.org/docs/8.3/static/runtime-con
On Tue, May 20, 2008 at 09:17:03AM -0700, Joshua D. Drake wrote:
> > The only non-commented lines are:
> >
> > [EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
> >
> > local all all trust
> > hostall all 127.0.0.1/32 tru
conf that's actually being used ? Perhaps
there's another one lying in another cluster's directory ?
What happens if you rename it so PG cannot find it anymore
- does PG complain about the missing file ?
> [mailto:[EMAIL PROTECTED] On Behalf Of Karsten Hilbert
Interesting. Are my m
On Tue, May 20, 2008 at 08:24:30AM -0700, Dan Joo wrote:
> /home/djoo[8:25am]$ %psql kermit -U postgres
>
> psql: FATAL: Ident authentication failed for user "postgres"
> confused why I can't access. Is there another file that I need to alter
> besides the pg_hba.conf file?
That depends on
On Wed, May 14, 2008 at 10:36:31AM -0500, David McNett wrote:
> If the view is limited as you describe, don't use is.
Ah, of course, that was the best advice amongst all :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
Sent via pgsql-ge
On Wed, May 14, 2008 at 08:21:00AM -0700, Stephan Szabo wrote:
> Can't you just do something like order by name, rank as part of the
> distinct on subselect to force it to pick the rank 1 row for a given name?
>
> So, basically
> select * from
> ( select distinct on ... order by name, rank )
> o
On Wed, May 14, 2008 at 09:35:10AM -0500, Decibel! wrote:
> Someone should probably teach the gnumed folks about schemas, too... ;)
Instead of Why? I should have said And what? I am, of
course, open to insights on that.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD
On Wed, May 14, 2008 at 09:35:10AM -0500, Decibel! wrote:
> SELECT name, zip, zip='04317' AS zipmatch
> FROM urb LEFT JOIN streets ON (streets.urb_id = urb.urb_id )
> ORDER BY zipmatch DESC, name
> ;
The view dem.v_zip2data (which I erronously left out in my
first post) does just that - i
On Wed, May 14, 2008 at 09:28:50AM -0500, David McNett wrote:
> I think perhaps you have misunderstood what I was suggesting.
Very well possible.
> If the
> SQL in your original post works, then my suggestion will also work.
Indeed, my initial post had a typo. Here is the last (most complex) qu
On Wed, May 14, 2008 at 09:35:10AM -0500, Decibel! wrote:
> Someone should probably teach the gnumed folks about schemas, too... ;)
Why ? We use several:
dem - demographics stuff
clin - clinical stuff
gm - gnumed internal stuff
i18n - i18n-related stuff
au
On Wed, May 14, 2008 at 08:43:31AM -0500, David McNett wrote:
>> Effectively I want known-zip cities first, then
>> fragment-matching cities but without those already in the
>> known-zip list.
>
> I think you've made things far more complicated than you need.
Very likely, yes.
> How about an appr
On Wed, May 14, 2008 at 09:48:20PM +0800, mian wang wrote:
> select * from (
>select *, 1 as rank from dem.urb where
>name ilike 'Lei%' and
>zip = '04317'
>union -- avoid distinctness at this level
>
Hi all,
let's assume I want to select cities by name fragment:
select * from dem.urb where name ilike 'Lei%';
Then, let's assume I know the zip code and want to use that
for limiting the range of cities returned:
select * from dem.urb where
name ilike 'Lei%' and
> And maybe having one huge index managing the uniqueness across partitioned
> data just defeats the idea of data partitioning!
Except when you want uniqueness across all partitions.
Karsten
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://w
On Thu, Apr 24, 2008 at 10:25:44AM +0200, Andreas 'ads' Scherbaum wrote:
> If you define a medical database, you have to extend the ENUM values a
> bit, but even then you know the possible values in advance
Considering scary genetic experiments I wouldn't even be
sure about that.
> It all depend
On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote:
>> I would put it that gender is not so easily defined, which makes it a
>> poor choice for enum.
>
> Absolutely true. Which is odd, because this example is trotted out
> whenever there's a thread about ENUMs.
So it's good we got it in the
On Wed, Apr 23, 2008 at 05:18:12PM -0600, Scott Marlowe wrote:
> > hermaphrodite
> > transgender with female phenotype
> > transgender with male phenotype
> the most common and easiest is intersex.
The political correctness of any one term changes over time.
The above list should close the
On Wed, Apr 23, 2008 at 05:51:48PM -0400, Robert Treat wrote:
> > Add
> >
> > hermaphrodite
> > transgender with female phenotype
> > transgender with male phenotype
> >
> > and you should be set from current medical science's point
> > of view ;-)
> >
>
> The standard is unknown, male, female
On Wed, Apr 23, 2008 at 11:46:35AM +0200, Tim Tassonis wrote:
> As you probably are all aware of, this results now in a cluster that
> will only allow you to create UTF-8 databases. I have read some posts
> regarding this topic where it is explained that allowing LATIN1 on a
> cluster initia
On Wed, Apr 23, 2008 at 12:38:48PM +0200, Andreas 'ads' Scherbaum wrote:
> Yes. You should/can use ENUM for something like 'gender':
> male, female, unknown. You don't need to add other values ever (yeah, i
> skipped some special cases).
I was gonna say ! :-)
Add
hermaphrodite
transgender with
On Thu, Apr 17, 2008 at 04:06:57AM -0700, Paul Boddie wrote:
> One caveat: psycopg2 doesn't (or didn't) use cursors in a transparent
> fashion like pyPgSQL does. If you're traversing potentially large data
> sets, this will mean that psycopg2 will download all the result data
> into the client pro
On Wed, Apr 16, 2008 at 08:21:15PM +0100, Sam Mason wrote:
> Hum, what's an "EMR"?
Sorry, Electronic Medical Record.
> Why not do:
>
> CREATE TYPE tstz AS ( ts TIMESTAMP WITH TIME ZONE, tz TEXT );
>
> And use this instead?
That should work. At the time (a couple of years ago) I
wasn't aware
On Tue, Apr 15, 2008 at 05:29:09PM +0200, Martijn van Oosterhout wrote:
> > Perhaps I confuse this with some limitation of a previous
> > implementation of the enum type. Also perhaps I was
> > misguided into thinking tags cannot be modified by the
> > "don't delete from table of tags" part.
>
>
On Tue, Apr 15, 2008 at 03:31:46PM +0100, Sam Mason wrote:
> But I was under the impression that you didn't want any time zone
> information.
Wrong impression.
> You wanted to know that that an appointment was at 3PM at
> the patients local time,
... plus "what does local time mean".
> attemptin
On Tue, Apr 15, 2008 at 09:21:19AM -0700, Steve Crawford wrote:
>> So I thought, "lets learn a bit of Python", and I stumbled upon
>> a choice of these two libraries. Whch would you suggest?
>> How do they differ?
>>
> Well, pygresql seems unmaintained since mid 2006 and the psycopg2 site
>
On Tue, Apr 15, 2008 at 03:43:05PM +0200, Martijn van Oosterhout wrote:
> On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > Yes, I know about tagged types but have shyed away from them
> > so far courtesy of them not being adjustable after the fact.
>
>
On Tue, Apr 15, 2008 at 02:31:22PM +0100, Sam Mason wrote:
> On Tue, Apr 15, 2008 at 02:46:14PM +0200, Karsten Hilbert wrote:
> > Of course, the actual time stored in the database in UTC is
> > quite correct - it was indeed 3pm in location B when it was
> > 7am in London. Bu
On Mon, Apr 14, 2008 at 09:39:57PM -0400, Tom Lane wrote:
> considering alignment...). ISTM that we have defined timestamptz
> in such a way that it solves many real-world problems, and timestamp
> also solves real-world problems,
No doubt about it.
> but the use-case for a timestamp plus an exp
On Mon, Apr 14, 2008 at 09:10:52PM -0400, Tom Lane wrote:
> Actually, your mistake is in imagining that timestamptz represents the
> timezone explicitly ... it doesn't.
Which really is a great pity :-(
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E40
On Sat, Apr 05, 2008 at 08:42:34PM -0700, Frank Miles wrote:
> Unfortunately this does not help for lesser events (i.e. NOTICE and WARNING).
> My preliminary effort suggests that psycopg isn't passing these.
Not as exceptions, certainly.
For one thing there's
cursor.statusmessage which (should)
On Fri, Apr 04, 2008 at 12:02:20PM -0700, Frank Miles wrote:
> I have a moderately DB-ignorant question: is there a "built-in" way for an
> application to receive the message emitted by a RAISE in a PgSQL
> function?
>
> Context: I have a moderately complex application (in python, using psyc
On Thu, Mar 20, 2008 at 02:08:13PM +0100, Martijn van Oosterhout wrote:
> > It's great fun to watch people from all across the globe
> > change data on test patients in our public test database.
> > The frontend is written to display such updates in realtime
> > (well, whatever it takes to get the
On Wed, Mar 19, 2008 at 11:37:16AM +1030, Tyler, Mark wrote:
> > Oh, you can, you can calculate the name of the NOTIFY dynamically
> > in the trigger sending the notify, for example embedding a primary key
> value.
>
> I don't understand how this can work. Surely my subscriber applications
> hav
On Tue, Mar 18, 2008 at 01:28:36PM +1030, Tyler, Mark wrote:
> This
> is because I cannot pass any information with the NOTIFY apart from the
> fact that "something happened".
Oh, you can, you can calculate the name of the NOTIFY
dynamically in the trigger sending the notify, for example
embedding
On Wed, Mar 12, 2008 at 07:52:29AM -0400, Kynn Jones wrote:
> > An ON CONNECT trigger enforced by the database seems a bit scary to me.
> > If it's broken, how you gonna get into the DB to fix it?
A "psql --skip-on-connect-trigger", only available to, say,
superusers ? Or a database flag (like th
On Mon, Mar 03, 2008 at 01:22:17PM -0600, Erik Jones wrote:
> Where are you getting this information.
IMO the OP wanted to know how people *use* arrays, not how
one *can* use arrays.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
On Mon, Mar 03, 2008 at 10:42:50AM -0700, dmp wrote:
> The project MyJSQLView will provided basic support
> for array types in PostgreSQL at the next release.
> Information is desired from anyone that uses arrays
> in PostgreSQL to effect this support.
> 1. What Size, <10 or 100's, 1000's of ele
uires DDL whenever a form is added by a user.
The second requires client-side logic making form reuse across clients
a lot harder (SPOT violation ?).
The third sounds OK -- but seems to be of the apparently dreaded EAV type.
What am I missing ? Where should I get a clue ?
Thanks,
Karsten Hilbert
On Thu, Jan 31, 2008 at 02:35:01AM -0800, T.J. Adami wrote:
> Everytime I deploy a PostgreSQL server in a ubuntu or debian based
> server, I create some scripts called pg_start, pg_stop and pg_reload,
> save them on default postgresql home dir. Then I create symbolic links
> on /usr/bin, and so on
On Thu, Dec 20, 2007 at 12:55:02AM -0500, Tom Lane wrote:
> "Mike C" <[EMAIL PROTECTED]> writes:
> > And for non-persistent transaction ids, the documentation says that
> > this is for read-only transactions. What defines a read-only
> > transaction for this purpose?
>
> A transaction that has no
On Mon, Nov 12, 2007 at 02:19:21PM +0100, Patric Bechtel wrote:
> Just guess: We have bigint id's through the system, so I want to give
> the users the convenience of typing only the last 4-5 digits (which most
> of the time is enough). So the query we issue really is
> ... like "%$userinput"
>
>
On Mon, Nov 12, 2007 at 12:46:58AM +0100, Patric Bechtel wrote:
> select * from bla where a like '8%'
Patrick, I'm not sure what you expect to come back:
8 ? 0.08 ?
8% of each of bla.a's values ?
do 7% or 9% count, too ? ("a like '8%'" seems to say "well,
about 8% of a, or close, anyways").
I
On Fri, Nov 09, 2007 at 11:26:21AM +0100, Reg Me Please wrote:
> WARNING: relation "public.t_dati" contains more than "max_fsm_pages" pages
> with useful free space
> HINT: Consider compacting this relation or increasing the configuration
> parameter "max_fsm_pages".
>
> Would it be possible
On Wed, Nov 07, 2007 at 05:36:47PM +0200, Marko Kreen wrote:
> > > I'm wondering if you cast the md5sum as a bytea instead of text and
> > > then sort, if that would solve it simply.
> >
> > Along the lines of
> >
> > ... ORDER BY decode(md5('...'), 'hex');
> >
> Maybe using digest(.., 'md
On Wed, Nov 07, 2007 at 03:54:02PM +0100, Martijn van Oosterhout wrote:
> > Should I be going about this sorting or hashing or detection
> > business in another way entirely which can be done at the
> > SQL level ?
>
> I'm wondering if you cast the md5sum as a bytea instead of text and
> then
Hi,
in GNUmed (wiki.gnumed.de) we use schema hashing to detect
whether a database can safely be upgraded or used by a
client. The general procedure is this:
- generate a line-by-line representation of the database
objects in the format "schema.table.column::data type"
from the information cat
On Sun, Oct 28, 2007 at 01:59:22AM +0200, Dennis Brakhane wrote:
> I have some problems supporting "translatable columns" in a way that
> is both efficient and comfortable for the programmer who has to write
> SQL-Queries (we use iBatis)
Maybe this helps a bit:
http://salaam.homeunix.com
301 - 400 of 642 matches
Mail list logo
