On Mon, 8 Dec 2008, Benjamin Krajmalnik wrote:
Thanks.
Then we have an inconsistency between this and the documentation for the
|| operator, where it is showing the abilty to concat numeric types
without explicit casting.
http://www.postgresql.org/docs/8.3/static/functions-string.html
I've found that if I run this select (below) I get a table returned
named 'dma' een though I specified like 'dm_%' :
Underscore is a special character for like matching any single character
so I don't think that's wrong.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To
On Tue, 25 Mar 2008, kevin kempter wrote:
I've placed this sql in a script:
psql my_db !
begin;
SET CONSTRAINTS ALL DEFERRED ;
delete from account where 1 = 1;
delete from cust where 1 = 1;
delete from cust_type where 1 = 1;
delete from cust_orders where 1 = 1;
commit;
!
The tables
On Thu, 2 Aug 2007, Ralph Smith wrote:
I'm preparing to upgrade a 7.4.7 DB to 8.2.4.
I just got connectivity from new to old (different hosts), and being
a newhire and no-one had ever done any maintenance on the old DB, I
connected as joe-user to the old DB using the client of the new.
On Sat, 28 Jul 2007, De Leeuw Guy wrote:
Hello Stephan
Thanks for you respons.
Stephan Szabo a ?crit :
_PG_fini is called when the file is unloaded, but not at process end,
according to the documentation, so I don't think it does what you want.
No, I make a small test :
In _PG_fini I
On Fri, 27 Jul 2007, De Leeuw Guy wrote:
I make a lot of tests with trigger and first problem the function
_PG_fini are never called it is a bug ?.
_PG_fini is called when the file is unloaded, but not at process end,
according to the documentation, so I don't think it does what you want.
On Sun, 8 Apr 2007, Karthikeyan Sundaram wrote:
Hi team,
I have a requirement like this.
create table valid_lovs (code_id int not null,lov_value int not null
,description varchar(256),status bit(1) not null default '1',constraint
lov_pk primary key (code_id,lov_value));
I need to
On Thu, 18 Jan 2007, Negandhi, Nishith wrote:
Hi,
All my tables in the database have CreateDate and LastUpdateDate
columns. I need to create a trigger wherein on insert the CreateDate
column is inserted with the current date. On Update the LastUpdateDate
is inserted with the current date.
On Fri, 24 Nov 2006, Marcelo Costa wrote:
Hi, all
I migrate my database from 7.4 to 8.1.5 and make tests with aplication
but this don´t works fine.
Some trigers don´t work and send to me error messages as this:
Warning: pg_query(): Query failed: ERROR: INSERT is not allowed in a
On Mon, 24 Jul 2006, Mans wrote:
Hello,
Note: I know that its not a very good db design. But what if a senario
comes in front of you?
I have created an uncommon database design. Which is as follows:
Created 2 Tables :- Emp1 and Emp2
TableA with 2 Attributes
A1 and A2.
A1 is the
On Thu, 13 Jul 2006, Chris Hoover wrote:
I am having what appears to be a bug with unique indexes on 8.1.3.
I have created a new table.
create table payer_835 (
payer_id int8 not null default
nextval('payer_835_payer_id_seq'::regclass) primary key,
payer_name
On Tue, 9 May 2006, Pascal Tufenkji wrote:
How can I reset the sequence to 1
If I use the following statement
Select setval('mytable_id_seq',1);
I put the last value as 1
So when I insert a new row the value will be 2 and not 1 as it should be
I cannot put Select
On Wed, 19 Apr 2006, Thusitha Kodikara wrote:
Hi,
I observed the following on PostgreSQL 8.1.3 (on Windows 2000).
(1) alter table invoice add column active boolean default true;
This will add a new column active with a default clause as true and
also sets the value true to all existing
On Thu, 23 Mar 2006, Bradley Kieser wrote:
All,
I know that this isn't strictly an admin question but please forgive me
for asking.
I am writing a (admin) job which does a select off a PG database based
on three columns:
last_backup: timestamp
backup_unit: integer - Represents day,
On Mon, 6 Mar 2006, ow wrote:
PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 2005
(prerelease) (Debian 4.0.2-4)
Hi,
Can't get pg_hba.conf with trust to work:
[EMAIL PROTECTED]:~$ psql -U postgres
psql: FATAL: Ident authentication failed for user postgres
On Sun, 22 Jan 2006, Dan Bikle wrote:
I'm allowed to connect to the db10 database without authentication!:
bash-2.05b$ psql db10 scott
Welcome to psql 8.1.1, the PostgreSQL interactive terminal.
Type: ＼copyright for distribution terms
＼h for help with SQL commands
＼? for
On Thu, 15 Dec 2005, Szabolcs BALLA wrote:
Hi,
I have a strange problem with psql 7.4.7.
I have customers who run xp, with sp1 (with sp2 no problem), when they
report from our web-based application they send a query
after a single click. The same queries have been posted twice within a
few
On Tue, 1 Nov 2005, Diego wrote:
Hi,
I´m a brazilian programmer!
I have a question about Postgres UNIQUE KEY. Look:
(Step 1)
CREATE TABLE test (
id integer not null primary key,
id_uni integer not null,
cod integer,
name varchar(40),
constraint test_uk unique(id_uni, cod)
)
(Step
On Thu, 8 Sep 2005, Kailash Vyas wrote:
hi
I have a query regarding triggers.
On INSERT, UPDATE, DELETE I want to fire a trigger to relect it to another
database on postgres sever.
how can I do this operation.
This is tricky, because you probably want to have the same transactional
On Fri, 5 Aug 2005, D Kavan wrote:
Hi,
Thanks for the reply. That didn't help him, but he asked me to post this.
There are 66 project id's in the project table and 3 rows in the
project_members table for global_id 2915, but it only returns 3. I would
think it should return 66 rows, with
On Tue, 12 Jul 2005, [iso-8859-1] Sebastian Kühner wrote:
Hello,
I'm new here in this group... and I hope that I find the solution for my
problem here.
I wrote a simple function which looks like this:
CREATE OR REPLACE FUNCTION watchdog() RETURNS TIME AS '
DECLARE
watchdog_control
On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
Hi Stephan, tks
I drop database and move directory data to data01.
I already executed initdb --locale=C and the file postgresql.conf change
to LC_MESSAGES, LC_MONETARY, LC_NUMERIC and LC_TIME = 'C', but the problem
persist.
I
On Tue, 12 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
The command's return
teste=# show LC_COLLATE;
ERROR: Option 'lc_collate' is not recognized
Darn, that must have been added after 7.3.x. If you have pg_controldata,
I think you can use pg_controldata path to data directory. I
On Tue, 12 Apr 2005, Stephan Szabo wrote:
On Tue, 12 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
The command's return
teste=# show LC_COLLATE;
ERROR: Option 'lc_collate' is not recognized
Darn, that must have been added after 7.3.x. If you have pg_controldata,
I think you can
On Mon, 11 Apr 2005, [iso-8859-1] Reuly Bússolo Mendes wrote:
In the Cygwin, the return is correct:
prodes
TELHA FRANCESA CAMBORIU
TELHA PORTUGUESA SAO CRISTOVAO
TELHA ROMANA LEONEL PEREIRA
TELHA TRANSPARENTE
On Mon, 14 Mar 2005, Gourish Singbal wrote:
The Query needs to have the distinct clause in the select statement
and the UPPER clause in the order by clause.
eg.
select distinct id, type from user_list order by UPPER(type)
Please let me know if there is any solution to this issue
thanks in
On Fri, 21 Jan 2005, Rao Kumar wrote:
Database System startup message
In postgres version 7.4.6, I notice that sometimes when the database starts
up, it outputs a log message such as 2005-01-18 14:44:13 FATAL: the
database system is starting up. Shouldn't this be LOG instead of FATAL
On Wed, 12 Jan 2005, Goulet, Dick wrote:
You may well be on the development team, but you are wrong for
one very important reason. If the Postgresql executables are owned by
root they execute with the priviledges of root. Thereby any local
Not on any reasonable system unless
On Mon, 3 Jan 2005, Bradley Kieser wrote:
Hi,
I use views extensively to implement security on tables. This requires
each table to have a view. All updates, inserts and deletes take place
through the view. The view has rules for each of these operations
defining security for that table.
On Wed, 10 Nov 2004, Sharon Schooley wrote:
I am new to Postgresql. I'm trying to load tables from SQLServer bcp
export, comma delimited. I'm loading datetime datatype into timestamp.
I've loaded one table successfully and failed on others with the same
error:
Bad timestamp external
On Thu, 4 Nov 2004, David Bear wrote:
I'm using pg 7.3 on freebsd..
I've created a database use sql.
now, as the pg superuser I cant seem to grant any permissions on the
tables in the db..
npcenter-# \z
Access privileges for database npcenter
Schema |Table | Access privileges
On Thu, 28 Oct 2004, Andrei Bintintan wrote:
I try to dump a database from a 7.4.2 postgre system and to import it on
a 7.3.2. system, but I have a problem with the sequences in the dump.
In general, the above is not guaranteed to work. pg_dump will use features
of the dumping version so
On Fri, 22 Oct 2004, Joe Maldonado wrote:
Scott Marlowe wrote:
On Thu, 2004-10-21 at 10:49, Joe Maldonado wrote:
Scott Marlowe wrote:
On Wed, 2004-10-20 at 08:17, Joe Maldonado wrote:
Hello all,
I have created users for which I have restricted access to SELECT
On Tue, 19 Oct 2004, Bryan Biggers wrote:
Can anyone tell me what the data file names with the .1 .2 .3 etc.
extensions are? Are these undo versions of my tables or something? I
need to recover some disk space and I'm wondering if I need them. Here
is an example...
-rw---1 postgres
On Fri, 1 Oct 2004, Scott Marlowe wrote:
On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
Okay, just so no one posts about this again...
the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads
with a status of '5' to the top of the list... it is NOT meant to only
On Sat, 2 Oct 2004, Scott Marlowe wrote:
On Sat, 2004-10-02 at 09:14, Stephan Szabo wrote:
On Fri, 1 Oct 2004, Scott Marlowe wrote:
On Fri, 2004-10-01 at 14:26, Shane | SkinnyCorp wrote:
Okay, just so no one posts about this again...
the 'ORDER BY t.status=5,lastreply' clause
On Thu, 30 Sep 2004, Duane Winner wrote:
Hello,
We have a database with data loaded and now I need to GRANT
SELECT,UPDATE,INSERT,DELETE to all tables in 4 different schemas for a
specific postgresql user account.
I have two problems:
1) One of these schemas has 75 tables. Is there a way
On Fri, 1 Oct 2004, Michael Paesold wrote:
Shane | SkinnyCorp wrote:
Okay, just so no one posts about this again...
the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads
with a status of '5' to the top of the list... it is NOT meant to only
grab
threads where the
On Mon, 20 Sep 2004, Jaime Casanova wrote:
I have a reference table that holds all the status
used in a system (it's a very little table just 10 or
15 rows).
create table status (
cod_status char(2) not null primary key,
nam_status textnot null
);
create table
On Thu, 12 Aug 2004, Thomas Madsen wrote:
I'm running a production server with PostgreSQL version 7.2.1, that does
You really should upgrade. If not to 7.4.x, at least to the last 7.2
release.
The problem is that TOAST tables keeps springing forth and consume disk
space.
We do a VACUUM
there for
applications that were written for older versions of PostgreSQL.
You probably should be using queries that use the ONLY keyword
rather than relying on the guc variable.
On Sun, 18 Jul 2004, Stephan Szabo wrote:
On Tue, 13 Jul 2004, evgeny tsurkin wrote:
Hi All!
That probably
On Tue, 13 Jul 2004, evgeny tsurkin wrote:
Hi All!
That probably was already asked thousand times
but i did not find an exact answer:
I want to have two tables the second one will have
all the columns from the first + some extra .The data
should be complittly separate .I was trying to use
On Wed, 14 Jul 2004, Joost Kraaijeveld wrote:
Is it possible to turn of the case sensitivity for tables and columns in
queries (to all CAPS)? I have a (closed source) tool that I have to use
(Clarion) that generates the queries and I cannot change the way the
tool generates the queries.
On Sat, 3 Jul 2004, Guido Barosio wrote:
Hi,
This is the problem. I create a database from cero. I create a empty table,
name students. I ask for an EXPLAIN
on this new table, and the output of the query analyzer tells me that this table is
filled with 1000 rows.
So...why is
On Fri, 2 Jul 2004, Rahul k wrote:
I need to query a table with column name having
special characters :, @, /, for example:
ab:cde12n/[EMAIL PROTECTED]
You'd need to double quote the name on creation and on any usage of the
name (for example in a select list or expression) in SQL statements.
On Fri, 25 Jun 2004, Carlos Benkendorf wrote:
I would like to know if space disk is free to the Operational System
during a standard vacuum (without the full option)?
I found in section 21.1.1 Recovering disk space of Postgresql 7.4.2 manual
something about it.
The standard form of VACUUM
On Fri, 25 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is
table1.field1 =* table2.field2
In Oracle the joins are with the simbol (+),
On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
Hello Everybody?...
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is field1=*field2
In Oracle the joins are with the
On Wed, 9 Jun 2004, Mauri Sahlberg wrote:
rahaks=# begin foo
rahaks-# ;
ERROR: parser: parse error at or near foo at character 7
rahaks=# begin;
BEGIN
rahaks=# set constraints all deferred;
SET CONSTRAINTS
In addition to the other messages, the above only defers deferrable
constraints.
On Fri, 27 Feb 2004, Phillip R. aka Qbert wrote:
Am Mittwoch, 25. Februar 2004 16:49 schrieb Phillip R. aka Qbert:
...
I figured it's a user problem, so I thought it might be a good idea
to drop my test-db elefant-data, and try to create a new one, this
time making shure it'd be with the
On Wed, 19 May 2004, Jie Liang wrote:
According to the document of rule:
CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id=OLD.id;
Delete from bbb where id=OLD.id;
Delete from ccc where id=OLD.id
);
Should work, but it doesn't, what wrong with it?
What is
On Mon, 17 May 2004, Gregory S. Williamson wrote:
Stephan,
Thanks for the info, but alas, no success.
I have:
List of database users
User name | User ID | Attributes
---+-+
testuser | 100 |
postgres | 1 |
On Fri, 7 May 2004, Gaetano Mendola wrote:
Hi all,
I have a table with ~ 3e+6 rows on it.
I do select on this table in this way:
(1) select * from user_logs where login_time::date = now()::date;
consider that login_time is a TIMESTAMPTZ with an index on it.
If I use the select in
On Tue, 27 Apr 2004, Glenn MacGregor wrote:
Now I need to change the parentname field (in the case of vimid = 2)
from [EMAIL PROTECTED] to test and keep the vimname field as is. When I do
this the constraint no longer works (which makes perfect sense).
1 | [EMAIL PROTECTED] | cell | f |
On Thu, 8 Apr 2004, Terry Hampton wrote:
Anyone know this list member,
who was kind enought to reply?
No, but he's sent me private messages of the sort
in the past (and in fact also sent on in response
to my reply to this message).
Original Message
Subject: Re:
On Wed, 7 Apr 2004, Jaime Casanova wrote:
hi all, there is a way to use my own index with pk constraint instead of the
implicitly created one?
why? just because i don't like the name, maybe can i change the generated
name?
You should be able use the full version with the constraint naming
On Tue, 16 Mar 2004, Thomas Leung wrote:
I want to index my table using the year of the date. So I create the
following function.
create function to_year(date) returns varchar as '
declare
str varchar;
begin
str := to_char($1, );
return str;
end;
' language 'plpgsql'
On Thu, 18 Mar 2004 [EMAIL PROTECTED] wrote:
Recently We Update our Postgresql database server by installing Postgresql
7.4.1, we followed the basic installation steps that appear in the install
file, everything was fine till this morning when we realize that the
partition (/var) where we
On Mon, 8 Mar 2004, Silvana Di Martino wrote:
Alle 15:08, lunedì 8 marzo 2004, Stephan Szabo ha scritto:
That's what I figured, but given a system where the password is given on
startup to the database, you would need another layer for the security,
have you though about how that would
On Sun, 7 Mar 2004, Silvana Di Martino wrote:
3) This means that you have to manage by yourself all the details of the
password one-time entry at the RDBMS start-up time, its storing (in RAM,
only) and its passage to the SQL SELECTs. IMHO, this is still far to satisfy
our need for a standard
On Fri, 5 Mar 2004, Silvana Di Martino wrote:
Alle 15:11, venerdì 5 marzo 2004, Alex Page ha scritto:
If you're trying to protect against somebody taking down your server
room door with a sledgehammer, lifting your server out of the rack,
driving it away and booting off an alternative
On Fri, 5 Mar 2004, Silvana Di Martino wrote:
Alle 20:14, venerdì 5 marzo 2004, Stephan Szabo ha scritto:
Unfortunately, the new Italian law forces us to take seriously into
account this catastrophic scenario and another one that is almost as
worring: an unfaithful SysAdmin that copies
On Wed, 11 Feb 2004, Paulo Rogerio Zimolo wrote:
I'm trying to do pg_dump an old version (7.3.4) to a new one (7.4.1) with
the following command:
pg_dump -U username -h server -i -o database | psql -U username -h
newserver newdatabase
As a result I got:
pg_dump: server
On Mon, 9 Feb 2004, Tuan Luu wrote:
Example:
Table 1:
Inventory, Productnr, Productserial
(PK Inventory, Prouctnr)
Table 2:
Pruductnr, Produktdesc, Productversion
(PK Productnr; FK Productnr)
This Construct gives me an error during the creation in Postgresql
(saying there is no
On Fri, 30 Jan 2004, Gaetano Mendola wrote:
Hi all,
is it normal that postgres dont complain
doing a commit after a deadlock ?
kalman=# select * from test where a = 5 for update;
ERROR: deadlock detected
DETAIL: Process 4144 waits for ShareLock on transaction 40180; blocked
by process
On Wed, 4 Dec 2003, Ashok Chauhan wrote:
i am a new user in postgresql.
problem:- in postgresql there is any command to see history (previous
day queries) like as history command in linux.
Not precisely. For the backend, you can log the statements that are run
by changing the
On Thu, 4 Dec 2003, Alan Graham wrote:
I'm doing a low cost, low performance roll your own replication project,
between various offices around Australia. The replication is
asynchronous, and peer to peer. I've looked at the various replication
projects, and for one reason or another,
On Thu, 4 Dec 2003, Andrei Bintintan wrote:
Hi,
I have the following table:
CREATE TABLE public.rights (
id int4 DEFAULT nextval('rights_id_seq'::text) NOT NULL,
id_user int4 NOT NULL,
id_modull int4 NOT NULL,
CONSTRAINT rights_pkey PRIMARY KEY (id)
)
and I created the following
On Tue, 25 Nov 2003, Andrei Bintintan wrote:
I give an example:
These are the datas from the table names:
id n1 n2
1 AaAaAaAa
2X X
3A A
4 aa
5 abab
6 _Y_Y
8 ..a..a
9 .x.x
7 ...a...a
If I run: select * from names order
On Sat, 22 Nov 2003, Ashok Chauhan wrote:
# include stdlib.h
# include libpq-fe.h
int main()
{
int feild;
PGresult *result;
PGconn *conn;
conn = PQconnectdb(database);
result = PQexec (conn, select * from teblename);
feild = PQntuples
On Sun, 16 Nov 2003, ow wrote:
--- ow [EMAIL PROTECTED] wrote:
Perhaps I should clarify.
First, I ran pg_dump to extract schema and data *together*. Then I ran
pg_restore to restore the db. It took about 1 hour to create tables and copy
the data, then about 40 min to create indexes,
On Mon, 17 Nov 2003, Jeff wrote:
On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo [EMAIL PROTECTED] wrote:
By the way, what does your schema look like? I created an 80M row fk
table and 20K row pk table with an int4 key between them and indexes on
the two key fields. It took
On Mon, 17 Nov 2003, ow wrote:
--- Jeff [EMAIL PROTECTED] wrote:
On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo [EMAIL PROTECTED] wrote:
By the way, what does your schema look like? I created an 80M row fk
table and 20K row pk table with an int4 key between them
On Mon, 17 Nov 2003, ow wrote:
--- Stephan Szabo [EMAIL PROTECTED] wrote:
I assume you're also not modifying the pktable rows (since that would
access the fk table based solely on the fk).
I do modify the fk table: inserts and updates (but pk is never updated). Also
do not delete
On Mon, 17 Nov 2003, ow wrote:
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Well, I've been trying to deal with the particular case at hand, ie, get
your load in a more reasonable amount of time assuming that you had more
constraints and this was going to be a particular problem for you
On Mon, 17 Nov 2003, ow wrote:
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Like I said, it's been discussed and I would expect some form of this for
7.5 although I can't say for certain. Enough people were interested in
the discussion that it's likely to happen with a little championing
On Sun, 16 Nov 2003, ow wrote:
--- Peter [EMAIL PROTECTED] wrote:
Read again. No one was talking of pg_restore.
Perhaps I should clarify.
First, I ran pg_dump to extract schema and data *together*. Then I ran
pg_restore to restore the db. It took about 1 hour to create tables and copy
On Sun, 16 Nov 2003, ow wrote:
--- Stephan Szabo [EMAIL PROTECTED] wrote:
Only assuming that no changes were made between dump and restore. This
could be changes to schema or data done manually, but it could also be a
locale or possibly encoding change if you have any textual foreign
On Tue, 11 Nov 2003, Antonis Antoniou wrote:
Guys, does anyone has any idea?
Are you sure that vacuum is not just waiting on a lock that some other
transaction is holding? I'd suggest checking the contents of pg_locks.
---(end of broadcast)---
On Tue, 11 Nov 2003, pginfo wrote:
Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?
It won't directly tell you what statement is running (although my guess
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
--+--+-+---+-+-
16757 |16976 | | 23169 | AccessShareLock | t
On Tue, 11 Nov 2003, pginfo wrote:
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
On Tue, 11 Nov 2003, pginfo wrote:
It is possible to be one not closed transaction, but in this case nobody will be
able to modify this table (tables) and
the system will stop to respond. The paradox is that the system works well
without
Not necessarily. People are going to be
On Thu, 16 Oct 2003, Oli Sennhauser wrote:
I would like to start a second postmaster on my server.
First problem was the lock file /tmp/.s.PGSQL.5432.lock
and its socket. But you can workaround that by the -k
parameter. So I was able to start at least 3 clusters...
If you want to use
On Fri, 10 Oct 2003, Jodi Kanter wrote:
Ok. sorry to confuse everyone...I got my restore to fun to completion so
apparently my question about running restores in psql and the ordering
of the data are not relevant.
I do, however, have one other question I'd like to pose.
I am getting serveral
On Fri, 10 Oct 2003, Jodi Kanter wrote:
It appears that some of these errors are due to the parent table being
populated after the child table. Can I control the order of the copy
statements in my script when I run the pg_dump?
I think if you use one of the custom formats and pg_restore you
On Tue, 30 Sep 2003, Anna Kanevsky wrote:
This is an almost embarrassing question, but I managed to delete all rows
out of one of the tables by making a little typo in the WHERE statement.
Is there any way to restore these? the db was NOT vacuumed after that. but
then, it wasn't backed up
On Fri, 26 Sep 2003, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] writes:
I've been through them. None of 'em turn off // comments. Or #-sign
On at least some versions of gcc it looks like --std=c89 turns them off
Hmm, I haven't tried that in particular. I wonder what else it does
On Fri, 26 Sep 2003, Tom Lane wrote:
Stephan Szabo [EMAIL PROTECTED] writes:
However, the immediate problem I have seems to come from the fact that
on Linux at least we're basically lying to configure about what's in the
system headers when we go to compile. port/linux.h on my system
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
Stephan Szabo writes:
Configure doesn't find struct addrinfo (because it's in a __USE_POSIX
block) so it looks like we use our own version, but, when we're actually
then compiling getaddrinfo.c, there's a redefinition error because this
time
On Fri, 26 Sep 2003, Peter Eisentraut wrote:
Stephan Szabo writes:
It's not a problem for me unless I'm compiling with CFLAGS=-std=c89.
Don't do that then. :-)
Well, the discussion started with Tom trying to find an option that
disallowed // comments for gcc. :)
I don't agree
On Fri, 26 Sep 2003, Tom Lane wrote:
Chad R. Larson [EMAIL PROTECTED] writes:
I suspect that among the conformance switches, you can find a combination
you like:
I've been through them. None of 'em turn off // comments. Or #-sign
On at least some versions of gcc it looks like --std=c89
On Mon, 22 Sep 2003 [EMAIL PROTECTED] wrote:
You do realize that the shell is going to interpret that string in
double quotes right?
I guess so, for the very same I have tried with
Command: psql test -c CREATE FUNCTION add_one (integer) RETURNS
INTEGER AS ' BEGIN RETURN ''$1''
On Mon, 22 Sep 2003, Hornyak Laszlo wrote:
Hi all!
We have a database on postgreSQL 6.2 and it is extremely slow, so we
started vacuum on it. I know it locks the tables, so clients can not use
it until the process is finished, but it is extremely slow on a 1.800.000
record table and we
On Mon, 22 Sep 2003 [EMAIL PROTECTED] wrote:
Dear all,
This is about the same problem which I have been facing for the past one week and
which I am unable to solve.
I have create a function which return +1 of the argument passed.
Function Definition:
CREATE FUNCTION add_one (integer)
On Mon, 22 Sep 2003 [EMAIL PROTECTED] wrote:
Command: psql test -c CREATE FUNCTION add_one (integer) RETURNS
INTEGER AS ' BEGIN REURN $1 + 1; END; ' LANGUAGE
'plpgsql';
You do realize that the shell is going to interpret that string in
double quotes right?
On Thu, 18 Sep 2003, Ravi T Ramachandra wrote:
Hi,
We are using postgresql 7.3.2 on lunux platform. We performed locking
test as follows via JDBC:
Started 2 concurrent transaction with autocommit false and isolation
READ_COMMITTED :
Transaction 1:
===
Update row 1
Sleep
On Fri, 19 Sep 2003, Ravi T Ramachandra wrote:
Here is the table structure. FYI, we tried the experiment with mysql
and the concurrency is working fine.
create table TABLE1( TABLE_ID IDENTITY NOT NULL ,
VA_ID SMALLINT NOT NULL,
On Thu, 4 Sep 2003, Yudha Setiawan wrote:
Dear Expert,
I got a trouble with LOCK on my table (Inquery table).
I've put the LOCK (using select bla.bla for update)
on trigger(trigger insert) of Table_A. It's work properly.
when i tried insert into Table_A bla.bla.bla with more
than 5 user in
On Thu, 28 Aug 2003, Ludwig Heusser wrote:
Hallo dears PG-Users,
I have sucessfully installed the postgreSQL database an I want to administrate
the tables with phppgadmin. Almost ist perfekt except that I can't set a user
passwort. Wenn I add a new user by using the phppgadmin, the new user
1 - 100 of 274 matches
Mail list logo
