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 th
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, but
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 Jav
Hi,
This is the wrong mailing list but I don't sent it to pgsql-bugs with
success.
--- Begin Message ---
POSTGRESQL BUG REPORT TEMPLATE
=
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 bi
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 "
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
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 a
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 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 lik
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 g
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 statement
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 '
>
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,
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 opin
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 n
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 unexpec
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:
http://www.postgresql.org/docs/7.2/interactive/xfunc-c.ht
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
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:
> > > >
> >
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
> 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*).
http://developer.postgresql.org/do
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,
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,
> 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").
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.htm
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
>
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
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, 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 ]
> >
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, 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:
>
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 compatibil
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 se
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
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's an interesting response from mysql.com sales. Frankly, I don't see
how using it on multiple internal servers violates the GPL?!?:
Hi John,
Thank you for your interest in MySQL. My answers below.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent:
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 cu
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 correc
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
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 a
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)---
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 HKS
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 PROTECT
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 t
On Wed, Oct 08, 2003 at 11:45:36AM -0400, Richard Welty wrote:
> On Wed, 8 Oct 2003 11:28:00 -0400 (EDT) John Wells <[EMAIL PROTECTED]> wrote:
>
> > 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
> >
46 matches
Mail list logo
