Hello,
On Sun, Aug 13, 2017 at 10:00:23AM -0400, Igor Korot wrote:
> However, I can't find this file anywhere on the system.
> I am able to connec to the server locally with psql. I can also
> connect to the server
> from the ODBC driver from my program. However doing a global search I
> can't fin
Recently I started to take a look at Postgresql on the Source Level. I wanted to extend the Parser by a simple Clause which isn't as easy as I expected.
Hence I'm here asking for help. This might seem trivial for a Person which is able to answer this Question but please take a moment of your time
On 8/14/17 04:14, Stefan Wagner wrote:
> I would really appreciate if someone could hack me a quick example of a
> new clause lets call it ADDITIONAL with Keywords HIGH, LOW to order
> columns. I just want the construct. What
> the Keywords accomplish and the Algorithm is something I'm gonna try to
Hi,
I'd just like to quickly reach out to let you know that we released a
new (open source) network engine in which we also utilize PostgreSQL and want
to thank you for the work you put into the project.
PostgreSQL is utilized for two parts in the network engine:
- as an option for a backend db
Hello.
I will start developing an extension to PostgreSQL next to PostGIS using the C
language.
If my new type were:
CREATE TYPE mytype (.., .., .., geom geometry);
The creation of the structure in c, would be something like?
#include "liblwgeom.h"
Struct mytype
{
Int32 id;
LWGEOM lwg
In order to get an LWGEOM from PostGIS you'll need to convert from the
serialized form (GSERIALIZED) which you can read all about in the
liblwgeom.h header. You'll be adding a hard dependency of course, but
hopefully you're OK with that.
If you're just hoping to build a compound type, as your exam
Hi,
I'm trying to write an application (using libpqxx/C++) which creates graphical
images of large and complex relations between tables (basically an SVG image
with hot spots for drilling down on details). I need to essentially create
icons of tables and their columns, and then draw interconn
Hello,
i try to replicate my database. what i have done?
- create a cluster on slave (UTF8, en_US.utf8 collate/c_type)
- stop cluster and cleanup datadir
- do basebackup from master
- start db-cluster
Master has utf8, en_us.uft8 collate/c_type
Now my db on slave has UTF8, c.utf8 collate/c_type.
On Mon, Aug 14, 2017 at 2:46 PM, wrote:
> Hi,
>
> I'm trying to write an application (using libpqxx/C++) which creates
> graphical images of large and complex relations between tables (basically
> an SVG image with hot spots for drilling down on details). I need to
> essentially create icons of t
Just to add that running psql with the -E switch is REALLY handy for seeing
how psql executes queries to find how tables etc are put together.
...snip...
For all tables and columns I get no output at all. Basically I need all tables
and columns for which the column is neither a regular primary key, nor a
foreign key. This will be marked as an attribute in the diagramming program.
Your query for primary keys which are not foreign keys
...
> Just to add that running psql with the -E switch is REALLY handy for seeing
> how psql executes queries to
> find how tables etc are put together.
I can't actually use that feature to gather the information I'm interested in
since all I have are tables and data with no formal informatio
On Mon, Aug 14, 2017 at 6:38 PM, wrote:
> ...
> > Just to add that running psql with the -E switch is REALLY handy for
> seeing how psql executes queries to
> > find how tables etc are put together.
>
> I can't actually use that feature to gather the information I'm interested
> in since all I ha
On Tue, Aug 15, 2017 at 3:52 AM, basti wrote:
> master and slave had set the same locales.
> I dont unterstand that i can create a database in en_us.utf8 and then when i
> did the basebackup it's change to c locale.
> I cant find any option for pg_basebackup to set locale/collate.
> I use this how
Hi
Quick question. I have a 2 node cluster - each node has its own ip.
But from reading this, I really need a 3rd ip, which potentially floats
between the nodes to which ever is the master / rw node.
Is that right? Sort of makes sense I guess
A
On 14 August 2017 at 16:47, Andreas Kretschmer
Am 15.08.2017 um 05:15 schrieb Alex Samad:
Hi
Quick question. I have a 2 node cluster - each node has its own ip.
But from reading this, I really need a 3rd ip, which potentially
floats between the nodes to which ever is the master / rw node.
Is that right? Sort of makes sense I guess
16 matches
Mail list logo