[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was taken down for
disk upgrade and mysql apperantly did not commit the last insert.. OK he was
using myisam but still..:-)
It sounds like that is more a problem with improper operating protocols
than with
On Thu, 2003-10-09 at 02:16, CSN wrote:
Is there any date type that can be used for 0-255
values? Like an int1 or byte column.
An int2 with a constraint on it.
--
-
Ron Johnson, Jr. [EMAIL PROTECTED]
Jefferson, LA USA
Fear the
You can try to use dblink (function returning results
from a remote database)and create some triggers with
it in order to make remote referential integrity.
Or if there's a lot of links between the tables in the
2 databases it may be better to use one database.
--- David Busby [EMAIL
Dennis Gearon wrote:
Isn't HKSC one of the languages supported by UNICODE? I thought they had
every langauge past and present in it.
You'll have to map HKSCS to UNICODE yourself before the data hits
postgresql, and data out of postgresql would be in UNICODE, and up to
you to convert back to
Is there any date type that can be used for 0-255
values? Like an int1 or byte column.
CSN
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---(end of broadcast)---
On Thursday 09 October 2003 08:10, CSN wrote:
Is there a way to have p/k sequences get automatically
set to max(id)+1 after COPY's like the following?
copy table1 (id,name) from stdin;
1 abc
2 def
3 fhi
\.
Not really - if you don't use the sequence it keeps its value. If you look at
Joe Conway wrote:
D. Stimits wrote:
table field pair. E.G., if I had in table 'one':
left right
=
a b
a c
b d
...then I'd need a list of a, b, c, d, and produce a new table:
left right
=
a b
a c
a d
b a
b c
b d
c a
c
Mat wrote:
Lines from postgresql.conf that don't start with a '#':
tcpip_socket = true
shared_buffers = 126976 #992 MB
sort_mem = 36864#36 MB
vacuum_mem = 73696 #72 MB
I would suggest scale down shared buffers to 128 or 64MB and set effective cache
size
Greetings,
I am trying to create a database to store imges as large objects. I am using
postgres7.3.4 on a SuSE8.2 machine. I read the PostgreSQL documentation on
lage objects. There are some new fnctions which I am unfamilar with. I have
books on postgresql but I am not aware of any
Here's an interesting response from mysql.com sales. Frankly, I don't see
how using it on multiple internal servers violates the GPL?!?:
btw, forgive me if this comes through as a repost later. I'm still
getting used to having multiple email addrs in this client :)
Hi John,
Thank you for your
CSN wrote:
Is there any date type that can be used for 0-255
values? Like an int1 or byte column.
You can use a smallint with constraint.
HTH
Shridhar
---(end of broadcast)---
TIP 8: explain analyze is your friend
Here is a simplificated example:
CREATE OR REPLACE FUNCTION ttt () RETURNS text AS '
return ;
' LANGUAGE 'plperlu';
CREATE OR REPLACE FUNCTION qqq () RETURNS text as '
DECLARE
v_text text;
v_text2 text;
BEGIN
v_text := upper(); -- cyrillic chars
v_text2 := ttt();
RETURN
I created a schema and piped it to psql but got an error message:
~/hacks/psql $ cat create.sql | psql test
ERROR: table country does not exist
ERROR: parser: parse error at or near ) at character 91
ERROR: table customer does not exist
NOTICE: CREATE TABLE will create implicit
On Wed, 2003-10-08 at 16:23, Joshua D. Drake wrote:
Here is the simple thing about MySQL licensing. It is GPL. If you
modify the mySQL source or you link a proprietary app to mySQL without
a commercial license. You must distrubute your changes and or
application as GPL or GPL compatibile.
On Thu, Oct 09, 2003 at 14:28:57 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
http://www.postgresql.org/docs/7.3/static/sql-createdomain.html
CREATE DOMAIN domainname [AS] data_type
[ DEFAULT default_expr ]
[ constraint [, ... ] ]
where constraint is:
[
I just run a script to update them after importing data. Something like this... (not
a real script...)
while read tablename
do
echo select setval('${tablename}_${tablename}_seq', \
(select max(${tablename}id) from $tablename)) | psql database
done
tablenames.txt
Of course, this
On Thu, 2003-10-09 at 14:46, Bruno Wolff III wrote:
On Thu, Oct 09, 2003 at 14:28:57 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
http://www.postgresql.org/docs/7.3/static/sql-createdomain.html
CREATE DOMAIN domainname [AS] data_type
[ DEFAULT default_expr ]
[
It's my opinion that we should be using PG, because of the full ACID
support, and the license involved. A consultant my company hired before
bringing me in is pushing hard for MySql, citing speed and community
support, as well as ACID support.
Does the consultant push speed AND ACID or speed OR
On Thu, Oct 09, 2003 at 15:55:27 -0400,
Gene Vital [EMAIL PROTECTED] wrote:
have an example :)
Bruno Wolff III wrote:
On Thu, Oct 09, 2003 at 14:26:21 -0400,
Gene Vital [EMAIL PROTECTED] wrote:
when inserting new records into parent / child tables, what is the best
recommended
On Thu, Oct 09, 2003 at 01:33:39PM +0200, Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Karel Zak [EMAIL PROTECTED] writes:
BTW, MySQL versions without transactions are unusable for 365/7/24
systems, because you cannot make backup of DB without transaction or
redo
On Thu, Oct 09, 2003 at 14:46:08 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
On Thu, 2003-10-09 at 14:46, Bruno Wolff III wrote:
On Thu, Oct 09, 2003 at 14:28:57 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
http://www.postgresql.org/docs/7.3/static/sql-createdomain.html
CREATE
fine). PG returns: ERROR: Relation _con does not exist
This is my query:
SELECT
_CON.con_id,
Please make sure you get the quoting right regarding table
names. PostgreSQL will fold _CON into _con unless quoted
_CON. So, it may be that you created the table with quotes
(_CON). Now, in
OK, I have the following table:
create table citations_by_level
(
aid smallint,
wid smallint,
v_level varchar(50),
w_level varchar(50),
x_level varchar(50),
y_level varchar(50),
z_level varchar(50),
byteloc integer
);
(If it helps,
ok, I am new to Postgres so could you give a little better explanation
of this ??
I haven't created any sequence for this I am just using a type serial
field. will I have to create a sequence for it?
Here is my code to create the tables
CREATE TABLE workstations (station_id INT4 PRIMARY KEY,
Is there any date type that can be used for 0-255
values? Like an int1 or byte column.
A SMALLINT is two bytes on disk, use char instead. This is a hidden
goodie in PostgreSQL and one that I wish was exposed via a more
conventional syntax (*hint hint*).
Is there a way to have p/k sequences get automatically
set to max(id)+1 after COPY's like the following?
copy table1 (id,name) from stdin;
1 abc
2 def
3 fhi
\.
CSN
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
On Thu, 2003-10-09 at 15:13, Bruno Wolff III wrote:
On Thu, Oct 09, 2003 at 14:46:08 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
On Thu, 2003-10-09 at 14:46, Bruno Wolff III wrote:
On Thu, Oct 09, 2003 at 14:28:57 -0500,
Ron Johnson [EMAIL PROTECTED] wrote:
On Thu, 9 Oct 2003 [EMAIL PROTECTED] wrote:
Andrew Sullivan [EMAIL PROTECTED] writes:
On Thu, Oct 09, 2003 at 08:52:36AM -0600, scott.marlowe wrote:
Fact: If you write your application to work with ODBC - MySQL
connectivity, you can write a closed source app and sell it for money and
In PostgreSQL 7.2 (Redhat 7.3 version, so it is patched), I'm trying to
create a Version-1 C server extension. The Version-0 format works, the
Version-1 version fails with:
undefined reference to 'pg_detoast_datum'
According to docs at:
Julie May wrote:
What I would like to do is also return the date that is assigned to
d_date for the current iteration of the first loop. The following
code does not work. I either get one of three error messages
depending on how many quote marks I use (unterminated string, error
with $1, or
I don't know what Postgres considers a relation and had no intention of
creating one when piping my schema to it... I always DROP TABLE before
CREATE TABLE, so here are the ERRORS emitted when building the database:
3:ERROR: table country does not exist
6:ERROR: table customer does not
On Thu, 9 Oct 2003 01:28, John Wells wrote:
Yes, I know you've seen the above subject before, so please be gentle with
the flamethrowers.
I'm preparing to enter a discussion with management at my company
regarding going forward as either a MySql shop or a Postgresql shop.
It's my opinion
On Thu, 2003-10-09 at 12:54, Sean Chittenden wrote:
Is there any date type that can be used for 0-255 values? Like
an int1 or byte column.
A SMALLINT is two bytes on disk, use char instead. This is a hidden
However char has some serious deficiencies IIRC, such as the fact
Added to TODO:
o Allow PL/pgSQL to handle %TYPE arrays, e.g. tab.col%TYPE[]
---
Bruno BAGUETTE wrote:
CREATE OR REPLACE FUNCTION myownfunction(members.id%TYPE[],
events.id%TYPE) RETURNS BOOLEAN AS '
Running a perl script against my dev server (pg 7.3.4) that currently runs
fine on the production server. And for some reason Pg always seems to hang
during the process (see below for Top print out). This happens randomily
throughout the script and can be on a SELECT, INSERT, or UPDATE
Joe,
Thank you very much. I didn't even think of casting the result of the first
loop. I will test out the function tomorrow with the cast included and let
you know how it works. From the looks of it (your results) it should work
fine.
Joe Conway Wrote:
I think you had it working when you
On Thursday, October 9, 2003, at 01:42 AM, Shridhar Daithankar wrote:
[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was
taken down for disk upgrade and mysql apperantly did not commit the
last insert.. OK he was using myisam but still..:-)
It sounds
Ron Johnson writes:
test1=# create domain d_tinyint as smallint constraint chk_tinyint CHECK (smallint
between 0 and 255);
ERROR: DefineDomain: CHECK Constraints not supported
So, how would I create a domain that limits a smallint?
You would have to wait for PostgreSQL 7.4.
--
Peter
On Thu, 9 Oct 2003, Sean Chittenden wrote:
Is there any date type that can be used for 0-255
values? Like an int1 or byte column.
A SMALLINT is two bytes on disk, use char instead. This is a hidden
However char has some serious deficiencies IIRC, such as the fact that
there's no int-char
Oliver Elphick wrote:
But as far as Debian is concerned, paragraph 1 applies:
1. Free use for those who are 100% GPL
If your application is licensed under GPL or compatible OSI license
approved by MySQL AB, you are free and welcome to ship any GPL software
of MySQL AB with your application. By
Joe Conway wrote:
D. Stimits wrote:
A google search shows very little concerning the pg_detoast_datum
undefined reference link error. It is looking more like the V1 has to
be skipped and I'll have to go back to V0 if I can't get this to work.
You haven't shown us your function, so it's a bit
Hi,
This is the wrong mailing list but I don't sent it to pgsql-bugs with
success.
---BeginMessage---
POSTGRESQL BUG REPORT TEMPLATE
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Joshua D. Drake wrote:
It is not that we don't want to include replication in the base
project it is that ERserver does not meet the requirements of what can
be included in the base project. Specifically (I believe) the
requirement of
D. Stimits wrote:
A google search shows very little concerning the pg_detoast_datum
undefined reference link error. It is looking more like the V1 has to be
skipped and I'll have to go back to V0 if I can't get this to work.
You haven't shown us your function, so it's a bit difficult to help,
On Thu, 2003-10-09 at 08:33, [EMAIL PROTECTED] wrote:
[snip]
that a shutdown process that isn't tested can cause problems even with
commercial databases. And as someone who has to put up with MySQL on
Then that's a piss-poor commercial DBMS, since that means that the
DB would be corrupt if the
45 matches
Mail list logo
