On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote:
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> Can not create pgdump_oid table. Explanation from backend: 'ERROR:
> cannot create pgdump_oid
>
> Is there a way to repair this?
>
> I would guess that this means there is
On Mon, Jan 15, 2001 at 08:36:46PM -0500, Tom Lane wrote:
> I would guess that this means there is a file named "pgdump_oid" hanging
> around in the database directory, no doubt leftover from some previous
> pg_dump cycle. Manually removing the file should get you up and running
> again. However
Hi.
I'm having trouble with committing a transaction. Intuitively it
should work but does not.
I've got a table with 2 foreign keys, minrev and maxrev. They refer
to a the revisionid value in another table. I need to update the
second table to reduce the revisionid, then insert a new row. At
Josh Berkus wrote:
> Folks,
>
> Oh, yes, one more:
>
> 4. If I pass a NULL to any of the parameters of a PL/PGSQL
> function, any (other) VARCHAR parameters are set to NULL as
> well.
Fixed in 7.1. Impossible to fix in 7.0.x or earlier due to
missing capabilities of the function manage
Josh Berkus wrote:
> Folks,
>
> 1. While I am able to use the %TYPE declaration within
> PL/PGSQL functions, I am unable to use this declaration in
> the parameters for the function -- I get 'Parse Error at or
> near "."'
I assume you're trying to do something like
CREATE FUNCTION my
Hi Everybody...
Who can design a secure database for my www project?
I don't have any idea where to start?
What language to use?
Sugestions?
Will you be interested in doing it? ($)
E-mail : momomor(at)dingoblue.net.au
at=@
Greetings from Australia...:)
Tom Lane wrote:
>
>
> I've heard lots of people want to increase BLCKSZ, but you're the first
> one who ever wanted to reduce it. You sure you want to do this? It's
> going to make the maximum row length uncomfortably short.
And it may even not work, as some system tables (that are also affec
hi,
I am having a problem in inserting a sound file into the database(i
am using oracle 8).
I heard that I can use Blob datatype for this but i don't know how to
use it or how to write a query for that .So if you know this please tell
me as soon as possible.
Thank you.
hi,
I am having a problem in inserting a sound file into the database(i am
using oracle 8).
I heard that I can use Blob datatype for this but i don't know how to use it
or how to write a query for that .So if you know this please tell me as soon
as possible.
Thank you.
I need help, which is the symbol used in postgreSql to carry out the outer
join.
in oracle the is used (+)
in sybase the is used * and
in postgreSql?
thank you
Hipp Mauricio
> > select * from testdate where field1 between '2000-10-01' and
> > '2000-11-30' ;
> >
> >field1
> >
> > 2000-09-30 < why is it here??
> > 2000-10-20
> > 2000-11-25
>
> It works fine for me (7.0.3, Debian GNU/Linux "unstable").
>
> I suspect your problem has to do with t
On Mon, 15 Jan 2001, Alexaki Sofia wrote:
> Hello,
>
> A)
> I am going to load a huge amount of data in the DBMS using JDBC
> and I want to reduce as much as possible the required loading time.
>
> Initially I loaded all data in one transaction. Subsequently, I increased
> the number of buff
Mauricio Hipp Werner wrote:
>
> I need help, which is the symbol used in postgreSql to carry out the outer
> join.
>
> in oracle the is used (+)
> in sybase the is used * and
> in postgreSql?
The PostgreSQL outer join is accomplished using SQL92 syntax. You will
not find real outer joins *exce
On Mon, Jan 15, 2001 at 06:16:00PM -0400, Mauricio Hipp Werner wrote:
> I need help, which is the symbol used in postgreSql to carry out the outer
> join.
>
> in oracle the is used (+)
> in sybase the is used * and
> in postgreSql?
I don't really understand your question, but from src/test/regr
On Mon, 15 Jan 2001, Mauricio Hipp Werner wrote:
MHW> in oracle the is used (+)
MHW> in sybase the is used * and
MHW> in postgreSql?
In PostgreSQL we have no outer joins at all. But it is promised they
are going to arrive soon, perhaps in 7.1?
Bye Borek
--
Here is a test case that illustrates the problem. I figured I was
doing it all wrong before and didn't bother to distill and include a
test case.
create table objects(
revisionid int4,
primary key (revisionid));
create table objcatalog(
minrev int4,
maxrev int4,
foreign key (minrev) references
I wanted to compile python will an installed
postgres package ...can i do it .How?
TIA
Sharmad
Jan,
> I assume you're trying to do something like
>
> CREATE FUNCTION myfunc(mytab.x%TYPE, mytab.y%TYPE) ...
>
> because that's the only way I've found to get this error
That's correct.
> Indeed, a good idea (for 7.2). Bruce, put it onto TODO
> please.
T
Hello All,
This is my first post (so be gentle with me)...
Is there a searchable archive?
I would like suggestions and examples of adding SQL-92
data type BIT compatibility to a PostgreSQL schema.
>From the doc's I gather you can "CREATE TYPE bit"
with storage int or int4... but I don't know
a
Keith,
> This is my first post (so be gentle with me)...
Well, yea-hah! Fresh meat, boys! Bring out the branding
iron and the Wayne Newton B-sides!
> I would like suggestions and examples of adding SQL-92
> data type BIT compatibility to a PostgreSQL schema.
First let me ask you: Why do you
Folks,
Well, I now have a copy of Bruce's book on order. Bruce, if
your sales have been slow, don't let A-W blame it on the
online draft. According to Stacy's, it takes them an
average of 7 working days to get Ingram to cough up a new
copy, which is twice the normal period for tech books. As a
On 16 Jan 2001 at 20:40 (-0800), Josh Berkus wrote:
| So, while I wait for my copy ... I can't find in the online
| docs anywhere a comprehensive list of built-in functions.
| You know, stuff like CURRVAL() and NOW(). Can anyone point
| me to such a list? Guessing parameters is getting
| frustr
[ Charset ISO-8859-1 unsupported, converting... ]
> Folks,
>
> Well, I now have a copy of Bruce's book on order. Bruce, if
> your sales have been slow, don't let A-W blame it on the
> online draft. According to Stacy's, it takes them an
Sold 2,155 copies in the first month. I know they think
Keith,
> This is a compatibility issue. While I prefer to use
> BOOLEAN, this is SQL3
> and not available on the (unfortunately must use)
> MS-SQL/MSDE platform.
>
> My options are to use a CHAR field and re-write my code
> for "T" and "F" or
> an int field and re-write my code to use "field=0"
24 matches
Mail list logo
