Bill Moran schrieb:
> While I've no objection to someone helping out by converting files, I
find it odd that flv is suggested. I've yet to find anything that can
play flv files on my FreeBSD desktop machine. I'm pretty sure mplayer
can play mov files ... I guess I'll find out this evening when
Greg Stark schrieb:
On Tue, Jul 28, 2009 at 1:41 PM, Andreas
Wenk wrote:
Why not use a standardized openly documented container format like
mpeg4 with mpeg4 part 2 compression instead of one controlled by a
single company like flv or quicktime? That would let people play it
using any of various
Jennifer Trey schrieb:
I am in the process of switching to Ubuntu, and I have a couple of
question to get started. I installed pgadmin and postgre through the
Synaptic Package Manager. I am unfamiliar with the console so I prefer
to use pgAdmin to set things up.
congratulations for switching
Christophe Pettus schrieb:
Historically, MOV has been the least-bad container format; Flash support
on anything besides Windows has, traditionally, been very spotty. The
files themselves are pretty much the same size; FLV is (as noted) a
container format, not a codec, and the video is H.264
Christophe Pettus schrieb:
On Jul 28, 2009, at 8:35 AM, Andreas Wenk wrote:
uh - HTML 5 is supported by the browser when?
Currently, the tag is supported by Firefox 3.5, Safari 3 and 4,
Chrome 3 (in alpha, I believe), iPhone 3.
That being said, we can do a fallback to Quicktime, then to
David Fetter schrieb:
Just a quick question. Wouldn't it be better to provide the videos in flv
format in a player in this page. Since I have a MAC, I have no problems
viewing the videos. But with my Linux box and FF 3.5 I can't.
You can use xine on your Linux box :)
Cheers,
David.
David, t
The function "convert_to(string text, dest_encoding name)" will throw an
error and so break my application when not supported characters are
included in the unicode string.
So what can I do
- to filter characters out which have no counterpart in the latin codesets
- or to simple ignore wrong cha
terval from (select
generate_series(0,10) as a) as s;
?column?
-
2009-08-03 00:00:00
2009-09-03 00:00:00
2009-10-03 00:00:00
2009-11-03 00:00:00
2009-12-03 00:00:00
2010-01-03 00:00:00
2010-02-03 00:00:00
2010-03-03 00:00:00
2010-04-03 00:00:00
2010-05-03 00:00:
The function "convert_to(string text, dest_encoding name)" will throw an
error and so break my application when not supported characters are
included in the unicode string.
So what can I do
- to filter characters out which have no counterpart in the latin codesets
- or to simple ignore wrong cha
So there is definitely no way to this natively? Which would be better
because this an easy task, which should be part of the main distribution.
What is more performant - has anyone made a benchmark?
1) Perl:
http://markmail.org/message/2jpp7p26ohreqnsh?q=plperlu+iconv+postgresql&page=1&refer=2
Alban Hertroys schrieb:
On 3 Aug 2009, at 20:32, Andreas Kalsch wrote:
Problem: Users will enter _any_ characters in my application and an
error really doesn't help in this case.
I think the real problem is: Where do you lose the original encoding
the users input their data with? I
How is it possible to refer to another database, like:
select * from otherDatabase.nodes;
I have read something about schemas and I have simply created an own
schema for every database with the same name, but it still does not
work. Is there anything plain and simple?
Best,
Andi
--
Sent v
Will it decrease performance to refer to other schemas?
David Fetter schrieb:
On Tue, Aug 04, 2009 at 04:41:51AM +0200, Andreas Kalsch wrote:
How is it possible to refer to another database, like:
select * from otherDatabase.nodes;
Generally, you use schemas for this. Schemas are
gant, but will be my solution then ...
John R Pierce schrieb:
Andreas Kalsch wrote:
Will it decrease performance to refer to other schemas?
no. the schemas are simply two namespaces in the same database.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Two causes:
1) I have to rewrite many lines of code = time
2) In MySQL I have access - with superuser rights - to _all_ existing
databases inside the installation. In Postgres I haven't.
But, of course, that are just details.
Best,
Andi
Tom Lane schrieb:
Andreas Kalsch writes:
2009, at 24:57, Andreas Kalsch wrote:
I think the real problem is: Where do you lose the original encoding
the users input their data with? If you specify that encoding on the
connection and send it to a database that can handle UTF-8 then you
shouldn't be getting any conversion problem
rting from exotic sets and it's the way
to go for a site with high traffic. I would prefer to do it on the
PHP/Python side to send in one encoding to the database server, because
it could be that you additionally send own strings.
Alban Hertroys schrieb:
On 4 Aug 2009, at 15:02, Andr
RRAYS-SEARCHING)
But i don't know how to create an index for that...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --en
ls.
>
> Is there a way to either test if the custom variable is set, or to specify a
> global default for the custom variable ?
I think, you can use COALESCE(your_variable, default_value) to solve
that problem. Try it, it is untested.
Andreas
--
Really, I'm not out to destroy M
a bug, isn't it?
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe
rr04 wrote:
I am an MIT student doing a project on schema-less database usage and would
greatly appreciate if you guys can fill out a quick survey on this (should
take < 5 mins)
http://bit.ly/nosqldb
Hi,
even when I think that most of the people on this list will answer the
same way to your
A. Kretschmer wrote:
> In response to Angus Miller :
> > Hi
> >
> > Given the sql below shouldn't I get the 3 records back?
>
> No, why?
Oh,... sorry, right. 8.1 returns 3 rows, see Tom's answer.
Andreas
--
Really, I'm not out to destroy
Has somebody integrated Unicode normalization into Postgres? if not, I
would have to implement my own function by using this CPAN module:
http://search.cpan.org/~sadahiro/Unicode-Normalize-1.03/ .
I need a function which removes all diacritics (1) and transforms some
characters to a more compa
NSERT INTO t (ts) VALUES(to_tsvector(normalize(?)));
Andi
David Fetter schrieb:
On Wed, Sep 16, 2009 at 07:20:21PM +0200, Andreas Kalsch wrote:
Has somebody integrated Unicode normalization into Postgres? if not, I
would have to implement my own function by using this CPAN module:
h
Update: The error is of course: The function tries to return "str"
instead of unicode. It is not str.decode('UTF-8') which causes the error.
Andreas Kalsch schrieb:
No,
I need a solution which is as generic as possible. I use UTF-8 encoded
unicode strings on all levels.
included in
the main distribution?
Andi
Sam Mason schrieb:
On Wed, Sep 16, 2009 at 09:35:02PM +0200, Andreas Kalsch wrote:
CREATE OR REPLACE FUNCTION test (str text)
RETURNS text
AS $$
import unicodedata
return unicodedata.normalize('NFKD', str.decode('UTF
My standard encoding is UTF-8 on all levels so I don't need this
high-cost call:
plpy.execute("select setting from pg_settings where name =
'server_encoding'");
Additionally I want to get the original cases.
For this purpose my solution is still fitting to my need. But it is not
the one you
PostgreSQL server failed to start. Please check the log output.
>
>
> What can I do to figure out why it won't start?
I know, from IRC, the problem has been solved, there was no space on the
disk ...
Unfortunately, i haven't logs.
Andreas
--
Really, I'm not out to destroy
How do I rename constraints? Renaming columns will not rename constraints.
Andi
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
David Fetter schrieb:
On Thu, Oct 08, 2009 at 08:24:06PM +0200, Andreas Kalsch wrote:
How do I rename constraints? Renaming columns will not rename constraints.
BEGIN;
ALTER TABLE foo DROP CONSTRAINT bar;
ALTER TABLE foo ADD CONSTRAINT bluf...;
COMMIT;
Cheers,
David.
--
Sent
...
How can I enable system catalog modifications?
Thanks for your help, so far.
Andi
Tom Lane schrieb:
Andreas Kalsch writes:
But with this operation you will recreate the whole index. - I have
found out, that the name of the constraint's index is the same as the
constraint, so th
Reid Thompson wrote:
> In the case where a_text is null, I essentially want the same result as the
> case when a_text = ''.
>
> would this:
> select a_int || coalesce(a_text,'') from test1 where a_int = 102;
> be the proper way?
Yes.
Andreas
--
Re
group by a;
a | array_agg
---+---
1 | {1,2,3}
2 | {1,4}
(2 Zeilen)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin
FK's?
You can't reorder the fields, use a 'SELECT field 1, field2, ..., fieldN
FROM instead. It has hothing to do with the FK's field.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
und 2 times in string 'fooXblaX').
How about:
test=*# select length('fooXblaX') -
length(regexp_replace('fooXblaX','X','','g')) / length('X');
?column?
--
2
(1 Zeile)
Andreas
--
Really, I'm not out to de
these numbers with PostgreSQL.
>
> Does anyone know such number?
Not really what your are looking for, but also interesting:
http://vimeo.com/1081680
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
Salvete!
I have the following problem.
I'd like to define the operator symbol / as a left unary operator for
reciprocal value of a number.
I did this with a C-function and all the stuff around, but it does not work.
Hiere is an extract and simplified example with the same error message
as in m
On 18.09.2013 02:17, David Johnston wrote:
Andreas Ulbrich wrote
create operator ^- (leftarg = float, procedure = reciproce);
works too, but
create operator / (leftarg = float, procedure = reciproce);
not.
Do you mean the "^" operator or the "^-" operator? Rowan claims
QUERY PLAN
-
Index Scan using idx_hstore on my_hstore (cost=0.13..8.15 rows=1 width=36)
Index Cond: (werte ? 'key1'::text)
Filter: ((werte -> 'key1'::text) = 'val1'::text
Matteo Beccati wrote:
> Hi Andreas,
>
> On 27/09/2013 09:24, Andreas Kretschmer wrote:
> > This query can't use the index:
> >
> > test=*# explain select * from my_hstore where werte->'key1' = 'val1&
Johann Spies wrote:
> SELECT A.article_id, A publication_year
>
> I have seen it once before and could not figured out what is causing it.
The point is the missing point between A and publication_year ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just b
Hi @all,
ist there (in 9.1) a way to unload a shared lib?
It seems it's impossible since 8.1 or so, i'm right?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
it is used) or eager load (for slower startup
> but
> faster execution).
not sure I fully understand your point. Isn't this the typical
mode-of-operation plus added cache warming?
Anyways, just wanted to point you to [1] which gives a good overview of cache
warming tech
improves our build times but I think there
are better ways to have in-memory/application caches than using a postgres.
What is your use-case?
Regards
Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
files at the
> same time, thus requiring only a few GB of free space?
AFAIK a VACUUM FULL frees the old data after having completely written the new
version. So the size of the original table is an upper bound for the space
requirement and it can be much less (in case the original table is blo
Slony or Bucardo.
WAL's contains transaction informations for the whole cluster, you can't
choose particular databases or tables.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
---+---
2013-12-16 01:16:19.783235+01 | 2013-12-18 01:16:19.783235+01
(1 row)
AFAIK that should also be SQL compliant.
Regards,
Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
John,
- Ursprüngliche Mail -
> On 12/15/2013 4:17 PM, Andreas Brandl wrote:
> > select current_timestamp, current_timestamp + interval '2' day;
>
> that should be interval '2 day' (note the ' moved), and for a
> variable number passed as a pa
hello all,
don't ask why, but a customer created tables with foreign key constraints but
with inconsistent data.
Because of this he disabled all triggers (alter table foo disable trigger all).
So far, so bad ...
(he can't clean the data at the moment)
In the dump there are the constraints, but
atabase from Oracle to PostgreSQL. All ARIN systems are now
operating normally. We thank you for your patience as we continue to
strive to improve our services.
This is great news indeed!
--
Andreas Karlsson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
Jeff Silberberg wrote:
> Anyway, I Am now looking for new host instead of fixing this one..
I'm working for internet24.de, a hosting - provider in germany. We are
support PostgreSQL in our shared hostig ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be
far we use PostgreSQL via ODBC, but now we want to
switch to a native libpq implementation.
--
with best regards,
Andreas Lubensky
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing a
proper replacement (as ODBC probably does) most likely requires a full
blown SQL parser...
On Mon, 2014-01-20 at 14:08 +0400, Dmitriy Igrishin wrote:
> Hey Andreas,
>
>
> 2014/1/20 Andreas Lubensky
> Hi,
>
> Is there any way to make PostgreSQL
"Michael P. Soulier" hat am 20. Januar 2014 um 15:33
geschrieben:
> Hi,
>
> I have a uniqueness constraint on an integer value in a table where I would
> like to mass increment all of the existing rows.
>
> ie.
> update rules set rule_number = rule_number + 1;
>
> This violates the uniquness con
Hello,
When implementing a database backend with libpq I realized that it seems
to be impossible to declare a cursor on a prepared statement. Is this
correct? What is the reason for this limitation?
--
with best regards,
Andreas Lubensky
--
Sent via pgsql-general mailing list (pgsql-general
should work for you too. :-)
Right, and as a hint: dont store the AGE of a person, store the
birthdate instead.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If
, 2014-01-23 at 15:07 -0600, Merlin Moncure wrote:
> On Thu, Jan 23, 2014 at 8:31 AM, Andreas Lubensky
> wrote:
> > Hello,
> > When implementing a database backend with libpq I realized that it seems
> > to be impossible to declare a cursor on a prepared statement. Is this
d the
transaction is rolled back to the savepoint, the next commit results in
a warning:
Snapshot reference leak: Snapshot 0xb5e4b0 still referenced
I'm not sure what to make of that. Can it be ignored? Is rolling back
large object operations not possible?
--
with best regards,
Andreas Lubensky
Thanks Alvaro, that is good to know. At the moment we are stuck with
version 9.1.9 and have to stay there at least for Linux. But do I
understand correctly, that the warning can be ignored for the moment?
On Fri, 2014-01-31 at 15:15 -0300, Alvaro Herrera wrote:
> Andreas Lubensky wrote:
>
after a crash, but after a regular shutdown / restart all
data in the table.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin w
Andreas Joseph Krogh wrote:
> I'm trying to define the following exclusion-constraint
>
>
> alter table my_table add EXCLUDE USING gist (is_default WITH =,
> daterange(valid_from, valid_to, '[)') WITH &&) WHERE (is_default = true);
>
>
> But
;: 3, "d": 4}
The same goes for removing values.
Did I overlook something obvious or is there really no way to do that right now?
Best regards,
Andreas Heiduk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello Oleg,
how are the odds that the '||' and '-' operators from jsonbx will be
included in the public 9.4 release?
Andreas
On 2 May 2014 21:21, Oleg Bartunov wrote:
> Andreas,
>
> take a look on https://github.com/erthalion/jsonbx. This is a place,
> where
Hello Oleg,
that's a pitty. I think at least some server-side processing for jsonb
would make a round package. But I will monitor Dimitri's extension.
Thank you very much for your answer.
Andreas
On 3 May 2014 00:26, Oleg Bartunov wrote:
> No way, Andreas !
>
> But, we
gt; native Windows port, quickly becoming a committer to help with his
> efforts. He's one of the project's webmasters and sysadmins and also
> contributes to related projects such as pgAdmin. In his spare time, he
> serves as President of the Board of PostgreSQL Europe.
Congrat
the
> postgres or it also takes into account the linux buffers that postgres uses?
shared hit: read from shared mem
shared read: read from disk into shared mem
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
have the password to
connect to the db.
i did not find any options to send the password with the command line in
vacuumdb!?
CheersAndreas
--
Dipl. Geoökologe Andreas Laggner
Institut für Agrarrelevante Klimaforschung (AK) des vTI
Arbeitsgruppe Emissionsinventare
Johann Heinrich von
thank you depesz, your help was very useful!
Am 12.05.2011 13:19, schrieb hubert depesz lubaczewski:
On Thu, May 12, 2011 at 10:56:20AM +0200, Andreas Laggner wrote:
Hi list,
i always vaccumed my postgresql automatically with crontab, because
autovacuum is not suitable for my applications
body=help>
List-ID:
List-Owner: <mailto:pgsql-general-ow...@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majord...@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majord...@postgresql.org?body=unsub%20pgsql-gene
ate_notify| 752 kB
> btv_admin.tv_program | 656 kB
> btv.rel_material2tag | 592 kB
> (15 rows)
>
> The sum of biggest tables is not even close to the total db size .
> Some index going wild ?
Your sum doesn't contains indexes and toa
postgresql.conf. But it still
> > going through sequential scan.
>
> It sounds like your index can't actually be used to satisfy your
> query. Without seeing the table definition, index definition, and
> query, however, it's pretty hard to give you a real answer.
Nick Raj wrote:
>
> On Mon, May 23, 2011 at 5:44 PM, Andreas Kretschmer
>
> wrote:
>
> Andrew Sullivan wrote:
>
> > On Mon, May 23, 2011 at 05:31:04PM +0530, Nick Raj wrote:
> > > Hi,
> > > I have build an index. When, i ex
wstrzalka wrote:
> Hi
>
>Is there any estimate where 9.1 potentially could be released?
Sure. When it's ready ;-)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvald
http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
>
> isn't it limit for PHP?
Maybe...
Yeah, i think, 16 MByte isn't the real limit, yes. And i've seen
queries larger than that limit, but i can't find the link, sorry.
(maybe depesz.com, dunno, can't
LTER TABLE
Time: 50,810 ms
test=*# \d foo;
Table "public.foo"
Column | Type | Modifiers
+-+---
t | integer |
test=*# select * from foo;
t
---
1
2
3
4
(4 rows)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
s be utilized to operate on
> views directly? Please let me know on this.
Sure, you can do that (with recent versions) with:
copy (select * from your_view) to ...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
reserve (maybe 3 or so)
And you need a propper recovery.conf on the new client.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin w
the client (same
hardware). In my experience it's only a fraction of work for the client
(streaming replication with 9.0)
> every day? if it cannot, any other suggestions for HA ?thx in advance
Depends on your requirements, for instance heartbeat and DRBD is an
other solution.
Andreas
-
omethign like this?
Yes, use the CTID-column.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unk
140.00 rows=1 width=6) (actual
time=19.090..19.090 rows=0 loops=1)
-> Seq Scan on a (cost=0.00..140.00 rows=1 width=6) (actual
time=0.014..3.868 rows=1 loops=1)
Trigger for constraint b_i_fkey: time=9823.762 calls=1
Total runtime: 9846.789 ms
(4 rows)
The same plan, but n
problems
> reading from the bytea-stream.
You can set bytea_output from 'hex' (now default) to 'escape'
(traditional format). You can do that in the postgresq.conf (for the
whole cluster), via ALTER DATABASE or per session.
HTH.
Andreas
--
Really, I'm not out to destroy
? -
>
> My question is: should I increase shared_buffers
> from 1024MB to 8192MB, does it make any sense?
I think, 4GB is okay, 8GB too high. You can increase work_mem, but all
depends on your workload...
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a co
at users can see other databases.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxon
tual time=0.065..55.730 rows=3060 loops=1)
Total runtime: 56.169 ms
(2 rows)
Why not using the index (it's a primary key) for the first query?
PG 9.1.3
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
Tom Lane wrote:
> Andreas Kretschmer writes:
> > production=*# explain analyse select * from boxes;
> > QUERY PLAN
> >
an I retrieve the complete structure in one query ?
Start with parent is null in the first query (instead of 'where
node=4').
*untested*
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Li
ilywtf.com/Articles/Stupid-Coding-Tricks-The-TSQL-Madlebrot.aspx
http://wiki.postgresql.org/wiki/Mandelbrot_set
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god,
"Little, Douglas" hat am 30. Juli 2012 um 16:36
geschrieben:
> I have an input source that is in epoch time.Is there a built-in
> conversion to changing to timestamp
>
>
>
select 'epoch'::date + * '1second'::interval;
Andreas
-
Hi all,
great feature, but i can't find a TIMERANGE, i want to store time-ranges, for
instance [10:00:00,16:00:00), how can i do that?
Regards, Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
Jeff Davis wrote:
> On Fri, 2012-08-03 at 17:06 +0200, Andreas Kretschmer wrote:
> > Hi all,
> > great feature, but i can't find a TIMERANGE, i want to store time-ranges,
> > for
> > instance [10:00:00,16:00:00), how can i do that?
>
> CREATE TYPE timer
Kevin Grittner wrote:
> David Greco wrote:
>
> > Surprised to see this isn't offered as a Foreign Data Wrapper- one
> > to other Postgres servers.
>
> People have been working on it. It seems quite likely to be
> included in the 9.3 release next year.
That
If i where you i would try:
select lo_unlink(rest) from image
but i'm never used this function...
Neanderthelle Jones hat am 12. August 2012 um 12:16
geschrieben:
> I'd like to delete all the image files from a table by issuing an
> interactive psql command. Given
>
> CREATE TABLE image (
>
> select lo_unlink(rest) from image
>
> but i'm never used this function...
i've ...
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Name | Owner | Access privileges | Description
+---+---+
foobar | root | | my new comment
(1 row)
Regards, Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e f2>, instead there should be two entries in the index and ).
>
> we have a few use cases for the above, perhaps we need to alter the
> schema somehow to accommodate the above,
2 separate indexes? One on f1 and one on f2?
Andreas
--
Really, I'm not out to destroy Microsoft
max(id) from table_that_does_not_exist;
ERROR: relation "table_that_does_not_exist" does not exist
LINE 1: select max(id) from table_that_does_not_exist;
The database can't know and analyse the function-body.
Andreas
--
Really, I'm not out to destroy Microsoft
salah jubeh wrote:
> Hello Andreas,
>
> Thanks for the reply, The example I have posted is very simple and you are
> right it is very similar to select max (id) from table_that_does_not_exist;
> But
> there are more here, for example imagine I have something like
>
>
e: 0,605 ms
test=*# insert into a values (array[1,2,30]);
ERROR: new row for relation "a" violates check constraint "a_i_check"
(only for values greater than 10, but i think you can see the wa...)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a
new row for relation "i" violates check constraint "i_i_check"
Nice! Didn't know that with all()
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
&quo
the
> application(s).
>
> Nowaday it's not uncommon that multiple applications read and write to the
> same database and in that case you simply
> cannot rely on all of them to validate the data.
Full ack.
Andreas
--
Really, I'm not
401 - 500 of 1080 matches
Mail list logo
