Thanks a lot Guillaume,
It worked!!
Guillaume Lelarge escribió:
Le lundi 30 mars 2009 à 16:39:59, toni hernández a écrit :
[...]
I've been trying to import some data from a csv file to my database.
I have some fields of the table that I want to keep so I typed
copy mytable (column
Affidab
Hi ,
is there a way that we could find which procpid or connection that
has created a particular temporary schema (pg_temp_*) ?.
In one of our db a temporary schema (pg_temp_48) was using more
than 200GB of disk space and how to find the connection which has created
the temp s
This email is subject to a disclaimer which may be found by connecting to
www.medscheme.co.za and clicking on the "Terms of Use" link.
Alternatively, the disclaimer can be emailed to you by sending a blank email to
"meds_disclai...@medscheme.co.za".
I guess you should use Bytea
El día 30 de marzo de 2009 19:01, Félix Sánchez Rodríguez
escribió:
> Greetings:
>
> I need to use a PostgreSQL Data Base to store different kinds of files, eg:
> images, videos. So, I'm wondering what data type should I use.
>
> Tbanks in advance
--
Sent via pgsql-
Thank you
"Yes, it does. It might be worthwile to use
WHERE sel=123 AND mod(sel,6)=3
I think you could use a rule to add the mod() condition automatically.
"
this is great idea
But the problem is i did not accomplish to find a way to change query like
partitioning=# select * from main
On Montag 30 März 2009 Kevin Grittner wrote:
> I don't want anything to attempt to process a WAL file while it is in
> the process of being copied. By copying to a separate directory on
> the same mount point and moving it, once complete, to the location
> where other software is looking for WAL f
On Tue, Mar 31, 2009 at 08:31:43AM -0300, Agustin Ignacio Genoves wrote:
> I guess you should use Bytea
Or go for large objects.
> > Greetings:
> >
> > I need to use a PostgreSQL Data Base to store different kinds of files, eg:
> > images, videos. So, I'm wondering what data type should I use.
>
On Tue, Mar 31, 2009 at 2:21 AM, Marc Abbott wrote:
> Hi
>
> We have detected the following error in out PG logs:
>
> SASTERROR: invalid memory alloc request size 4294967294.
>
> I have searched for the error and was pointed to a patch on the following
> link:
>
> http://anoncvs.postgresql.org/c
ashok raj writes:
> is there a way that we could find which procpid or connection that
> has created a particular temporary schema (pg_temp_*) ?.
In 8.3 and up, the number in the pg_temp_N schema name is the same as
the first component of the virtualxids that that session uses. Not
sur
2009/3/31 Marc Abbott :
> This email is subject to a disclaimer which may be found on our website by
> clicking on this link: disclaimer. If you would prefer, the disclaimer can
> be emailed to you by clicking here.
> Hi
> We have detected the following error in out PG logs:
> SASTERROR: invalid m
Michael Monnerie wrote:
> It is no problem if B reads, A can copy without a problem, even
> without the cp before mv.
B could open the file while it is being copied, and read to the
current end of file before A has finished copying. If we used rsync
it would, by default, copy to a temporary fi
Scott Marlowe writes:
> On Tue, Mar 31, 2009 at 2:21 AM, Marc Abbott wrote:
>> http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c.diff?r1=1.61.2.1&r2=1.61.2.2
> That IS the patch. However, why are you trying to patch pgsql by
> hand? Seems a hard way to do things.
ashok raj escribió:
> Hi ,
>
> is there a way that we could find which procpid or connection that
> has created a particular temporary schema (pg_temp_*) ?.
>
> In one of our db a temporary schema (pg_temp_48) was using more
> than 200GB of disk space and how to find the conne
Hello People,
I have some doubts about Vacuum Full. There We go:
1) The Only thing that *Vacuum Full* (Only Full, not Analyze) is to clean
"dead space" on the disc, and reorganize the relation at the physical level?
If it's true, so doing this may speed up *select's*, while the Postgres will
going
On Tue, Mar 31, 2009 at 10:04 AM, Rafael Domiciano
wrote:
> Hello People,
>
> I have some doubts about Vacuum Full. There We go:
> 1) The Only thing that Vacuum Full (Only Full, not Analyze) is to clean
> "dead space" on the disc, and reorganize the relation at the physical level?
> If it's true,
Hello Postgres Gurus,
I have a restore problem.
If you do the backup as a text file:
pg_dump.exe -i -h machine -p 5432 -U postgres -F p -v -f
"C:\dbname_text.dump.backup" dbname
You can see the order in which the restore will happen. And the restore seems
to be happening in the following order
Hello Everyone.
I am having issues with privilege inheritance to a login role through a group
role.
These are the steps I am performing:
1. data: stcities belongs to user gdb, it resides in the gdb schema
2. map user is a login role:
CREATE ROLE map LOGIN
ENCRYPTED PASSWORD 'md59ec9dda576d
Kasia Tuszynska writes:
> The problem arises, if data in lets say the adam schema is dependent on
> tables in the public schema, since the data in the public schema does not
> exist yet, being created later.
That's not supposed to happen. Are you possibly running an early 8.3
release? pg_dump
Kasia Tuszynska writes:
> I am having issues with privilege inheritance to a login role through a group
> role.
> These are the steps I am performing:
> 1. data: stcities belongs to user gdb, it resides in the gdb schema
> 2. map user is a login role:
> CREATE ROLE map LOGIN
> ENCRYPTED P
19 matches
Mail list logo
