[EMAIL PROTECTED] says...
> > 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 Interbase/Firebi
Hi Alvaro,
On Jan 15, 2004, at 10:31 PM, Alvaro Herrera wrote:
Maybe it's tangential to this discussion, but there's a type to store
that kind of intervals. It's called tinterval. ISTM it's not too much
documented, and I haven't really used it.
alvherre=> select tinterval('2003-10-28', '2004-11
> 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 T
What about a SELECT syntax like that?
SELECT
CASE WHEN bar.foo_id IS NULL THEN bar.*
ELSE foo.*
FROM foo, bar
Anyway, I need a SELECT query that gets data from a FIRST TABLE if a
specific value in a SECOND TABLE is NULL or from SECOND TABLE itself if
the value IS NOT NULL.
Any suggestio
I am currently evaluating all open source databases and possibly my fresh
opinion will be of interest.
I went over documentation and setup of Firebird, MySQL and PostgreSql and
here is "perception"(to get better understanding one has to run thing for
quite a while):
As for "user friendly" image:
On Thu, 15 Jan 2004, Tom Lane wrote:
> Csaba Nagy <[EMAIL PROTECTED]> writes:
> > On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
> >> why not use pgsql-chat, which isn't being used at all right now ... ?
>
> > I have the impression that these "Postgres vs MySQL vs XXX" stuff is
> > regularly
On Thu, 15 Jan 2004, Francois Suter wrote:
> > why not use pgsql-chat, which isn't being used at all right now ... ?
> >>
> >> I would suggest that we consider forming a pgsql-competitive email
> >> list for
>
> Whatever, but using another mailing is definitely an excellent idea. I
> actually stop
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
here's one more.
In coding an game asset server I want to keep a large number of file
revisions of varying sizes (1Kb-50Mb) inside the database.
Naturally
Eric wrote:
Hi,
I would like to know if a daemon exist to intercept Oracle queries and
translate to postgresql query...
I have a windows app (AccPac) that connect to an Oracle server via
ODBC. I would like to replace the Oracle server with a postgresql.
Accpac support only Oracle, DB2, MS-SQ
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> From the HTML docs:
> "The referenced columns must be the columns of a unique or primary key
> constraint in the referenced table."
> I personally don't know of a work around. Maybe some of the others do.
There is no workaround, because foreign keys
On Thu, 15 Jan 2004, [ISO-8859-1] Victor Spång Arthursson wrote:
> New to foreign keys and have some questions
>
> The first is, i have a language table with a primary key on the fields
> lang and relid:
>
> relid | lang |text
> ---+--+-
> 1 | uk | hello
> 1
Csaba Nagy <[EMAIL PROTECTED]> writes:
> On Thu, 2004-01-15 at 16:14, Marc G. Fournier wrote:
>> why not use pgsql-chat, which isn't being used at all right now ... ?
> I have the impression that these "Postgres vs MySQL vs XXX" stuff is
> regularly started up by newcomers to this list. So whereve
Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> >You're kidding me...
> >
> >
> >
> No I am not... You missed the point, there is no official Linux website.
> Linux.org is ran by one guy,
> linux.com is run by VA (I actually used to have [EMAIL PROTECTED]), I own
> Linuxdoc.org and Linuxdo
Hi all!
I have a big problem installing postmaster as a service under Windows XP
with cygwin. I already installed postgresql on 2 machines without
problems but this machine really seem to don't like postgresql ;) I do
exactly the procedure indicated in the README file but I always got the
sa
Karsten Hilbert <[EMAIL PROTECTED]> writes:
>> 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
From the HTML docs:
"The referenced columns must be the columns of a unique or primary key
constraint in the referenced table."
I personally don't know of a work around. Maybe some of the others do.
On Thursday 15 January 2004 10:56 am, Victor Spång Arthursson wrote:
> New to foreign keys and
Hi all,
I have the impression that these "Postgres vs MySQL vs XXX" stuff is
regularly started up by newcomers to this list. So wherever you will
decide to move it, it will still pop up here - the new-comers will know
nothing about being elsewhere, except it is called something very-very
suggestiv
I would suspect the manner in which it was started. Does your postresql.conf
file have tcpip_socket=true?. If it is set to false and the script that
starts Postgres does not use the '-o -i' switch then the database will not
accept tcpip connections. Have you tried psql on the database host to s
On Thursday 15 January 2004 15:02, Bill Moran wrote:
> I'm having a little trouble understanding how to do something. I assume
> I'm just missing it in the documentation, so a pointer to relevent docs
> would be as welcome as a direct answer.
>
> I have a project in which I'll need to create a num
On Thursday 15 January 2004 15:22, Uros wrote:
>
> RH> Also - make sure you haven't got a column called 'email' in any query
> where RH> you are using the variable 'email' - that can cause confusion.
>
>
> Problem was aliases, becasu alias name was the same as column and then the
> same name was va
On Thu, 15 Jan 2004, Bill Moran wrote:
> I'm having a little trouble understanding how to do something. I assume
> I'm just missing it in the documentation, so a pointer to relevent docs
> would be as welcome as a direct answer.
>
> I have a project in which I'll need to create a number of store
Uros <[EMAIL PROTECTED]> writes:
> I have problem with my function and I can find what's wrong.
Don't use plpgsql variable names that conflict with field names of the
tables you are trying to access in the function.
regards, tom lane
---(end of bro
New to foreign keys and have some questions…
The first is, i have a language table with a primary key on the fields
lang and relid:
relid | lang |text
---+--+-
1 | uk | hello
1 | dk | hej
1 | de | guten tag
2 | uk | world
2 | dk | værld
David Garamond <[EMAIL PROTECTED]> writes:
> The MySQL manual recommends that we create a "fixed-length row" if
> possible, for speed (especially scanning speed).
> Is there a similar recommendation in PostgreSQL?
No. There are some marginal optimizations that take place if your
columns are fix
> 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
> 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 t
> Do the developers generally oppose the idea of a threaded (but
> non-embedded) backend as well? If the backend is thread-safe, then users
> can still choose to run multiprocess or multithreaded right?
I've been under the impression that the developers were opposed to a
threaded server because of
why not use pgsql-chat, which isn't being used at all right now ... ?
I would suggest that we consider forming a pgsql-competitive email
list for
Whatever, but using another mailing is definitely an excellent idea. I
actually stopped reading -general recently because it got bogged down
in yet an
Hello Richard,
Thursday, January 15, 2004, 4:10:10 PM, you wrote:
RH> On Thursday 15 January 2004 14:25, Uros wrote:
>> Hello!
>>
>> I have problem with my function and I can find what's wrong.
>>
>> WARNING: Error occurred while executing PL/pgSQL function
>> fn_insert_entry_pending WARNING: l
You're kidding me...
No I am not... You missed the point, there is no official Linux website.
Linux.org is ran by one guy,
linux.com is run by VA (I actually used to have [EMAIL PROTECTED]), I own
Linuxdoc.org and Linuxdoc.com...
The closest you get to a "linux" website is kernel.org.
Sincer
Heres what is get with nmap localhost
[EMAIL PROTECTED]
[EMAIL PROTECTED] root]# nmap localhost
Starting nmap V. 3.00 ( www.insecure.org/nmap/ )
Interesting ports on database (127.0.0.1):
(The 1590 ports scanned but not shown below are in state: closed)
Port State Service
21/tcp
why not use pgsql-chat, which isn't being used at all right now ... ?
On Thu, 15 Jan 2004, Chris Travers wrote:
> From: "Jonathan Bartlett" <[EMAIL PROTECTED]>
> > We need a Postgres vs MySQL Mailing list :)
>
> you are going to laugh but I don't think that this is such a bad idea,
> provided th
"Nick Barr" <[EMAIL PROTECTED]> writes:
>> Isn't there also a performance benefit as you can use an index if you
>> say "this definitely starts at the beginning" with the '^'?
> That is what I was thinking, which is the other reason why I put it in.
> This is only the case with the default locale
I can send you the test data, but it's confidential so
I'll need to ask that you handle it carefully. Can
you contact me off-list about this? I tried to send
to your account directly but was bounced by your spam
filter from both this and another account.
Ben
--- Tom Lane <[EMAIL PROTECTED]> wro
From: "Keith C. Perry" <[EMAIL PROTECTED]>
> 3) Not being able to "find" something in via search BEFORE even reading
the
>documentation is somewhat backwards. You have to at least get a feel
for
>the docs before even know what to look for. That is not to say that
the
>search engine i
Regarding MAC address as a machine key.
I suspect that you could take md5(MAC_Address || IPV4_Address) to create a
machine ID which you can reasonably expect to be unique (i.e. the chance of
having 2 identical MAC addresses on the same IPV4 address is small enough to
disregard). I only suggest us
Tom Lane wrote:
The fact that RI triggers issue SQL commands is an artifact of
their implementation (and one that I believe Stephan and Jan would like
to get rid of); they shouldn't be cluttering the log at all.
I am glad you mentioned that - I did find myself wondering why it was
necessary t
From: "Jonathan Bartlett" <[EMAIL PROTECTED]>
> We need a Postgres vs MySQL Mailing list :)
you are going to laugh but I don't think that this is such a bad idea,
provided that it is not limited to Postgres vs MySQL. Advocacy is good and
all, but they are more interested in promoting PostgreSQL t
From: <[EMAIL PROTECTED]>
> First I would be happy to help get these things in postgresql. I'm not a
> c/c++ programming guru and would have to learn a bit before I could do the
> coding. I would be happy to test or talk about what's needed or anything
> like that. Or just keep the fire burning
Mark Kirkwood <[EMAIL PROTECTED]> writes:
> So setting "log_statement=true" does all *statements* - but not all
> *executions* of each statement. Is this the intention?
AFAIK this is an implementation artifact that's never really been
discussed. Another aspect of the artifact is that SQL command
> Yeah, this is an error in the 7.3 pg_dump logic for schemas. Use the
> pg_dump from the 7.4 installation to dump the 7.3 server, or manually
> edit the dump file ...
When I try to build 7.4.1 on that system, I get the following error
in the regression test:
/home/postgres/src/postgresql-7.4.1/
41 matches
Mail list logo
