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.htm
> 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 m
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;
> !
>
> Th
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 wan
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 n
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 cur
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
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 setval
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 al
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 d
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
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
>＼
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
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)
>
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
oc
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 row
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_c
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
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 . I don't
remember enough ab
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
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 TRANS
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
> th
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 "FA
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 instal
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 rep
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
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 mov
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
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 postg
On Sun, 3 Oct 2004, Gaetano Mendola wrote:
> 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:
&
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...
&g
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
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
> > thre
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 ther
On Mon, 20 Sep 2004, Jaime Casanova wrote:
> --- Stephan Szabo <[EMAIL PROTECTED]>
> escribió:
> >
> > On Mon, 20 Sep 2004, Jaime Casanova wrote:
> >
> > > There is a way to not enforce the creation of a
> > > primary or unique index on a referenc
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
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
marily 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:
> >
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
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..
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 stat
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 si
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
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 w
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
const
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
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?
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 |
On Sun, 16 May 2004, Gregory S. Williamson wrote:
> In postgres 7.4, is there any way to stop a user from creating tables in a given
> database ?
Make the user not have rights to create objects in any schemas. Most
likely you'd only need to change the public schema, but if you've granted
create
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 se
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:
On Thu, 8 Apr 2004, Terry Hampton wrote:
> I thought this was answered before, but I
> could not find anything in my saved email.
>
> I need to ALTER a table to add a new column.
> I want the new column to be between two existing
> columns, however. Didn't I see
On Thu, 8 Apr 2004, Tony Reina wrote:
> I'm developing a database for scientific recordings. These recordings
> are traditionally saved as binary flat files for simplicity and
> compact storage. Although I think ultimately having a database is
> better than 1,000s of flat files in terms of data ac
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 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 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;
> ' languag
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
On Mon, 8 Mar 2004, Silvana Di Martino wrote:
> Alle 17:40, domenica 7 marzo 2004, Stephan Szabo ha scritto:
> > Who has access to the unencrypted versions of the data? Are there people
> > who will have access to the database who might have access to some of the
> > encrypte
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 stand
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
> > > w
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 alternativ
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
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 v
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 p
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, th
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 fol
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 postgresql.c
On Wed, 3 Dec 2003, Ferdinand Smit wrote:
> Hi,
>
> When trying to explain a developer of our organisation the reson why the index
> was'nt used, i was confused my self.
>
> The simple question is: Why does the analyzer only use the index when the
There are a fiew things going on:
First, the st
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 * fro
On Sat, 22 Nov 2003, Ashok Chauhan wrote:
>
> # include
> # include
> int main()
> {
> int feild;
> PGresult *result;
> PGconn *conn;
> conn = PQconnectdb("database");
> result = PQexec (conn, "select * from teblename");
> feild = PQntuples (resul
On Wed, 19 Nov 2003, Tomasz Spyrczak wrote:
> I've just compiled PostgreSQL 7.4 and come across this problem:
>
> I have a table like this:
>
> CREATE TABLE test (field1 integer, field2 integer default 0);
>
> Then I want to insert some "empty" record like this:
>
> INSERT INTO test (field1, field
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 tha
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 goin
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 (b
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 f
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
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 creat
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
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
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
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 | tr
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
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 gu
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)---
T
On Fri, 7 Nov 2003, Michiel Lange wrote:
> I am certainly not awake, that I have troubles with a simple thing like
> this, but there it is
>
> I have three tables: Names(NameID INT4 PRIM INDEX, Name VARCHAR(30)),
> Groups(GroupID INT4 PRIM INDEX, Group VARCHAR(30))
> And a table Members(NameI
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 sepa
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 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 serv
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, 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
disallow
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.
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
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
1 - 100 of 314 matches
Mail list logo
